| 1 |
<?php |
| 2 |
function newsDelete($id) { |
| 3 |
if (!$id) return; |
| 4 |
global $dbh, $syspicdir; |
| 5 |
$sql = "SELECT pic FROM paragraphs WHERE (news_id = $id)"; |
| 6 |
$sth = $dbh->prepare($sql); |
| 7 |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
| 8 |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
| 9 |
while ($row = $sth->fetchrow_array()) MyDelete($syspicdir."/".$row[0]); |
| 10 |
$sth->finish(); |
| 11 |
$sql = "DELETE FROM paragraphs WHERE (news_id = $id)"; |
| 12 |
$dbh->dbh_do($sql); |
| 13 |
$sql = "SELECT title_pic FROM news WHERE (news_id = $id)"; |
| 14 |
$sth = $dbh->prepare($sql); |
| 15 |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
| 16 |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
| 17 |
while ($row = $sth->fetchrow_array()) MyDelete($syspicdir."/".$row[0]); |
| 18 |
$sth->finish(); |
| 19 |
$sql = "DELETE FROM cat_news WHERE (news_id = $id)"; |
| 20 |
$dbh->dbh_do($sql); |
| 21 |
$sql = "DELETE FROM spec_news WHERE (news_id = $id)"; |
| 22 |
$dbh->dbh_do($sql); |
| 23 |
$sql = "DELETE FROM news WHERE (news_id = $id)"; |
| 24 |
$dbh->dbh_do($sql); |
| 25 |
} |
| 26 |
?> |
Parent Directory
| 
Revision Log