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
>
>
