";
}
switch($refaction) {
case ("del"):
$id = $_REQUEST['id'];
$sql = "DELETE FROM ".$wpdb->prefix."logbookRef WHERE id = $id";
if ($wpdb->query($sql)){
logbook_ref_list();}
else{
echo "Book could not be deleted!";
}
break;
case ("edit"):
$refid = $_REQUEST['id'];
$refquery = "SELECT refnumber, refdescription
FROM ".$wpdb->prefix."logbookRef
WHERE id = $refid";
$refresult = $wpdb->get_row($refquery);
if ($_REQUEST['save']){
$data_array=array('refnumber' => $_REQUEST['refnumber'], 'refdescription' => $_REQUEST['refdescription']);
$where_array = array('id' => $refid);
if ($wpdb->update( $wpdb->prefix . 'logbookRef', $data_array, $where_array ))
{
logbook_ref_list();
}
else{
echo "Reference could not be processed!";
$wpdb->show_errors();
$wpdb->print_error();
}
}
else {
echo "
";
echo "
Edit reference
";
echo "";
echo "
";
}
break;
case ("add"):
if ($_REQUEST['save']){
$refquery="INSERT INTO ".$wpdb->prefix."logbookRef (refnumber,refdescription) VALUES ('$_REQUEST[refnumber]','$_REQUEST[refdescription]')";
if ($wpdb->query($refquery))
{
logbook_ref_list();
}
else{
echo "Reference could not be added!";
$wpdb->show_errors();
$wpdb->print_error();
}
}else{
echo "