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
Got this error ?
This is because, name and id are name of the attributes/fields in the database and are not defined variable names in PHP script. So instead of using $row[id] and $row[name], write $row[0] and $row[1]
how to make update for multiple users?? for example i have my user account and my friend has his own account. so, how we can update our own private data individually(means with out knowing modified with each other? ).
thanks
from bahir dar university
Ethiopia
@zewdu, You could keep the user ID of the logged in user in a session. Use that session variable in WHERE clause of the update mysql query. Simple.
hi, I'm trying to edit more than one field at the same time. But it updates only the first field "name".
for example
1. Google, Nexus, ,Android edit I'd like to edit this at the same time.
2. Apple, Iphone, IOS edit
etc
@raudi, Use $names = urlencode( $_GET['names'] ); and save it into database table.
Created a member's only setting and using a session to log into the members area how would I put together a view profile and update profile by passing the $_SESSION value to the DB? I originally used you sign up, log in video to create it.
Thanks for your tutorial! Very helpful! Keep it up, guy :)
Hi, Thank you for this tutorial. I'd love to see how you handle a delete function.
@venrooy,you can find it here Delete / Remove Records In Database Table: PHP & MySQL
how to edit image in database?????
Since you store the location of the actual image in your database table, it's like regular text edit.
You simply change the path of the image.
Maybe from a old location to a new one OR from one image path to the other.
My it brings up only the first record to update no matter which record I click, any thought?
Update with WHERE condition pointing to the latest id. #simple
Nice :).
Thank you that you have inserted the code :)