I Write Code to Save data in the Wordpress database table (table name is wp_fafa)
But Can't Save data in
$qry = $wpdb->query( "INSERT INTO `wp_fafa` (titile,liveprice,changing,lowest,topest,time) VALUES ('" . trim($row->item(0)->nodeValue) . "','" . trim($row->item(2)->nodeValue) . "','" . trim($row->item(4)->nodeValue) . "','" . trim($row->item(6)->nodeValue) . "','" . trim($row->item(8)->nodeValue) . "','" . trim($row->item(10)->nodeValue) . "')");
$wpdb->query($qry);
The following code will properly store data in wp_fafa:
$wpdb->insert( $wpdb->prefix . 'fafa',
array(
'title' => trim($row->item(0)->nodeValue),
'liveprice' => trim($row->item(2)->nodeValue),
'changing' => trim($row->item(4)->nodeValue),
'lowest' => trim($row->item(6)->nodeValue),
'topest' => trim($row->item(8)->nodeValue),
'time' => trim($row->item(10)->nodeValue)
),
array(
'%s',
'%s',
'%s',
'%s',
'%s',
'%s'
)
);
Make sure you have declared the $wpdb variable global $wpdb;. Also calling $wpdb->query() will execute the query for you, so no need to do it again.
I would also recommend using $wpdb->insert() as this escapes your data for you:
global $wpdb;
$wpdb->insert(
$wpdb->prefix . 'fafa',
array(
'titile' => trim( $row->item(0)->nodeValue ),
'liveprice' => trim( $row->item(2)->nodeValue ),
'changing' => trim( $row->item(4)->nodeValue ),
'lowest' => trim( $row->item(6)->nodeValue ),
'topest' => trim( $row->item(8)->nodeValue ),
'time' => trim( $row->item(10)->nodeValue ),
)
);
querymethod and notinsert?