Looking for somewhere to host your site? Browse our PHP web hosts section!

Home > Code Snippets > Add data to a MySQL database

Add data to a MySQL database

Description

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

The code


<?php


/**
 * 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.";

?>

Get the code

Download the file to your computer: Click here to get the file