MediaSmartServer.net
http://www.mediasmartserver.net/forums/

MySQL add-on problems
http://www.mediasmartserver.net/forums/viewtopic.php?f=10&t=12864
Page 1 of 1

Author:  Neil T [ Tue Dec 11, 2012 10:05 am ]
Post subject:  MySQL add-on problems

Hi I'm a newbie so please forgive me if this has been covered before. I have installed the mysql add-in and it seems to work in that I can login to the the pma section and administer my databases. However, although I have tried several times to connect to a database and access a table from my php scripts I get no data.

I am using mysqli to establish connections: $mysqli = new msqli('localhost', 'root', '*****', 'database');, and get no error messages indicating that I have a connection, but...

When I then use a $mysqli->query(sql), I get no results and no error message.

Please can someone help?

Author:  yakuza [ Wed Dec 12, 2012 11:49 am ]
Post subject:  Re: MySQL add-on problems

Is there data in your database you are querying? Have you tried putting in bad credentials to see if you get an error message?

Author:  Neil T [ Wed Dec 12, 2012 2:40 pm ]
Post subject:  Re: MySQL add-on problems

Thank you for responding but I have now managed to get it working - my fault, I was not using the correct server. I assumed it wouyld be the name of my WHS but found it is still 'localhost'.

:roll:

Page 1 of 1 All times are UTC - 7 hours [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/