<?php
//數(shù)據(jù)庫操作
//1.導(dǎo)入數(shù)據(jù)庫
require("../../public/dbconfig.php");
//2.連接數(shù)據(jù)庫
$link=mysql_connect(HOST,USER,PASS) or die("數(shù)據(jù)庫連接失敗");
//3.選擇數(shù)據(jù)庫，設(shè)置字符集
mysql_select_db(DBNAME,$link);
mysql_set_charset("utf8");
//4.編寫sql語句，發(fā)送sql語句到數(shù)據(jù)庫
$sql="select * from users";
$res=mysql_query($sql,$link);
//5.解析結(jié)果集
while($user=mysql_fetch_assoc($res)){
echo "<tr align='center'>";
echo "<td>{$userstate[$user['state']]}</td>";
echo "<td>{$user['username']}</td>";
echo "<td>".date("Y-m-d",$user['addtime'])."</td>";
echo "<td>
<a href='edit.php?id={$user['id']}'>修改</a> 
<a href='action.php?a=del&id={$user['id']}'>刪除</a>
</td>";
echo "</tr>";
}
mysql_free_result($res);
mysql_close($link);
?>

<?php>
//在advanced\common\config\main-local.php的conponents中配置好db；
//連接數(shù)據(jù)庫
$connection = Yii::$app->db;
//編寫預(yù)處理查詢語句
$command = $connection->createCommand('SELECT * FROM post');
//執(zhí)行操作
$posts = $command->queryAll();
$post = $command->queryOne();
$titles = $command->queryColumn();
<?php>

//數(shù)據(jù)表customer對象實例化
$customer = new Customer();
$customer->name = 'Qiang';
$customer->save(); // 一行新數(shù)據(jù)插入 customer 表