Video tutorial demonstrates updating / editing of data / records from the database table and displaying it on the browser.
First look at these short videos:
Connect to the database
Simple / basic insertion operation
Insertion of Records into Database using Forms: PHP & MySQL (important)
SELECT / LIST Records From Database Table: PHP & MySQL
Page Contents
index.php
<?php include_once('db.php'); if(isset($_POST['name'])) { $name = $_POST['name']; if(mysql_query("INSERT INTO apple VALUES('','$name')")) echo "Successful Insertion!"; else echo "Please try again"; } $res = mysql_query("SELECT * FROM apple"); ?> <form action="." method="POST"> Name: <input type="text" name="name"/><br /> <input type="submit" value=" Enter "/> </form> <h1>List of companies ..</h1> < ?php while( $row = mysql_fetch_array($res) ) echo "$row[id]. $row[name] <a href='edit.php?edit=$row[id]'>edit<br />"; ?>
edit.php
<?php include_once('db.php'); if( isset($_GET['edit']) ) { $id = $_GET['edit']; $res= mysql_query("SELECT * FROM apple WHERE id='$id'"); $row= mysql_fetch_array($res); } if( isset($_POST['newName']) ) { $newName = $_POST['newName']; $id = $_POST['id']; $sql = "UPDATE apple SET name='$newName' WHERE id='$id'"; $res = mysql_query($sql) or die("Could not update".mysql_error()); echo "<meta http-equiv='refresh' content='0;url=index.php'>"; } ?> <form action="edit.php" method="POST"> Name: <input type="text" name="newName" value="<?php echo $row[1]; ?/>"><br /> <input type="hidden" name="id" value="<?php echo $row[0]; ?/>"> <input type="submit" value=" Update "/> </form>
meta tag used to redirect to other page..
<meta http-equiv='refresh' content='0;url=index.php'>
MySQL Query
mysql> UPDATE apple SET name='newName' WHERE id='session_id';
Security Issue:
Make sure not to allow people to explicitly pass random id’s and retrieve and edit/update other’s data. To solve this issue, you can save the id of the logged in user in a session variable and instead of passing id to edit.php we can directly use the id stored in our session variable.
This would solve the issue.
Video’s To Watch:
GET method in action
Post method in action
session variable basics
User login and session
View Comments
Hi Satish, I am a student and I see your tutorial about php login and registration form in same project (phploginsession) and it is really nice. Could you please tell me how can i make same project adding update form with your login and register form using php and mysql database ? Thank you for your time .
@syed, Simply add the above code to your project and make sure to check, if the user has logged in before making the edit - with the help of session variable.
Use the search form present in the right sidebar and search for session and validation etc tutorials ..all those video tutorials would help for your project.
All the best ..
thanksssssssssssssssss,you helped me perfect....
thanks for you :)
Thank you for sharing this technique. Would you please post the code for DB.PHP?
@Michael, The link to it is at the top. I'll link it here too, hope that helps :-)
Connect to the database
You are best brother !
Great video! All working but i want to be able to add a new record, a new row which i can edit. But seems to be a conflict with ID. Whats the solution??
@Umar, You can check the video tutorial present here: Insert And Extract/Fetch Data From Database: PHP Script