?
Solved

Display all records from a mysql database

Posted on 2014-01-09
7
Medium Priority
?
333 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 84

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 84

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
Simplify Your Workload with One Tool

How do you combat today’s intelligent hacker while managing multiple domains and platforms? By simplifying your workload with one tool. With Lunarpages hosting through Plesk Onyx, you can:

Automate SSL generation and installation with two clicks
Experience total server control

 

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 2000 total points
ID: 39770606
0
 
LVL 111

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…
The viewer will learn how to count occurrences of each item in an array.
Suggested Courses

649 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