做个笔记,tp5操作数据库字段。
public function add_alter(){
$flag = Db::query("Describe `cm_ip_distance` `xxx`");
if($flag){
$data = ['longitude'=>'113.303604','latitude'=>'29.475075','distance'=>'532','xxx'=>1606288381];
}
else{
$query = Db::query("ALTER TABLE `cm_ip_distance` ADD `xxx` varchar(20)");
$data = ['longitude'=>'116.34','latitude'=>'40.45','distance'=>'1600.23','xxx'=>1576080000];
}
$insert = Db::table('cm_ip_distance')->insert($data);
}