欢迎移步到新博客中阅读同篇此文
http://exp.szer.me/parry/blog/wordpress/index.php/2018/06/29/medoo-col/
Medoo微框架中也支持原生查询,从而可以通过执行sql指令 SHOW COLUMNS FROM TABLE
来获取字段列信息。
$database = new Medoo([
'database_type' => DATABASE_TYPE,
'database_name' => DATABASE_NAME,
'server' => SERVER,
'username' => USERNAME,
'password' => PASSWORD,
'port' => PORT,
'charset' => CHARSET
]);
$columns = $database->query("SHOW COLUMNS FROM $table")->fetchAll();
//$columns里有全部的数据信息
unset($field_list);
$field_list = [];
foreach ($columns as $col){
//var_dump($col);
/** col是一个数组 里面包含表内一个字段列的信息
可以用数字或字符索引
array(12) {
["Field"]=> string(2) "id"
[0]=> string(2) "id"
["Type"]=> string(7) "int(11)"
[1]=> string(7) "int(11)"
["Null"]=> string(2) "NO"
[2]=> string(2) "NO"
["Key"]=> string(3) "PRI"
[3]=> string(3) "PRI"
["Default"]=> NULL
[4]=> NULL
["Extra"]=> string(0) ""
[5]=> string(0) ""
}
**/
$field_list[] = $col['Field'];
}
var_dump($field_list);