Hi everyone, I have been struggeling with this for some time know and don't
know where it goes wrong. I want to upload pictures into a folder AND store
their path into MySQL. I used a joe's auto tutorial but can't get it to
work. All the information is put in correctly but not the picture.

Please help me, here's my code: (ps globals are off)

if ($_POST[submit]) {

$link = mysql_pconnect("localhost","myusername","mypassword");
$db = test;
mysql_select_db($db,$link);

$query = "INSERT INTO inventory
(registration,type,total_time,price,description,picture_name)
VALUES
('$_POST[registration]','$_POST[type]','$_POST[total_time]','$_POST[price]',
'$_POST[description]','$_POST[picture]')";

exec("cp $_POST[picture]
//localhost/seabird.jmtech.ca/OTF.com/images/$_POST[picture_name]");

mysql_query( $query, $link);
print 'Thank you<br>You have submitted the following information:<br>';
echo "Registration: $_POST[registration]<br>\n";
echo "Type: $_POST[type]<br>\n";
echo "Total Time: $_POST[total_time]<br>\n";
echo "Price: $_POST[price]<br>\n";
echo "Description: $_POST[description]<br>\n";
echo "temp file: $_POST[picture]<br>\n";
echo "file name: $_POST[picture_name]<br>\n";
echo "file size: $_POST[picture_size]<br>\n";
echo "file type: $_POST[picture_type]<br>\n";
echo "<br>\n";
echo "<img src=images/$picture_name><br>\n";
}
else { ?>
    <form enctype="multipart/form-data" method="post"
action="<?php echo $PHP_SELF ?>">
      <p>Registration<br>
        <input type="Text" name="registration" size="25" value="N">
        <br>
        type<br>
        <input type="Text" name="type" size="25">
        <br>
        total time<br>
        <input type="Text" name="total_time" size="25">
        <br>
        price<br>
        <input type="Text" name="price" size="25">
        <br>
        Description<br>
        <textarea name="description"></textarea>
        <br>
        picture<br>
        <input type="file" name="picture" size="25">
        <input type="submit" name="submit" value="Upload">
      </p>
    </form>


--
http://seabird.jmtech.ca

Attitude is Everything!
But Remember, Attitudes are Contagious!
Is Yours worth Catching????





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to