GNU nano 2.9.3 if ($con->errno) {
print "Error connecting to Server:".$con->error."
\n";
exit(1);
}
$con->select_db(DB);
if ($con->errno) {
print "Error connecting to Database:".$con->error."
\n";
exit(1);
}
$query="drop table if exists TB_measurements;
create table TB_measurements(id int auto_increment, mdate datetime default now(),
s1 decimal(10,2), s2 decimal(10,2), s3 decimal(10,2), s4 decimal(10,2),
s5 decimal(10,2), s6 decimal(10,2), primary key(id))";
$res=$con->multi_query($query);
if ($res) {
print "Table created success!
\n";
} else {
print "Table create Error
\n";
}
//print $res;
} catch (Exception $e) {
print "Exception:".$e->getMessage()."
\n";
}
?>