';
print '';
print "Form to Control a Database";
print "
');
print ('');
}
elseif ($_POST['LAST'] == "MAIN"){
// if ( $_POST[command] == "VIEWBIDS"){
// viewbids();
// }
if ( $_POST['command'] == "VIEWAUCTIONS"){
viewauctions();
}
//if ( $_POST[command] == "PLACEBID"){
// placebid();
// }
if ( $_POST['command'] == "ADDITEM"){
additem();
}
if ( $_POST['command'] == "INSERTITEM"){
print "Change this to call the insertitem() function from addauction_insert.php";
}
/* if ( $_POST['command'] == "ADDUSER"){
adduser();
}
*/
}
/*CUT THE FOLLOWING lines and use the mydb3.php class instead
NOTE DO NOT DO THIS UNTIL YOU HAVE FOLLOWED THE APPROPRIATE INSTRUCTIONS inside
instructions.txt*/
function showerror()
{
if (mysqli_connect_error()){
die ("Error". mysqli_connect_errno() . " : " . mysqli_connect_error());
}else{
die ("Could not connect to the MySQL Database");
}
}
function connectdb($dbname)
{
include '../blurg.inc';
if (!($dbh = mysqli_connect("localhost", "coperni","$password" ))){
showerror();
}
if(!mysqli_select_db($dbh, $dbname)){
showerror();
}
return $dbh;
}
/*STOP CUTTING HERE!!! */
/*this function should be put into a file called viewauctions.php*/
function viewauctions()
{
$databasename = "m_coperni";
$db1 = connectdb($databasename);
$QUERY1 = mysqli_prepare($db1, "SELECT i.item_id, i.item, i.category, i.starttime,i.endtime,
c.firstname,c.lastname
FROM auction_items i, customers c
WHERE i.customer_id=c.customer_id
ORDER BY i.item_id");
//Note, if you had things to bind, THIS is the line to do it!
if(!mysqli_stmt_execute($QUERY1)){
showerror();
} else{
mysqli_stmt_store_result($QUERY1);
mysqli_stmt_bind_result($QUERY1, $item_id, $item, $category, $starttime, $endtime,$firstname, $lastname);
print<<Test of Auction_Items Database
';
print ('Go Back to Main DB Control Page');
print '';
}
/*This function should be put into a file called additem.php */
function additem()
{
print<<
STARTHTML;
print ('');
print '
