StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POphp class not responding
primarykey
Id
4175118
data
AcceptedAnswerId
4175139
AnswerCount
3
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-11-13T22:43:01.533
FavoriteCount
0
LastActivityDate
2012-05-27T12:28:01.560
LastEditDate
2012-05-27T12:28:01.560
LastEditorUserId
499770
OwnerUserId
499770
ParentId
0
PostTypeId
1
Score
1
ViewCount
222
LastEditorDisplayName
text
Body
I have a problem with the following piece of PHP script: <pre><code><?php abstract class root { protected $con; protected $sql; protected $query; protected $row; protected function __construct__() { require_once("db.settings.php"); $this->con = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die(mysql_error($this->con)); mysql_query("SET NAMES UTF8", $this->con) or die(mysql_error($this->con)); mysql_close($this->con); mysql_select_db(DB_NAME, $this->con); } protected function __destruct__() { mysql_close($this->con); unset($this->con); } } class users extends root { private $h; public function __construct__() { parent::__construct__(); } public function __destruct__() { parent::__destruct__(); } public function register($uname, $pass, $mail, $name) { $this->hash = sha1($uname . md5($pass) . $name); $this->sql = "INSERT INTO users (user, pass, mail, name, hash) VALUES ($uname, $pass, $mail, $name, $this->hash)"; mysql_query($this->sql, $this->con) or die(mysql_error($this->con)); mysql_close($this->con); return true; } public function login($uname, $pass) { $this->sql = "SELECT * FROM users WHERE user = $uname AND pass = " . md5($pass); mysql_query($this->sql, $this->con) or die(mysql_error($this->con)); if(mysql_num_rows !== 1){ mysql_close($this->con); return false; } else { setcookie("who", $uname, time() + 3600); $this->h = md5($pass); setcookie("token", $this->h, time() + 3600); $this->h = sha1($uname . md5($pass)); setcookie("hash", $uname, time() + 3600); return true; } } public function logout() { if(isset($_COOKIE['who']) && isset($_COOKIE['token']) && isset($_COOKIE['hash']) && $_COOKIE['hash'] == sha1($_COOKIE['who'] . $_COOKIE['token'])) { setcookie("who", $uname, time() - 1); setcookie("token", $uname, time() - 1); setcookie("hash", $uname, time() - 1); return true; } else { setcookie("who", $uname, time() - 1); setcookie("token", $uname, time() - 1); setcookie("hash", $uname, time() - 1); return false; } } public function check() { if(isset($_COOKIE['who']) && isset($_COOKIE['token']) && isset($_COOKIE['hash']) && $_COOKIE['hash'] == sha1($_COOKIE['who'] . $_COOKIE['token'])) { return true; } else { return false; } } } class iPhone extends root { private $hash; public $content = array(); private $j = 0; public function __construct__() { parent::__construct__(); } public function __destruct__() { parent::__destruct__(); } public function registerIphone() { # implented later $this->hash = md5(time); $this->sql = "UPDATE users SET phoneid = " . $this->hash . " WHERE user = " . $_COOKIE['who']; mysql_query($this->sql, $this->con) or die(mysql_error($this->con)); setcookie("phoneid", $this->hash, 1314000); return true; } public function checkIphone() { # implented later $this->sql = "SELECT * FROM users WHERE phoneid = " . $_COOKIE['phoneid'] . " LIMIT 1"; if(mysql_query($this->sql, $this->con)) { return true; } else { return false; } } public function deleteIphone($who) { # implented later $this->sql = "UPDATE users SET phoneid = '' WHERE user = $who"; if(mysql_query($this->sql, $this->con)) { return true; } else { return false; } } public function showContent($what) { $this->sql = "SELECT * FROM content WHERE articleName = " . $what . " AND media = Handheld"; $this->query = mysql_query($this->sql, $this->con) or die(mysql_error($this->con)); while($this->row = mysql_fetch_array($this->query)) { $content[$j]['id'] = $row['id']; $content[$j]['date'] = $row['date']; $content[$j]['articleName'] = $row['articleName']; $content[$j]['content'] = $row['content']; $this->j++; } mysql_close($this->con); return $this->content; } } class contentManager extends root { public $content = array(); private $j = 0; public function __construct__() { parent::__construct__(); } public function __destruct__() { parent::__destruct__(); } public function showContent($what) { $this->sql = "SELECT * FROM content WHERE articleName = $what AND media = Browser"; $this->query = mysql_query($this->sql, $this->con) or die(mysql_error($this->con)); while($this->row = mysql_fetch_array($this->query)) { $content[$j]['id'] = $row['id']; $content[$j]['date'] = $row['date']; $content[$j]['articleName'] = $row['articleName']; $content[$j]['content'] = $row['content']; $this->j++; } mysql_close($this->con); return $this->content; } public function editContent($id, $articlename, $content) { $this->sql = "UPDATE content SET articleName = $articlename, content = $content WHERE id = $id"; mysql_query($this->sql, $this->con) or die(mysql_error($this->con)); return true; } public function deleteContent($id) { $this->sql = "DELETE FROM content WHERE id = $id"; mysql_query($this->sql, $this->con) or die(mysql_error($this->con)); return true; } } class map extends root { private $j = 0; private $key = "my google maps api key"; private $address; private $helper; private $page; private $xml; private $longitude; private $latitude; private $altitude; public function __construct__() { parent::__construct__(); } public function __destruct__() { parent::__destruct__(); } public function getMarkers() { $this->sql = "SELECT * FROM markers"; $this->query = mysql_query($this->sql, $this->con) or die(mysql_error($this->con)); while($this->row = mysql_fetch_array($this->query)) { if($this->j < (mysql_num_rows($this->query) -1 )){ print("['" . $this->row['address'] . "', " . $this->row['lat'] . ", " . $this->row['lng'] . ", 1],"); $this->j++; } else { print("['" . $this->row['address'] . "', " . $this->row['lat'] . ", " . $this->row['lng'] . ", 1]"); $this->j++; } } } public function setMarkers($addr) { $this->helper = str_replace(" ", "+", $addr); $this->helper = explode(",", $this->helper); $this->address = "http://maps.google.com/maps/geo?q=$this->helper[0],+$this->helper[1],+$this->helper[2]&output=xml&key=$this->key"; $this->page = file_get_contents($this->address); $this->xml = new SimpleXMLElement($this->page); list($this->longitude, $this->latitude, $this->altitude) = explode(",", $xml->Response->Placemark->Point->coordinates); echo $this->longitude . " :: " . $this->latitude; } public function deleteMarkers($id) { /* *** FUNCTION NOT YET IMPLENTED! */ } } ?> </code></pre> For those, who do not want to read source: I create an abstract class, that creates database connection, then other classes, like login extends it, using the parents database connection. The problem is, whenever I create an instance of a class, like: <pre><code>$map = new map(); </code></pre> Then try to do something with the instance: <pre><code>$map->setMarkers(""); </code></pre> Nothing happens. Literally nothing. No error message, and no output. All help would be highly appreciated!
Tags
<php><oop>
Title
php class not responding
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USPeter Szabo
UserOwnerUserId
1. USPeter Szabo
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POphp class not responding
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COHave you tried debugging? e.g. adding `print` statements to find out where it gets stuck?
 singulars
 PostPostId
 POphp class not responding
 UserUserId
 USOliver Charlesworth
2. COYep, tried to print strings from the root and from the child classes constructors && destructors.
 singulars
 PostPostId
 POphp class not responding
 UserUserId
 USPeter Szabo

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.