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');
}
