Databases
StackOverflow2013
Postsdbo
POInsert data into database isnt working
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInsert data into database isnt working
    text
    copied!<p>I'm a little stuck, I can update the database manually, but through PHP it isn't working.</p> <p>database fields:</p> <pre><code>Column Type Collation Attributes Null Default Extra id int(10) UNSIGNED No auto_increment addedby varchar(100) latin1_swedish_ci No location text latin1_swedish_ci No details text latin1_swedish_ci No deadline text latin1_swedish_ci No datefixed int(200) No 0 completed int(11) No 0 </code></pre> <p>Add_jobs.php:</p> <pre><code>&lt;?php $pagetitle = "Add Job"; $checkrank = 3; include ($_SERVER['DOCUMENT_ROOT'].'/header.inc.php'); $helpfaerie = mysql_fetch_array(mysql_query("SELECT * FROM helpfaerie WHERE page = 'reportbug'")); $helpfaerie2 = mysql_fetch_array(mysql_query("SELECT * FROM members WHERE username = '$username'")); if ($helpfaerie2[helpfaerie] == 1) { echo "&lt;div id=\"helpfaerie\" style=\"overflow: auto; position:fixed; bottom:0; right:0; \"&gt;&lt;table width=\"200\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\" style=\"border-top: 1pt solid black;border-bottom: 1pt solid black;border-left: 1pt solid black;border-right: 1pt solid black; background-color:#ffffff;\"&gt; &lt;tr&gt; &lt;td&gt;&lt;center&gt;&lt;img src=\"http://images.neopets.com/items/toy_faerie_psellia.gif\" border=\"0\"&gt;&lt;/center&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;p&gt;$helpfaerie[text]&lt;/p&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td style=\"text-align: right;\"&gt;[&lt;a href=\"$baseurl/closehelp.pro.php\"&gt;x&lt;/a&gt;]&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt;&lt;/div&gt;"; } ECHO &lt;&lt;&lt;END &lt;center&gt; &lt;FORM ACTION="add_jobs.pro.php" enctype="multipart/form-data" METHOD=POST&gt; &lt;table width="366" border="0" cellspacing="0" cellpadding="0"&gt; &lt;tr&gt; &lt;td colspan="2"&gt;&lt;center&gt;Add Job&lt;p&gt;&lt;/center&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="118"&gt;Job Location (If any):&lt;/td&gt; &lt;td width="249"&gt;&lt;textarea name="page" cols="20" rows="1" value="" &gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="118"&gt;Details::&lt;/td&gt; &lt;td width="249"&gt;&lt;textarea name="wrong" cols="20" rows="10" value="" &gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td width="118"&gt;Deadline::&lt;/td&gt; &lt;td width="249"&gt;&lt;textarea name="line" cols="20" rows="1" value=""&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&amp;nbsp;&lt;/td&gt; &lt;td&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="2"&gt;&lt;center&gt;&lt;font size="-1"&gt;&lt;i&gt; &lt;input type=submit name=Submit value="Add Jobs"&gt; &lt;/i&gt;&lt;/font&gt;&lt;/center&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt;&lt;/FORM&gt; &lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/center&gt; END; include ($_SERVER['DOCUMENT_ROOT'].'/footer.inc.php'); ?&gt; </code></pre> <p>Notes: dblink (is link to my database, which works fine,) Addon, is basically for smileys and grammer.</p> <p>Basically this is to be a jobs page, which we update with jobs we need to do around the site.</p> <p>add_jobs.pro.php:</p> <pre><code>&lt;?php $pagetitle = "Add Jobs"; $checkrank = 3; include ($_SERVER['DOCUMENT_ROOT'].'/addon.php'); include ($_SERVER['DOCUMENT_ROOT'].'/dblink.php'); include ($_SERVER['DOCUMENT_ROOT'].'/security/stripusers.php'); $page = $_POST['page']; $wrong = $_POST['wrong']; $line = $_POST['line']; $page = mysql_real_escape_string($page); $page = stripslashes($page); $page = stripusers($page); $wrong = mysql_real_escape_string($wrong); $wrong = stripslashes($wrong); $wrong = stripusers($wrong); $line = mysql_real_escape_string($line); $line = stripslashes($line); $line = stripusers($line); if ((!$page) OR (!$wrong) OR (!$line)) { die(header("Location: $baseurl/add_jobs.php?error=Please+do+not+leave+any+info+blank.")); } else { mysql_query("INSERT INTO assignments (addedby,location,details,deadline,datefixed) VALUES ('$username','$page','$wrong','$line','$timestamp','0')"); header("Location: add_jobs.php?error=Thank+you.+Your+Job+has+been+submitted."); } ?&gt; </code></pre> <p>Ive just entered another issue. </p> <p>Once Jobs are submitted, they then get listed on this</p> <pre><code>&lt;?php $pagetitle = "Active Jobs"; $checkrank = 0; include ($_SERVER['DOCUMENT_ROOT'].'/header.inc.php'); $view=$_GET['view']; $num = mysql_num_rows(mysql_query("SELECT * FROM `assignments` WHERE 1")); if ($num &lt;= 0) { echo " &lt;p&gt;&lt;center&gt; There are no active jobs :D"; } $sort = mysql_query("SELECT * FROM `assignments` WHERE 1"); while($sort2 = mysql_fetch_array($sort)) { if($sort2[id]) { $tym = date("H:i",$sort2[date]); $wcd = date("M j Y",$sort2[date]); echo(" &lt;center&gt; &lt;table width=\"607\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\" style=\"border-top: 1pt solid black;border-bottom: 1pt solid black;border-left: 1pt solid black;border-right: 1pt solid black; \"&gt; &lt;tr&gt; &lt;td width=\"139\" valign=\"top\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#5eaed4;\"&gt;Submitted By:&lt;/td&gt; &lt;td width=\"450\" valign=\"top\" style=\"border-bottom: 1pt solid black;background-color:#f4f4f4;\"&gt;$sort2[addedby]&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#8cc7e3;\"&gt;Date Submitted:&lt;/td&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;background-color:#f4f4f4;\"&gt; $wcd @ $tym NST&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#5eaed4;\"&gt;Job Location:&lt;/td&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;background-color:#f4f4f4;\"&gt;$sort2[location] [&lt;a href=\"$sort2[location]\"&gt;View&lt;/a&gt;]&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#8cc7e3;\"&gt;Job Description:&lt;/td&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;background-color:#f4f4f4;\"&gt;$sort2[details]&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#8cc7e3;\"&gt;Deadline:&lt;/td&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;background-color:#f4f4f4;\"&gt;$sort2[deadline]&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign=\"top\" style=\"border-right: 1pt solid black; background-color:#5eaed4;\"&gt;completed?:&lt;/td&gt; &lt;td valign=\"top\" style=\"background-color:#f4f4f4;\"&gt;Click When Completed [&lt;a href=\"$baseurl/staff/submitted/completed_job.pro.php?id=$sort2[id]\"&gt;x&lt;/a&gt;]&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/center&gt; "); } } echo "&lt;p&gt;&lt;/center&gt;\n"; echo "&lt;/center&gt;\n"; include ($_SERVER['DOCUMENT_ROOT'].'/footer.inc.php'); ?&gt; </code></pre> <p>Which you then click a X and it then classes them as completed which then is meant to remove them off the page, but Its not doing do, they just stay listed, </p> <p>But they are also registering that their fixed, and showing on the completed Jobs page.</p> <p>completed_jobs.php</p> <pre><code> &lt;?php $pagetitle = "Active Jobs"; $checkrank = 0; include ($_SERVER['DOCUMENT_ROOT'].'/header.inc.php'); $view=$_GET['view']; $num = mysql_num_rows(mysql_query("SELECT id FROM assignments WHERE completed =1")); if ($num &lt;= 0) { echo " &lt;p&gt;&lt;center&gt; There are no complete Jobs at this time."; } $sort = mysql_query("SELECT * FROM assignments WHERE completed =1"); while($sort2 = mysql_fetch_array($sort)) { if($sort2[id]) { $tym = date("H:i",$sort2[date]); $wcd = date("M j Y",$sort2[date]); $ftym = date("H:i",$sort2[datefixed]); $fwcd = date("M j Y",$sort2[datefixed]); echo(" &lt;center&gt; &lt;table width=\"607\" border=\"0\" cellspacing=\"0\" cellpadding=\"4\" style=\"border-top: 1pt solid black;border-bottom: 1pt solid black;border-left: 1pt solid black;border-right: 1pt solid black; \"&gt; &lt;tr&gt; &lt;td width=\"139\" valign=\"top\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#5eaed4;\"&gt;Submitted By:&lt;/td&gt; &lt;td width=\"450\" valign=\"top\" style=\"border-bottom: 1pt solid black;background-color:#f4f4f4;\"&gt;$sort2[addedby]&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#8cc7e3;\"&gt;Date Submitted:&lt;/td&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;background-color:#f4f4f4;\"&gt; $wcd @ $tym NST&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#5eaed4;\"&gt;Job Location:&lt;/td&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;background-color:#f4f4f4;\"&gt;$sort2[location] [&lt;a href=\"$sort2[location]\"&gt;View&lt;/a&gt;]&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#8cc7e3;\"&gt;Job Description:&lt;/td&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;background-color:#f4f4f4;\"&gt;$sort2[details]&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;border-right: 1pt solid black; background-color:#8cc7e3;\"&gt;Deadline:&lt;/td&gt; &lt;td valign=\"top\" style=\"border-bottom: 1pt solid black;background-color:#f4f4f4;\"&gt;$sort2[deadline]&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td valign=\"top\" style=\"border-right: 1pt solid black; background-color:#5eaed4;\"&gt;Completed On:&lt;/td&gt; &lt;td valign=\"top\" style=\"background-color:#f4f4f4;\"&gt;$fwcd @ $ftym NST&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;p&gt;&amp;nbsp;&lt;/p&gt;&lt;/center&gt; "); } } echo "&lt;p&gt;&lt;/center&gt;\n"; echo "&lt;/center&gt;\n"; include ($_SERVER['DOCUMENT_ROOT'].'/footer.inc.php'); ?&gt; and then completed_job.pro.php &lt;?php $pagetitle = "Completed Jobs"; $checkrank = 30; include ($_SERVER['DOCUMENT_ROOT'].'/addon.php'); include ($_SERVER['DOCUMENT_ROOT'].'/dblink.php'); $id=$_GET['id']; mysql_query("UPDATE assignments SET completed = '1' WHERE id = '$id'"); mysql_query("UPDATE assignments SET datefixed = '$timestamp' WHERE id = '$id'"); header("Location: completed_jobs.php?error=Job+has+been+updated+to+complete+:)"); ?&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload