|
|
Posted by haggis on 10/13/72 11:44
On Sat, 8 Apr 2006 12:34:20 +0200, "Dejan"
<ddundov_REMOVE_@veleri.hr> wrote:
>>>Hy,
>>>
>>>Sorry for my terreble english
>>>
>>>I have this simple code for deleting rows in mysql table...
>>>Everything works fine with it.
>>>So, what do i wanna do...:
>>>my sql table looks something like this:
>>>id Name Surname pictr0 picrt1 pictr2
>>>pictr3
>>>1 Ivan Johnes 1.jpg 120.jpg 111.jpg
>>>pic11.jpg
>>>2 John Doe 2.jpg pic123.jpg img13.jpg
>>>pic12.jpg
>>>
>>>images (pictr0, pictr1...) are located in images/ folder..., and when i
>>>delete one row i wanna pictures deleted too.
>>>I have used this script, buth i realised i'm only deleting data in sql
>>>tabel, and images are filling my web hosting space.
>>>Any ideas?
>>>
>>>Tnx in advance
>>>Dejan
>>>----------------------------------------
>>>
>>><?php
>>>$host="localhost"; // Host name
>>>$username="xyxxx"; // Mysql username
>>>$password="xxxxx"; // Mysql password
>>>$db_name="delete"; // Database name
>>>$tbl_name="test_mysql"; // Table name
>>>
>>>// Connect to server and select databse.
>>>mysql_connect("$host", "$username", "$password")or die("cannot connect");
>>>mysql_select_db("$db_name")or die("cannot select DB");
>>>
>>>$sql="SELECT * FROM $tbl_name";
>>>$result=mysql_query($sql);
>>>
>>>$count=mysql_num_rows($result);
>>><table width="400" border="0" cellspacing="1" cellpadding="0">
>>><tr>
>>><td><form name="form1" method="post" action="">
>>><table width="400" border="0" cellpadding="3" cellspacing="1"
>>>bgcolor="#CCCCCC">
>>><tr>
>>><td bgcolor="#FFFFFF"> </td>
>>><td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in
>>>mysql</strong> </td>
>>></tr>
>>><tr>
>>>.
>>>.(simple html code)
>>>.
>>></tr>
>>><?php
>>>while($rows=mysql_fetch_array($result)){
>>>?>
>>><tr>
>>><td align="center" bgcolor="#FFFFFF"><input name="checkbox[]"
>>>type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
>>><td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
>>><td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
>>><td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
>>><td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
>>></tr>
>>><?php
>>>}
>>>?>
>>><tr>
>>><td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete"
>>>type="submit" id="delete" value="Delete"></td>
>>></tr>
>>><?
>>>// Check if delete button active, start this
>>>if($delete){
>>>for($i=0;$i<$count;$i++){
>>>$del_id = $checkbox[$i];
>>>$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
>>>$result = mysql_query($sql);
>>>}
>>>
>>>// if successful redirect to delete_multiple.php
>>>if($result){
>>>echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete.php\">";
>>>}
>>>}
>>>mysql_close();
>>>?>
>>>
Have a look at this -
http://uk.php.net/file_exists
and then
http://uk.php.net/unlink
Remove _your_teeth_ to reply.
[Back to original message]
|