Hello Friends,

If you are a learner (new) in PHP / Mysql and don’t know how to update / edit data in to table in Mysql database from php file than Here is the easiest and error-free way to update / modify data in to  table in Mysql database.

You can modify data using UPDATE query . here you are going to update record which is already exist . so you need to update record based on id or primary key. so dont forget to write WHERE clause in Update query . look at  the below code.

<?php
///*** This file will help you to update data in to tables in MYSQL database using PHP – Rakshit Patel **////

include(“mysql-connection.php”);

mysql_select_db(“testing”); // select database

$sql = “UPDATE test_table SET
name = ‘kate’,
email = ‘kate@gmail.com’,
message = ‘hiiii’ WHERE id = ‘1′ “;

mysql_query($sql) or die(‘Error, update query failed’);

include(“mysql-connection-close.php”);
?>

Here first i have added mysql-connection.php file which will make connection with Mysql database. If you dont know how to make connection with Mysql database than click here.

Now i have selected Mysql database (named testing ). if you have not created database than click here.

After selecting database , you need to execute the query as written above to update record in to table. If you have not created table yet , than click here.

Thats it. Just check the record you have updated by using Select Query.

At last i have included mysql-connection-close.php file.

<?php ///*** This file will close MYSQL connection using PHP – Rakshit Patel **////

mysql_close($connection); // close mysql connection
?>

This is nothing but it will close connection which we have made earlier. Its not necessary but a sign of Good Programmer.

Cheers !!

 

Related posts:

  1. Mysql Tutorial – Upload files to MYSQL database
  2. Mysql Tutorial – Download files from MYSQL database
  3. PHP Tutorial – Basic PHP variables
  4. Block IP addresses using .htaccess or .php file