get free code

Add data to a MySQL database
Description

How to insert and save information into a MySQL database table using PHP.
The code





/**

* Change the first line to whatever

* you use to connect to the database.

*

* We're using two values, title and

* text. Replace these with whatever

* you want to add to the database.

*

* Finally, change tablename to the

* name of your table.

*/



// Your database connection code

db_connect();



$query = "INSERT INTO tablename(title, text) VALUES('$title','$text')";



$result = mysql_query($query);



echo "The data has been added to the database.";



?>