1 Topic by Casper

  • Casper
  • Member
  • Offline
  • Registered: 2007-11-19
  • Posts: 12

Topic: 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.";

?>