vetman Posted October 3, 2008 Share Posted October 3, 2008 I have ascript to update my database, first it reads the database, then puts it in a table with an update button. When you click the item you want to update it is supposed to allow you to change anything in the table line. When you are done, it's supposed to update the database. It says it does but doesn't do anything. Here is the code. <?php include 'connect.php'; // Connect to server and select database. mysql_connect($dbhost, $dbuser, $dbpass)or die("cannot connect"); mysql_select_db("rwts_webmaster")or die("cannot select DB"); // get value of id that sent from address bar $id=$_GET['id']; // Retrieve data from database $sql="SELECT * FROM example WHERE id='$id'"; $result = mysql_query($sql); $rows = mysql_fetch_array($result); ?> <table width="400" border="0" cellspacing="1" cellpadding="0"> <tr> <form name="form1" method="post" action="update_ac.php"> <td> <table width="100%" border="0" cellspacing="1" cellpadding="0"> <tr> <td> </td> <td colspan="3"><strong>Update data in mysql</strong> </td> </tr> <tr> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td> <td align="center"> </td> </tr> <tr> <td align="center"> </td> <td align="center"><strong>Name</strong></td> <td align="center"><strong>Lastname</strong></td> <td align="center"><strong>Email</strong></td> </tr> <tr> <td> </td> <td align="center"><input name="name" type="text" id="name" value="<? echo $rows['name']; ?>"></td> <td align="center"><input name="lastname" type="text" id="lastname" value="<? echo $rows['lastname']; ?>" size="15"></td> <td><input name="email" type="text" id="email" value="<? echo $rows['email']; ?>" size="15"></td> </tr> <tr> <td> </td> <td><input name="id" type="hidden" id="id" value="<? echo $rows['id']; ?>"></td> <td align="center"><input type="submit" name="Submit" value="Submit"></td> <td> </td> </tr> </table> </td> </form> </tr> </table> <?php // close connection mysql_close(); ?> Second script to update the database. <?php include 'connect.php'; // Connect to server and select database. mysql_connect($dbhost, $dbuser, $dbpass)or die("cannot connect"); mysql_select_db("rwts_webmaster")or die("cannot select DB"); echo "Connected to Database <br>"; // update data in mysql database $sql = "UPDATE example SET name='$name', lastname='$lastname', email='$email' WHERE id ='$id'"; $result=mysql_query($sql); // if successfully updated. if($result){ echo "Successful"; echo "<BR>"; echo "<a href='list_records.php'>View result</a>"; } else { echo "ERROR"; } ?> Thanks in advance ! Link to comment https://forums.phpfreaks.com/topic/126887-solved-i-have-a-problem-could-use-some-advice/ Share on other sites More sharing options...
ranjuvs Posted October 3, 2008 Share Posted October 3, 2008 In the update page you need to include the code below <?php $getId = $_POST['id']; $getName = $_POST['name']; $getLastname = $_POST['lastname']; $sql = "UPDATE example SET name='$getName', lastname='$getLastname', email='$email' WHERE id ='$getId'"; ?> Link to comment https://forums.phpfreaks.com/topic/126887-solved-i-have-a-problem-could-use-some-advice/#findComment-656279 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.