|
|
Posted by Dejan on 04/10/06 03:43
This is true help, thank you very much
Dejan.
Jerry Stuckle <jstucklex@attglobal.net> wrote in message
news:MYednUoJOpnKoafZnZ2dnUVZ_uidnZ2d@comcast.com...
> Dejan 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();
> > ?>
> >
> >
>
> You'll need to fetch the rows first, then delete. For instance - if `id`
is the
> primary key to your table:
>
> foreach($checkbox as $del_id) { // Personal preference - I like foreach
> $query = "select pictr0, pictr1, pictr2, pictr3 from $tblname where
id=$del_id";
> $result = mysql_query($query);
> if ($result && mysql_num_rows > 0) {
> $pics = mysql_fetch_array($result);
> unlink($pictr0);
> unlink($pictr1);
> unlink($pictr2);
> unlink($pictr3);
> $query = "DELETE FROM $tblname WHERE id='$del_id'";
> $result = mysql_query($query);
> echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete.php\">";
> }
> else
> if ($result == null)
> echo "Error fetching data: " . mysql_error();
> else
> echo "No data returned";
>
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================
[Back to original message]
|