How to insert query in wordpress database

6 comments

1. WordPress provides the $wpdb class of functions for interacting with the database.

   To insert an email address you could do something like:

   <?php 
   
     $wpdb->insert('wp_email_subscription', 
       array(
         'name'          => 'name',
         'address'       => 'name@email.com'
       ),
       array(
         '%s',
         '%s'
       ) 
     ); 
   
   ?> 
   

   More info on the WordPress Codex.

   Log in to Reply

2. $wpdb->query("INSERT INTO wp_email_subscription (name, email, date) VALUES ('$name', '$email', '$date')"  );
   

   This is if you want to insert values to your table. You do not have to use $wpdb->email_subscription for the prefix as it’s the table you created yourself, otherwise, if you were inserting values to default WordPress tables you would prefer doing
   $wpdb->users etc.

   Log in to Reply

3. you can go for

   global $wpdb;
   $wpdb->insert('wp_email_subscription',array('name'=>$name,'email'=>$email),array('%s','%s'));
   

   go through this for better understanding:

   http://codex.wordpress.org/Class_Reference/wpdb

   Log in to Reply

4. function insert($array = false)
   {
       global $wpdb;
       return $wpdb->insert($wpdb->prefix . 'email_subscription', $array);
   }
   

   Log in to Reply

5.  global $wpdb
   
    $wpdb->insert('wp', array(
                           'email' => $_POST['email'],
                           'city'  =>   $_POST['city'],
                           'state' =>$_POST['state'],
                           'phone' => $_POST['phone'],
                          'mobile' => $_POST['mobile'],
                          )
                );
   

   Log in to Reply

6. global $wpdb;
   $table = $wpdb->prefix.'you_table_name';
   $data = array('column1' => 'data one', 'column2' => 123);
   $format = array('%s','%d');
   $wpdb->insert($table,$data,$format);
   

   All information you can read here

   Log in to Reply