本文整理汇总了PHP中model::runSql方法的典型用法代码示例。如果您正苦于以下问题：PHP model::runSql方法的具体用法？PHP model::runSql怎么用？PHP model::runSql使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类model的用法示例。
在下文中一共展示了model::runSql方法的11个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getPostulantesEvaluacionByVacante
public function getPostulantesEvaluacionByVacante($vacante)
{
$sql = "select u.id as usuario_id, v.id as vacante_id , et.id as etapa_id, u.nombres, u.apellidos, u.numero_identificacion, v.titulo, et.nombre as etapa, e.valor, e.observacion\n\t\t\t\tfrom vacante as v \n\t\t\t\tinner join postulacion as p on p.vacante_id = v.id\n\t\t\t\tinner join usuario as u on p.postulante_id = u.id \n\t\t\t\tinner join evaluacion as e on e.postulacion_id = p.id\n\t\t\t\tinner join etapa as et on et.id = e.etapa_id\n\t\t\twhere v.id = {$vacante} or 999 = {$vacante}\n\t\torder by u.id, v.id, et.id";
$model = new model();
$result = $model->runSql($sql);
return $model->getRows($result);
}示例2: deleteArea
public function deleteArea()
{
$area = $_GET['id'];
$sql = "update area set eliminado = 1 where id = " . $area;
$model = new model();
$result = $model->runSql($sql);
}示例3: deleteCategoria
public function deleteCategoria()
{
$categoria = $_GET['id'];
$sql = "delete from categoria where id = " . $categoria;
$model = new model();
$result = $model->runSql($sql);
}示例4: getCategoriaList
/**
* Obtiene Categorias
*/
public function getCategoriaList()
{
$model = new model();
$sql = "select * from categoria ";
$result = $model->runSql($sql);
return $model->getRows($result);
}示例5: getUsuarioByCedula
public function getUsuarioByCedula($cedula)
{
$model = new model();
$sql = "select * from usuario where numero_identificacion = " . $cedula;
$result = $model->runSql($sql);
$resultArray = $model->getRows($result);
return $resultArray[0];
}示例6: obtenerUsuario
public function obtenerUsuario($usuario)
{
$model = new model();
$sql = "Select * from usuario where numero_identificacion = " . $usuario;
$result = $model->runSql($sql);
$resultArray = $model->getRows($result);
return $resultArray[0];
}示例7: getRespuestas
public function getRespuestas($desempenioId)
{
$model = new model();
$sql = "SELECT * FROM respuesta as r\t\t\t\t\n\t\t\t\twhere r.desempenio_id = " . $desempenioId;
$result = $model->runSql($sql);
return $model->getRows($result);
}示例8: getEtapaById
public function getEtapaById($id)
{
$model = new model();
$sql = "select * from etapa where id = " . $id;
$result = $model->runSql($sql);
return $model->getRows($result);
}示例9: getPais
public function getPais($pais_id)
{
$model = new model();
$sql = "select * from pais where id = " . $pais_id;
$result = $model->runSql($sql);
$resultArray = $model->getRows($result);
$resultArray = $resultArray[0];
return $resultArray;
}示例10: getAreas
public function getAreas()
{
$model = new model();
$sql = "select * from area where eliminado = 0";
$result = $model->runSql($sql);
return $model->getRows($result);
}示例11: getEmailByCI
public function getEmailByCI($user)
{
$model = new model();
$sql = "select * from usuario where username = " . $user . " and eliminado = 0";
$result = $model->runSql($sql);
$resultArray = $model->getRows($result);
if (count($resultArray) > 0) {
return $resultArray[0];
}
return null;
}