Re: [PHP] mysql_connect noob question

Thanks for that good suggestion.

I tried that and as expected, the passed variables are coming through 
exactly as expected:

array(3) {
   ["user"]=>
   string(3) "joe"
   ["password"]=>
   string(11) "complacency"
   ["login"]=>
   string(5) "Login"
}

The bottom one seems to be the submit button's tag.

I'm at a loss too. It should work. Replacing all 3 script variables with 
hard-coded values for the login works fine - so I know the host string 
is fine.

Very weird!

On 4/20/13 1:36 AM, tamouse mailing lists wrote:
> No, that's for writing safe html output.
>
> If the user or password contains special chars, sending them through
> htmlspecialchars would turn them into html entities. i doubt you want that.
>
> I'm at a loss here. The only thing Ican think of is to try something like
> this at the top of the script:
>
> <?php
>
> error_reporting(-1);
> ini_set('display_errors',1);
> ini_set('display_startup_errors',1);
> header("Content-type: text/plain");
> var_dump($_POST);
> exit;
>
> ?>
>
> and see precisely what is being passed in from your form.
>   On Apr 19, 2013 10:50 PM, "Glob Design Info" <[email protected]> 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
>>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>