|
|
Posted by Dejan on 04/10/06 01:34
I know about this two functions.
I'm looking for a way to implement something like this:
When i'm deleting row, script select's this 4 coloumns form that row first,
put's it into an array.
Then i have file names in array, and i cann delete (unlink etc.) them, and
the row.
I understend that, buth i don't know how to implement it in this delete
loop.
Dejan
<haggis@_your_teeth_nerdshack.com> wrote in message
news:5a8f32d42lh1tb2lb1uij46ig1ocfh1cg6@4ax.com...
> 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]
|