Thanks for that good suggestion.

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

array(3) {
  string(3) "joe"
  string(11) "complacency"
  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:


header("Content-type: text/plain");


and see precisely what is being passed in from your form.
  On Apr 19, 2013 10:50 PM, "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 <>

On 4/19/2013 9:33 PM, Glob Design Info wrote:
They aren't on the same server. The DB is on, the web
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
user '<user>'@'' (using password: YES)
*/Library/WebServer/Documents/wservices/connect.php* on line *29*

(But with the real user name, not just '<user>')


On 4/19/13 3:28 PM, tamouse mailing lists wrote:
On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info <>
I know this has probably been answered already.

When I pass a user name and password from a form to my PHP script
then pass those to mysql_connect it doesn't connect. When I paste
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.


PHP General Mailing List (
To unsubscribe, visit:

First guess is that you don't have privileges for
'<user>'@'', but you may have privileges

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
Do your user or password contain spaces, thereby requiring quotes in
your call?
PHP General Mailing List (
To unsubscribe, visit:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to