21,886
社区成员
发帖
与我相关
我的任务
分享
/*
*pdo链接 多少自己填,主从可以一样
* key 为正则表达式 ^web_开头的表,使用的链接
*/
$config['pdoconn']=array(
'default'=>array("master"=>array("0"=>array("dsn"=>"mysql:dbname=mallbook;host=localhost;port=3306","username"=>"admin","password"=>"123456","CHARACTER"=>"utf8")),
"slaves"=>array("0"=>array("dsn"=>"mysql:dbname=mallbook;host=localhost;port=3306","username"=>"admin","password"=>"123456","CHARACTER"=>"utf8"))
)
);
//产品环境使用(Product)
//$projectenv="product";
$projectenv="product";
$config["webprojectpath"]=dirname(__FILE__)."/";
$config["webprojectname"]=strlen($_SERVER['SCRIPT_FILENAME'])."projectname"; //根据项目来缓存,所以最好一个网站不要一样
include($config["webprojectpath"]."framework/queryorm.php");
$supply=M("supply"); //表示生成一个数据库模型
$supply->get(3,4); //表示取得两条主键为3 4的两条记录
print_r($supply->record);
array (
0 =>
array (
'supplyid' => '3',
'typeid' => '1',
'bookid' => '410',
'userid' => '0',
'total' => '0',
'isView' => 'Y',
'author' => '',
'linkname' => '',
'phone' => '',
'isPic' => 'N',
'mobile' => '13800138000',
'address' => '上地站',
'email' => '',
'msn' => '',
'qq' => '',
'title' => 'ssssssss',
'dest' => '',
'picurl' => '',
'srcpri' => '0.00',
'outpri' => '0.00',
'per' => '0.0',
'press' => '',
'adddate' => '2007-10-06',
'content' => 'ssssssssssss',
),
1 =>
array (
'supplyid' => '4',
'typeid' => '2',
'bookid' => '0',
'userid' => '0',
'total' => '0',
'isView' => 'Y',
'author' => '',
'linkname' => '',
'phone' => '',
'isPic' => '',
'mobile' => '',
'address' => '天津河东',
'email' => '',
'msn' => '',
'qq' => '',
'title' => '标题',
'dest' => '',
'picurl' => '',
'srcpri' => '0.00',
'outpri' => '0.00',
'per' => '0.0',
'press' => '',
'adddate' => '2007-10-06',
'content' => '内容',
),
)
$supply->up();//edit 3 编辑刚才那两条记录第一行记录内容
//up执行后 $supply->data就有数据了
//有点类似$result[0];样子
//如果再up一次就是$result[1] 如果最后没有了就会变成空了
//当然也可以
$rowobj=$supply->getObjRecord();
$row=$supply->getRecord();
//这两个都是取得$supply->record;
//取回所有record数据
function setpassword($pwd)
{
$this->data['password']=md5($pwd);
return $this;
}
$supply=M("supply");
$supply->get(3,4)->up(); //把3设置为编辑状态
$books=M("booktype");
$books->get(411)->up(); //取得id为411的行 并设置为编辑状态
$info=M("info")->limit(1)->fetch()->up(); //取得info一行记录并设置编辑状态
$supply->Books($books)->Infos($info)->fetch(); //关联查询
//有点类似这样子 where("bookid='".$books->bookid."' and typeid='".$infos->infoid."'")->fetch();
//当然这样也行 只要设置了$books,$infos有数据为编辑状态后
$supply->Books()->Infos()->fetch(); //是一样的。
print_r($supply->getRecord());
//$supply->findBySupplyidDY("12");
where supplyid>'12' //DY表示大于
//AND|OR|LIKE|DY|DD|XY|XD|BD|ISNULL|NOTNULL|IN|NOTIN|NOTEQ|EQ
// > >= < <= != != =
//对应的符号
//$supply->whereuseridORbookid(12,9);
where userid='12' OR bookid='9' //像用户登录时候查询经常用到
//$supply->whereUseridANDBookid(12,9);
where userid='12' AND bookid='9'
//$supply->findBybookidORuseridINaddress(12,array(77,56,8,9),'cname');
where bookid='12' OR userid IN (77,56,8,9) AND address='cname'