getMessage() . "\n";
//echo 'DBMS/User Message: ' . $db->getUserInfo() . "\n";
//echo 'DBMS/Debug Message: ' . $db->getDebugInfo() . "\n";
exit;
}
if(isset($_POST['countMeIn'])) {
if(empty($_POST['name'])) $_POST['name'] = "anonymous";
if(empty($_POST['count']) || empty($_POST['thingCounted'])) {
print "
If we don't know what you counted or how many you counted, we can't count you in.";
} else {
$sql = sprintf("INSERT INTO ncd (name,count,thingCounted) VALUES ('%s',%d,'%s')",$_POST['name'],$_POST['count'],$_POST['thingCounted']);
$result = $db->query($sql);
if (DB::isError($result)) {
die ($result->getMessage());
} else {
print "
You've been counted!";
}
}
}
$sql = "SELECT * FROM ncd";
$result = $db->query($sql);
if (DB::isError($result)) {
die ($result->getMessage());
} else {
while($someCount = $result->fetchRow(DB_FETCHMODE_OBJECT)) {
print "
".$someCount->name."'s count:
"
."
".$someCount->count." ".$someCount->thingCounted."
"
."
submitted on ".formatTimestamp($someCount->created)."
";
}
}
?>
disconnect();
?>