Completely different function call().
mysql_connect() - the port is part of the host.
*server*
The MySQL server. It can also include a port number. e.g. hostname:port
or a path to a local socket e.g. :/path/to/socket for the localhost.
If the PHP directive
On Apr 21, 2013, at 3:33 PM, Glob Design Info i...@globdesign.com wrote:
What question did I not answer?
That proves that you're not listening -- you are total waste of time for anyone
trying to help.
Welcome to my ignore file.
tedd
_
tedd.sperl...@gmail.com
Well all, it turns out the *correct* answer to my question, which no one
answered, and which only degenerated into a kindergarten-like argument is:
You need to add the port # to the *end* of the mysql_connect() call.
i.e.:
$link = mysqli_connect( $host, user, pass, $database, $port );
Glad
On 4/23/2013 10:39 AM, Glob Design Info wrote:
Well all, it turns out the *correct* answer to my question, which no one
answered, and which only degenerated into a kindergarten-like argument is:
You need to add the port # to the *end* of the mysql_connect() call.
i.e.:
$link = mysqli_connect(
On 4/21/2013 7:35 PM, Glob Design Info wrote:
A very complex solution that takes time to learn, configure, and
install, vs. a single file I can toss on the server.
Over-engineering is what is daft.
As has been pointed out to you - your simplistic approach to this task
is going to cost you
On Sat, Apr 20, 2013 at 9:37 PM, Glob Design Info i...@globdesign.com wrote:
Night now this is just a test server. On the real thing I'll do it right.
On 4/20/13 10:58 AM, Tedd Sperling wrote:
On Apr 20, 2013, at 11:44 AM, Stuart Dallas stu...@3ft9.com wrote:
On 20 Apr 2013, at 16:25, Jim
On Apr 21, 2013, at 9:32 AM, Stuart Dallas stu...@3ft9.com wrote:
However, a more important question for me is why you are doing this. You say
you are aware of the security implications, and that you'll deal with that
later, but I question how you're going to deal with it. What exactly are
On Sun, Apr 21, 2013 at 9:12 AM, Tedd Sperling tedd.sperl...@gmail.com wrote:
On Apr 21, 2013, at 9:32 AM, Stuart Dallas stu...@3ft9.com wrote:
However, a more important question for me is why you are doing this. You say
you are aware of the security implications, and that you'll deal with
On 21 Apr 2013, at 15:46, tamouse mailing lists tamouse.li...@gmail.com wrote:
On Sun, Apr 21, 2013 at 9:12 AM, Tedd Sperling tedd.sperl...@gmail.com
wrote:
On Apr 21, 2013, at 9:32 AM, Stuart Dallas stu...@3ft9.com wrote:
However, a more important question for me is why you are doing this.
On Sun, Apr 21, 2013 at 9:49 AM, Stuart Dallas stu...@3ft9.com wrote:
On 21 Apr 2013, at 15:46, tamouse mailing lists tamouse.li...@gmail.com
wrote:
On Sun, Apr 21, 2013 at 9:12 AM, Tedd Sperling tedd.sperl...@gmail.com
wrote:
On Apr 21, 2013, at 9:32 AM, Stuart Dallas stu...@3ft9.com
On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info i...@globdesign.com 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
What question did I not answer?
I am developing a web portal that has to display the tables in the DB via a
form/script. The web page has a login with user and password. Right now I am
just trying to connect.
On Apr 21, 2013, at 7:12 AM, Tedd Sperling tedd.sperl...@gmail.com wrote:
On Apr
Not meaning to beat the proverbial dead horse
I am developing a web portal that has to display the tables in the DB via a
form/script. The web page has a login with user and password. Right now I
am just trying to connect.
This for a commercial app - the client wants both an API connect via
Except that a) I already have my form and script done, b) don't have time to
learn phpMyAdmin, c) want to know why the script doesn't work as-is.
On Apr 21, 2013, at 12:46 PM, David OBrien dgobr...@gmail.com wrote:
Not meaning to beat the proverbial dead horse
I am developing a web portal
One other thing I noted in the FAQ was this:
Dots in incoming variable names
Typically, PHP does not alter the names of variables when they are passed into
a script. However, it should be noted that the dot (period, full stop) is not a
valid character in a PHP variable name. For the reason,
On Sun, Apr 21, 2013 at 6:01 PM, Glob Design Info i...@globdesign.comwrote:
One other thing I noted in the FAQ was this:
Dots in incoming variable names
Typically, PHP does not alter the names of variables when they are passed
into a script. However, it should be noted that the dot (period,
On 21 Apr 2013, at 22:43, Glob Design Info i...@globdesign.com wrote:
Except that a) I already have my form and script done, b) don't have time to
learn phpMyAdmin, c) want to know why the script doesn't work as-is.
You have multiple database users who will need to do this, or just one
On 21 Apr 2013, at 23:01, Glob Design Info i...@globdesign.com wrote:
I should note my user name in this case *is* an email address, however the
dots in that address are *not* being converted to underscores as mentioned
(at least not visibly).
This could be the culprit. Try using a username
I should note my user name in this case *is* an email address, however
the dots in that address are *not* being converted to underscores as
mentioned (at least not visibly).
I just created a free account there and the email says my username is
dgobr...@gmail.com
but I connected to it from
In fact using the @gmail.com part added on gives me the same error as the OP
I think their welcome email needs tweaking.. try it without the domain
added on
On Sun, Apr 21, 2013 at 6:56 PM, David OBrien dgobr...@gmail.com wrote:
I should note my user name in this case *is* an email address,
Except that I want to use my script and form - precisely because I have
already sunk time into it. I'm not going to sink *more* time into
something that could potentially create *another* problem.
I want the script to work - as it should if PHP is 1/2 what it's cracked
up to be. If not, I'll
Tried that. Still didn't work.
I appears to be the port.
On 4/21/13 3:40 PM, Stuart Dallas wrote:
On 21 Apr 2013, at 23:01, Glob Design Info i...@globdesign.com wrote:
I should note my user name in this case *is* an email address, however the dots
in that address are *not* being converted
SUCCESS!
However.
if ( $_REQUEST['Submit'] ) {
makes it work (using my own form button ID).
Why it doesn't work without this on my machine is beyond me. But it doesn't.
Could it be somehow there is something about accessing the $_REQUEST that
changes something?
I am baffled as to the
Even more strange:
It doesn't work from the form with or without the domain (but on the
command line it does), but..
IF I add the $_REQUEST access *and* use the user that the *MySQL*
install has, and *not* the xeround user name (my email), then it *does*
work!
WEIRD.
On 4/21/13 3:59
On 22 Apr 2013, at 00:16, Glob Design Info i...@globdesign.com wrote:
Except that I want to use my script and form - precisely because I have
already sunk time into it. I'm not going to sink *more* time into something
that could potentially create *another* problem.
The idea of sunk time is
A very complex solution that takes time to learn, configure, and
install, vs. a single file I can toss on the server.
Over-engineering is what is daft.
On 4/21/13 4:33 PM, Stuart Dallas wrote:
On 22 Apr 2013, at 00:16, Glob Design Info i...@globdesign.com wrote:
Except that I want to use my
Ever heard of the MySQL C Connector?
http://www.karlkraft.com/index.php/2010/06/02/mysql-and-objective-c/
:-)
On 4/21/13 4:33 PM, Stuart Dallas wrote:
On 22 Apr 2013, at 00:16, Glob Design Info i...@globdesign.com wrote:
Except that I want to use my script and form - precisely because I
On 22 Apr 2013, at 00:35, Glob Design Info i...@globdesign.com wrote:
A very complex solution that takes time to learn, configure, and install, vs.
a single file I can toss on the server.
Over-engineering is what is daft.
Building your house by making your own bricks is daft. Using bricks
On 22 Apr 2013, at 00:36, Glob Design Info i...@globdesign.com wrote:
Ever heard of the MySQL C Connector?
http://www.karlkraft.com/index.php/2010/06/02/mysql-and-objective-c/
That would be Objective-C, not C.
I have used libmysqlclient extensively, but there's a lot more to a MySQL
After all this, the OP remains unenlightened. This is just a waste of time.
You are doing this wrong. There are existing tools that do what your
client wants. A command line tool is not the same as the php library.
are all met with I don't want to learn, just tell me what isn't working.
Too bad.
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
On Sat, Apr 20, 2013 at 10:36 AM, tamouse mailing lists
tamouse.li...@gmail.com 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
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
Goog suggestion. The user name is an email address so it does contain @.
Password is all pure lowercase ASCII.
Wonder if the shift-2 is causing the problem?
On 4/20/13 4:44 AM, Matijn Woudt wrote:
On Sat, Apr 20, 2013 at 10:36 AM, tamouse mailing lists
tamouse.li...@gmail.com wrote:
No,
On Apr 19, 2013, at 4:43 PM, Glob Design Info i...@globdesign.com 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
$form_user = $_POST[ 'user' ];
$form_pass = $_POST[ 'password' ];
# Connect to remote DB
$LINK = mysql_connect( $host, $form_user, $form_pass );
And yes, my $host param is correct.
Have you tried
$LINK = mysql_connect( $host, $form_user, $form_pass );
just for the heck of it?
Why are you allowing anyone to connect to your database from a form?
Cheers,
tedd
_
tedd.sperl...@gmail.com
http://sperling.com
A little OT, but...
What do you mean by this question? How do you check someone's
credentials if not by connecting to a db to verify the
On 20 Apr 2013, at 16:25, Jim Giner jim.gi...@albanyhandball.com wrote:
Why are you allowing anyone to connect to your database from a form?
A little OT, but...
What do you mean by this question? How do you check someone's credentials if
not by connecting to a db to verify the login?
On 4/20/2013 11:44 AM, Stuart Dallas wrote:
On 20 Apr 2013, at 16:25, Jim Giner jim.gi...@albanyhandball.com wrote:
Why are you allowing anyone to connect to your database from a form?
A little OT, but...
What do you mean by this question? How do you check someone's credentials if
not by
Same error. That just turns those into string literals.
On 4/20/13 5:48 AM, David OBrien wrote:
$form_user = $_POST[ 'user' ];
$form_pass = $_POST[ 'password' ];
# Connect to remote DB
$LINK = mysql_connect( $host, $form_user, $form_pass );
And yes, my $host param is correct.
Have you tried
On Apr 20, 2013, at 11:44 AM, Stuart Dallas stu...@3ft9.com wrote:
On 20 Apr 2013, at 16:25, Jim Giner jim.gi...@albanyhandball.com wrote:
Why are you allowing anyone to connect to your database from a form?
A little OT, but...
What do you mean by this question? How do you check
Night now this is just a test server. On the real thing I'll do it right.
On 4/20/13 10:58 AM, Tedd Sperling wrote:
On Apr 20, 2013, at 11:44 AM, Stuart Dallas stu...@3ft9.com wrote:
On 20 Apr 2013, at 16:25, Jim Giner jim.gi...@albanyhandball.com wrote:
Why are you allowing anyone to
On Fri, Apr 19, 2013 at 10:43 PM, Glob Design Info i...@globdesign.comwrote:
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
Already did that. I printed the form values in the PHP script after they
are received and they print exactly as entered in the form. Even checked
for extra spaces.
Any functions I can pass the values to to remove the magic quotes?
Thanks,
On 4/19/13 1:47 PM, Matijn Woudt wrote:
On Fri, Apr
On Fri, Apr 19, 2013 at 10:59 PM, Glob Design Info i...@globdesign.comwrote:
Already did that. I printed the form values in the PHP script after they
are received and they print exactly as entered in the form. Even checked
for extra spaces.
Any functions I can pass the values to to remove
On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info i...@globdesign.com 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
Nope, quotes are not visible in the output.
Both the HTML and the script it calls are shown below. They are in 2
separate files. The variable names in both are user and password.
The data comes through to the PHP script fine - if I print them I see
exactly what I typed in the form, but when I
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*
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
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
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
No, no spaces.
I am wondering if I need to use htmlspecialchars()
On Apr 19, 2013, at 7:17 PM, Jim Giner jim.gi...@albanyhandball.com 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
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 jim.gi...@albanyhandball.com 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,
Dunno. The code definitely has the underscore.
On Apr 19, 2013, at 9:11 PM, Jim Giner jim.gi...@albanyhandball.com wrote:
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
54 matches
Mail list logo
