How to retrieve data from wordpress database in php and display on a page?

Question

I am using a theme that i installed and activated in wordpress .The theme is Zerif-lite.

I added a table to the database named "doctors" with 2 attributes "id" and "name". What I'm trying to do is to select all data in this table. I've used the following code but nothing is displayed

$mystuff = $wpdb->get_row("SELECT * FROM doctors WHERE 1);

Any Help??

bhavesh vala · Accepted Answer · 2015-06-11 10:59:03Z

1

try this

global $wpdb;
$result = $wpdb->get_results("select * from `table_name` where column = value");
foreach($result as $results){
  echo $results->field1;
  echo $results->field2;
}

answered Jun 11, 2015 at 10:59

bhavesh vala

8717 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

vrajesh · Accepted Answer · 2015-06-11 09:44:05Z

0

try this:

global $wpdb;
$result = $wpdb->get_results("select * from `table_name`");
foreach($result as $row){
echo $row->field1;
echo $row->field2;
echo $row->field3;
}

answered Jun 11, 2015 at 9:44

vrajesh

2,9423 gold badges28 silver badges40 bronze badges

Collectives™ on Stack Overflow

How to retrieve data from wordpress database in php and display on a page?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related