maybe_drop_column

函式
maybe_drop_column ( $table_name, $column_name, $drop_ddl )
引數
  • (string) $table_name Database table name.
    Required:
  • (string) $column_name Table column name.
    Required:
  • (string) $drop_ddl SQL statement to drop column.
    Required:
返回值
  • (bool) True on success or if the column doesn't exist. False on failure.
定義位置
相關方法
maybe_add_column_maybe_update_plugins_maybe_update_coreget_hidden_columnsparent_dropdown
引入
1.0.0
棄用
-

maybe_drop_column: 這是WordPress中的一個函式,允許你從資料庫表中刪除一個列,如果它存在的話: 這個函式檢查該列是否存在,如果存在,它就把該列從表中刪除。

從資料庫表中刪除列,如果它存在的話。

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
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;
}
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; }
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;
}

常見問題

FAQs
檢視更多 >