PHP

Inserting Data into a Database

You want to insert records into a database.

Use INSERT. YOu can use either of the following models:

INSERT INTO table_name values ('value1', 'value2', etc.)
INSERT INTO table_name (column1_name, column2_name), etc.) values ('value1', 'value2', etc.)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="EN" lang="EN">
<head>
<title>Inserting Data into a Database</title>
<meta Name="Author" Content="Hann So">
</head>
<body>
<p>
<?php

if (isset($_POST['submit'])) {
		process_form();
	}
	else {
		display_form();// display form for the first time
	}

function display_form() {
	echo <<<HTML
	<h2>Inserting Data into a Database</h2>
	<form action = "$_SERVER[SCRIPT_NAME]" method="post">
	Username:
	<input type="text" name="username" size="50" value="hann" />
	<br />
	Password:
	<input type="password" name="password" size="50" />
	<br />
	Database name:
	<input type="text" name="db" size="50" value="hann_db" />
	<br />
	Table name:
	<input type="text" name="table" size="50" value="blog_entries" />
	<br />
	Title:
	<input type="text" name="title" size="50" value="First blog" />
	<br />
	Entry Text:
	<textarea name="entry" cols="40" rows="5">This is my first blog</textarea>
	<br />
	<input type="submit" name="submit" value="Submit" />
	</form>
HTML;
}

function process_form() {

	DEFINE ('DB_HOST', "localhost");
	DEFINE ('DB_USER', "$_POST[username]");
	DEFINE ('DB_PASSWORD', "$_POST[password]");
	DEFINE ('DB_NAME', "$_POST[db]");
	DEFINE ('TABLE_NAME', "$_POST[table]");

	$title = stripslashes(trim($_POST[title]));
	$entry = stripslashes(trim($_POST[entry]));


	echo "<p>Opening the connection to the database server.</p>";
	if ($link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD)) {
		echo "<p>The connection worked. The link is $link</p>";

		// select a database
		if (@mysql_select_db(DB_NAME)) {
			echo "<P>The database ", DB_NAME, " has been selected.</p>";
		}
		else {
			die ("<p>Could not select the database because: ". mysql_error(). "</p>");
		}

		// define the query
		// NOW() inserts the current time
		$query = "INSERT INTO " . TABLE_NAME . " (
		title, entry, date_entered)
		VALUES ('".$title."', '".$entry."', NOW())";
		// run the query
		if (@mysql_query($query)) {
			echo "<p>The blog entry has been added.</p>";
		// close the connection
		mysql_close($link);
		}
		else {
			die ("<p>Could not insert records into the table because: ". mysql_error(). "</p>");
		}
	}
	else {
		die ("<p>Could not connect to MySQL because: ". mysql_error(). "</p>");
	}
	echo "<p><a href=\"$_SERVER[SCRIPT_NAME]\">Try again?</a></p>\n";
	echo "<p><a href=\"example_r.php\">Retrieve data?</a></p>\n";

}

?>
</p>
</body>
</html>
?>
</p>
</body>
</html>

View the effect