A WordPress-centric search engine for devs and theme authors



maybe_create_table ›

Since1.0.0
Deprecatedn/a
maybe_create_table ( $table_name, $create_ddl )
Parameters: (2)
  • (string) $table_name Database table name.
    Required: Yes
  • (string) $create_ddl Create database table SQL.
    Required: Yes
Returns:
  • (bool) False on error, true if already exists or success.
Defined at:
Codex:

Create database table, if it doesn't already exist.



Source

function maybe_create_table( $table_name, $create_ddl ) {
		global $wpdb;
		foreach ( $wpdb->get_col( 'SHOW TABLES', 0 ) as $table ) {
			if ( $table == $table_name ) {
				return true;
			}
		}
		// Didn't find it, so try to create it.
		$wpdb->query( $create_ddl );

		// We cannot directly tell that whether this succeeded!
		foreach ( $wpdb->get_col( 'SHOW TABLES', 0 ) as $table ) {
			if ( $table == $table_name ) {
				return true;
			}
		}
		return false;
	}
endif;

if ( ! function_exists( 'maybe_add_column' ) ) :