prefix . "member";
function addmyplug() {
global $wpdb;
$table_name = $wpdb->prefix . "member";
$MSQL = "show tables like '$table_name'";
if($wpdb->get_var($MSQL) != $table_name)
{
$sql = "CREATE TABLE IF NOT EXISTS $table_name (
id mediumint(9) NOT NULL AUTO_INCREMENT,
time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
fname varchar(255) NULL,
passwd varchar(255) NULL,
email varchar(255) NULL,
contactno varchar(255) NULL,
address text NULL,
PRIMARY KEY id (id)
) ";
require_once(ABSPATH . "wp-admin/includes/upgrade.php");
dbDelta($sql);
}
}
/* Hook Plugin */
register_activation_hook(__FILE__,'addmyplug');
if(isset($_REQUEST['info']) && $_REQUEST['info'] == 'no'){
header("Location:admin.php?page=myplug/muyplg.php&info=n");
exit;
}
/* Creating Menus */
function member_Menu()
{
/* Adding menus */
add_menu_page(__('Member List'),'Member List', 8,'myplug/muyplg.php', 'member_list');
/* Adding Sub menus */
add_submenu_page('myplug/muyplg.php', 'Add Member', 'Add Member', 8, 'member_add', 'member_add');
wp_register_style('demo_table.css', plugin_dir_url(__FILE__) . 'css/demo_table.css');
wp_enqueue_style('demo_table.css');
wp_register_script('jquery.dataTables.js', plugin_dir_url(__FILE__) . 'js/jquery.dataTables.js', array('jquery'));
wp_enqueue_script('jquery.dataTables.js');
}
add_action('admin_menu', 'member_Menu');
function member_list() {
include "memberlist.php";
}
function member_add() {
include "member-new.php";
}
if(isset($_POST["submit"]))
{
if($_POST["addme"] == "1")
{
$objMem->addNewMember($table_name = $wpdb->prefix . "member",$_POST);
header("Location:admin.php?page=myplug/muyplg.php&info=saved");
exit;
}
else if($_POST["addme"] == "2")
{
$objMem->updMember($table_name = $wpdb->prefix . "member",$_POST);
header("Location:admin.php?page=myplug/muyplg.php&info=upd");
exit;
}
}
function viewmember_list()
{
global $wpdb, $table_name ;
wp_register_style('demo_table.css', plugin_dir_url(__FILE__) . 'css/demo_table.css');
wp_enqueue_style('demo_table.css');
wp_register_script('jquery.dataTables.js', plugin_dir_url(__FILE__) . 'js/jquery.dataTables.js', array('jquery'));
wp_enqueue_script('jquery.dataTables.js');
$sSQL = "select * from $table_name";
$arrresult = $wpdb->get_results($sSQL);
?>
Manage Members
| ID |
Full Name |
E-Mail |
Contact No. |
Address |
0)
{
foreach($arrresult as $key => $val)
{
?>
|
fname; ?> |
email; ?> |
contactno; ?> |
address; ?> |
| No Records |