PHP Conexion::sql方法代码示例

 function getBusiness()
 {
     $conexion = new Conexion();
     $sql = "select * from business order by name asc";
     $row = $conexion->sql($sql);
     return $row;
     //regresamos el arreglo con la consulta de Noticias por Campus
 }

 function User($id = 0)
 {
     if ($id != 0) {
         $conexion = new Conexion();
         $sql = "select * from login where login_id='{$id}'";
         $row = $conexion->sql($sql);
         $array = mysql_fetch_array($row);
         $this->idUser = $array['login_id'];
         $this->name = $array['login_usuario'];
         $this->password = $array['login_contra'];
         $this->tipe = $array['login_tipo'];
     }
 }

 function getEmailsByIdLender()
 {
     $conexion = new Conexion();
     $sql = "select * from email where id_lender='{$this->id_lender}' order by name asc";
     $row = $conexion->sql($sql);
     return $row;
 }

}
if (isset($_POST['amex'])) {
    $amex = $_POST['amex'];
    echo $amex . '<br>';
}
if (isset($_POST['discover'])) {
    $discover = $_POST['discover'];
    echo $discover . '<br>';
}
if (isset($_POST['debit'])) {
    $debit = $_POST['debit'];
    echo $debit . '<br>';
}
if (isset($_POST['ebt'])) {
    $ebt = $_POST['ebt'];
    echo $ebt . '<br>';
}
$balanActual = $_POST['balanActual'];
echo $balanActual . '<br>';
$splitFunds = $_POST['splitFunds'];
echo $splitFunds . '<br>';
$ach = $_POST['ach'];
echo $ach . '<br>';
//  function insertAplicacion(){	// inserta el cliente cargado en los atributos
$conexion = new Conexion();
$query = "insert into aplicacion(nomLegal,Cname,dirFisica,ciudad,estado,codigo," . "dirFacOtro,ciudadOtro,estadoOtro,codigoOtro,Pnumber,fax,taxId,fechaInicio,tiempoDue," . "website,tiempoEnt,Email,estadoIncor,tipoIndus,ultimoMes,dosMeses,tresMeses,cuatroMeses," . "ventaUltMes,tickUltimo,ventaDosMes,tickDosMes,ventaTresMes,tickTresMes,ventaCuatroMes," . "tickCuatroMes,Fname,Lname,tituloDue,dirDue,ssn,fechaNac,porcentajeDue,ciudadDue,estadoDue,cpDue," . "numCasaDue,numCelDue,Fname2,Lname2,tituloDue2,dirDue2,ssn2,fechaNac2,porcentajeDue2,ciudadDue2,estadoDue2," . "cpDue2,numCasaDue2,numCelDue2,arrendador,montoRent,cuenta,numTelCuenta,modeloTerm,numTerm,procesador," . "financiadora,promeMenVentas,Sales," . "visa,amex,discover,debit,ebt,balanActual,splitFunds,ach)" . "values('{$nomLegal}','{$Cname}','{$dirFisica}','{$ciudad}'," . "'{$estado}','{$codigo}','{$dirFacOtro}','{$ciudadOtro}','{$estadoOtro};'," . "'{$codigoOtro}','{$Pnumber}','{$fax}','{$taxId}','{$fechaInicio}','{$tiempoDue}'," . "'{$website}','{$tipoEnt}','{$Email}','{$estadoIncor}','{$tipoIndus}','{$ultimoMes}'," . "'{$dosMeses}','{$tresMeses}','{$cuatroMeses}','{$ventaUltMes}','{$tickUltimo}','{$ventaDosMes}'," . "'{$tickDosMes}','{$ventaTresMes}','{$tickTresMes}','{$ventaCuatroMes}','{$tickCuatroMes}'," . "'{$Fname}','{$Lname}','{$tituloDue}','{$dirDue}','{$ssn}','{$fechaNac}','{$porcentajeDue}','{$ciudadDue}'," . "'{$estadoDue}','{$cpDue}','{$numCasaDue}','{$numCelDue}','{$Fname2}','{$Lname2}','{$tituloDue2}','{$dirDue2}'," . "'{$ssn2}','{$fechaNac2}','{$porcentajeDue2}','{$ciudadDue2}','{$estadoDue2}','{$cpDue2}','{$numCasaDue2}'," . "'{$numCelDue2}','{$arrendador}','{$montoRent}','{$cuenta}','{$numTelCuenta}','{$modeloTerm}','{$numTerm}'," . "'{$procesador}','{$financiadora}','{$promeMenVentas}','{$Sales}','{$visa}','{$amex}','{$discover}'," . "'{$debit}','{$ebt}','{$balanActual}','{$splitFunds}','{$ach}')";
$conexion->sql($query);
//  }
?>

 public function modificar($a, $b, $c, $d)
 {
     $bd = new Conexion();
     $bd->sql("update usuario_table set nombres='{$a}',apellidos='{$b}',correo='{$c}'\n\t\t\twhere id = '{$d}';");
 }

 function updateFilter()
 {
     $conexion = new Conexion();
     $query = "update filter set business='{$this->business}',foreclosure='{$this->foreclosure}',landlord='{$this->landlord}',years='{$this->years}',bankstatements='{$this->bankstatements}',bank_average='{$this->bank_average}',nsf='{$this->nsf}',creditcard='{$this->creditcard}',creditcard_t='{$this->creditcard_t}',creditcard_average='{$this->creditcard_average}',email='{$this->email}' where id_filter='{$this->id_filter}'";
     $conexion->sql($query);
 }

 function getUsers()
 {
     $conexion = new Conexion();
     $sql = "select * from user order by name";
     $result = $conexion->sql($sql);
     return $result;
     //regresamos el arreglo con la consulta de Noticias por Campus
 }

 function getSegmentoPaginadoSinPublicar()
 {
     $conexion = new Conexion();
     $sql = "SELECT *  FROM publicacion order by id_publicacion DESC LIMIT " . ($this->page - 1) * 4 . ", 4";
     $row = $conexion->sql($sql);
     return $row;
 }

 function getFilteredLenders()
 {
     $conexion = new Conexion();
     $sql = "select * from lender where business Not LIKE '%{$this->business}' and foreclosure='{$this->foreclosure}' and landlord='{$this->landlord}' and total_months <='{$this->total_months}'  and bankstatements='{$this->bankstatements}' and bank_average <='{$this->bank_average}' and nsf<='{$this->nsf}' and creditcard='{$this->creditcard}' and creditcard_t <='{$this->creditcard_t}' and creditcard_average <='{$this->creditcard_average}'   ";
     $row = $conexion->sql($sql);
     return $row;
     //regresamos el arreglo con la consulta de Noticias por Campus
 }

 function altaRepresentante()
 {
     $con = new Conexion();
     $sql = "INSERT INTO representante (prefijo_rep, nombre_rep, ape_rep, calle_rep, num_rep, ciudad_rep, cp_rep, estado_rep, tel1_rep, tel2_rep, email_rep) " . "VALUES('{$this->prefijo}', " . "'{$this->nombre}', " . "'{$this->apellido}'," . " '{$this->calle}', " . "'{$this->numero}'," . " '{$this->ciudad}'," . " '{$this->cp}'," . "'{$this->estado}'," . " '{$this->tel1}', " . "'{$this->tel2}', " . "'{$this->email}')";
     $con->sql($sql);
 }