Advertisement
Guest User

s

a guest
Dec 31st, 2021
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.71 KB | None | 0 0
  1.   public static FUNCTION mdlConsultaCodCredito($busca)
  2.     {
  3.         $dbconec = Conexion::Conectar();
  4.         try {
  5.             $data = [];
  6.             $query = "SELECT cre_credito
  7.                FROM CREDITO.dbo.CR_CREDITOS
  8.                 WHERE cre_credito LIKE '%?%'";
  9.             $stmt = $dbconec->PREPARE($query);
  10.             $stmt->EXECUTE([$busca]);
  11.                 $data = $stmt->fetchAll(PDO::FETCH_ASSOC);
  12.                
  13.                 $obj = json_encode($data);
  14.                 RETURN $obj;
  15.             //$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
  16.         } catch (Exception $e) {
  17.             echo '<span class="label label-danger label-block">ERROR AL CARGAR LOS DATOS, PRESIONE F5</span>';
  18.         }
  19.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement