Solved

Display all records from a mysql database

Posted on 2014-01-09
7
309 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 83

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 83

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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
This article discusses how to create an extensible mechanism for linked drop downs.
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

930 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

11 Experts available now in Live!

Get 1:1 Help Now