WordPress 5 Cookbook

How to do it...

Follow these steps to create a custom table using a plugin:

1. Open the wpcookbookchapter7.php file using the code editor.
2. Add the following code at the end of the file to create a custom table on plugin activation:

register_activation_hook( __FILE__, 'wpccp_chapter7_install_db_tables' );function wpccp_chapter7_install_db_tables(){  global $wpdb,$wp_roles;  $wpccp_book_details = $wpdb->prefix . 'wpccp_book_details';  $sql_wpccp_book_details = "CREATE TABLE IF NOT EXISTS   $wpccp_book_details (    id int(11) NOT NULL AUTO_INCREMENT,    book_id int(11) NOT NULL,    book_price varchar(256) NOT NULL,    book_pages int(11) NOT NULL,    updated_at datetime NOT NULL,    PRIMARY KEY (id)    );";  require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta( ...