Adds column to a database table, if it doesn’t already exist.
Parameters
$table_name
stringrequired- Database table name.
$column_name
stringrequired- Table column name.
$create_ddl
stringrequired- SQL statement to add column.
Source
function maybe_add_column( $table_name, $column_name, $create_ddl ) {
global $wpdb;
foreach ( $wpdb->get_col( "DESC $table_name", 0 ) as $column ) {
if ( $column === $column_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( "DESC $table_name", 0 ) as $column ) {
if ( $column === $column_name ) {
return true;
}
}
return false;
}
Changelog
Version | Description |
---|---|
1.3.0 | Introduced. |
User Contributed Notes
You must log in before being able to contribute a note or feedback.