GOOD!!!! What was the problem!?!?
Dan On Monday, February 4, 2002, at 01:44 PM, [EMAIL PROTECTED] wrote: > Ok, > > I got it woohoo!!! > > It works! > > Thanks for all your help > > -----Original Message----- > From: Dan Brunner [mailto:[EMAIL PROTECTED]] > Sent: Monday, February 04, 2002 10:35 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Re: FIle Uploading to database > > > Does the file come from a Form?? > > Your hosting provider...might be the problem. > > Dan > > > On Monday, February 4, 2002, at 09:57 AM, [EMAIL PROTECTED] wrote: > >> I changed it to its absolute path... It resides with my hosting >> provider... >> >> I removed the >> >> $pat = array("#", "@", "*", "&", "%", "@","$","'","`"); >> $w= '_'; >> $pic_name2 = str_replace ($pat, $w, stripslashes($pic_name)); >> >> To see if the file is being uploaded... >> >> Here is the actual code: >> >> $db = @mysql_select_db("williamsen", $connection) or die("Could not >> select database"); >> $sql ="INSERT INTO Canidate (id, FirstName, LastName, Industry, >> Address1, Address2, City, State, Zip, LocationPref, Phone, Email, >> ResumeUp) >> VALUES >> (\"$id\", \"$FirstName\", \"$LastName\", \"$Industry\", \"$Address1\", >> \"$Address2\", \"$City\", \"$State\", \"$Zip\", \"$LocationPref\", >> \"$Phone\", \"$Email\", \"$userfile\" )"; >> $result = @mysql_query($sql,$connection) or die("OOPS!! Couldn't >> Execute Query!"); >> >> exec("cp '$userfile', 'home/sites/site190/web/resumes/$userfile'"); >> >> The $sql query needed the $connection in there for it to work >> >> -----Original Message----- >> From: Dan Brunner [mailto:[EMAIL PROTECTED]] >> Sent: Monday, February 04, 2002 9:46 AM >> To: [EMAIL PROTECTED] >> Cc: [EMAIL PROTECTED] >> Subject: Re: [PHP-DB] Re: FIle Uploading to database >> >> >> Make sure the path name is correct.... >> >> Let's say you compiled apache with this prefix /web.... >> >> you must have the full path name to work...like this >> >> exec("cp '$ResumeUp' '/web/htdocs/resumes/$ResumeUp2'"); >> >> Also check permissions... >> >> I think that was my problem at first too!!! >> >> >> You can also do debug the script..... >> >> Like this >> >> echo $ResumeUp; >> >> That should print the tmp file you form created....... >> >> Let me know... >> >> >> Once this pasts...It works really well... >> >> >> Dan >> >> >> >> On Monday, February 4, 2002, at 09:35 AM, [EMAIL PROTECTED] wrote: >> >>> The INSERT statement works fine now, but the file isn't being >> uploaded. >>> I cannot figure out why >>> >>> -----Original Message----- >>> From: Dan Brunner [mailto:[EMAIL PROTECTED]] >>> Sent: Monday, February 04, 2002 7:54 AM >>> To: [EMAIL PROTECTED] >>> Cc: [EMAIL PROTECTED] >>> Subject: Re: [PHP-DB] Re: FIle Uploading to database >>> >>> >>> Hey did you get it to work yet?!?! >>> >>> >>> Dan >>> >>> >>> On Sunday, February 3, 2002, at 09:08 PM, [EMAIL PROTECTED] wrote: >>> >>>> Umm.. >>>> >>>> SET parameter is for the UPDATE query >>>> >>>> >>>> "Adam Royle" <[EMAIL PROTECTED]> wrote in message >>>> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >>>>> You missed the SET parameter in your query... example is below... >>>>> >>>>> $query = "INSERT INTO Canidate SET (FirstName, LastName, Indus... >>>>> >>>>> Adam >>>>> >>>>> -----Original Message----- >>>>> From: Todd Williamsen [mailto:[EMAIL PROTECTED]] >>>>> Sent: Monday, February 04, 2002 11:06 AM >>>>> To: [EMAIL PROTECTED] >>>>> Subject: Re: FIle Uploading to database >>>>> >>>>> >>>>> 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! >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> PHP Database Mailing List (http://www.php.net/) >>>> To unsubscribe, visit: http://www.php.net/unsub.php >>>> >>> >>> >> >> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
