<?
define("DBName","test");
define("HostName","localhost");
define("UserName","root");
define("Password","");
if(!mysql_connect(HostName,UserName,Password)){
echo "Cannot get connected to the database ".DBName."!<br>";
echo mysql_error();
exit;
}
mysql_select_db(DBName);
// Creating the t table. If it already exists,
// "@" overrides the error message
@mysql_query("create table t(id int, a double)");
// Inserting 10 records into the table
for($i=0; $i<10; $i++){
$id=time();
mysql_query("insert into t(id, a) values($id, '$i')");
}
// Outputting all records
$r=mysql_query("select * from t");
for($i=0; $i<mysql_num_rows($r); $i++) {
$f=mysql_fetch_array($r);
echo "$f[id] -> $f[a]<br>\n";
}
?>
|