//Se l'utente non è loggato quindi non è valorizzata //la variabile $_SERVER['PHP_AUTH_USER'] allora richiamo il login include("auth.php"); include('ajaxpaginator.class.php'); define("DB_SERVER","62.149.150.59"); //localhost is usually fine unless your MySQL server resides on another machine define("DB_NAME","Sql151072_1"); //The name of your database define("DB_USER","Sql151072"); //The user for your database define("DB_PASSWORD","3fdf3000"); //The password for your database $conn = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD ,DB_NAME) ; $query = "SELECT * FROM preventivi WHERE is_archive ='N'"; $recordsPerPage = 30;//number of records per page // page number, records per page, sql query, and the mysqli connection object if(isset($_GET['page']) AND is_numeric($_GET['page']) ) { $pageid=$_GET['page']; } else{$pageid="1";} $paginator = new AjaxPaginator($pageid,$recordsPerPage,$query,$conn); $paginator->debug = false; try{ $rows = $paginator->paginate(); }catch (Exception $e){ echo $e->getMessage(); } $pageId= empty($_GET['page'])? 1:$conn->real_escape_string($_GET['page']); if(isset($_GET['mode']) && $_GET['mode']=="canc" && isset($_GET['id']) && is_numeric($_GET['id'])) { $query = "DELETE users WHERE id='".$_GET['id']."'"; if($query) { } } ?>
Id | Cliente | Pagato ? | Data emissione | Iva | Data pagamento | Edita | Elimina |
---|