Image upload and filename to DB

drputo

Hi there,

I searched this forum thouroughly and wasn't able to find a clear answer as in how to upload an image and have that file location be inputed to a table.

What should I create in the image table? The primary key INT and VARCHAR for the file name?

Is there a clear script that someone could show me to do this?

Thank you in advance.

bretticus

I always thought the manual had a clear example.

drputo

However I don't see a word about taking that file name and location and putting into

MYSQL.

I will ask again,

Can someone show me how to upload a file and take that file location, and insert into a table as text?

Thank you in advance.

drputo

Is there anyone out there?

greatepier

I am working on a database with genealogy data with images and used the following

$form_data_name' is the image

<?php

if ($submit) {

MYSQL_CONNECT("localhost","username","password");
mysql_select_db("database");

$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));

$result=MYSQL_QUERY("INSERT INTO binary_data (doctype, bin_data,filename,filesize,filetype) ".
    "VALUES ('$doctype', '$data','$form_data_name','$form_data_size','$form_data_type')");

$id= mysql_insert_id();
print "<p>This file has the following Database ID: <b>$id</b>";

MYSQL_CLOSE();

} else {

?>

<form method="post" action="<?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
    Document type / Document type <br>
    <input type="text" name="doctype"  size="10"> <br>
    <input type="hidden" name="MAX_FILE_SIZE" value="100000">
    <br>Bestand/File:<br>
    <input type="file" name="form_data"  size="40">
    <p><input type="submit" name="submit" value="submit">
    </form>

<?php

}

?>

This works for me

drputo

Ok that's great but is there something missing?

Don't I have to define what directory to upload the file in?

Also,

Where do I define $form_data_name ?

and what do I define it as?

Thank you again in advance.

bastien

example here though its quick n dirty