Author: (203.106.219.---)
Date: 02-25-04 16:42
Hm..I change a bit--it works fine.
INSERT FILE
<?php
// Connect to the database
$dbhost = 'localhost';
$dbusername = 'testuser';
$dbpasswd = 'testpassword';
$database_name = 'simple';
$connection = mysql_connect($dbhost,$dbusername,$dbpasswd)
or die ("Could not connect to server.");
$db = mysql_select_db($database_name, $connection)
or die("Could not select database.");
// Generate SQL code to store data on database.
$insert_sql = "INSERT INTO simple_table (text) VALUES ('test text, 1,2,3')";
// Execute SQL code.
mysql_query( $insert_sql )
or die ( "It Did not Work: ".mysql_error() );
// Tell User we are done.
echo "Data Inserted";
?>
QUERY FILE
<?php
// Connect to the database
$dbhost = 'localhost';
$dbusername = 'testuser';
$dbpasswd = 'testpassword';
$database_name = 'simple';
$connection = mysql_connect($dbhost,$dbusername,$dbpasswd)
or die ("Could not connect to server.");
$db = mysql_select_db($database_name, $connection)
or die("Could not select database.");
// Generate code to retrieve data from database.
$select_sql = "SELECT text FROM simple_table ";
echo $select_sql;
// Retrieve code from database.
$result = mysql_query( $select_sql ) or die ( "It Did not Work: " . mysql_error() );
// Display results to user.
while ( $row = mysql_fetch_object ( $result ) )
{
echo $row->text . "<br>" ;
echo "PHP is working.<br>";
}
?>
|
|