← Back
Editing: test.php
<?php $urlBase = "/var/www/vhosts/smartmedia2000.it/httpdocs"; require_once ($urlBase."/booking/conn.php"); require_once ($urlBase."/funct.php"); require_once ($urlBase."/class_b.php"); $query = new output(); $sql = "SELECT * FROM `contratti` WHERE `id_utente` =21 AND `numero` LIKE '%/12' AND `tipo_contr` >1"; $rows = $query->freeQuery ($sql, 0); foreach ($rows as $row) { $sql0 = "SELECT * FROM presenze WHERE id_contratto=(SELECT id FROM `contratti` WHERE `id_utente` =21 AND `numero` LIKE '".substr ($row->numero, 0, strlen ($row->numero)-2)."11' AND `tipo_contr` >1) AND data_in LIKE '0000%'"; $rows0 = $query->freeQuery ($sql0, 0); foreach ($rows0 as $row0) { $sql2 = "INSERT INTO presenze (id_utente, id_contratto, id_persona, tipo_pers) VALUES (21, ".$row->id.", ".$row0->id_persona.", ".$row0->tipo_pers.")"; //$query->freeQuery ($sql2, 0); $echo.= $sql2."<br />"; } } echo $echo; ?>
Save File
Cancel