<?php/*
Plugin Name: Demo Plugin
Plugin URI: https://shwetadanej.com/
Description: A simple way to create custom database tables and it's CRUD operations from WordPress admin panel
Version: 1.0.0
Author: Shweta Danej
Author URI: https://shwetadanej.com/
Text Domain: demo-plugin
*//**
* Add function on plugin activation hook
*/register_activation_hook(__FILE__,'sd_plugin_activation');/**
* Callback function of plugin activation hook
* This will check if website is multisite or not, if yes then loop through it and create table for each website
*
* @return void
*/functionsd_plugin_activation(){$db_created=get_option("sd_db_created");if(!$db_created){global$wpdb;$table1=$wpdb->prefix.'sd_tbl_1';require_once(ABSPATH.'wp-admin/includes/upgrade.php');$charset_collate=$wpdb->get_charset_collate();$table1_query="CREATE TABLE IF NOT EXISTS ".$table1." (
id int(11) NOT NULL AUTO_INCREMENT,
user_id int(11) NOT NULL,
date date NOT NULL,
time time NOT NULL,
PRIMARY KEY id (id)
)$charset_collate;";dbDelta($table1_query);$table2=$wpdb->prefix.'sd_tbl_2';$table2_query="CREATE TABLE IF NOT EXISTS ".$table2." (
id int(11) NOT NULL AUTO_INCREMENT,
question text NOT NULL,
answer varchar(50) NOT NULL,
PRIMARY KEY id (id)
)$charset_collate;";dbDelta($table2_query);update_option("sd_db_created",true);}}
Top comments (0)
Subscribe
We're a place where coders share, stay up-to-date and grow their careers.
Top comments (0)