index.php

Go to the documentation of this file.

<?php

    $conid = $_POST['val'];
    
    $confname = $_POST['confname'];
    $rooms = $_POST['rooms'];
    $endtime = $_POST['endtime'];
    $starttime = $_POST['starttime'];
    $confdate = $_POST['confdate'];
    $address = $_POST['address'];
    $description = $_POST['description'];
    

        
Connect_DatabaseController::connect();



/*
echo "confid:" . $conid;
echo "<br/>confname:" . $confname;

$sql_edit_conference="UPDATE conference SET name='$confname', rooms='$rooms', endtime='$endtime',
starttime='$starttime', conf_date='$confdate', address='$address', description='$description'
 WHERE conferenceid=$conid";
 */
if($confname == NULL) ;
else {
$sql_edit_conference="UPDATE conference SET name='$confname' WHERE conferenceid=$conid";
mysql_query($sql_edit_conference) or die (mysql_error());
}

if($rooms == NULL) ;
else {
$sql_edit_conference="UPDATE conference SET rooms='$rooms' WHERE conferenceid=$conid";
mysql_query($sql_edit_conference) or die (mysql_error());
}

if($endtime == NULL) ;
else {
$sql_edit_conference="UPDATE conference SET endtime='$endtime' WHERE conferenceid=$conid";
mysql_query($sql_edit_conference) or die (mysql_error());
}

if($starttime == NULL) ;
else {
$sql_edit_conference="UPDATE conference SET starttime='$starttime' WHERE conferenceid=$conid";
mysql_query($sql_edit_conference) or die (mysql_error());
}

if($confdate == NULL) ;
else {
$sql_edit_conference="UPDATE conference SET conf_date='$confdate' WHERE conferenceid=$conid";
mysql_query($sql_edit_conference) or die (mysql_error());
}

if($address == NULL) ;
else {
$sql_edit_conference="UPDATE conference SET address='$address' WHERE conferenceid=$conid";
mysql_query($sql_edit_conference) or die (mysql_error());
}

if($description == NULL) ;
else {
$sql_edit_conference="UPDATE conference SET description='$description' WHERE conferenceid=$conid";
mysql_query($sql_edit_conference) or die (mysql_error());
}

echo "<br/>Conference Edited" . "<br/>";
//INSERTION OF CONFERENCE
//insert conference properties into conference table

//mysql_close($con);

?>