For plugins or themes often database connections are needed to store settings for APIs or other things. Below you will find the code for creating a new table in the database. We use a plugin for this. The connection is made via The plugin creates a 4 column table when activated. This then looks like this:<\/p>\n\n\n\n <\/span> In the following examples, this table is used as a starting point.<\/p>\n\n\n\n WordPress DB (short The output shows all account names which have the fictitious Strictly speaking, all the magic happens on line 3.<\/p>\n\n\n\n In this query, $wpdb<\/code> with the WordPress database credentials:<\/p>\n\n\n\nfunction create_plugin_database_tables( ) {\n global $wpdb, $table_prefix;\n require_once( ABSPATH . '\/wp-admin\/includes\/upgrade.php' );\n $new_table = $table_prefix . "plugin_table_name";\n if( $wpdb->get_var( "show tables like '$new_table'" ) != $new_table )\n {\n $sql = "CREATE TABLE `" . $new_table . "` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `account_name` varchar(255) NOT NULL,\n `account_type` int(11) NOT NULL,\n `transfer_state` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ";\n dbDelta($sql);\n }\n}\nregister_activation_hook( __FILE__, 'create_plugin_database_tables' );<\/pre><\/div>\n\n\n\n
Name `wp_plugin_table_name`<\/span><\/span>
<\/span>
`id` int(11)<\/i><\/span><\/span>
<\/span>
`account_name` varchar(255)<\/i><\/span><\/span>
<\/span>
`account_type` int(11)<\/i><\/span><\/span>
<\/span>
`transfer_state` varchar(255)<\/i><\/span><\/span>
<\/span><\/p>\n\n\n\nOptions with WordPress DB<\/h2>\n\n\n\n
$wpdb<\/code>) offers the same structure as normal MySQL Script. These are also used via $wpdb<\/code> in the same complexity. Standard functions like SELECT<\/code>, INSERT<\/code>, UPDATE <\/code>and DELETE<\/code> are covered here in more detail.<\/p>\n\n\n\nWordPress database: SELECT<\/h3>\n\n\n\n
account_name<\/code> = 123aaa and account_type<\/code> = 1.<\/p>\n\n\n\nglobal $wpdb;\n$session_id = "123aaa";\n$dbquery = $wpdb->prepare( "SELECT * FROM ".$wpdb->prefix."plugin_table_name WHERE account_name = %s AND account_type = %d", $session_id, 1 );\n$db_entries = $wpdb->get_results( $dbquery );\nif(count( $db_entries ) != 0 ) {\n\tforeach( $db_entries as $src_entry ) {\n \t$account_name = $src_entry->account_name;\n \treturn $account_name;\n }\n}<\/pre><\/div>\n\n\n\n%<\/code> variables are used. %s<\/code> stands for string, a type assignment as a placeholder. %d<\/code> stands for decimal number, also a placeholder. The values for the query are appended as parameters at the end of the prepare function.<\/p>\n\n\n\nWordPress database: INSERT<\/h3>\n\n\n\n