How to create or add new tables using wordpress theme

With custom professional theme you need to add the custom table in wordpress database, Using this code you can, add new tables using wordpress theme

add new tables using wordpress theme

If you want to add one more table to wordpress database you need to just use the following code.

Open the functions.php file and copy paste the code.

[viral-lock message=”Solution code is Hidden! It’s Visible for Users who Liked/Shared This article on Facebook or Twitter or Google+. Like or Tweet this article to reveal the content.”]

01$wordpressapi_db_version = "1.0";
02 
03global $wpdb;
04global $wordpressapi_db_version;
05 
06$table_name = $wpdb->prefix . "liveshoutbox";
07if($wpdb->get_var("show tables like '$table_name'") != $table_name) {
08 
09$sql = "CREATE TABLE " . $table_name . " (
10id mediumint(9) NOT NULL AUTO_INCREMENT,
11time bigint(11) DEFAULT '0' NOT NULL,
12name tinytext NOT NULL,
13text text NOT NULL,
14url VARCHAR(55) NOT NULL,
15UNIQUE KEY id (id)
16);";
17 
18require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
19dbDelta($sql);
20 
21$welcome_name = "Mr. WordPress";
22$welcome_text = "Congratulations, you just completed the installation!";
23 
24$insert = "INSERT INTO " . $table_name .
25" (time, name, text) " .
26"VALUES ('" . time() . "','" . $wpdb->escape($welcome_name) . "','" . $wpdb->escape($welcome_text) . "')";
27 
28$results = $wpdb->query( $insert );
29 
30add_option("wordpressapi_db_version", $wordpressapi_db_version);
31 
32}

[/viral-lock]

`1`	`register_activation_hook(__FILE__,'YOUR_FUNCTION_NAME');`

add new tables using wordpress theme

Published by

Purab

I am Purab from India, Software development is my profession and teaching is my passion. Programmers blog dedicated to the JAVA, Python, PHP, DevOps and Opensource Frameworks. Purab's Github Repo Youtube Chanel Video Tutorials Connect to on LinkedIn View all posts by Purab

One thought on “How to create or add new tables using wordpress theme”

I suggest using CREATE TABLE IF NOT EXISTS instead of querying twice.

add new tables using wordpress theme

Share Article:

Published by

Purab

One thought on “How to create or add new tables using wordpress theme”

Leave a Reply Cancel reply