Solved

Display all records from a mysql database

Posted on 2014-01-09
7
321 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

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 110

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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

739 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