// database connection # host, user, password, dbname $db = new mysqli('localhost', 'archivemain', 'Scott22!', 'archivemain'); if($db->connect_errno > 0){ die('Unable to connect to database [' . $db->connect_error . ']'); } function do_sql($SQL) { global $db; if(!$result = $db->query($SQL)){ die('
MySQL Error: [' . $db->error . ']'."\n$SQL");
}
return $result;
}
function show_results($array) {
if (count($array) <1) {echo "no data"; return;}
$first=$array[0];
echo '| '; echo $key; echo ' | '; } echo '
|---|
| '; echo $value; echo ' | '; } echo '