Naming Help & More!

[Anon]

Please help us!

We are placing a one form page for client updating of their database. We want to be able to have them fill in a form, as well as select a picture location, and have the information and image entered properly into the database. We have made this application work with two separate actions (complete the initial information first, then add a picture second). We have also combined the two into one form, although our client has to specify the name of the picture itself for database reference.

We now would like to use the Last Insert Id command to automatically name the image so the client doesn’t have to worry about unique names and redundant renaming after image selection. We were originally trying to auto increment this, but believe that the last insert id is the right way to do it.

Following is our script, although the definition of file name was originally written for auto increment use. Please advise us as to what corrections or additions we need to make, as well as WHERE we should make them. We are very new to this.

Thank you for your help.

<?

if ($submit) {
$connection = mysql_connect("localhost", "", "")
or die ("Couldn't connect to server.");

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

$filename = ("image" . $id . ".jpg");
copy($image, "/path/pics/$filename");

$filesize=filesize($image);
$filetype=filetype($image);

mysql_query("INSERT INTO inventory VALUES
('$id', '$trailertype', '$info', '$filename', '$filesize', '$filetype', '$description', '$pulltype', '$size', '$weight', '$price')") or die (mysql_error());

echo "

[Anon]

I choose not to use the auto_increment function of MySQL, for no peticular reason other than I had never used it before.

For random numbers that I need to be unique, I use time();

$filename = time();

for a better system, use microtime()

$mtime = microtime();
$mtime = ereg_replace('.', '', $mtime);
$mtime = explode(' ', $mtime);
$filename = $mtime[1] . $mtime[0];

more info at

http://www.php.net/manual/function.time.php
http://www.php.net/manual/function.microtime.php

Chris Lee

[Anon]

When the user goes to upload the image include the form data in the form for the image upload. First do a insert on the form data. Next copy the image over using the mysql_insert_id() function with the insert id as the file name. if the filename is the same as the id in the database you should always have a unique name and there isn't any need to update the database with the filename, just remove the filename column. to find an ad just reference 'file_path/inventory_id.jpg' for example.

try this:

$filesize=filesize($image);
$filetype=filetype($image);

mysql_query("INSERT INTO inventory VALUES
('$id', '$trailertype', '$info', '$filesize', '$filetype', '$description', '$pulltype', '$size', '$weight', '$price')") or die (mysql_error());

$filename = ("image" . mysql_insert_id() . ".jpg");
copy($image, "/path/pics/$filename");

now the issue will be if they need to have multiple images for each entry. a better way to handle this might be to include another table that has just filename and a reference to the id for the inventory table.

CREATE TABLE pics(
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
filename VARCHAR(255),
filetype VARCHR(255),
filesize INT,
inventory_id INT
);

in this case just run another insert after inserting the form data and set inventory_id to LAST_INSERT_ID(). just have a folder that contains only pics and again use the id as the filename.

[Anon]

What is the column which is the auto-increment?
You only get the auto increment if you don't set
a specific value, so if it's ID they you won't want
to include that in your INSERT statement.

Then, <i>after</i> you insert the row, you call
mysql_insert_id() and get the automatic ID
value from the last insert. Only then can you use
this value in renaming your .jpg files. And, by the
way, if you <i>are</i> running on some form of
unix, and the upload directory is on the same
volume as the document root, then you can save
a lot of overhead by using link() to give the file
a new name in the desired directory, or rename()
to accomplish the same effect. Either way, you're
just creating a new directory reference for the
file; the contents don't have to be copies.