wpseek.com
A WordPress-centric search engine for devs and theme authors
maybe_drop_column › WordPress Function
Since1.0.0
Deprecatedn/a
› maybe_drop_column ( $table_name, $column_name, $drop_ddl )
Parameters: (3) |
|
Returns: |
|
Defined at: |
|
Codex: |
Drops column from database table, if it exists.
Related Functions: maybe_add_column, _maybe_update_plugins, _maybe_update_core, get_hidden_columns, parent_dropdown
Source
function maybe_drop_column( $table_name, $column_name, $drop_ddl ) {
global $wpdb;
// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Cannot be prepared. Fetches columns for table names.
foreach ( $wpdb->get_col( "DESC $table_name", 0 ) as $column ) {
if ( $column === $column_name ) {
// Found it, so try to drop it.
// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- No applicable variables for this query.
$wpdb->query( $drop_ddl );
// We cannot directly tell whether this succeeded!
// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- Cannot be prepared. Fetches columns for table names.
foreach ( $wpdb->get_col( "DESC $table_name", 0 ) as $column ) {
if ( $column === $column_name ) {
return false;
}
}
}
}
// Else didn't find it.
return true;
}