本文整理汇总了PHP中SqlQuery类的典型用法代码示例。如果您正苦于以下问题:PHP SqlQuery类的具体用法?PHP SqlQuery怎么用?PHP SqlQuery使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了SqlQuery类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: loadProjectKeywords
public function loadProjectKeywords($projectId)
{
$sql = 'SELECT * FROM keywords WHERE u_p_c_id = ? AND type = 2';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->set($projectId);
return $this->getList($sqlQuery);
}
示例2: buscar
public function buscar($nombre)
{
$sql = 'SELECT * FROM apuntes u WHERE titulo like ? and b_borrado=0';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setString('%' . $nombre . '%');
return $this->getList($sqlQuery);
}
示例3: queryByConfiguracionIdMontoAsc
public function queryByConfiguracionIdMontoAsc($value)
{
$sql = 'SELECT * FROM reglas_cupones WHERE configuracion_id = ? order by monto ASC';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber($value);
return $this->getList($sqlQuery);
}
示例4: queryByDistribuidorId
public function queryByDistribuidorId($value)
{
$sql = 'SELECT * FROM condicion WHERE usuario_id = ? OR usuario_id IS NULL order by condicion_categoria_id';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber($value);
return $this->getList($sqlQuery);
}
示例5: _supplierCollection
protected function _supplierCollection($key)
{
$sqlQuery = new SqlQuery();
$sql = "SELECT id, name" . $this->table . "FROM supplier`" . $this->index . "`WHERE" . $key . "\n\n LEFT JOIN ( SELECT id_ingredient, id_supplier, MIN(price) FROM has_supplier\n\n IF (id=id_supplier){min(price)}";
$result = $sqlQuery->execute($sql);
return $result['supplier'];
}
示例6: getResponses
/**
* Get all records from table
*/
public function getResponses($challengeId)
{
$sql = "SELECT response.*, user.first_name, user.last_name, user.username \r\n\t\t\t\t\tFROM challenge_responses as response JOIN user_info as user\r\n\t\t\t\t\t\tWHERE response.challenge_id = ? AND response.user_id = user.id ORDER BY response.creation_time ASC ;";
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber($challengeId);
return $this->getListReponse($sqlQuery);
}
示例7: load
public function load($indexList = null, $column = false)
{
$sqlQuery = new SqlQuery();
$column = $column ? $column : $this->index;
if (isset($indexList)) {
$indexList = " WHERE " . $column . " IN (" . implode(',', $indexList) . ")" . implode(' AND ', $this->filters);
} else {
$indexList = array_reduce($this->filters, function ($prev, $next) {
return $prev == "" ? " WHERE " . $next : $prev . " AND " . $next;
}, "");
}
if ($this->order) {
$indexList .= ' ORDER BY `' . $this->orderColumn . '` ' . $this->orderDir;
}
if ($this->limit > -1) {
$indexList .= ' LIMIT ' . $this->limit;
}
$sql = "SELECT * FROM " . $this->table . $indexList;
$result = $sqlQuery->execute($sql);
if ($result['status']) {
foreach ($result['data'] as $item) {
$this->processItem($item);
}
}
}
示例8: getUserJobPreferredJobLocations
public function getUserJobPreferredJobLocations($userId)
{
$sql = "SELECT * FROM working_locations as locations JOIN user_locations as user_location \r\n\t\t\t\t\tWHERE locations.id = user_location.location_id \r\n\t\t\t\t\t\tAND user_location.user_id = ?";
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber($userId);
return $this->getList($sqlQuery);
}
示例9: queryAllConversation
/**
* Get all records from table
*/
public function queryAllConversation($projectId)
{
$sql = 'SELECT * FROM project_responses WHERE project_id = ? AND status = 5';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber($projectId);
return $this->getList($sqlQuery);
}
示例10: updateStatus
public function updateStatus($id)
{
$sql = 'UPDATE user_access_aid SET status=1 WHERE id = ?;';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber($id);
return $this->executeUpdate($sqlQuery);
}
示例11: deleteReminder
public function deleteReminder($id)
{
$sql = 'UPDATE reminders SET status = 2 WHERE id = ?';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber($id);
return $this->executeUpdate($sqlQuery);
}
示例12: queryInFechas
function queryInFechas($inicio, $fin, $hotelId)
{
$sql = "SELECT DISTINCT * FROM hotel_fechas\n WHERE hotel_id = ? AND UNIX_TIMESTAMP(fecha) BETWEEN UNIX_TIMESTAMP('{$inicio}') \n AND UNIX_TIMESTAMP('{$fin}')";
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber($hotelId);
return $this->getList($sqlQuery);
}
示例13: deleteByFormIdUserId
public function deleteByFormIdUserId($userId, $formId)
{
$sql = 'DELETE FROM teamroom_push_forms.user_forms WHERE user_id = ? AND form_id = ?';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber($userId);
$sqlQuery->setNumber($formId);
return $this->executeUpdate($sqlQuery);
}
示例14: baja
public function baja($id)
{
$sql = 'UPDATE usuarios SET b_borrado = ? WHERE id_usuario = ?';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->setNumber("1");
$sqlQuery->setNumber($id);
return $this->executeUpdate($sqlQuery);
}
示例15: updateLastLoginTime
public function updateLastLoginTime($userId, $timestamp)
{
$sql = 'UPDATE user_info SET last_login_time = ? WHERE id = ?';
$sqlQuery = new SqlQuery($sql);
$sqlQuery->set($timestamp);
$sqlQuery->set($userId);
return $this->executeUpdate($sqlQuery);
}