<?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()); } } }