Solved

Display all records from a mysql database

Posted on 2014-01-09
7
315 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
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

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 109

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

If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
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 purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…

839 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