Queste sono le tre pagine complete
Codice PHP:
<?php//action.phpinclude ("{$_SERVER['DOCUMENT_ROOT']}/archivio/crud.php");$object = new Crud();if(isset($_POST["action"])){ if($_POST["action"] == "Load") { $record_per_page = 1000; $page = '';
if(isset($_POST["page"])) { $page = $_POST["page"]; } else { $page = 1; } $start_from = ($page - 1) * $record_per_page;
echo $object->get_data_in_table("SELECT * FROM registro ORDER BY data desc, id DESC LIMIT $start_from, $record_per_page"); echo '<br /><div align="center">'; echo $object->make_pagination_link("SELECT * FROM registro ORDER by data desc, id desc", $record_per_page); echo '</div><br />';
} if($_POST["action"] == "Insert") { $id = mysqli_real_escape_string($object->connect, $_POST["id"]); $data = mysqli_real_escape_string($object->connect, $_POST["data"]); $categoria = mysqli_real_escape_string($object->connect, $_POST["categoria"]); $cognome = mysqli_real_escape_string($object->connect, $_POST["cognome"]); $data_nascita = mysqli_real_escape_string($object->connect, $_POST["data_nascita"]); $motivo = mysqli_real_escape_string($object->connect, $_POST["motivo"]); $protocollo = mysqli_real_escape_string($object->connect, $_POST["protocollo"]); $assegnazione = mysqli_real_escape_string($object->connect, $_POST["assegnazione"]); $query = " INSERT INTO registro (data, categoria, cognome, data_nascita, motivo, protocollo, assegnazione) VALUES ('".$data."', '".$categoria."', '".$cognome."', '".$data_nascita."', '".$motivo."', '".$protocollo."', '".$assegnazione."')"; $object->execute_query($query); $id = mysqli_insert_id(); $result1 = " INSERT INTO assegna (id, assegnazione) VALUES (LAST_INSERT_ID(), '".$assegnazione."')";$object->execute_query($result1); echo 'DATI INSERITI'; } if($_POST["action"] == "Fetch Single Data") { $output = ''; $query = "SELECT * FROM registro WHERE id = '".$_POST["id"]."'"; $result = $object->execute_query($query); while($row = mysqli_fetch_array($result)) {
$output["data"] = $row['data']; $output["categoria"] = $row['categoria']; $output["cognome"] = $row['cognome']; $output["data_nascita"] = $row['data_nascita']; $output["motivo"] = $row['motivo']; $output["protocollo"] = $row['protocollo']; $output["assegnazione"] = $row['assegnazione']; } echo json_encode($output); }
if($_POST["action"] == "Edit") { $data = mysqli_real_escape_string($object->connect, $_POST["data"]); $categoria = mysqli_real_escape_string($object->connect, $_POST["categoria"]); $cognome = mysqli_real_escape_string($object->connect, $_POST["cognome"]); $data_nascita = mysqli_real_escape_string($object->connect, $_POST["data_nascita"]); $motivo = mysqli_real_escape_string($object->connect, $_POST["motivo"]); $protocollo = mysqli_real_escape_string($object->connect, $_POST["protocollo"]); $assegnazione = mysqli_real_escape_string($object->connect, $_POST["assegnazione"]); $query = "UPDATE registro SET data = '".$data."', categoria = '".$categoria."', cognome = '".$cognome."', data_nascita = '".$data_nascita."', motivo = '".$motivo."', protocollo = '".$protocollo."', assegnazione = '".$assegnazione."' WHERE id= '".$_POST["id"]."'"; $object->execute_query($query); $result2 = " INSERT INTO assegna ( id, assegnazione) SELECT id, assegnazione FROM registro where id = '" . $_POST["id"] . "'";$object->execute_query($result2); echo 'DATI AGGIORNATI'; } if($_POST["action"] == "Delete") { $query = "DELETE FROM fascicoli WHERE id_imm = '".$_POST["id_imm"]."'"; $object->execute_query($query); echo "Data Deleted"; } if($_POST["action"] == "Search") { $search = mysqli_real_escape_string($object->connect, $_POST["query"]); $query = " SELECT * FROM registro WHERE cognome LIKE '%".$search."%' or data_nascita LIKE '%".$search."%' OR motivo LIKE '%".$search."%' OR protocollo LIKE '%".$search."%' OR assegnazione LIKE '%".$search."%' ORDER BY id DESC "; $connection = mysqli_connect('localhost', '', '', 'archivio') or exit ($connection_error);
$result = mysqli_query($connection, $query); $num_rows = mysqli_num_rows($result);?> <h3 align="center">Totale ricerca <?php echo " $num_rows ";
echo $object->get_data_in_table($query); } }?>[PHP]
<?phpclass Crud{ //crud class public $connect; private $host = "localhost"; private $username = ''; private $password = ''; private $database = 'archivio';
function __construct() { $this->database_connect(); }
public function database_connect() { $this->connect = mysqli_connect($this->host, $this->username, $this->password, $this->database); }
public function execute_query($query) { return mysqli_query($this->connect, $query); }
public function get_data_in_table($query) { $output = ''; $result = $this->execute_query($query); $output .= ' <table id="anagrafica" class="table table-bordered table-striped"> <tr> <th >Data</th> <th width="10%">Categoria</th> <th width="30%">Cognome e Nome</th> <th width="30%">Data di Nascita</th> <th class="text-center" width="35%">Motivo</th> <th width="10%">Protocollo</th> <th width="35%">Assegnazione</th> <th width="10%">Aggiorna</th> <th width="10%">Precedenti</th> </tr> '; if(mysqli_num_rows($result) > 0) { while($row = mysqli_fetch_object($result)) { $oDate = new DateTime($row->data);$sDate = $oDate->format("d/m/Y"); $output .= ' <tr> <td>'.$sDate.'</td> <td align="center">'.$row->categoria.'</td> <td align="center">'.$row->cognome.'</td> <td align="center">'.$row->data_nascita.'</td> <td align="center">'.$row->motivo.'</td> <td align="center">'.$row->protocollo.'</td> <td align="center">'.$row->assegnazione.'</td> <td><button type="button" name="update" id="'.$row->id.'" class="btn btn-success btn-xs update">Aggiorna</button></td> <td align = center><a href=/archivio/fetch.php?id='.$row->id.'><img SRC=p.jpg ></a></td> </tr> '; } } else { $output .= ' <tr> <td colspan="5" align="center">No Data Found</td> </tr> '; } $output .= '</table>'; return $output; } function upload_file($file) { if(isset($file)) { $extension = explode('.', $file["name"]); $new_name = rand() . '.' . $extension[1]; $destination = './upload/' . $new_name; move_uploaded_file($file['tmp_name'], $destination); return $new_name; } }
function make_pagination_link($query, $record_per_page) { $output = ''; $result = $this->execute_query($query); $total_records = mysqli_num_rows($result); $total_pages = ceil($total_records/$record_per_page); for($i=1; $i<=$total_pages; $i++) { $output .= '<span class="pagination_link" style="cursor
ointer; padding:6px; border:1px solid #ccc;" id="'.$i.'">'.$i.'</span>'; } return $output; }}?>[/PHP]
Codice PHP:
<?phpinclude_once ("{$_SERVER['DOCUMENT_ROOT']}/archivio/dbconfig.php");if(!$user->is_loggedin()){ $user->redirect('index.php');}$user_id = $_SESSION['user_session'];$stmt = $DB_con->prepare("SELECT * FROM users WHERE user_id=:user_id");$stmt->execute(array(":user_id"=>$user_id));$userRow=$stmt->fetch(PDO::FETCH_ASSOC);?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><link rel="stylesheet" href="bootstrap/css/bootstrap.min.css" type="text/css" /><link rel="stylesheet" href="style.css" type="text/css" /><title>Benvenuto - <?php print($userRow['user_email']); ?></title><div class="content">Benvenuto : <?php print($userRow['user_name']); ?></div></body></html><?phpinclude ("{$_SERVER['DOCUMENT_ROOT']}/archivio/crud.php");$object = new Crud();?><html>
<body> <script > document.getElementById('data').value = (new Date()).format("yyyy-mm-dd");</script><a href=index.php><h2 align ="left">logout</a></h2> <div class="container box">
<h3 align="center">Cartellini numero <?php $mysqli = new mysqli("localhost","", "", "archivio");
$query = $mysqli->prepare("SELECT * FROM registro");$query->execute();$query->store_result();
$rows = $query->num_rows;
echo $rows;
?>
</h3><br /><br /> <div class="col-md-8"> <button type="button" name="add" id="add" class="btn btn-success" data-toggle="collapse" data-target="#user_collapse">Aggiungi</button> </div> <div class="col-md-4"> <input type="text" name="search" id="search" placeholder="Cerca" class="form-control" /> </div> <br /> <br /> <div id="user_collapse" class="collapse"> <form method="post" id="user_form"> <label>Data</label> <input type="text" name="data" id="data" class="form-control" value="<?php echo date('Y-m-d'); ?>"/> <br /> <label>Categoria</label> <input type="text" name="categoria" id="categoria" class="form-control" onchange="this.value = this.value.toUpperCase( );"/> <br /> <label>Cognome e Nome</label> <input type="text" name="cognome" id="cognome" class="form-control" onchange="this.value = this.value.toUpperCase( );"/> <br /> <label>Data di Nascita</label> <input type="text" name="data_nascita" id="data_nascita" class="form-control" placeholder="Inserire data GG/MM/AAAA" pattern ="([0-9]{1,2}.[0-9]{1,2}.[0-9]{4})" /> <br /> <label>Motivo</label> <input type="text" name="motivo" id="motivo" class="form-control" onchange="this.value = this.value.toUpperCase( );" /> <br /> <label>Protocollo</label> <input type="text" name="protocollo" id="protocollo" class="form-control" onchange="this.value = this.value.toUpperCase( );"/> <br /> <label>Assegnazione \ Scarico</label> <input type="text" name="assegnazione" id="assegnazione" class="form-control" onchange="this.value = this.value.toUpperCase( );"/> <br /> <div align="center"> <input type="hidden" name="action" id="action" /> <input type="hidden" name="id" id="id" /> <input type="submit" name="button_action" id="button_action" class="btn btn-default" value="Insert" /> </div> </form> </div> <br /><br /> <div id="registro" class="table-responsive"> </div> </div> </body></html>
<script type="text/javascript"> $(document).ready(function(){
load_data();
$('#action').val("Insert");
$('#add').click(function(){ $('#user_form')[0].reset(); $('#button_action').val("Insert"); }); function load_data(page) { var action = "Load"; $.ajax({ url:"action.php", method:"POST", data:{action:action, page:page}, success:function(data) { $('#registro').html(data); } }); }
$(document).on('click', '.pagination_link', function(){ var page = $(this).attr("id"); load_data(page); });
$('#user_form').on('submit', function(event){ event.preventDefault(); var data = $('#data').val(); var categoria = $('#categoria').val(); var cognome = $('#cognome').val(); var data_nascita = $('#data_nascita').val(); var motivo = $('#motivo').val(); var protocollo = $('#protocollo').val(); var assegnazione = $('#assegnazione').val(); if(cognome != '' && categoria != '') { $.ajax({ url:"action.php", method:"POST", data:new FormData(this), contentType:false, processData:false, success:function(data) { alert(data); $('#user_form')[0].reset(); load_data(); $('#action').val("Insert"); $('#button_action').val("Insert"); } }) } else { alert("Both Fields are Required"); } });
$(document).on('click', '.update', function(){ var id = $(this).attr("id"); var action = "Fetch Single Data"; $.ajax({ url:"action.php", method:"POST", data:{id:id, action:action}, dataType:"json", success:function(data) { $('.collapse').collapse("show"); $('#id').val(data.id); $('#data').val(data.data); $('#categoria').val(data.categoria); $('#cognome').val(data.cognome); $('#data_nascita').val(data.data_nascita); $('#motivo').val(data.motivo); $('#protocollo').val(data.protocollo); $('#assegnazione').val(data.assegnazione); $('#button_action').val("Edit"); $('#action').val("Edit"); $('#id').val(id); } }); }); else { return false; } }); $('#search').keyup(function(){ var query = $('#search').val(); var action = "Search"; if(query != '') { $.ajax({ url:"action.php", method:"POST", data:{query:query, action:action}, success:function(data) { $('#registro').html(data); } }); } else { load_data(); } }); });</script>
Rispondi quotando
