I am new to WordPress and I am trying to retrieve data from the database using wpdb.
I have created a custom template in order to add the PHP code but when I tried to display the retrieved data, it did not show anything.
where is the error ?
search info.php
<?php
/*
Template Name: search info
*/
get_header();
global $wpdb;
$result = $wpdb->get_var('select owner-name from owner-info where owner-id= 5');
echo $result;
get_footer();
?>
In wordpress, there is a table prefix (default : 'wp_' or which you have provided) in each table name, please check & include in the table name if required, then your table name will be 'wp_owner-info' & if 'wp_' is not added in your table name then keep as it is.
And the code will be:
With prefix i.e. table_name = wp_owner-info
<?php
/*
Template Name: search info
*/
get_header();
global $wpdb;
$result = $wpdb->get_results("select owner-name from wp_owner-info where owner-id= 5");
echo $result;
get_footer();
?>
OR
Now without prefix i.e. table_name = 'owner-info'
<?php
/*
Template Name: search info
*/
get_header();
global $wpdb;
$result = $wpdb->get_results("select owner-name from owner-info where owner-id= 5");
echo $result;
get_footer();
?>
I hope, this will be useful for you.
Try to use custom query with global varibale $wpdb where you can use dynamic database prefix of table name in query as standred method
$tablename = $wpdb->owner-name;
$ownerID = 5;
$query = $wpdb->prepare( "SELECT * FROM $tablename WHERE owner-id=%s",$ownerID );
$result = $wpdb->get_results( $query );
I don't know about your table structure, but dash - is not a valid character in table or column names. Replace it with the appropriate char, most likely an underscore _, so it becomes
$result = $wpdb->get_var('select owner_name from owner_info where owner_id= 5');
If the name really includes -, you must quote identifiers with backticks, see MySQL - Schema Object Names for details
$result = $wpdb->get_var('select `owner-name` from `owner-info` where `owner-id`= 5');
If its showing blank or white page. then you need to enable wordpress debug mode to know what's wrong with your code. Enable WP Debug
Refresh your WordPress page. here you got the error message. Post your error message here. We will give you the fix. you can fix it by yourself :)
