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; }