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



check_column ›

Od1.0.0
Przestarzałyn/a
check_column ( $table_name, $col_name, $col_type, $is_null = null, $key = null, $default = null, $extra = null )
Parametry: (7)
  • (string) $table_name Table name
    Wymagane: Tak
  • (string) $col_name Column name
    Wymagane: Tak
  • (string) $col_type Column type
    Wymagane: Tak
  • (bool) $is_null Optional. Check is null.
    Wymagane: Nie
    Domyślny: null
  • (mixed) $key Optional. Key info.
    Wymagane: Nie
    Domyślny: null
  • (mixed) $default Optional. Default value.
    Wymagane: Nie
    Domyślny: null
  • (mixed) $extra Optional. Extra value.
    Wymagane: Nie
    Domyślny: null
Powrót:
  • (bool) True, if matches. False, if not matching.
Zdefiniowane na:
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



Źródło

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