function construire_tableau($theme = 0, $pertinence = 0, $diff = 0, $nbQuestions)
{
$connexion = connect($host, $port, $user, $password, $database);
//On récupère un recordset correspondant aux critères
$query = "SELECT Q.noq, Q.question, Q.reponse " . "FROM questions Q";
/* ", sujets S, themes T, pertinences P, difficultes D ".
"WHERE Q.noq = S.noq AND S.theme = T.theme AND ".
"S.pertinence = P.pertinence AND S.difficulte = D.difficulte".
"AND S.theme = ". $theme ." AND S.pertinence = ". $pertinence ." AND S.difficulte = ". $diff .";";
*/
$result = exec_query($connexion, $query);
$Nbr = numrows($result);
echo "Nombre d'enregistrements : " . $Nbr . "<BR>";
//Organisation aléatoire des questions
$ints = range(0, $Nbr - 1);
srand(time());
shuffle($ints);
if ($Nbr < $nbQuestions) {
$nbQuestions = $Nbr;
}
// On construit le tableau permettant de trier aléatoirement
for ($i = 0; $i < $nbQuestions && ($row = fetch_array($result, $ints[$i])); $i++) {
echo "libelle Q : " . $row[1] . "<BR>";
$tabQ[$i][0] = $row[0];
// recuperation du numero,
$tabQ[$i][1] = $row[1];
// du libelle,
$tabQ[$i][2] = $row[2];
// de la reponse a la question
}
close($connexion);
return $tabQ;
}
function listOptionsLabel($dataset, $choixdef)
{
global $database;
$query = "SELECT * FROM " . $dataset;
$result = exec_query($database, $query);
$Nbr = numrows($result);
for ($i = 0; $i < $Nbr; $i++) {
$tablo[$i] = fetch_array($result, $i);
}
if ($Nbr > 2) {
sort($tablo);
}
echo "<select name=liste_" . $dataset . ">\n";
for ($i = 0; $i < $Nbr; $i++) {
list($cle, $label) = $tablo[$i];
if ($cle == $choixdef) {
echo " <option selected>" . $cle . " = " . $label . "</option>\n";
} else {
echo " <option>" . $cle . " = " . $label . "</option>\n";
}
}
echo "</select>\n";
return 1;
}
# BACA DATA DALAM FORM, masukkan datake variabel
$errMsg = "";
$idAlat = secure(trim($_POST['idAlat']));
$namaAlat = strtoupper(secure(trim($_POST['namaAlat'])));
$lokasi = secure(trim($_POST['lokasi']));
$kategori = secure(trim($_POST['kategori']));
$kondisi = secure(trim($_POST['kondisi']));
$ketersediaan = secure(trim($_POST['ketersediaan']));
# SIMPAN DATA KE DATABASE.
// Jika tidak menemukan error, simpan data ke database
//$kodeBaru = buatKode("ma_barang", "");
//$txtPassword2 = MD5($password);
//Periksa apakah nM barang sudah ada atau belum ?
$qri = "SELECT * FROM alat WHERE nama_alat='{$namaAlat}'";
$res = querydb($qri);
$row = numrows($res);
if ($row < 1) {
//nama barang belum ada -> insert
$sql = "INSERT INTO alat (id_alat, nama_alat, lokasi,kategori,kondisi,ketersediaan)\n\t\t\t\t\tVALUES ('{$idAlat}', '{$namaAlat}','{$lokasi}','{$kategori}','{$kondisi}','{$ketersediaan}')";
$res = querydb($sql);
if ($res) {
$errMsg .= "<div class=\"alert alert-success alert-dismissible\" role=\"alert\">";
$errMsg .= "<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-label=\"Close\"><span aria-hidden=\"true\">×</span></button>";
$errMsg .= "SUKSESS !!! Data sudah disimpan !!!";
$errMsg .= "</div>";
} else {
$errMsg .= "<div class=\"alert alert-danger alert-dismissible\" role=\"alert\">";
$errMsg .= "<button type=\"button\" class=\"close\" data-dismiss=\"alert\" aria-label=\"Close\"><span aria-hidden=\"true\">×</span></button>";
$errMsg .= "GAGAL !!! Data tidak bisa disimpan !!!";
$errMsg .= "</div>";
}
$posisi = 0;
$halaman = 1;
} else {
$posisi = ($halaman - 1) * $batas;
}
if (isset($_GET['booking'])) {
$booking = $_GET['booking'];
}
if (empty($booking)) {
$qri = "SELECT * FROM peminjaman";
$hsl = querydb($qri);
} else {
$qri = "SELECT * FROM peminjaman WHERE status = '-'";
$hsl = querydb($qri);
}
$jml_data = numrows($hsl);
$jml_hal = ceil($jml_data / $batas);
if ($jml_hal > 20) {
$jml_hal = 20 and $batas = ceil($jml_data / $jml_hal);
$posisi = ($halaman - 1) * $batas;
}
$file = "pagecontrol.php?open=peminjaman";
?>
<div class="row" id="tabelpeminjaman">
<div class="panel panel-primary">
<div class="panel-heading"><span class="glyphicon glyphicon-book"></span> DAFTAR PEMINJAMAN ALAT</div>
<div class="panel-body">
<p><a class="btn btn-info btn-sm" id="btnPeminjamanTambah" href="peminjaman_addpage.php">Pinjam Alat</a>
<a class="btn btn-default btn-sm" id="btnPeminjamanTambah" href="peminjaman.php?booking=1">Daftar Booking Alat</a></p>
<div class="table-responsive">
?>
<table width=70% bgcolor="#FFC38B" cellpadding=5>
<tr><td width=100%><center><h3>
<?php
echo $questions[$numQuestion][1] . "<BR><BR>";
?>
</h3></center></td></tr>
<?php
// On recupere les differents choix proposes
$connexion = connect($host, $port, $user, $password, $database);
# connect to the database
$query = "SELECT choix FROM choix WHERE noq={$questions[$numQuestion]}[0];";
$result = exec_query($connexion, $query);
$nbEnr = numrows($result);
// S'il n'y a aucun choix
if ($nbEnr == 0) {
?>
<tr><td><CENTER><B>Aucun proposition pour cette question</B></CENTER></td></tr>
<?php
exit;
}
for ($i = 0; $i < $nbEnr && ($row = fetch_array($result, $i)); $i++) {
$tabChoix[$i] = $row[0];
?>
<tr><td><input type="checkbox" name="choix" value="<?php
$row[0];
?>
"></td></tr>
function getrecord($table, $id)
{
global $mysqli;
$query = "SELECT * FROM " . $table . " WHERE id = '" . intval($id) . "' LIMIT 1";
if (numrows($query)) {
$res = mysqli_query($mysqli, $query);
$row = mysqli_fetch_assoc($res);
return $row;
} else {
return false;
}
}
<?php
$_SESSION['pagingid'] = '';
if ($page == "") {
$page = 1;
}
$from = ($page - 1) * $record_per_page;
$cnt = $from;
$total_pages = 0;
$total_record = numrows($sql);
//echo $total_record;
if ($total_record > 0) {
$total_pages = $total_record / $record_per_page;
$total_pages = Ceil($total_pages);
$total_page_set = $total_pages / $page_per_set;
$total_page_set = Ceil($total_page_set);
$sql = $sql . " limit " . $from . "," . $record_per_page;
}
