0

hi all,
i am having a page. where we can see list of files in a table and in every row download link is there.we can download that file by clicking on download link, so now i need a delete link also which deletes the selected file by using its fileid.i tried for it. but i am not getting. so please..i need it..
Thank u.

2
Contributors
4
Replies
5
Views
7 Years
Discussion Span
Last Post by etftw
0

Can you post the code that generates this table?

In the mean time try to copy and paste the code you use for the download links but replacing the download link field with fieldid.

If you can post the code up then I will edit it for you.

0
<html>
<body>
<meta http-equiv="refresh" content="7">

<link rel="stylesheet" type="text/css" href="style.css"/>
<form enctype="multipart/form-data" action="upload2.php" method="post">
<table>
<tr>
<td><img src="Logofinalcopy.gif"></td>

</tr>
</table><br><hr style="color: red;">
<table align="right"><tr> <td></td>
        <td align="right" style="color: navy;"><strong><?php echo "Welcome ".$_SESSION[username];?>,</strong></td>
    </tr></table><br/> 
    <table><tr><td> 
<tr>
	<td style="color: navy;">
		<strong>Please choose a file: </strong>
	</td> 
	<td>
		<input id="file" name="uploaded" type="file"><br>
    </td>
</tr>
<tr><td>
<input type="submit" value="Upload" name="btn" onclick="return check(),return doClear()"></td></tr>
</table>
<?php
ob_start();                                                                    
@session_start();
require_once ("check.php");
createsessions($username,$password,$userid,$projectid,$projectname,$filename,$size,$allocatedmemory,$answer,$usedmemory,$Remainingmemory,$result,$data3);
include 'connection.php';

 $sql= "select * from files where uploadedby='$_SESSION[username]' and projectname='$_SESSION[answer]' ";
 mysql_error();
    $result=mysql_query($sql);
    $num=mysql_num_rows($result);?>
<table border="1" cellspacing="0" cellpadding="0" align="center" style="width: 500px" bordercolor="red">
<tr>
<th></th> 
<th style="color: navy;">Fileid</th>
<th style="color: navy;">Filename</th>
<th style="color: navy;">Uploadedby</th>
<th style="color: navy;">Uploadeddate(Y-M-D)</th>
<th style="color: navy;">Size(in KB)</th>
</tr>
 <?php
 $i=0;
while ($i < $num) {
 $f=mysql_result($result,$i,"fileid");     
$f1=mysql_result($result,$i,"filename");
$f2=mysql_result($result,$i,"uploadedby");
$f3=mysql_result($result,$i,"uploadeddate");
$f4=mysql_result($result,$i,"size");
                             
?>
 <tr>
 <td><a style="color: navy;cursor: pointer" onclick=" window.open('http://10.70.2.142/Project/download.php?f1=<?php echo $f1;?>','popup','width=550,height=400,scrollbars=no,resizable=no,toolbar=no,directories=no,location=center,menubar=no,status=no,left=370,center=0,top=300')">
    download</a></td>
<td><?php echo $f;?></td>
<td><?php echo $f1;?></td> 
<td><?php echo $f2; ?></td>
<td><?php echo $f3;?></td>
<td><?php echo $f4; ?> </td>
<!--<td><a style="color: navy;cursor: pointer"> Delete</a></td>--></tr>
<?php
    $i++;
    }
?>
</table>


</form></body></html>
0

i need to hav the delete link on line 66.like download on line 59.
Thanks for ur reply

0

Replace line 66 with this:

<td><a style="color: navy;cursor: pointer"> <a href="delete.php?id=<?php echo $f; ?>">Delete</a></td>

And then create a file called delete.php in the same directory and put this inside:

<?php
	include 'connection.php';
	mysql_query("DELETE FROM FILES WHERE fileid = ".mysql_real_escape_string($_GET['id']));
?>

You should do some work on delete.php to make it check for appropriate errors etc. but this should get you by in the mean time until you have the time to improve it.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.