<?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">
<?php
require_once 'db_connect.php';
require_once 'cruds.php';
$db = new DB_CONNECT();
$cruds = new CRUDS();
$sender = $_GET['id'];
// mysql selecting rows with matching caracters
$query = "SELECT * FROM `es` WHERE id={$sender}";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
?>
<form class="form-horizontal" method="POST" id="f" action="update.php" role="form">
<div class="alert alert-success alert-dismissable" id="alertbox" style="display:none;">
<button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
<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'] != "") {
<!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries -->
<!--[if lt IE 9]>
<script src="html5shiv.js"></script>
<script src="respond.min.js"></script>
<![endif]-->
</head>
<body>
<?php
// include db connect class
require_once 'db_connect.php';
require_once 'cruds.php';
// connecting to db
$db = new DB_CONNECT();
$cruds = new CRUDS();
$id = $_GET['id'];
$query = "SELECT * FROM `es` WHERE id={$id}";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$prix = 0;
?>
<div class="container">
<div >
<table style="width :100%;" >
<tr>
<td>
<h3><font color="#000">Expres</font><span class="text-muted">Service Multimedia</span> <span style="float:right;" class="text-info">FACTURE</span></h3>
<hr/>
</td>
$mdp = $_POST['mdp'];
$marq = $_POST['marq'];
$pan = $_POST['pan'];
$devis = $_POST['pre'];
$delai = $_POST['delai'];
$op = $_POST['op'];
$max = 9999;
$min = 100;
$ref = floor(rand() * ($max - $min + 1)) + $min;
$ref = $ref + rand($ref - rand($max / 4, $min / 2), 50);
date_default_timezone_set("Europe/Paris");
$datess = date("d-m-Y h:m");
require_once 'db_connect.php';
require_once 'cruds.php';
$db = new DB_CONNECT();
$cruds = new CRUDS();
$query = "\n INSERT INTO `db528031369`.`es` \n (`id`, `agent`, `dates`, `nom`, `model`, `imei`, `mdp`, `tel`, `etat`, `ref`, `sauv`, `marq`, `op`, `pan`, `devis`, `delai`) \n VALUES \n (NULL, '{$agent}', '{$datess}', '{$nom}', '{$mod}', '{$imei}', '{$mdp}', '{$tel}', '{$etat}', '{$ref}',NULL, '{$marq}', '{$op}', '{$pan}', '{$devis}', '{$delai}')";
mysql_query($query) or die(mysql_error());
/******* Manage Sauv ***********/
$query = "SELECT sauv FROM es WHERE ref='{$ref}'";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$sauv = $row['sauv'];
$result = $cruds->getAll("sauvegarde");
while ($row = mysql_fetch_array($result)) {
$v = $row['nom'];
$v = preg_replace('/\\s+/', '', $v);
if (isset($_POST[$v])) {
if (!empty($_POST[$v]) && $_POST[$v] != null) {
$sauv = $sauv . " " . $_POST[$v];
$query = "UPDATE es SET sauv='{$sauv}' WHERE ref='{$ref}'";
<?php
// include db connect class
require_once 'db_connect.php';
require_once 'cruds.php';
// connecting to db
$db = new DB_CONNECT();
$cruds = new CRUDS();
$sender = $_GET['sender'];
if ($sender == "1" || $sender == 1) {
return;
}
$nom = $_GET['search'];
echo $nom;
// mysql selecting rows with matching caracters
$query = "SELECT * FROM `es` WHERE nom LIKE '%' '{$nom}' '%' OR agent LIKE '%' '{$nom}' '%' OR imei LIKE '%' '{$nom}' '%' \n OR ref LIKE '%' '{$nom}' '%'";
$result = mysql_query($query) or die(mysql_error());
?>
<?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;
<?php
$devis = $_POST['pre'];
$delai = $_POST['delai'];
$diag = $_POST['diag'];
$con = $_POST['con'];
$statu = $_POST['statu'];
$id = $_POST['id'];
$pay = $_POST['pay'];
require_once 'db_connect.php';
require_once 'cruds.php';
$db = new DB_CONNECT();
$cruds = new CRUDS();
$query = "\n UPDATE `db528031369`.`es` SET\n devis='{$devis}',\n delai='{$delai}',\n diag='{$diag}',\n con='{$con}',\n status='{$statu}',\n pay='{$pay}' WHERE id={$id}";
mysql_query($query) or die(mysql_error());
/********** Point de Control *************/
$result = $cruds->getAll("pointC");
$id_es = $id;
$cruds->deleteByEs("es_pc", $id_es);
while ($row = mysql_fetch_array($result)) {
$v = $row['nom'];
$v = preg_replace('/\\s+/', '', $v);
$v_id = $row['id'];
if (isset($_POST[$v])) {
if (!empty($_POST[$v]) && $_POST[$v] != null) {
$v_stat = $_POST[$v];
$query = "\n\t\t\t\t\t\tINSERT INTO `db528031369`.`es_pc` \n\t\t\t\t\t\t(`id` , `id_es` , `id_pc`, `stat`)\n\t\t\t\t\t\tVALUES \n\t\t\t\t\t\t(NULL , '{$id_es}', '{$v_id}', '{$v_stat}')";
mysql_query($query) or die(mysql_error());
}
}
}
