function majStatus($a_matos, $a_action) { $qry = "Select groupe from materiel where materielID = {$a_matos}"; $sqlCmdMatos = "update materiel set etat='{$a_action}' where materielID={$a_matos}"; $sqlCmdGroupe = "update materiel set etat='{$a_action}' where groupe={$a_matos}"; try { $db = new sqlite3($GLOBALS['dbaseName']); $result = $db->query($qry); $row = $result->fetchArray(); $group = $row[0]; if ($group == $a_matos) { $sqlCmd = $sqlCmdGroupe; } else { $sqlCmd = $sqlCmdMatos; } logMe("LIB : majStatus(\"{$sqlCmd}\")"); $db->exec($sqlCmd); $db->close(); } catch (Exception $e) { logme("ERROR : {$e}"); return; } }
<?php $tableToChange = 'pages'; $db = new sqlite3("content.db"); $rs = $db->query('select showDate, expDate, id from ' . $tableToChange . ' where date(showDate) > date(expDate)'); if ($rs) { while ($row = $rs->fetchArray()) { var_dump($row); echo "\n\n Fixing... \n\n"; $db->exec('update ' . $tableToChange . ' set showDate="' . $row['expdate'] . '", expDate="' . $row['showdate'] . '" where id=' . $row['id']); echo "Fixed"; } }