StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP Global variable in class is reset
primarykey
Id
2600990
data
AcceptedAnswerId
2601502
AnswerCount
6
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2010-04-08T15:03:09.987
FavoriteCount
0
LastActivityDate
2010-04-09T09:28:48.697
LastEditDate
2010-04-08T16:09:02.287
LastEditorUserId
7913
OwnerUserId
311079
ParentId
0
PostTypeId
1
Score
0
ViewCount
1972
LastEditorDisplayName
text
Body
<p>I have a web form that manipulates records in a MySQL database. I have a method for displaying an edit interface for both creating new records and editing them</p> <pre><code>if ($_POST['new_page']) { print "<h2>Create new page</h2>\n"; $isNew=1; $this->EditForm(); } else if($_POST['edit']){ print "<h2>Edit page</h2>\n"; $isNew=0; $this->EditForm(); } </code></pre> <p>I am trying to use the global variable $isNew to determine where a record is to be added or updated. However, whenever my SaveChanges() function is run, $isNew is always 0. $isNew is declared immediately after the class declaration, outside all of the functions.</p> <pre><code>class Editor{ public $isNew; </code></pre> <hr> <p>Full code sample (from <a href="http://pastebin.com/40TQFEd5" rel="nofollow noreferrer">http://pastebin.com/40TQFEd5</a>):</p> <pre><code>When the object is created in index.php, the method HTMLEditorHandler() is called <?php class HTMLEditor{ var $isNew; function SaveChanges($author, $company, $title, $content, $new){ // Get AuthorID // Search database for ID $sql="SELECT ID"; $sql.=" FROM authors"; $sql.=" WHERE Name = '$author'"; $author_id=$this->db->getOne($sql); // If author not found, add to database if(!$author_id){ $sql="INSERT INTO authors(Name)"; $sql.="VALUES ('{$author}')"; $this->db->query($sql); $author_id=mysql_insert_id(); } print "isNew: ".$this->isNew; /*if($this->isNew==1){ $sql="INSERT INTO pages(CompanyID, AuthorID, Title, Content, DateCreated, DateUpdated)"; $sql.=" VALUES ('{$company}', '{$author_id}', '{$title}', '{$content}', NOW(), NOW())"; $this->db->query($sql); } else if($this->isNew==0){ print "Not new"; }*/ } function EditForm($isNew){ if(isset($_POST['pageID'])){ $sql="SELECT Name, Title, Content, CompanyID"; $sql.=" FROM pages, authors\n"; $sql.=" WHERE pages.AuthorID = authors.ID"; $sql.=" AND pages.ID = '".$_POST['pageID']."'"; $result=$this->db->query($sql); $row=$result->fetchRow(); $company=$row['CompanyID']; } print "<form action=\"{$_SERVER['PHP_SELF']}\" method=\"post\">\n"; print "<table width=\"100%\"summary=\"New Page\"\n>"; print "<tr>\n"; print "<th>Author: </th>\n"; print "<td><input type=\"text\" name=\"author\""; if(isset($row['Name'])){ print "value=\"".$row['Name']."\""; } print "/></td>\n"; print "</tr>\n"; print "<tr>\n"; print "<th>Company: </th>\n"; print "<td>\n"; $this->ShowCompanies($company); print "</td>\n"; print "</tr>\n"; print "<tr>\n"; print "<th>Title: </th>\n"; print "<td><input type=\"text\" name=\"title\""; if(isset($row['Title'])){ print "value=\"".$row['Title']."\""; } print "/></td>\n"; print "</tr>\n"; print "<tr>\n"; print "<th>Content: </th>\n"; print "<td>\n"; print $this->myToolBar->EditableArea("content", htmlspecialchars($row['Content']), "100%", 400, "NoSave"); print "</td>\n"; print "</tr>\n"; print "</table>\n"; print "<input type=\"submit\" name=\"save\" value=\"Save\"/>\n"; print "<input type=\"submit\" name=\"\" value=\"Cancel\"/>\n"; print "</form>\n"; } function DefaultForm(){ print "<form action=\"{$_SERVER['PHP_SELF']}\" method=\"post\">\n"; print "<input type=\"submit\" name=\"new_page\" value=\"Create a new page\"/>"; print "<h2>Edit an existing page</h2>\n"; print "<table summary=\"Edit Page\">\n"; print "<tr><th>Year</th><td>"; print "<select name=\"year\" onchange=\"showPages()\" id=\"year_select\">\n"; for ($year=date('Y'), $max_year=date('Y')-10; $year > $max_year; $year--) { print "<option value=\"".$year."\">".$year."</option>\n"; } print "</select>\n"; print "</td></tr>"; print "<tr><th>Company: </th><td>"; $sql="SELECT organisations.OrgID, companynames.CompanyName"; $sql.=" FROM qsvision.organisations"; $sql.=" LEFT JOIN qsvision.companynames"; $sql.=" ON qsvision.organisations.CompanyID=qsvision.companynames.CompanyID"; $sql.=" WHERE CompanyName!=''"; $sql.=" GROUP BY companynames.CompanyID"; $sql.=" ORDER BY companynames.CompanyName ASC"; $organisations=$this->db->getAll($sql); print "<select name=\"org_id\" onchange=\"showPages()\" id=\"org_id\">\n"; print "<option value=\"\">[Select...]</option>\n"; for($i=0, $max_i=count($organisations); $i<$max_i; $i++){ print "<option value=\"{$organisations[$i]['OrgID']}\""; if($site['OrgID']==$organisations[$i]['OrgID']){ print " selected=\"selected\""; } print ">".htmlspecialchars($organisations[$i]['CompanyName'])."</option>\n"; } print "</select>\n"; print "</td></tr>\n"; print "</table>"; print "<div id=\"results_table\"></div>"; print "</form>"; } function HTMLEditorHandler(){ if ($_POST['new_page']) { print "<h2>Create new page</h2>\n"; $this->EditForm(true); } else if($_POST['edit']){ print "<h2>Edit page</h2>\n"; $this->EditForm(false); } else if($_POST['delete']){ $this->DeletePage(); $this->DefaultForm(); } else if($_POST['save']){ $this->SaveChanges($_POST['author'], $_POST['org_id'], $_POST['title'], $_POST['content'],$this->isNew); $this->DefaultForm(); } else { $this->DefaultForm(); } } } ?> </code></pre>
Tags
<php><variables><global>
Title
PHP Global variable in class is reset
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USgregmac
UserOwnerUserId
1. USRobert
plurals
PostLinksPostIdRelatedPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
2. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
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. This table or related slice is empty.
CommentsPostId

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.