Nu tā man ir datubaze ar nosaukumu aiko un tajā tabula Upload
struktūra sekojoša
Id tinyint(11) UNSIGNED auto_increment
name varchar(255)
size varchar(255)
type varchar(255)
content mediumblob BINARY
Es dabuju bmp failu datubazee bet nevaru dabuut ara
- ar ara es domaju izvadiit uz ekrana.
Man ir šads fails UploadXX3.php
<html>
<head>
<title>Download File From MySQL</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
// -------------------------- maina bufera vetribu ---------------------------------
$hostname="localhost";
$username="yyyyyyyy";
$password="xxxxxxx";
$dbName="aiko";
$usertable="Upload";
// ------------------------pievienojas datubazei--------------------------------------
MYSQL_CONNECT ($hostname,$username,$password) OR DIE ("nav servera");
mysql_select_db("$dbName") or DIE ("Nav DB");
$query = "SELECT id, name FROM 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="UploadXX3.php?id=<?=$id;?>"><?=$name;?></a> <br>
<?
}
}
mysql_close();
?>
</body>
</html>
varu izvadiit faila nosaukumu bet failu ka bildi nevaru.