how to insert data in database in wordpress plugin?

by

how to insert data in database in wordpress plugin Using the $wpdb->insert(), This article describes how to have your plugin automatically create a MySQL/MariaDB table to store its data.

how to insert data in database in wordpress plugin

Using the $wpdb->insert()

function getAccountInfo() {     
  global $wpdb;     
  $table_name = $wpdb->prefix . 'pakainfo_v1';     
  $wpdb->insert($table_name, array('column_1' => $invocie_number, 'column_2' => $subscriptions, //other columns and data (if available) ...)); 
} 

function mySecondFunction() {     
  global $wpdb;     
  $table_name = $wpdb->prefix . 'pakainfo_v1';     
  $commnets = 'Another method of insert.';     
  $date = date('Y-m-d H:i:s');     
  $wpdb->query("INSERT INTO $table_name(content_id, content_message, content_date) VALUES(NULL, '$commnets', '$date')"); 
}

create table and insert data in wordpress plugin

create table in wordpress plugin

prefix . "api_wp_info"; 
$charset_collate = $wpdb->get_charset_collate();
 $sql = "CREATE TABLE IF NOT EXISTS $table_name (
  id mediumint(9) NOT NULL AUTO_INCREMENT,
  name tinytext NOT NULL,
  email tinytext NOT NULL,
  number tinytext NOT NULL,
  shop_domain text NOT NULL,
  PRIMARY KEY  (id)
) $charset_collate";
require_once( ABSPATH .'wp-admin/includes/upgrade.php' );
dbDelta( $sql );
}

?>

how to create table in wordpress database?

function myplugin_update_db_check() {
    global $jal_db_version;
    if ( get_site_option( 'jal_db_version' ) != $jal_db_version ) {
        jal_install();
    }
}
add_action( 'plugins_loaded', 'myplugin_update_db_check' );

Don’t Miss : How To Insert Query In WordPress Using Wpdb? – Examples?

create table and insert data in wordpress plugin

prefix . "api_wp_info"; 
	$charset_collate = $wpdb->get_charset_collate();
	 $sql = "CREATE TABLE IF NOT EXISTS $table_name (
	  id mediumint(9) NOT NULL AUTO_INCREMENT,
	  name tinytext NOT NULL,
	  email tinytext NOT NULL,
	  number tinytext NOT NULL,
	  shop_domain text NOT NULL,
	  PRIMARY KEY  (id)
	) $charset_collate";
	require_once( ABSPATH .'wp-admin/includes/upgrade.php' );
	dbDelta( $sql );
}
function insermember()
{global $wpdb;
$table_name = $wpdb->prefix . "api_wp_info"; 
$wpdb->insert('wp_api_wp_info',
array('name'=>$name,
'email'=>$email,
'number'=>$number,
'shop_domain'=>$shop_domain),
array('%s','%s'));
register_activation_hook(__FILE__, 'table_create' );
register_activation_hook(__FILE__, 'insermember' );
?>

How to insert form data in MySql database WordPress?

insert( 'wp_post_job', array(
'profile' => $_POST['profile'],
'lname' => $_POST['lname'],
'email' => $_POST['email'],
'city' => $_POST['city'],
array( '%s', '%s', '%s', '%s')
);
}
?> 


infinityknow.com blog.

Your valuable feedback, question, or comments about this article are always welcome.

If you enjoyed and liked this post, don’t forget to share.





 
Related posts:
    

  1. how to Get Database Table Prefix In WordPress?
    2.

Leave a Comment