当前位置: 首页>>代码示例>>PHP>>正文


PHP SqlQuery::setNumber方法代码示例

本文整理汇总了PHP中SqlQuery::setNumber方法的典型用法代码示例。如果您正苦于以下问题:PHP SqlQuery::setNumber方法的具体用法?PHP SqlQuery::setNumber怎么用?PHP SqlQuery::setNumber使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在SqlQuery的用法示例。


在下文中一共展示了SqlQuery::setNumber方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: 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);
 }
开发者ID:rajnishp,项目名称:teamroomV3,代码行数:8,代码来源:UserFormsMySqlExtDAO.class.php

示例2: 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);
 }
开发者ID:PhyrionX,项目名称:OPUniversity,代码行数:8,代码来源:UsuariosMySqlExtDAO.class.php

示例3: deleteUserSkill

 /**
  * Delete record from table
  * @param skill primary key
  */
 public function deleteUserSkill($id, $userId)
 {
     $sql = 'DELETE FROM user_skills WHERE id = ? AND user_id = ?';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($id);
     $sqlQuery->setNumber($userId);
     return $this->executeUpdate($sqlQuery);
 }
开发者ID:rajnishp,项目名称:teamroomV3,代码行数:12,代码来源:SkillsMySqlExtDAO.class.php

示例4: update

 /**
  * Update record in table
  *
  * @param RelacionAmigosMySql relacionAmigo
  */
 public function update($relacionAmigo)
 {
     $sql = 'UPDATE relacion_amigos SET fecha_amistad = ? WHERE id_usuario1 = ?  AND id_usuario2 = ? ';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->set($relacionAmigo->fechaAmistad);
     $sqlQuery->setNumber($relacionAmigo->idUsuario1);
     $sqlQuery->setNumber($relacionAmigo->idUsuario2);
     return $this->executeUpdate($sqlQuery);
 }
开发者ID:PhyrionX,项目名称:OPUniversity,代码行数:14,代码来源:RelacionAmigosMySqlDAO.class.php

示例5: update

 /**
  * Update record in table
  *
  * @param WorkingLocationsMySql workingLocation
  */
 public function update($workingLocation)
 {
     $sql = 'UPDATE working_locations SET location_name = ?, added_on = ? WHERE id = ?';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($workingLocation->getLocationName());
     $sqlQuery->set($workingLocation->getAddedOn());
     $sqlQuery->setNumber($workingLocation->getId());
     return $this->executeUpdate($sqlQuery);
 }
开发者ID:rajnishp,项目名称:teamroomV3,代码行数:14,代码来源:WorkingLocationsMySqlDAO.class.php

示例6: queryUsuarioEvento

 public function queryUsuarioEvento($idUsuario, $idEvento)
 {
     $sql = 'SELECT DISTINCT e.* FROM evento AS e ';
     $sql .= ' INNER JOIN campania AS c ON c.id = e.campania_id';
     $sql .= ' INNER JOIN empresa AS e ON e.id = c.empresa_id OR e.id = c.empresa_distribuidora_id ';
     $sql .= ' INNER JOIN usuario_empresa AS ue ON e.id = ue.empresa_id';
     $sql .= ' WHERE ue.usuario_id = ? AND e.id = ?';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($idUsuario);
     $sqlQuery->setNumber($idEvento);
     return $this->getList($sqlQuery);
 }
开发者ID:randyibarrola,项目名称:active,代码行数:12,代码来源:EventoMySqlExtDAO.class.php

示例7: 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);
 }
开发者ID:rajnishp,项目名称:teamroomV3,代码行数:10,代码来源:ChallengeResponsesMySqlExtDAO.class.php

示例8: 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);
 }
开发者ID:rajnishp,项目名称:teamroomV3,代码行数:10,代码来源:ProjectResponsesMySqlExtDAO.class.php

示例9: 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);
 }
开发者ID:rajnishp,项目名称:teamroomV3,代码行数:7,代码来源:UserAccessAidMySqlExtDAO.class.php

示例10: 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);
 }
开发者ID:randyibarrola,项目名称:active,代码行数:7,代码来源:HotelFechasMySqlExtDAO.class.php

示例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);
 }
开发者ID:rajnishp,项目名称:teamroomV3,代码行数:7,代码来源:RemindersMySqlExtDAO.class.php

示例12: 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);
 }
开发者ID:rajnishp,项目名称:teamroomV3,代码行数:7,代码来源:WorkingLocationsMySqlExtDAO.class.php

示例13: 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);
 }
开发者ID:randyibarrola,项目名称:active,代码行数:7,代码来源:CondicionMySqlExtDAO.class.php

示例14: deleteTeamMember

 /**
  * Delete team member from table
  * @param team primary key
  */
 public function deleteTeamMember($id)
 {
     $sql = 'UPDATE teams SET member_status = 2 WHERE id = ?';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($id);
     return $this->executeUpdate($sqlQuery);
 }
开发者ID:rajnishp,项目名称:teamroomV3,代码行数:11,代码来源:TeamsMySqlExtDAO.class.php

示例15: 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);
 }
开发者ID:randyibarrola,项目名称:active,代码行数:7,代码来源:ReglasCuponesMySqlExtDAO.class.php


注:本文中的SqlQuery::setNumber方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。