Hello Wp Rockers,
If you work with WordPress database then you must familiar
with some WordPress tables like wp_users, wp_posts, wp_comments etc.
Now if you want to create some more tables with custom columns.
Then here is a cool solution for you.
I’m going to create a new table wp_account. So I’m using
CREATE TABLE sql and set my column names with data types.
Take a look on the codes.
<?php // CREATE TABLE WP_ACCOUNT global $wpdb; $table_name = $wpdb->base_prefix."account"; if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name){ $sql = "CREATE TABLE ".$wpdb->base_prefix."account( account_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, client_id VARCHAR(200) NOT NULL, total_payment VARCHAR(200) NOT NULL, payment_date VARCHAR(200) NOT NULL, work_title VARCHAR(200) NOT NULL, details LONGTEXT NULL )"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta($sql); } ?>
First I’m using $wpdb->base_prefix for use the current prefix (Example: wp_ ).
I checked the table already exist or not by using $wpdb->get_var. Finally dbDelta for manupulate the sql.
Use this code. Refresh your database and check the new table wp_account with all the custom fields.
Another thing, if you want to know about How to remove a table in WordPress, please check the tutorial.
This website was… how do you say it? Relevant!! Finally I have found something
which helped me. Appreciate it!
Thanks you for like