Can we display some information from our myslq database on our website

Asked by:
HubFans / n/a Points
Time:
2014-10-25 3:24 pm EST
Category:
Databases
Hits:
72
I can insert data from HTML forms into mysql database using php, no problems. But what I want to do now is display some information from mysql database on my website and I am having problems. It doesn't look like my site is even attempting to connect to the database to receive data. Am I just doing something wrong, or does Webhosting hub prevent this entirely?

To ask this user for more information, please first login.

To submit an answer, please login.

ANSWERS

0

ScottM
Staff
16,266 Points
2014-10-25 8:16 pm EST
Hello,

You can most certainly connect to the database and retrieve data for display on your website. The connection will be the same as the form, however instead of INSERT you will use SELECT to pull data. Now comes the tricky part. There is no quick and easy tool to use to do this. It will require php coding to do so. We currently do not have a 'how to' guide for that, but I will work hard to get one out soon. The issue is, once the query is run against the database, there is no set code to deal with what will be pulled. Some people want one simple piece of data, some want a lot of data specific to a single entity such as a person or product, and some will want multiple entities with multiple data columns for each. Dealing with that will all be specific to the site.

I hope that doesn't scare you away, because once you learn that, you can do very powerful things with your site. You may want to check out your favorite search engine for more specific tutorials and we will certainly be adding to ours as well.

Kindest Regards,
Scott M

To submit a comment on this answer, please first login.

Want to share this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Need More Help?

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.
}