Databases
StackOverflow2013
Postsdbo
POphp mysql simple update: cannot read values
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POphp mysql simple update: cannot read values
    text
    copied!<p>probably stupid question but... I have a sample for PHP and MySQL, which doesn't work... there are 3 php files:</p> <ol> <li>list_records.php</li> <li>update.php</li> <li>update_ac.php</li> </ol> <p>the problem is that 3rd one doesn't read variables from the 2nd. What am I doing wrong?</p> <p>Here are my files/code:</p> <p>list_records.php</p> <pre><code>&lt;?php $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test_mysql"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $sql="SELECT * FROM $tbl_name"; $result=mysql_query($sql); ?&gt; &lt;table width="400" border="0" cellspacing="1" cellpadding="0"&gt; &lt;tr&gt; &lt;td&gt; &lt;table width="400" border="1" cellspacing="0" cellpadding="3"&gt; &lt;tr&gt; &lt;td colspan="4"&gt;&lt;strong&gt;List data from mysql &lt;/strong&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="center"&gt;&lt;strong&gt;Name&lt;/strong&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;strong&gt;Lastname&lt;/strong&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;strong&gt;Email&lt;/strong&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;strong&gt;Update&lt;/strong&gt;&lt;/td&gt; &lt;/tr&gt; &lt;?php while($rows=mysql_fetch_array($result)){ ?&gt; &lt;tr&gt; &lt;td&gt;&lt;?php echo $rows['name']; ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $rows['lastname']; ?&gt;&lt;/td&gt; &lt;td&gt;&lt;?php echo $rows['email']; ?&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;a href="update.php?id=&lt;?php echo $rows['id']; ?&gt;"&gt;update&lt;/a&gt;&lt;/td&gt; &lt;/tr&gt; &lt;?php } ?&gt; &lt;/table&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;?php mysql_close(); ?&gt; </code></pre> <p>update.php</p> <pre><code>&lt;?php $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test_mysql"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // get value of id that sent from address bar $id=$_GET['id']; // Retrieve data from database $sql="SELECT * FROM $tbl_name WHERE id='$id'"; $result=mysql_query($sql); $rows=mysql_fetch_array($result); ?&gt; &lt;table width="400" border="0" cellspacing="1" cellpadding="0"&gt; &lt;tr&gt; &lt;form name="form1" method="post" action="update_ac.php"&gt; &lt;td&gt; &lt;table width="100%" border="0" cellspacing="1" cellpadding="0"&gt; &lt;tr&gt; &lt;td&gt;&amp;nbsp;&lt;/td&gt; &lt;td colspan="3"&gt;&lt;strong&gt;Update data in mysql&lt;/strong&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="center"&gt;&amp;nbsp;&lt;/td&gt; &lt;td align="center"&gt;&amp;nbsp;&lt;/td&gt; &lt;td align="center"&gt;&amp;nbsp;&lt;/td&gt; &lt;td align="center"&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td align="center"&gt;&amp;nbsp;&lt;/td&gt; &lt;td align="center"&gt;&lt;strong&gt;Name&lt;/strong&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;strong&gt;Lastname&lt;/strong&gt;&lt;/td&gt; &lt;td align="center"&gt;&lt;strong&gt;Email&lt;/strong&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&amp;nbsp;&lt;/td&gt; &lt;td align="center"&gt; &lt;input name="name" type="text" id="name" value="&lt;?php echo $rows['name']; ?&gt;"&gt; &lt;/td&gt; &lt;td align="center"&gt; &lt;input name="lastname" type="text" id="lastname" value="&lt;?php echo $rows['lastname']; ?&gt;" size="15"&gt; &lt;/td&gt; &lt;td&gt; &lt;input name="email" type="text" id="email" value="&lt;?php echo $rows['email']; ?&gt;" size="15"&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&amp;nbsp;&lt;/td&gt; &lt;td&gt; &lt;input name="id" type="hidden" id="id" value="&lt;?php echo $rows['id']; ?&gt;"&gt; &lt;/td&gt; &lt;td align="center"&gt; &lt;input type="submit" name="Submit" value="Submit"&gt; &lt;/td&gt; &lt;td&gt;&amp;nbsp;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/td&gt; &lt;/form&gt; &lt;/tr&gt; &lt;/table&gt; &lt;?php // close connection mysql_close(); ?&gt; </code></pre> <p>update_ac.php</p> <pre><code>&lt;?php $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test_mysql"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // update data in mysql database $sql="UPDATE $tbl_name SET name='TEST', lastname='$lastname', email='$email' WHERE id='$id'"; $result=mysql_query($sql); // if successfully updated. if($result){ echo "Successful"; echo "&lt;BR&gt;"; echo "&lt;a href='list_records.php'&gt;View result&lt;/a&gt;"; } else { echo "ERROR"; } ?&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