/    Sign up×
Community /Pin to ProfileBookmark

how can I display images form my database in date order one at a time?

I got bokehs upload image page working fine on my site, slitly altered to also store the file path and username and datetime…

[CODE]mysql> create table uploaded_images
-> (
-> id int auto_increment not null,
-> user_name varchar(50),
-> filename varchar(150),
-> date DATETIME,
-> primary key(id)
-> );
Query OK, 0 rows affected (0.02 sec)

mysql> explain uploaded_images;
+———–+————–+——+—–+———+—————-+
| Field | Type | Null | Key | Default | Extra |
+———–+————–+——+—–+———+—————-+
| id | int(11) | NO | PRI | NULL | auto_increment |
| user_name | varchar(50) | YES | | NULL | |
| filename | varchar(150) | YES | | NULL | |
| date | datetime | YES | | NULL | |
+———–+————–+——+—–+———+—————-+
4 rows in set (0.00 sec)

mysql>[/CODE]

upload.procesor.php

[code=php]<?php session_start();?>
<?php

// filename: upload.processor.php

// first let’s set some variables

// make a note of the current working directory, relative to root.
$directory_self = str_replace(basename($_SERVER[‘PHP_SELF’]), ”, $_SERVER[‘PHP_SELF’]);

// make a note of the directory that will recieve the uploaded files
$uploadsDirectory = $_SERVER[‘DOCUMENT_ROOT’] . $directory_self . ‘uploaded_files/’;

// make a note of the location of the upload form in case we need it
$uploadForm = ‘http://’ . $_SERVER[‘HTTP_HOST’] . $directory_self . ‘upload.form.php’;

// make a note of the location of the success page
$uploadSuccess = ‘http://’ . $_SERVER[‘HTTP_HOST’] . $directory_self . ‘upload.success.php’;

// name of the fieldname used for the file in the HTML form
$fieldname = ‘file’;

$datetime = `datetime(dMy)(hms)`;

// Now let’s deal with the upload

// possible PHP upload errors
$errors = array(1 => ‘php.ini max file size exceeded’,
2 => ‘html form max file size exceeded’,
3 => ‘file upload was only partial’,
4 => ‘no file was attached’);

// check the upload form was actually submitted else print form
isset($_POST[‘submit’])
or error(‘the upload form is neaded’, $uploadForm);

// check for standard uploading errors
($_FILES[$fieldname][‘error’] == 0)
or error($errors[$_FILES[$fieldname][‘error’]], $uploadForm);

// check that the file we are working on really was an HTTP upload
@is_uploaded_file($_FILES[$fieldname][‘tmp_name’])
or error(‘not an HTTP upload’, $uploadForm);

// validation… since this is an image upload script we
// should run a check to make sure the upload is an image
@getimagesize($_FILES[$fieldname][‘tmp_name’])
or error(‘only image uploads are allowed’, $uploadForm);

// make a unique filename for the uploaded file and check it is
// not taken… if it is keep trying until we find a vacant one
$now = time();
while(file_exists($uploadFilename = $uploadsDirectory.$now.’-‘.$_FILES[$fieldname][‘name’]))
{
$now++;
}

// now let’s move the file to its final and allocate it with the new filename
@move_uploaded_file($_FILES[$fieldname][‘tmp_name’], $uploadFilename)
or error(‘receiving directory insuffiecient permission’, $uploadForm);
//in addition to Bokeh’s script you can insert each record into a database.
$conn = mysql_connect(“localhost”,”username”,”password”)
or die(“Could not connect to MySQL”);
$db = mysql_select_db(“images”,$conn)
or die(“Could not select database”);
$q = “INSERT INTO uploaded_images (`user_name`,`filename`,`date`) VALUES (“$username”,”$uploadFilename”,NOW())”;
$s = mysql_query($q, $conn);

//if an error
echo(mysql_error());

// If you got this far, everything has worked and the file has been successfully saved.
// We are now going to redirect the client to the success page.
{ session_start();
session_register(“uploadFilename”);
$uploadFilename = $uploadFilename;
}
header(‘Location: ‘ . $uploadSuccess);

// make an error handler which will be used if the upload fails
function error($error, $location, $seconds = 5)
{
header(“Refresh: $seconds; URL=”$location””);
echo ‘<!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01//EN”‘.”n”.
‘”http://www.w3.org/TR/html4/strict.dtd”>’.”nn”.
‘<html lang=”en”>’.”n”.
‘ <head>’.”n”.
‘ <meta http-equiv=”content-type” content=”text/html; charset=iso-8859-1″>’.”nn”.
‘ <link rel=”stylesheet” type=”text/css” href=”stylesheet.css”>’.”nn”.
‘ <title>Upload error</title>’.”nn”.
‘ </head>’.”nn”.
‘ <body>’.”nn”.
‘ <div id=”Upload”>’.”nn”.
‘ <h1>Upload failure</h1>’.”nn”.
‘ <p>An error has occured: ‘.”nn”.
‘ <span class=”red”>’ . $error . ‘…</span>’.”nn”.
‘ The upload form is reloading</p>’.”nn”.
‘ </div>’.”nn”.
‘</html>’;
exit;
} // end error handler

?>[/code]

now what i want to do is display the images on a seperate page, one at a time, in datetime order starting with the most resant, with a next button at the botom. I would also like to be able to set a max image width and hight if pos.

anyone have any idea how to do this?

to post a comment
PHP

1 Comments(s)

Copy linkTweet thisAlerts:
@bokehJul 30.2006 — I would also like to be able to set a max image width and hight if pos.

anyone have any idea how to do this?[/QUOTE]
You need to do this while saving. Resize the image with the GD functions and then save it.
×

Success!

Help @PJStew spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.3,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,
)...