How to use wordpress wpdb class to insert data

Question

I am new to wordpress I am try to create table and insert data to that table. so within the wordpress database I created table called 'album' then I created directory called 'my-codes'(within root directory/ same level with 'wp-admin' , 'wp-content, 'wp-includes' directories)

within that directory I created insert.php then i added following code

<?php       
global $wpdb;
$wpdb->insert($wpdb->album , array("ID"=>1, "Name"=>'something'), array("%d", "%s"));

 ?>

but it give this error Fatal error: Call to a member function insert() on a non-object in C:\wamp\www\wordpress\my-codes\insert.php what is the mistake I did, please help me.

Joseph Silber · Accepted Answer · 2012-11-16 02:54:13Z

1

You have to load the Wordpress files within your script, so that you have access to Wordpress' $wpdb object:

require_once( '../wp-load.php' );

This will load all of Wordpress, even the functionality you don't need. If you want to only load the database part, read this article.

Update - The first argument to the insert method should be the name of your table:

$wpdb->insert(
    'album',
     array("ID"=>1, "Name"=>'something'),
     array("%d", "%s")
);

edited Nov 16, 2012 at 2:54

answered Nov 16, 2012 at 2:32

Joseph Silber

221k59 gold badges369 silver badges292 bronze badges

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

2 Comments

Joseph Silber Over a year ago

@user1784592 - The first argument to the insert method should be a string. See the update to my answer.

user1784592 Over a year ago

Sir, this question not related to above question, so if we want to retrieve data or update we have create separate files for each function isn't it ?

Maximus · Accepted Answer · 2012-11-16 02:35:35Z

0

require (dirname(dirname(__FILE__)) . '/wp-blog-header.php');
require (ABSPATH . WPINC . '/compat.php');
require (ABSPATH . WPINC . '/functions.php');
require (ABSPATH . WPINC . '/classes.php');

require_wp_db();
global $wpdb; // Look look! Over here! line 270 in wp-settings.php

if ( !empty($wpdb->error) )
        dead_db();

 //Execute your query here

answered Nov 16, 2012 at 2:35

Maximus

2,9564 gold badges40 silver badges55 bronze badges

Comments

Spencer Cameron-Morin · Accepted Answer · 2012-11-16 02:41:50Z

I would recommend using the WordPress Options API instead of creating a custom table, unless options won't fit your needs. Also, place all your code in your theme's functions.php. That way, you won't need to load any other WordPress files externally. They're already loaded for you automatically if your code is in functions.php.

Here's a quick example of how to store data in the database using options ( taken from the WP Codex article linked above ):

// Create an option to the database
add_option( $option, $value = , $deprecated = , $autoload = 'yes' );

// Removes option by name.
delete_option( $option );

// Fetch a saved option
get_option( $option, $default = false );

// Update the value of an option that was already added.
update_option( $option, $newvalue );

Options are much easier to implement and generally less error prone than direct database access. :)

Collectives™ on Stack Overflow

How to use wordpress wpdb class to insert data

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related