prefix . "award"; $award_db_version = "1.0"; add_action('admin_menu', 'awards_menu'); function awards_menu() { add_menu_page('Awards Plugin Settings', 'Add Awards', 'administrator', __FILE__, 'awards_settings',plugins_url('/images/icon.png', __FILE__)); } function awards_settings() { global $wpdb; global $table_name; if($_POST['submit']=="Save") { $dbfields["awards"] =$_POST['awards']; $dbfields["image_url"] =$_POST['image_url']; $rows_affected = $wpdb->insert( $table_name, $dbfields ); } if($_POST['delete']=="Delete") { $rows_affected = $wpdb->query("DELETE FROM $table_name WHERE id = '$_POST[id]'"); } if($_POST['update']=="Update") { $rows_affected = $wpdb->query("UPDATE $table_name SET awards = '$_POST[awards]' , image_url = '$_POST[image_url]' WHERE id = '$_POST[id]'"); } ?>

Award Management

Name of the award Award Image

get_var("show tables like '$table_name'") != $table_name) { $sql = "CREATE TABLE " . $table_name . " ( id mediumint(9) NOT NULL AUTO_INCREMENT, award_name VARCHAR(400) NOT NULL, image_url VARCHAR(400) NOT NULL, UNIQUE KEY id (id) );"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql); add_option("award_db_version", $award_db_version); } } register_activation_hook(__FILE__,'awards_install'); ?>