$fname="public/Belle2.xml";
$dbname = 'b2config';
$link = mysql_connect("f9lab02.ijs.si","basf2","belle2") or die("Couldn't make connection.");
$db = mysql_select_db($dbname, $link) or die("Couldn't select database");
echo "Connected
\n";
function mquery($query){
$result=mysql_query($query);
//echo "$query
";
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n" . 'Whole query: ' . $query . "\n" ;
echo "$message
";
die($message);
}
return $result;
}
$txt = file_get_contents($fname);
$timestamp=time();
$query=sprintf("INSERT INTO geometry (major,minor,data) VALUES ( '$timestamp' , '0' , '%s' ) ;", mysql_real_escape_string($txt) );
$result = mquery($query);
$query="SELECT * FROM geometry ;";
$result = mquery($query);
$num = mysql_num_rows($result);
echo "Total Number of rows in the table geometry $num
\n";
?>