<?php
namespace frontend\controllers;
use yii\web\Controller;
use yii\db\Migration;
use yii\db\Schema;
class TableController extends Controller
{
public function actionIndex()
{
$mir = new Migration();
$sch = new \yii\db\mysql\Schema;
$tableName='shang';
$db=Yii::$app->getDb();
$table=$db->createCommand("SHOW TABLES LIKE '".$tableName."'")->queryAll();
if($table==null) {
echo '1';
}else{
echo '2';
}
// $mir->createTable('shang', [
// 'id' => 'pk',
// 'title' => $sch::TYPE_STRING . ' NOT NULL',
// 'content' => $sch::TYPE_TEXT,
// ]);
$r=$db->getSchema()->getTableNames();//获取表名
$r=$db->getSchema()->getTableSchema('shang');//获取表字段名
}
}
yii2获取表及字段
最新推荐文章于 2023-12-27 19:33:35 发布