本文整理汇总了PHP中DbHelper::select方法的典型用法代码示例。如果您正苦于以下问题:PHP DbHelper::select方法的具体用法?PHP DbHelper::select怎么用?PHP DbHelper::select使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DbHelper
的用法示例。
在下文中一共展示了DbHelper::select方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getSavedRectangles
function getSavedRectangles()
{
return DbHelper::select(Rectangle::DB_TABLE, array(Rectangle::DB_COL_TOP_A, Rectangle::DB_COL_LEFT_A, Rectangle::DB_COL_TOP_B, Rectangle::DB_COL_LEFT_B));
}
示例2: function
<?php
$app->get('/courses', function () {
$db = new DbHelper();
$columns = "ID,title,description,price,start_date,end_date,max_number_of_students,ID_subject";
$table = "course";
$where = array();
$orwhere = array();
//$limit = 1;
$result = $db->select($table, $columns, $where, $orwhere);
echoResponse(200, $result);
});
示例3: echoResponse
echoResponse(200, $response);
});
$app->post('/signUp', function () use($app) {
$response = array();
$r = json_decode($app->request->getBody());
verifyRequiredParams(array('email', 'nickname', 'password'), $r->user);
require_once 'passwordHash.php';
$db = new DbHelper();
$nickname = $r->user->nickname;
$email = $r->user->email;
$password = $r->user->password;
$columns = 'ID,nickname,password,email,created';
$table = 'user';
$where = "";
$orwhere = "";
$isUserExists = $db->select($table, $columns, $where, $orwhere, '1');
if (!$isUserExists) {
$r->user->password = passwordHash::hash($password);
$table_name = "user";
$column_names = array('nickname', 'email', 'password');
$result = $db->insertIntoTable($r->user, $column_names, $table_name);
if ($result != NULL) {
$response["status"] = "success";
$response["message"] = "User account created successfully";
$response["ID"] = $result;
if (!isset($_SESSION)) {
session_start();
}
$_SESSION['ID'] = $response["ID"];
$_SESSION['nickname'] = $nickname;
$_SESSION['email'] = $email;