Een amin page maken, die filesverwijderd uit de db.
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
<?
if(isset($_GET['id']))
{
include '/config/config.php';
include '/config/opendb.php';
$id = $_GET['id'];
$query = "SELECT name, type, size, content FROM zap_img_upload WHERE id = '$id'";
$result = mysql_query($query) or die('Error, query failed');
list($name, $type, $size, $content) = mysql_fetch_array($result);
header("Content-Disposition: attachment; filename=$name");
header("Content-length: $size");
header("Content-type: $type");
echo $content;
include 'config/closedb.php';
exit;
}
?>
<html>
<head>
<title>Download File From MySQL</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style><!--a:hover{text-transform:uppercase; }--></style>
</head>
<body>
<?
include '/config/config.php';
include '/config/opendb.php';
$query = "SELECT id, name FROM zap_img_upload";
$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0)
{
echo "Database is empty <br>";
}
else
{
while(list($id, $name) = mysql_fetch_array($result))
{
?>
<a href="main.php?id=<?=$id;?>"><?=$name;?></a> <br>
<?
}
}
include '/config/closedb.php';
?>
</body>
</html>
if(isset($_GET['id']))
{
include '/config/config.php';
include '/config/opendb.php';
$id = $_GET['id'];
$query = "SELECT name, type, size, content FROM zap_img_upload WHERE id = '$id'";
$result = mysql_query($query) or die('Error, query failed');
list($name, $type, $size, $content) = mysql_fetch_array($result);
header("Content-Disposition: attachment; filename=$name");
header("Content-length: $size");
header("Content-type: $type");
echo $content;
include 'config/closedb.php';
exit;
}
?>
<html>
<head>
<title>Download File From MySQL</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style><!--a:hover{text-transform:uppercase; }--></style>
</head>
<body>
<?
include '/config/config.php';
include '/config/opendb.php';
$query = "SELECT id, name FROM zap_img_upload";
$result = mysql_query($query) or die('Error, query failed');
if(mysql_num_rows($result) == 0)
{
echo "Database is empty <br>";
}
else
{
while(list($id, $name) = mysql_fetch_array($result))
{
?>
<a href="main.php?id=<?=$id;?>"><?=$name;?></a> <br>
<?
}
}
include '/config/closedb.php';
?>
</body>
</html>
die pagina laat zien welke bestanden er in de db zitten. ik wil graag dat er een edit (om de name en discription te wijzigen) en een delete button bij komen.En dit wil ik graag in een mooie tabel zetten.
(dus dan moet elk laatje in een nieuw vakje)
kan iemand mij hier mee helpen?
alvast bedankt.
Gewijzigd op 01/01/1970 01:00:00 door Zap
UPDATE tabel SET kolom1 = waarde1, kolom2 = waarde2 WHERE id = waarde
DELETE FROM tabel WHERE id = waarde
@herjan het probleem is eigenijk dat ik neit weet hoe ik sit aan een link kan link, dat je bijv. de text delete klikt dat dat file dan gedelete wordt.
bedankt voor de reacties