Hello Friends,

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

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

include(“mysql-connection.php”);
mysql_select_db(“testing”); // select database

$sql = “INSERT INTO test_table (name, email, message) VALUES (‘john’, ‘john@gmail.com’, ‘hello’)”;

mysql_query($sql) or die(‘Error, insert 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 insert record in to table. If you have not created table yet , than click here.

Thats it. Just check the record you have inserted 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 – delete data from table
  2. Mysql database backup from PHP file
  3. Mysql Tutorial – Upload files to MYSQL database