| $field_name)) { echo(date($date_format, strtotime($result->$field_name ))); } else { echo($result->$field_name); } ?> | Show | Edit | Delete |
Sorry no records found, please try change your search preferences.
"); } else { echo("Sorry no records found.
"); } } echo("![](".get_option("siteurl")."/wp-content/plugins/admin-block-country/securimage/securimage_show.php)
");
echo("[ Different Image ]");
} else if ($field_type == "select") {
echo("");
} else if ($field_type == "radio") {
echo("");
} else if ($field_type == "checkbox") {
echo("");
}
if ($field_index >= 0) {
$field_id = $field_id."_".$field_index;
}
if ($_SESSION[$field_id."_error"] != "") {
echo "".$_SESSION[$field_id."_error"]."";
}
unset($_SESSION[$field_id."_error"]);
if ($field_type != "hidden") {
echo("");
}
}
// Adds a form field to the page. Only difference is the value is from the Wordpress get_option database table. Example get_option("siteurl").
function add_option_form_field($field_type, $field_label, $field_id, $option_name, $field_attributes = array(), $container_element, $container_attributes = array(), $value_options = array(), $field_index = -1) {
ABCTomM8::add_form_field(null, $field_type, $field_label, $field_id, "tomm8te_admin_option::".$option_name, $field_attributes, $container_element, $container_attributes, $value_options, $field_index);
}
// Creates the option in the database if it doesn't exist. For example: create_option_if_not_exist("plugin_version_no").
function create_option_if_not_exist($option_name) {
if (!get_option($option_name)) {
add_option($option_name);
}
}
// Creates a MySQL database table. Returns a create table sql query object.
function create_table($table_name, $fields_array_with_datatype, $primary_key_array) {
global $wpdb;
$table_name_prefix = $wpdb->prefix . $table_name;
$fields_comma_separated = implode(",", $fields_array_with_datatype);
$primary_key_comma_separated = implode(",", $primary_key_array);
$primary_key_text = ", PRIMARY KEY ($primary_key_comma_separated)";
if (count($primary_key_array) > 1) {
$primary_key_text = ", UNIQUE KEY ".$primary_key_array[0]." ($primary_key_comma_separated)";
}
$sql = "CREATE TABLE $table_name_prefix ($fields_comma_separated $primary_key_text);";
return dbDelta($sql);
}
// Adds fields to a MySQL Database table. Returns a alter table sql query object.
function add_fields_to_table($table_name, $fields_array_with_datatype) {
global $wpdb;
$table_name_prefix = $wpdb->prefix . $table_name;
$fields_comma_separated = implode(",", $fields_array_with_datatype);
$sql = "ALTER TABLE $table_name_prefix ADD $fields_comma_separated";
return $wpdb->query($sql);
}
// Run before making inserts and updates and then you can later rollback or commit a transaction.
function start_transaction($transaction_id) {
global $wpdb;
global $wp_transaction_id;
if ( !isset($wp_transaction_id) ) {
$wp_transaction_id = $transaction_id;
$wpdb->query("START TRANSACTION;");
}
}
// Rollback transaction.
function rollback_transaction($transaction_id) {
global $wpdb;
global $wp_transaction_id;
if ( isset($wp_transaction_id) && $wp_transaction_id == $transaction_id ) {
unset($wp_transaction_id);
$wpdb->query("ROLLBACK;");
}
}
// Commit a transaction.
function commit_transaction($transaction_id) {
global $wpdb;
global $wp_transaction_id;
if ( isset($wp_transaction_id) && $wp_transaction_id == $transaction_id ) {
unset($wp_transaction_id);
$wpdb->query("COMMIT;");
}
}
// Inserts data into the database. Returns true if inserted correct, false if not.
function insert_record($table_name, $insert_array) {
global $wpdb;
ob_start();
$wpdb->show_errors();
$table_name_prefix = $wpdb->prefix.$table_name;
$result = $wpdb->insert($table_name_prefix, $insert_array);
$wpdb->print_error();
$errors = ob_get_contents();
ob_end_clean();
if (preg_match("/WordPress database error:<\/strong> \[\]/", $errors)) {
return true;
} else {
$sql = "SHOW INDEXES FROM $table_name_prefix WHERE non_unique =0 AND Key_name != 'PRIMARY'";
$results = $wpdb->get_results($sql);
foreach ($results as $result) {
$col_name = $result->Column_name;
if (preg_match("/Duplicate entry (.+)'".$col_name."']/", $errors, $matches, PREG_OFFSET_CAPTURE)) {
if (!preg_match("/Must have a unique value/", $_SESSION[$col_name."_error"])) {
$_SESSION[$col_name."_error"] .= "Must have a unique value.";
}
}
}
return false;
}
}
// Updates data in the database. Returns true if updated correctly, false if not.
function update_record_by_id($table_name, $update_array, $id_column_name, $id) {
global $wpdb;
ob_start();
$wpdb->show_errors();
$table_name_prefix = $wpdb->prefix.$table_name;
$result = $wpdb->update($table_name_prefix, $update_array, array($id_column_name => $id));
$wpdb->print_error();
$errors = ob_get_contents();
ob_end_clean();
if (preg_match("/WordPress database error:<\/strong> \[\]/", $errors)) {
return true;
} else {
$sql = "SHOW INDEXES FROM $table_name_prefix WHERE non_unique =0 AND Key_name != 'PRIMARY'";
$results = $wpdb->get_results($sql);
foreach ($results as $result) {
$col_name = $result->Column_name;
if (preg_match("/Duplicate entry (.+)'".$col_name."']/", $errors, $matches, PREG_OFFSET_CAPTURE)) {
if (!preg_match("/Must have a unique value/", $_SESSION[$col_name."_error"])) {
$_SESSION[$col_name."_error"] .= "Must have a unique value.";
}
}
}
return false;
}
}
// Similar to update_record_by_id, but you have more control over which record to update. Returns true if updated correctly, false if not.
function update_record($table_name, $update_array, $where_array) {
global $wpdb;
ob_start();
$wpdb->show_errors();
$table_name_prefix = $wpdb->prefix.$table_name;
$result = $wpdb->update($table_name_prefix, $update_array, $where_array);
$wpdb->print_error();
$errors = ob_get_contents();
ob_end_clean();
if (preg_match("/WordPress database error:<\/strong> \[\]/", $errors)) {
return true;
} else {
$sql = "SHOW INDEXES FROM $table_name_prefix WHERE non_unique =0 AND Key_name != 'PRIMARY'";
$results = $wpdb->get_results($sql);
foreach ($results as $result) {
$col_name = $result->Column_name;
if (preg_match("/Duplicate entry (.+)'".$col_name."']/", $errors, $matches, PREG_OFFSET_CAPTURE)) {
if (!preg_match("/Must have a unique value/", $_SESSION[$col_name."_error"])) {
$_SESSION[$col_name."_error"] .= "Must have a unique value.";
}
}
}
return false;
}
}
// Deletes a record from the database. Returns a sql delete query object.
function delete_record_by_id($table_name, $id_column_name, $delete_id) {
global $wpdb;
$table_name_prefix = $wpdb->prefix.$table_name;
$id_column_name = sanitize_text_field($id_column_name);
$delete_id = intval($delete_id);
return $wpdb->query($wpdb->prepare("DELETE FROM $table_name_prefix WHERE $id_column_name = %d", $delete_id));
}
// Similar to delete_record_by_id, but more flexibility with selecting the record that you want to delete.
function delete_record($table_name, $where_sql) {
global $wpdb;
$table_name_prefix = $wpdb->prefix.$table_name;
$where_sql = sanitize_text_field($where_sql);
return $wpdb->query("DELETE FROM $table_name_prefix WHERE $where_sql");
}
// Get total record count from database table.
// $table_name = (string) The name of table you wish to find the record count for, without the prefix. The prefix is auto added in for you.
// $where_sql = (string)(optional) The SQL Where clause without the keyword WHERE.
function get_record_count($table_name, $where_sql = "") {
global $wpdb;
$table_name_prefix = $wpdb->prefix.$table_name;
if (!empty($where_sql)) {
$where_sql = "WHERE ".$where_sql;
}
$sql = "SELECT COUNT(*) as count FROM $table_name_prefix $where_sql";
// echo $sql;
return $wpdb->get_row($sql)->count;
}
// Select records from the database. Returns sql results object.
function get_results($table_name, $fields_array, $where_sql, $order_array = array(), $limit = "") {
global $wpdb;
$table_name_prefix = $wpdb->prefix.$table_name;
if ($fields_array == "*") {
$fields_comma_separated = "*";
} else {
$fields_comma_separated = implode(",", $fields_array);
}
if (!empty($where_sql)) {
$where_sql = "WHERE ".$where_sql;
}
$order_sql = "";
if (!empty($order_array)) {
$order_sql = "ORDER BY ".implode(",", $order_array);
}
$limit_sql = "";
if ($limit != "") {
$limit_sql = "LIMIT $limit";
}
$sql = "SELECT $fields_comma_separated FROM $table_name_prefix $where_sql $order_sql $limit_sql";
// echo $sql;
return $wpdb->get_results($sql);
}
// Selects a record from the database. Returns one sql record result object.
function get_row_by_id($table_name, $fields_array, $id_column_name, $id) {
global $wpdb;
$table_name_prefix = $wpdb->prefix.$table_name;
if ($fields_array == "*") {
$fields_comma_separated = "*";
} else {
$fields_comma_separated = implode(",", $fields_array);
}
return $wpdb->get_row($wpdb->prepare("SELECT $fields_comma_separated FROM $table_name_prefix WHERE $id_column_name = %d", $id));
}
// Similar to get_row_by_id, but more flexibility with selecting the record that you want.
function get_row($table_name, $fields_array, $where_sql) {
global $wpdb;
$table_name_prefix = $wpdb->prefix.$table_name;
if ($fields_array == "*") {
$fields_comma_separated = "*";
} else {
$fields_comma_separated = implode(",", $fields_array);
}
return $wpdb->get_row("SELECT $fields_comma_separated FROM $table_name_prefix WHERE $where_sql LIMIT 1");
}
}
}
?>