Php mysql query problem

Author: Björn J.

Visited 2903, Followers 2, Shared 0

Tags: database

I have now tried for a couple of days to get a php-script to read from mysql-database. When I load the page I get this error: Could not connect: php_network_getaddresses: getaddrinfo failed: hostname nor servname provided, or not known.

I attach the script

Can anyone tell me what I am doing wrong?

Posted on the 03/13/2013 08:17:05

6 ANSWERS

Samuel V.

User

Hello,

Well, I understand you have a DB server which URL is "database.my.site" ? Or, do you replace the variables with your own data ?

Posted on the 03/13/2013 13:09:31 from Samuel V.

Björn J.

User
Author

Hi,

yes, I don't want to give away too much.

I use the same settings as I do in the email-form to data, there it works

Posted on the 03/13/2013 13:13:38 from Björn J.

Samuel V.

User

Thanks. So perhaps is it the "server port" that is missing. For ex: "database.my.site:5345"

Have you already tried this ?

Posted on the 03/13/2013 13:16:14 from Samuel V.

Björn J.

User
Author

Since I don't have to give that in emailform I haven't tried that

Will do that as soon as I have tried with version10

I'll get back...

Posted on the 03/13/2013 18:55:50 from Björn J.

Björn J.

User
Author

Problem solved...

I really don't know what was wrong.

But now it works. the mysql_connect statement works now.

mysql_select_db should only use tablename as parameter.

Posted on the 03/16/2013 20:21:23 from Björn J.

Björn J.

User
Author

of course it should be databasename not tablenam

Posted on the 03/16/2013 20:22:41 from Björn J.