Nuovo server, query non funzionano

**lelemkop** · 04-07-2018, 14:29

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 &nbsp;  <?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 &nbsp;<?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>

Discussione: Nuovo server, query non funzionano

Strumenti discussione

Ricerca discussione

Visualizza

Visualizzazione discussione

Permessi di invio