php代码
<?php
// 根据uid进行分库分表
$uid = 10;
$model = usercontact::model($uid); // 覆盖了原有参数，改为传人分库分表所依据的值
$data = $model->findall();
$data = $model->dbconnection->createcommand()
->select("*")
->from($model->tablename())
->where('uid>1')
->limit(10)
->queryall();
$db = yii::app()->dbconnectionmanager->sharded($uid); // 调用sharded方法 设置库和表
$data = $db->createcommand()
->select("*")
->from('user_contact_'.$db->shardedtablekey)
->where('uid>1')
->limit(10)
->queryall();