$dbc = mysql_connect('localhost', 'root', 'rishi');
if (!$dbc) {
die('NOT CONNECTED:' . mysql_error());
}
$db_selected = mysql_select_db("restaurant", $dbc);
if (!$db_selected) {
die('NOT CONNECTED TO DATABASE:' . mysql_error());
}
if (empty($table)) {
echo "<script type=\"text/javascript\">" . "\n";
echo "alert(\"No Tables Selected!!!\");" . "\n";
echo "</script>" . "\n";
echo "<meta HTTP-EQUIV=\"REFRESH\" content=\"0; url=admin.html\">" . "\n";
} else {
$num_table = count($table);
for ($i = 0; $i < $num_table; $i++) {
$query = "DELETE FROM TABLES WHERE Table_Number = {$table[$i]};";
mysql_query($query);
}
echo "<script type=\"text/javascript\">" . "\n";
echo "alert(\"Selected Tables Deleted!!!\");" . "\n";
echo "</script>" . "\n";
echo "<meta HTTP-EQUIV=\"REFRESH\" content=\"0; url=admin.html\">" . "\n";
}
}
delete_table($_POST["table"]);
?>
</html>
</body>
</html>
<?php
session_start();
include 'header.php';
include 'function.php';
include 'db_connect.php';
include 'session.php';
$con = mysqli_connect(HOST, USER, PASSWORD, DATABASE);
if (mysqli_connect_errno($con)) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
if (isset($_GET['delete'])) {
$del_var = $_GET['delete'];
delete_table($del_var);
}
if (isset($_GET['action'])) {
logout();
header("Location: login.php");
}
$result = mysqli_query($con, "SELECT * FROM members");
?>
<p><a href="manage_user.php?action='logout'">Log Out</a></p>
<table width="100%" cellpadding="5">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Email</th>
<th>Action</th>
}
}
break;
case '2':
{
//golongan hewan
$p_gol5_jenis=$_POST['p_gol5_jenis'];
$p_gol5_ukuran=$_POST['p_gol5_ukuran'];
$p_gol5_kuantitas3=$_POST['p_gol5_kuantitas2'];
$p_gol5_satuan3=$_POST['p_gol5_satuan2'];
if ($jenis_aset_lain !== $hidden_jenis_aset_lain)
{
$getGolongan = get_golongan($GolonganHidden);
$delete = delete_table($getGolongan[0], $$getGolongan[1]);
$queryasetlain="insert into AsetLain(AsetLain_ID, Judul,Aset_ID,Ukuran)
values(NULL, '$p_gol5_jenis','$Aset_ID','$p_gol5_ukuran')";
$queryasetlain_update ="UPDATE Aset SET Kuantitas = '$p_gol5_kuantitas3',Satuan= '$p_gol5_satuan3' WHERE Aset_ID = $Aset_ID";
//$resultaset= mysql_query($queryaset)or die ('eror 17');
}
else
{
$queryasetlainupdate="UPDATE AsetLain SET Judul = '$p_gol5_jenis',Ukuran = '$p_gol5_ukuran'
WHERE AsetLain_ID = $AsetLain_ID AND Aset_ID = $Aset_ID";
$queryasetlain_update ="UPDATE Aset SET Kuantitas = '$p_gol5_kuantitas3',Satuan= '$p_gol5_satuan3' WHERE Aset_ID = $Aset_ID";
//$resultaset= mysql_query($queryaset)or die ('eror 17');
}
/**
* @brief upgrade to 2.2
* @global type $langUpgCourse
* @global type $global_messages
* @param type $code
* @param type $lang
* @param type $extramessage
*/
function upgrade_course_2_2($code, $lang) {
global $langUpgCourse, $global_messages;
Database::get()->query("USE `$code`");
// upgrade exercises
Database::get()->query("ALTER TABLE `exercise_user_record`
CHANGE `RecordStartDate` `RecordStartDate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'");
Database::get()->query("ALTER TABLE `exercise_user_record`
CHANGE `RecordEndDate` `RecordEndDate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'");
if (!DBHelper::fieldExists('exercices', 'results', $code))
echo add_field('exercices', 'results', "TINYINT(1) NOT NULL DEFAULT '1'");
Database::get()->query("ALTER TABLE `questions` CHANGE `ponderation` `ponderation` FLOAT(11,2) NULL DEFAULT NULL");
Database::get()->query("ALTER TABLE `reponses` CHANGE `ponderation` `ponderation` FLOAT(5,2) NULL DEFAULT NULL");
// not needed anymore
echo delete_table('mc_scoring');
if (accueil_tool_missing($code, 'MODULE_ID_UNITS')) {
Database::get()->query("INSERT INTO accueil VALUES (
'27',
'" . $global_messages['langCourseUnits'][$lang] . "',
'../../modules/units/index.php',
'description',
'2',
'0',
'',
'MODULE_ID_UNITS')");
}
// upgrade lp_module me to kainourio content type
Database::get()->query("ALTER TABLE `lp_module`
CHANGE `contentType` `contentType` ENUM('CLARODOC','DOCUMENT','EXERCISE','HANDMADE','SCORM','SCORM_ASSET','LABEL','COURSE_DESCRIPTION','LINK')");
Database::get()->query("ALTER TABLE `liens` CHANGE `url` `url` VARCHAR(255) DEFAULT NULL");
Database::get()->query("ALTER TABLE `liens` CHANGE `titre` `titre` VARCHAR(255) DEFAULT NULL");
// indexes creation
add_index('optimize', 'lp_user_module_progress', 'user_id', 'learnPath_module_id');
add_index('actionsindex', 'actions', 'module_id', 'date_time');
}
