Re: mysql_connect noob question

Dunno. The code definitely has the underscore. On Apr 19, 2013, at 9:11 PM, Jim Giner <jim.giner@albanyhandball.com> wrote: > On 4/20/2013 12:23 AM, Glob Design Info wrote: >> No, no spaces. >> >> I am wondering if I need to use htmlspecialchars() >> >> On Apr 19, 2013, at 7:17 PM, Jim Giner <jim.giner@albanyhandball.com> wrote: >> >>> On 4/19/2013 9:33 PM, Glob Design Info wrote: >>>> They aren't on the same server. The DB is on xeround.com, the web server >>>> is localhost. >>>> >>>> The host value is set and working. If I hard-code the user and password >>>> values in the mysql_connect() call and leave the host value as is, it >>>> connects fine. Only passing the user and password from the form cause it >>>> to fail. >>>> >>>> >>>> On 4/19/13 5:47 PM, David Robley wrote: >>>>> Glob Design Info wrote: >>>>> >>>>>> Sorry. The error displayed is: >>>>>> >>>>>> *Warning*: mysql_connect() [function.mysql-connect >>>>>> >>>>>> <http://localhost/wservices/function.mysql-connect>]: Access >>>>>> denied for >>>>>> user '<user>'@'ip70-162-142-180.ph.ph.cox.net' >>>>>> (using password: YES) in >>>>>> */Library/WebServer/Documents/wservices/connect.php* on line *29* >>>>>> >>>>>> (But with the real user name, not just '<user>') >>>>>> >>>>>> Thanks, >>>>>> >>>>>> On 4/19/13 3:28 PM, tamouse mailing lists wrote: >>>>>>> On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info >>>>>>> <info@globdesign.com> >>>>>>> wrote: >>>>>>>> I know this has probably been answered already. >>>>>>>> >>>>>>>> When I pass a user name and password from a form to my PHP script >>>>>>>> and >>>>>>>> then pass those to mysql_connect it doesn't connect. When I >>>>>>>> paste >>>>>>>> those >>>>>>>> exact same values into mysql_connect as string literals it works. >>>>>>>> >>>>>>>> Can anyone tell me why this happens? >>>>>>>> >>>>>>>> I know the strings are identical to the literals I try in a test >>>>>>>> but >>>>>>>> they don't work when submitted via form. >>>>>>>> >>>>>>>> $form_user = $_POST[ 'user' ]; >>>>>>>> $form_pass = $_POST[ 'password' ]; >>>>>>>> >>>>>>>> # Connect to remote DB >>>>>>>> >>>>>>>> $LINK = mysql_connect( $host, $form_user, $form_pass ); >>>>>>> >>>>>>> Please show the error you are getting from the mysql_connect >>>>>>> >>>>>>> >>>>>>>> And yes, my $host param is correct. >>>>>>>> >>>>>>>> Thanks, >>>>>>>> >>>>>>>> -- >>>>>>>> PHP General Mailing List (http://www.php.net/) >>>>>>>> To unsubscribe, visit: >>>>>>>> http://www.php.net/unsub.php >>>>>>>> >>>>>>> >>>>> >>>>> First guess is that you don't have privileges for >>>>> '<user>'@'ip70-162-142-180.ph.ph.cox.net', but you >>>>> may have privileges >>>>> for >>>>> '<user>'. >>>>> >>>>> And, what are you using for the $host value? If the script and mysql >>>>> are on >>>>> the same server, it shouldn't need to be anything other than >>>>> 'localhost'. >>>>> >>> Do your user or password contain spaces, thereby requiring quotes in your call? >>> >>> -- >>> PHP General Mailing List (http://www.php.net/) >>> To unsubscribe, visit: http://www.php.net/unsub.php >>> > Why does the error message refer to "mysql-connect" and not > "mysql_connect"? > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >