Eine auf WordPress spezialiserte Suchmaschine für Entwickler und Theme-Autoren



check_column ›

Seit1.0.0
Veraltetn/v
check_column ( $table_name, $col_name, $col_type, $is_null = null, $key = null, $default = null, $extra = null )
Parameter: (7)
  • (string) $table_name Table name
    Erforderlich: Ja
  • (string) $col_name Column name
    Erforderlich: Ja
  • (string) $col_type Column type
    Erforderlich: Ja
  • (bool) $is_null Optional. Check is null.
    Erforderlich: Nein
    Standard: null
  • (mixed) $key Optional. Key info.
    Erforderlich: Nein
    Standard: null
  • (mixed) $default Optional. Default value.
    Erforderlich: Nein
    Standard: null
  • (mixed) $extra Optional. Extra value.
    Erforderlich: Nein
    Standard: null
Gibt zurück:
  • (bool) True, if matches. False, if not matching.
Definiert in:
Codex:

Check column matches criteria.

Uses the SQL DESC for retrieving the table info for the column. It will help understand the parameters, if you do more research on what column information is returned by the SQL statement. Pass in null to skip checking that criteria.

Column names returned from DESC table are case sensitive and are listed: Field Type Null Key Default Extra



Quellcode

function check_column( $table_name, $col_name, $col_type, $is_null = null, $key = null, $default = null, $extra = null ) {
	global $wpdb;
	$diffs   = 0;
	$results = $wpdb->get_results( "DESC $table_name" );

	foreach ( $results as $row ) {

		if ( $row->Field == $col_name ) {

			// Got our column, check the params.
			if ( ( $col_type != null ) && ( $row->Type != $col_type ) ) {
				++$diffs;
			}
			if ( ( $is_null != null ) && ( $row->Null != $is_null ) ) {
				++$diffs;
			}
			if ( ( $key != null ) && ( $row->Key != $key ) ) {
				++$diffs;
			}
			if ( ( $default != null ) && ( $row->Default != $default ) ) {
				++$diffs;
			}
			if ( ( $extra != null ) && ( $row->Extra != $extra ) ) {
				++$diffs;
			}
			if ( $diffs > 0 ) {
				return false;
			}
			return true;
		} // end if found our column
	}
	return false;
}