<?php
require_once 'db_connect.php';
require_once 'cruds.php';
$db = new DB_CONNECT();
$cruds = new CRUDS();
$process = $_GET['process'];
$table = $_GET['table'];
switch ($process) {
case "1":
$id = $_GET['id'];
$result = $cruds->get($table, $id);
display($result, $table);
break;
case "2":
$id = $_GET['id'];
$cruds->delete($table, $id);
break;
default:
$result = $cruds->getAll($table);
display($result, $table);
break;
}
function display($result, $table)
{
switch ($table) {
case "users":
$i = 0;
if ($_GET['list'] == "1") {
?>
<select class="form-control" name="agent">
<table class="tables" style="width :100%; border-color: #CACACA;" border="1" >
<tr style="background-color:#f5f5f5;">
<td ><h5><b>Point de Controle</b></h5></td>
<td ><h5><b>Fonctione</b></h5></td>
<td ><h5><b>Prix</b></h5></td>
</tr>
<tr>
<td >
<?php
$res_es_pc = $cruds->getByIdEs("es_pc", $row['id']);
?>
<ul style="list-style:none;">
<?php
while ($res_es_pc_row = mysql_fetch_array($res_es_pc)) {
if ($res_es_pc_row['stat'] == "2") {
$res = $cruds->get("pointC", $res_es_pc_row['id_pc']);
$res_es_pc_row_row = mysql_fetch_array($res);
$r_nom = $res_es_pc_row_row['nom'];
?>
<li><?php
echo $r_nom;
?>
</li>
<?php
}
}
?>
<?php
$q = "SELECT * FROM pointC WHERE id NOT IN (SELECT id_pc FROM es_pc WHERE id_es='{$id}' AND stat='2')";
$res_es_pc = mysql_query($q) or die(mysql_error());
<strong>Succès!</strong> Dépôt mise à jour.
</div>
<div class="row">
<div class="col-md-5">
<hr/>
<input name="id" value="<?php
echo $row['id'];
?>
" type="hidden"/>
<div class="form-group">
<label for="agent" class="col-sm-4 control-label">Agent</label>
<div class="col-sm-8">
<div id="agent">
<?php
if ($row['agent'] != null || $row['agent'] != "") {
$result = $cruds->get("users", $row['agent']);
$tmprow = mysql_fetch_array($result);
echo " " . $tmprow['nom'];
}
?>
</div>
</div>
</div>
<h5 class="text-muted">Information du client</h5>
<hr/>
<div class="form-group">
<label for="nomclient" class="col-sm-4 control-label">Nom</label>
<div class="col-sm-8">
<?php
echo " " . $row['nom'];
<?php
// check for empty result
if (mysql_num_rows($result) > 0) {
// looping through all results
$i = 0;
while ($row = mysql_fetch_array($result)) {
$i++;
?>
<tr>
<td><?php
echo $i;
?>
</td>
<td><?php
$r = $cruds->get("users", $row['agent']);
$tmprow = mysql_fetch_array($r);
echo $tmprow['nom'];
?>
</td>
<td><?php
echo $row['nom'];
?>
</td>
<td><?php
echo $row['tel'];
?>
</td>
<td><?php
echo $row['imei'];
?>
