Solved

Display all records from a mysql database

Posted on 2014-01-09
7
307 Views
Last Modified: 2014-01-28
I want to display all records from a mysql database on a Wordpress page at www.theonedollarchallenge.com/companies using mysql query, and without using a psuedolanguage of any kind.

Assistance is greatly appreciated.
0
Comment
Question by:frugalmule
7 Comments
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 39770334
What do you mean by "psuedolanguage"?  If your hosting has phpMyAdmin, you can use that.  If you have shell access, you can use the 'mysql' command line program.  All three of my Wordpress installations include 11 separate tables in the database.
0
 

Author Comment

by:frugalmule
ID: 39770396
My host is Arvixe and it does have phpMyAdmin.

I know the name of the database, username, password, and name of the table.  How do I get a new wp page to display all of the data in the table?
0
 
LVL 82

Expert Comment

by:Dave Baldwin
ID: 39770405
Wordpress page?  You would have to write a new page or routine in PHP to do that.  Wordpress (when it is running) is always logged into the database because that's where it stores most of the information you see on the page.  

Have you used phpMyAdmin to look at the tables to see what you want to display?  phpMyAdmin is a better tool to just look at the tables.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 

Author Comment

by:frugalmule
ID: 39770429
Yes, that is what I am looking to do, simply display the table on a wordpress page.
0
 
LVL 1

Accepted Solution

by:
cutieangel earned 500 total points
ID: 39770606
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 39773409
This article shows many of the basics of PHP + MySQL, including examples for the new extensions that replace the obsolete MySQL extension.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/A_11177-PHP-MySQL-Deprecated-as-of-PHP-5-5-0.html
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Developers of all skill levels should learn to use current best practices when developing websites. However many developers, new and old, fall into the trap of using deprecated features because this is what so many tutorials and books tell them to u…
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now