wpseek.com
Bazujące na WordPress narzędzie wyszukiwania dla deweloperów i twórców motywów.



maybe_drop_column › WordPress Function

Od1.0.0
Przestarzałyn/a
› maybe_drop_column ( $table_name, $column_name, $drop_ddl )
Parametry: (3)
  • (string) $table_name Database table name.
    Wymagane: Tak
  • (string) $column_name Table column name.
    Wymagane: Tak
  • (string) $drop_ddl SQL statement to drop column.
    Wymagane: Tak
Powrót:
  • (bool) True on success or if the column doesn't exist. False on failure.
Zdefiniowane na:
Codex:

Drops column from database table, if it exists.



Powiązane Funkcje: maybe_add_column, _maybe_update_plugins, _maybe_update_core, get_hidden_columns, make_db_current

Źródło 

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;
}