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" <info@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxx>
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
