WordPress开发者和主题制作者的搜索引擎



check_column ›

Since1.0.0
已弃用n/a
check_column ( $table_name, $col_name, $col_type, $is_null = null, $key = null, $default = null, $extra = null )
参数: (7)
  • (string) $table_name Table name
    Required: Yes
  • (string) $col_name Column name
    Required: Yes
  • (string) $col_type Column type
    Required: Yes
  • (bool) $is_null Optional. Check is null.
    Required: No
    默认: null
  • (mixed) $key Optional. Key info.
    Required: No
    默认: null
  • (mixed) $default Optional. Default value.
    Required: No
    默认: null
  • (mixed) $extra Optional. Extra value.
    Required: No
    默认: null
返回:
  • (bool) True, if matches. False, if not matching.
定义在:
文档:

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



源码

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