← Back
Editing: persone_dup.php
<?php require_once ("../funct.php"); require_once ("sess.php"); require_once ("conn.php"); $ptitolo = "TEST"; require_once ("testacoda.php"); $query = new doQuery(); foreach ($_POST['sql'] AS $sqlT) { echo $sqlT; if ($sqlT) { $sqlAr = explode (';', $sqlT); foreach ($sqlAr AS $sql) $query->freeQuery ($sql, 0); } } $sql = stripslashes ($_POST['sql0']); if (strlen ($sql) > 45) { echo "<br />$sql"; $query->freeQuery ($sql, 0); } $sql = "SELECT * FROM `persone` WHERE 1 ORDER BY `cognome`, `nome`, `id`"; $row = $query->freeQuery ($sql, 3); for ($j=0; $j<count ($row); $j++) { if ($row[$j][1].$row[$j][3].$row[$j][4].$row[$j][6].$row[$j][26] == $row[$j-1][1].$row[$j-1][3].$row[$j-1][4].$row[$j-1][6].$row[$j-1][26]) { $elenco.= "<tr>"; for ($i=0; $i<count($row[$j])-1; $i++) if ($i != 7 && $i != 15) $elenco.= "<td nowrap>".$row[$j-1][$i]."</td>"; $elenco.= "</tr><tr>"; for ($i=0; $i<count($row[$j])-1; $i++) if ($i != 7 && $i != 15) $elenco.= "<td nowrap>".$row[$j][$i]."</td>"; $elenco.= "</tr> <tr><td colspan=20><b><i>SELECT `cognome`, `nome`, `presenze`.* FROM `presenze`, `persone` WHERE `persone`.`id`=`id_persona` AND (`id_persona` = ".$row[$j-1][0]." OR `id_persona` = ".$row[$j][0].");<br /> <input type=\"radio\" name=\"sql[$j]\" value=\"UPDATE `presenze` SET `id_persona` = ".$row[$j-1][0]." WHERE `id_persona` = ".$row[$j][0].";UPDATE `conti` SET `id_persona` = ".$row[$j-1][0]." WHERE `id_persona` = ".$row[$j][0].";DELETE FROM `persone` WHERE `id` = ".$row[$j][0]."\">Mantieni ".$row[$j-1][0]."<br /> <input type=\"radio\" name=\"sql[$j]\" value=\"UPDATE `presenze` SET `id_persona` = ".$row[$j][0]." WHERE `id_persona` = ".$row[$j-1][0].";UPDATE `conti` SET `id_persona` = ".$row[$j][0]." WHERE `id_persona` = ".$row[$j-1][0].";DELETE FROM `persone` WHERE `id` = ".$row[$j-1][0]."\">Mantieni ".$row[$j][0]."</td></tr>"; } } echo " <form method=\"post\"> <input type=\"submit\" value=\"esegui\"> <input type=\"text\" name=\"sql0\" size=\"80\" value=\"UPDATE `persone` SET ='' WHERE `id`=\"> <table><tr><td>id</td><td><b>id_ut</td><td><b>id_sogg</td><td><b>nome</td><td><b>cognome</td><td><b>sesso</td><td><b>data_nasc</td><td><b>comune_nasc</td><td><b>stato_nasc</td><td><b>cittadinanza</td><td><b>indirizzo</td><td><b>cap</td><td><b>citta</td><td><b>comune_res</td><td><b>stato_res</td><td><b>docum_tipo</td><td><b>docum_num</td><td><b>docum_data</td><td><b>docum_rilasc</td><td><b>telefono</td><td><b>fax</td><td><b>email</td><td><b>data_iscr</td><td><b>tipo</td><td><b>stato</td></tr> $elenco </table> </form>"; ?>
Save File
Cancel