^ 回到顶部
  • 人生没有定律,每个人都有自己的节奏
  • 本站wordpress建站教程均通过实践后发布,希望对你有帮助
  • 希望你的坚持,都是因为热爱,而不是因为不甘心
  • 5年wordpress建站经验,5星服务品质
  • 那些不愿意让你吃亏的人,才是真正值得你深交的人,也是值得你付出时间的人
  • 阿里云1核2g仅需102元/年,今日10点开抢

wordpress函数check_column()用法示例

check_column( string $table_name,  string $col_name,  string $col_type,  bool $is_null = null,  mixed $key = null,  mixed $default = null,  mixed $extra = null )

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


参数

$table_name

(string)
(Required)
Table name

$col_name

(string)
(Required)
Column name

$col_type

(string)
(Required)
Column type

$is_null

(bool)
(Optional)
Check is null.

Default value: null

$key

(mixed)
(Optional)
Key info.

Default value: null

$default

(mixed)
(Optional)
Default value.

Default value: null

$extra

(mixed)
(Optional)
Extra value.

Default value: null


返回值

(bool) True, if matches. False, if not matching.


源代码

File: wp-admin/install-helper.php

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

更新日志

Version 描述
1.0.0 Introduced.

相关函数

Uses

  • wp-includes/wp-db.php:
    wpdb::get_results()

User Contributed Notes

让小雨知道,这篇文章帮到了你
扫码关注微信公众号zs40086(微搜片)随时随地微信看片,抢先福利电影等你来

热门推荐

如有疑问,请前往问答中心反馈!

反馈