I have created a image upload for the site i am working on i now want the uer to be able to click on a preview button and this takes them to a separate page where they can see the images that have been uploaded.

for this to happen would i have to send a query to the database to retrieve the information or can i simply display them using the variable name which was set for the images.

Hi Kevin,
the basic question: do you store the images in a database or as files in a file system.

Also, what should I imagine when you say "the variable name which was set for the images"?

so you want to make a thumbnail? also you can make a field called "id" and match the id with the image location. and then select like that.

best way to store an image is to upload it. Store its directory as a varchar in a database then simply echo it back when you need it
there are better and more complicated but this is by far the easiest method


hope this helps

i think what you need is this:

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']);
$_FILES['uploadedfile']['tmp_name'];

all this does is make a variable that holds the directory (ex: "uploads/filename.extension" )
and that you can store in the database as a varchar

if you want me to make you a script just ask, np lol im bored.

hope this helps

i have now tried to connect to my database which is set up on the server and i keep getting could not connect. i have db.php page which sets up the database and recall this by using include db.php

Hi Kevin,
there's no way we could check the problem remotely.
Either you have the login data wrong (server name, username, password, db name) or the script doesn't connect or I don't know. Can you attach both db.php and the main script?

here is the db.php code
<?php

$dbhost = 'www.acmeart.co.uk';
$dbusername = 'acmeart';
$dbpasswd = 'all0wn01';
$database_name = 'acmeartdb';
$sitepath = "http://www.acmeart.co.uk/mercury/";
$sitename = "Mercury Email Distribution System";
$adminemail = "mercury@acmeart.co.uk";

$connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd")
or die ("Couldn't connect to server.");

$db = mysql_select_db("$database_name", $connection)
or die("Couldn't select database.");
?>

here is the code i am using to connect to the db.

<?php

include "db.php";

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die line 168
("QUERY ERROR: ".mysql_error());

$db = mysql_select_db("$database_name", $connection)
or die("QUERY ERROR: ".mysql_error());

// Create table in my_db database
mysql_select_db("$database_name", $connection);
$sql = "CREATE TABLE images
(
imageID int NOT NULL AUTO_INCREMENT,
Broad1 varchar(50),
Broad2 varchar(50),
Broad3 varhar(50)
)";



if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("$database_name", $con);

mysql_query("INSERT INTO image (Broad1)
VALUES ('$thumb_name')");

mysql_query($sql,$con);

mysql_close($con);

?>

i keep getting the error

(Using password: NO) in /home/acmeart/public_html/mercury/upload.php on line 168 QUERY ERROR: i have labelled line 168 for you

i have just spotted a typo and i am just getting could not connect now

i have changed 2 typo's in the code in the $conn = mysql_connect($dbhost, $dbuser, $dbpass)

$dbuser= $dbusername

$dbpass= $dbpasswd