How to Insert Data Into a MySQL Table Using PHP

To insert data into a MySQL table using PHP, you must first have a connection to the MySQL Server containing the database.

After you have the connection, you select the database that you would like to connect to.

After you've selected the database, you now use the INSERT INTO command to insert data into the table that you specify.

The code to perform this is below:

Coding

<?php $user= "user_name"; $password= "password"; $host= "host_name"; $database= "database_name"; $table= "table_name"; $connection= mysql_connect ($host, $user, $password); if (!$connection) { die ('Could not connect:' . mysql_error()); } mysql_select_db($database, $connection); mysql_query("INSERT INTO $table (column1_name, column2_name, column3_name) VALUES ('Value1', 'Value2', 'Value3')"); mysql_close($connection); ?>

Author's Note:- Using PHP to insert data into a MySQL table is a great and the best method for when you have to automate the insertion of data into a MySQL table, for example, when retrieving data from an HTML form to store the data in a MySQL table. You can also use this method when inserting data into your own table. Remember, also you can directly manually enter in data from phpmyAdmin.