Re: FIle Uploading to database
| From: | Todd Williamsen | Date: | Mon, 04 Feb 2002 01:06:02 +0000 |
| Subject: | Re: FIle Uploading to database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16472@lists.php.net to get a copy of this message | ||
Well... thanks to Dan Burner for the script... BUT
I cannot get this friggin INSERT statement to execute.. which craps out..
I cannot figure it out. I have been staring at it for about an hour and I
still cannot figure it out
here it is:
$db = @mysql_select_db($db_name, $connection) or die("Could not select
database");
$query = "INSERT INTO Canidate(FirstName, LastName, Industry, Address1,
Address2, City, State, Zip, LocationPref, Phone, Email, ResumeUp) VALUES
('$FirstName', '$LastName', '$Industry' '$Address1',
'Address2', '$City',
'$State', '$Zip', '$LocationPref', '$Phone',
'$Email', '$ResumeUp2')";
$result = @mysql_query($query, $connection) or die("could not execute
query");
$pat = array("#", "@", "*", "&", "%",
"@","$","'","`");
$w= '_';
$ResumeUp2 = str_replace ($pat, $w, stripslashes($ResumeUp));
exec("cp '$ResumeUp' '/resumes/$ResumeUp2'");
?>
it errors out on the $result "could not execute query"
Let me know if you need more info!
Thank you!
"Todd Williamsen" <todd@williamsen.net> wrote in message
news:20020203221517.87963.qmail@pb1.pair.com...
> I don't want the file to be stored in the database, but its location.
>
> What I want to do:
>
> Upload a file, it gets stored on the webserver, but its location on the
> server is stored in the database.
>
> Where do I look for something like this?
>
> What data type would I use to store the URL or file location?
>
> Thank you
>
>