It is currently Thu Mar 28, 2024 9:58 am

All times are UTC - 7 hours [ DST ]

Recent News:



Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: MySQL add-on problems
PostPosted: Tue Dec 11, 2012 10:05 am 
Offline
Newbie
Newbie

Joined: Tue Dec 11, 2012 9:54 am
Posts: 2
Thanks: 0
Thanked: 0 time in 0 post
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?


Top
 Profile  
Thanks  

Attention Guest: Remove this ad by Registering with the MediaSmartServer.net Forums. It's Free!
PostPosted: Wed Dec 12, 2012 11:49 am 
Offline
Founder
Founder
User avatar

Joined: Tue Jul 31, 2007 11:54 am
Posts: 10735
Location: Fort Collins, Colorado
Thanks: 630
Thanked: 931 times in 885 posts
Is there data in your database you are querying? Have you tried putting in bad credentials to see if you get an error message?

_________________
Alex Kuretz
Remote Notification: Monitoring and alerting for your Home Server via email, Twitter, text message, RSS, push notifications, and on your Mac desktop
Have you tried our Add-Ins?


Top
 Profile  
Thanks  
PostPosted: Wed Dec 12, 2012 2:40 pm 
Offline
Newbie
Newbie

Joined: Tue Dec 11, 2012 9:54 am
Posts: 2
Thanks: 0
Thanked: 0 time in 0 post
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:


Top
 Profile  
Thanks  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 7 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 13 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group