Re: [PHP] mysql_connect noob question

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 <[email protected]> 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 <[email protected]>
>>>>>> 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"?