note 70523 added to function.unlink
| From: | GonzaloAguirre at osu1 dot php dot net | Date: | Thu, 19 Oct 2006 15:29:18 +0000 |
| Subject: | note 70523 added to function.unlink | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-118774@lists.php.net to get a copy of this message | ||
most of PHP pages do not use blob type with images (or any kind of files), instead use link to them,
due to that integrity must be keep programing, so don't forget to unlink those references on
your database before delete it.
$logo_query = "select logo_link logo from company where id=".$id;
$logo_result = mysql_query($logo_query) or die ($query);
while( $row = mysql_fetch_array($logo_result, MYSQL_ASSOC) )
unlink( $row['logo'] );
$query = "delete from company where id=".$id;
enjoy it and happy integrity!!
----
Server IP: 130.206.1.5
Probable Submitter: 84.120.64.177
----
Manual Page -- http://www.php.net/manual/en/function.unlink.php
Edit -- https://master.php.net/note/edit/70523
Del: integrated -- https://master.php.net/note/delete/70523/integrated
Del: useless -- https://master.php.net/note/delete/70523/useless
Del: bad code -- https://master.php.net/note/delete/70523/bad+code
Del: spam -- https://master.php.net/note/delete/70523/spam
Del: non-english -- https://master.php.net/note/delete/70523/non-english
Del: in docs -- https://master.php.net/note/delete/70523/in+docs
Del: other reasons-- https://master.php.net/note/delete/70523
Reject -- https://master.php.net/note/reject/70523
Search -- https://master.php.net/manage/user-notes.php