Create Tables in wordpress db

Posted on by

register_activation_hook(__FILE__,’jal_install’);

register_activation_hook(__FILE__,’jal_install_data’);

function prefix_on_deactivate() {

$table_name = $wpdb->prefix . “evebook”;

$sql = “DROP TABLE ” . $table_name;

require_once(ABSPATH . ‘wp-admin/includes/upgrade.php’);

dbDelta($sql);

}

register_deactivation_hook(__FILE__, ‘prefix_on_deactivate’);

global $jal_db_version;

$jal_db_version = “1.0”;

function jal_install() {

global $wpdb;

global $jal_db_version;

$table_name = $wpdb->prefix . “evebook”;

//  time datetime DEFAULT ‘0000-00-00 00:00:00’ NOT NULL,

$sql = “CREATE TABLE $table_name (

id mediumint(9) NOT NULL AUTO_INCREMENT,

evename tinytext NOT NULL,

name tinytext NOT NULL,

title tinytext NOT NULL,

company tinytext NOT NULL,

industary tinytext NOT NULL,

caddress text NOT NULL,

tel tinytext NOT NULL,

mobile tinytext NOT NULL,

fax tinytext NOT NULL,

email tinytext NOT NULL,

seats tinytext NOT NULL,

UNIQUE KEY id (id)

);”;

require_once(ABSPATH . ‘wp-admin/includes/upgrade.php’);

dbDelta($sql);

add_option(“jal_db_version”, $jal_db_version);

}

function jal_install_data() {

global $wpdb;

$welcome_name = “Mr. WordPress”;

$welcome_text = “Congratulations, you just completed the installation!”;

$rows_affected = $wpdb->insert( $table_name, array( ‘time’ => current_time(‘mysql’), ‘name’ => $welcome_name, ‘text’ => $welcome_text ) );

}

Insert contetn into table

<?php

if(isset($_POST[“booking”])){

global $wpdb;

$table_name = $wpdb->prefix . “evebook”;

$evename = get_the_title();

$salutation = $_POST[“salutation”];

$fname = $_POST[“firstname”];

$lname = $_POST[“lastname”];

$title = $_POST[“title”];

$company = $_POST[“company”];

$industary = $_POST[“industry”];

$comaddress = $_POST[“caddres”].’,’;

$street = $_POST[“street”].’,’;

$district = $_POST[“district”].’,’;

$region = $_POST[“region”];

$tele = $_POST[“phone”];

$mobile = $_POST[“mobile”];

$fax = $_POST[“fax”];

$email = $_POST[“email”];

$seats = $_POST[“seat”];

$rows_affected = $wpdb->insert( $table_name, array(

‘evename’ => $evename,

‘name’ => $salutation .’ ‘ . $fname .’ ‘. $lname ,

‘title’ => $title ,

‘company’ => $company,

‘industary’ => $industary,

‘caddress’ => $comaddress .’ ‘. $street .’ ‘. $district .’ ‘. $region ,

‘tel’ => $tele,

‘mobile’ => $mobile,

‘fax’ => $fax,

’email’ => $email,

‘seats’ => $seats ) );

//$rows_affected = $wpdb->query( $wpdb->prepare( “DELETE FROM $table_name WHERE name = %d”, ‘null’));

} ?>