Insert & Fetch Data From WordPress Database

Admin

9 years ago

Insert Data in Database :

<?php
global $wpdb;

$a=$wpdb->insert( "table_name", array( 'image' => $ad_image , 'title' => $title, 'des' => $des, 'link' => $link ), array( '%s', '%s', '%s', '%s' ) );

?>

<?php

global $wpdb;

$a=$wpdb->insert( "table_name", array( 'image' => $ad_image , 'title' => $title, 'des' => $des, 'link' => $link ), array( '%s', '%s', '%s', '%s' ) );

Fetch Data Form Database :

<?php
global $wpdb;
$data_ads = $wpdb->get_row("SELECT * FROM table_name");
?>

<?php echo $data_ads->image; ?>

<?php

global $wpdb;

$data_ads = $wpdb->get_row("SELECT * FROM table_name");

<?php echo $data_ads->image; ?>

For Display row from database use column name e.g. “<?php echo $data_ads->image; ?>”. Instead of ‘image’ you can use any column name. id,name,image etc.