Codice PHP:
<?phpif (!isset($_SESSION)) { session_start();}
$Nome_tabella = 'anagrafica';
$filtro_livello = $_SESSION['MM_Auth_livello'];if ($filtro_livello < 3){ $limite_livello = 'id = '.$_SESSION['MM_Auth_id'].''; }else{ $limite_livello = 'id > 0'; }
//include("../connections/phpgotomysql.php");$db = new phpgotomysql();$db->getParams($config);$db->connect();
//=================================//INSERISCI //=================================if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "frm_inserisci")) { //************************* //da modificare //************************* $array_inserisci = array( 'id_auth' => $_POST["id"], 'nome' => $_POST["nome"], 'cognome' => $_POST["cognome"], 'cf' => $_POST["cf"], 'indirizzo' => $_POST["indirizzo"], 'citta' => $_POST["citta"], 'cap' => $_POST["cap"], 'note' => $_POST["note"], 'fax' => $_POST["fax"], 'mail' => $_POST["mail"], 'fisso' => $_POST["fisso"], 'cellulare' => $_POST["cellulare"], 'skype' => $_POST["skype"], 'web' => $_POST["web"], 'categoria' => $_POST["categoria"], 'attivita' => $_POST["attivita"], 'classificazione' => $_POST["classificazione"], 'stato' => $_POST["stato"], 'entita' => $_POST["entita"] );
$result_inserisci = $db->insert($Nome_tabella,$array_inserisci);
$VaiAllaPagina = "../index.php#ajax/gestione_clienti.php"; if (isset($_SERVER['QUERY_STRING'])) { $VaiAllaPagina .= (strpos($VaiAllaPagina, '?')) ? "&" : "?"; $VaiAllaPagina .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $VaiAllaPagina));
}
//=================================//MODIFICA //=================================if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "frm_modifica")) { //************************* //da modificare anche la variabile post in $result_modifica //************************* $array_modifica = array( 'id_auth' => $_POST["id"], 'nome' => $_POST["nome"], 'cognome' => $_POST["cognome"], 'cf' => $_POST["cf"], 'indirizzo' => $_POST["indirizzo"], 'citta' => $_POST["citta"], 'cap' => $_POST["cap"], 'note' => $_POST["note"], 'fax' => $_POST["fax"], 'mail' => $_POST["mail"], 'fisso' => $_POST["fisso"], 'cellulare' => $_POST["cellulare"], 'skype' => $_POST["skype"], 'web' => $_POST["web"], 'categoria' => $_POST["categoria"], 'attivita' => $_POST["attivita"], 'classificazione' => $_POST["classificazione"], 'stato' => $_POST["stato"], 'entita' => $_POST["entita"] );
$result_modifica = $db->update($Nome_tabella,$array_modifica,"id=".$_POST["id"].""); $VaiAllaPagina = "../index.php#ajax/gestione_clienti.php"; if (isset($_SERVER['QUERY_STRING'])) { $VaiAllaPagina .= (strpos($VaiAllaPagina, '?')) ? "&" : "?"; $VaiAllaPagina .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $VaiAllaPagina));echo 'ciao mondo';}
//=================================//CANCELLA //=================================if ((isset($_POST["MM_delete"])) && ($_POST["MM_delete"] == "frm_cancella")) { $result_cancella = $db->delete($Nome_tabella,"id=".$_POST["id"]."");
$VaiAllaPagina = "../index.php#ajax/gestione_clienti.php"; if (isset($_SERVER['QUERY_STRING'])) { $VaiAllaPagina .= (strpos($VaiAllaPagina, '?')) ? "&" : "?"; $VaiAllaPagina .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $VaiAllaPagina));
}
//=================================//VISUALIZZA //=================================$rs_auth = $db->query("SELECT * FROM ".$Nome_tabella." WHERE ".$limite_livello."");$row_rs_utenti = mysql_fetch_assoc($rs_auth);?>
<div class="row"> <div id="breadcrumb" class="col-md-12"> <ol class="breadcrumb"> <li><a href="index.php">Cruscotto</a></li> <li><a href="#">Clienti</a></li> <li><a href="ajax/gestione_cliente.php">Visualizza</a></li> </ol> </div></div>
<div class="row"> <div class="col-xs-12"> <div class="box"> <div class="box-header"> <div class="box-name"> <h4 class="page-header">Lista Clienti</h4> </div> <div class="box-icons"> <a class="collapse-link"> <i class="fa fa-chevron-up"></i> </a> <a class="expand-link"> <i class="fa fa-expand"></i> </a> <a class="close-link"> <i class="fa fa-times"></i> </a> </div> <div class="no-move"></div> </div> <div class="box-content no-padding table-responsive"> <table class="table table-bordered table-striped table-hover table-heading table-datatable" id="datatable-2"> <thead> <tr> <th><label><input type="text" name="search_azienda" value="Cerca Azienda" class="search_init" /></label></th> <th><label><input type="text" name="search_citta" value="Cerca Città" class="search_init" /></label></th> <th><label><input type="text" name="search_cellulare" value="Cerca Cellulare" class="search_init" /></label></th> <th><label><input type="text" name="search_categoria" value="Cerca Categoria" class="search_init" /></label></th> <th width="5"> </th> <th width="5"> </th> </tr> </thead> <tbody> <?php do { ?> <tr> <td><?php echo $row_rs_utenti['cognome']; ?></td> <td><?php echo $row_rs_utenti['citta']; ?></td> <td><?php echo $row_rs_utenti['cellulare']; ?></td> <td><?php echo $row_rs_utenti["categoria"];?></td> <td><form action="index.php?#ajax/cliente_modifica.php" method="get"> <button type="submit" class="btn btn-success" data-toggle="tooltip" title="Modifica utente"><i class="fa fa-save"></i></button> <input name="id_modifica" type="hidden" value="<?php echo $row_rs_utenti['id']; ?>" /> </form><td><form action="ajax/gestione_clienti.php" method="post" name="frm_cancella" onsubmit="return confirm('Vuoi cancellare il record?');"> <button type="submit" class="btn btn-danger" data-toggle="tooltip" title="Cancella utente"><i class="fa fa-times-circle"></i></button> <input name="id" type="hidden" value="<?php echo $row_rs_utenti['id']; ?>" /> <input name="MM_delete" type="hidden" value="frm_cancella" /> </form></td> </tr> <?php } while ($row_rs_utenti = mysql_fetch_assoc($rs_auth)); ?> </tbody> <tfoot> <tr> <th>Azienda</th> <th>Città</th> <th>Cellulare</th> <th>Categoria</th> <th> </th> <th> </th> </tr> </tfoot> </table> </div> </div> </div></div>
<script type="text/javascript">// Run Select2 plugin on elementsfunction DemoSelect2(){ $('#categoria').select2({placeholder: "Select OS"});
$('#attivita').select2({placeholder: "Select OS"});
$('#entita').select2({placeholder: "Select OS"});
$('#classificazione').select2({placeholder: "Select OS"});
$('#stato').select2({placeholder: "Select OS"});
}// Run timepickerfunction DemoTimePicker(){ $('#input_time').timepicker({setDate: new Date()});}$(document).ready(function() { // Create Wysiwig editor for textare TinyMCEStart('#wysiwig_simple', null); TinyMCEStart('#wysiwig_full', 'extreme'); // Add slider for change test input length FormLayoutExampleInputLength($( ".slider-style" )); // Initialize datepicker $('#input_date').datepicker({setDate: new Date()}); // Load Timepicker plugin LoadTimePickerScript(DemoTimePicker); // Add tooltip to form-controls $('.form-control').tooltip(); LoadSelect2Script(DemoSelect2); // Load example of form validation LoadBootstrapValidatorScript(DemoFormValidator); // Add drag-n-drop feature to boxes WinMove();});</script><script type="text/javascript">// Run Datables plugin and create 3 variants of settingsfunction AllTables(){ TestTable1(); TestTable2(); TestTable3(); LoadSelect2Script(MakeSelect2);}function MakeSelect2(){ $('select').select2(); $('.dataTables_filter').each(function(){ $(this).find('label input[type=text]').attr('placeholder', 'Cerca'); });}$(document).ready(function() { // Load Datatables and run plugin on tables LoadDataTablesScripts(AllTables); // Add Drag-n-Drop feature WinMove();});</script>