public function addpic($picdata) { $insertValues = array(); $pdoParams = array(); foreach ($picdata as $k => $v) { $insertValues[$k] = ':' . $k; $pdoParams[':' . $k] = $v; } $pdo = MysqlPDOModel::Me('sp_pic', 'content'); return $pdo->prepareInsert($insertValues)->insertPrepared($pdoParams); }
/** * 检查 */ public function checkUsername($username, $passwd) { $pdo = MysqlPDOModel::Me('user', 'admin'); $adminInfo = $pdo->prepareSelect('*', 'email=:email AND passwd=:passwd')->selectPrepared(array(':email' => $username, ':passwd' => $passwd)); if (!$adminInfo) { return false; } else { // 生成token $modAdmin = new admin_AdmintokenModel(); $token = $modAdmin->createToken($adminInfo); // 返回token return $token; } }
/** * 添加博客 * @param array $blogData * @return boolean */ public function addBlog($blogData) { if (!is_array($blogData)) { return false; } $insertValues = array(); $pdoParams = array(); foreach ($blogData as $k => $v) { $insertValues[$k] = ':' . $k; $pdoParams[':' . $k] = $v; } $pdo = MysqlPDOModel::Me('sp_blog', 'content'); return $pdo->prepareInsert($insertValues)->insertPrepared($pdoParams); }
/** * 默认动作 * Yaf支持直接把Yaf_Request_Abstract::getParam()得到的同名参数作为Action的形参 * 对于如下的例子, 当访问http://yourhost/Sample/index/index/index/name/root 的时候, 你就会发现不同 */ public function indexAction($name = "Stranger") { //$this->redirect('/shop/index/index/'); //return FALSE; //1. fetch query //$get = $this->_request->getQuery("get", "default value"); //2. fetch model //$model = new SampleModel(); //$model = new TestModel(); //$model->testRedis(); //$model = new p2b_UserModel(); //var_dump($model); // $yac = new \Yac(); // var_dump($yac->info()); //3. assign //$this->_view->assign("content", $model->selectSample()); //$this->_view->assign("name", $name); //4. render by Yaf, 如果这里返回FALSE, Yaf将不会调用自动视图引擎Render模板 $pdo = MysqlPDOModel::Me('user', 'user'); var_dump($pdo); response('Hello, It\'s Working', 0, 'PRINT'); }
/** * 获取博客详情 */ public function getBlogInfoById($blogid) { $pdo = MysqlPDOModel::Me('sp_blog', 'content'); return $pdo->prepareSelect('*', 'blogid=:blogid')->selectPrepared(array('blogid' => $blogid), 'One'); }