A WordPress-centric search engine for devs and theme authors



maybe_drop_column ›

Since1.0.0
Deprecatedn/a
maybe_drop_column ( $table_name, $column_name, $drop_ddl )
Parameters: (3)
  • (string) $table_name Table name
    Required: Yes
  • (string) $column_name Column name
    Required: Yes
  • (string) $drop_ddl SQL statement to drop column.
    Required: Yes
Returns:
  • (bool) False on failure, true on success or doesn't exist.
Defined at:
Codex:

Drop column from database table, if it exists.



Source

function maybe_drop_column( $table_name, $column_name, $drop_ddl ) {
	global $wpdb;
	foreach ( $wpdb->get_col( "DESC $table_name", 0 ) as $column ) {
		if ( $column == $column_name ) {

			// Found it, so try to drop it.
			$wpdb->query( $drop_ddl );

			// We cannot directly tell that whether this succeeded!
			foreach ( $wpdb->get_col( "DESC $table_name", 0 ) as $column ) {
				if ( $column == $column_name ) {
					return false;
				}
			}
		}
	}
	// Else didn't find it.
	return true;
}