Una funzione per pulire tutte le righe dove $key=$id in tabelle multiple.
< ?php
function purge_from_tables($id, $tbl_idx) {
foreach ($tbl_idx as $tbl => $key) {
if (!is_array($key)) {
$sql = "DELETE FROM %s WHERE %s=%s";
mysql_query(sprintf($sql, $tbl, $key, $id));
} else {
$sql = sprintf("DELETE FROM %s", $tbl);
$cnt = count($key);
$keys = array_keys($key);
for ($ii = 0; $ii < $cnt; $ii++) {
if ($ii == 0) {
$sql .= " WHERE ";
} else {
$sql .= " AND ";
}
$sql .= sprintf("%s=%s", $keys[$ii], $key[$keys[$ii]]);
}
mysql_query($sql);
}
}
return true;
}
?>
fonte: www.sastgroup.com
...leggi tutto»
RSS feeds