← Back
Editing: corr_ps.php
<?php require_once ("../funct.php"); require_once ("sess.php"); require_once ("conn.php"); require_once ("class.php"); $ieri = date ("Y-m-d", time()-(3600*24)+$deltaT); $altroieri = date ("Y-m-d", time()-(3600*48)+$deltaT); $idPres = $_REQUEST['idPres']; $query = new doQuery (); if ($idPres) { $sqlD = "UPDATE `presenze` SET `data_in` = '".$altroieri." 22:59:59' WHERE `id` = ".$idPres; $query->freeQuery ($sqlD, 0); echo "<h3>".$sqlD."</h3> <a href=\"modulo_ps2.php\">Verifica le PS</a>"; } $sql = "SELECT `presenze`.`id` as idPres, `cognome`, `nome`, `id_contratto`, `id_persona`, `data_in`, `tipo_all`, `tipo_pers` FROM `presenze` JOIN `persone` ON `persone`.`id` = `id_persona` WHERE `presenze`.`id_utente`=".$id_utente." AND `data_in` LIKE '".$ieri."%' ORDER BY `data_in` ASC"; $rows = $query->freeQuery ($sql, 0); foreach ($rows as $i=>$row) { $elenco.= "<tr><td>".$row->cognome."</td><td>".$row->nome."</td> <td>".$row->id_persona."</td><td>".$row->id_contratto." </td> <td><a href=\"".$_SERVER['PHP_SELF']."?idPres=".$row->idPres."\" title=\"gestisci data ".$row->cognome."\">".$row->data_in."</a> </td> <td>".$row->tipo_all."</td> <td>".$row->tipo_pers."</td></tr>"; } echo "<h3>".$ieri."</h3><table> $elenco </table>"; ?>
Save File
Cancel