Tul xxx Tul

Viewing: Query.php

<?php
class Query extends Conexion
{
    private $pdo, $con;
    public function __construct()
    {
        $this->pdo = new Conexion();
        $this->con = $this->pdo->conectar();
    }
    public function select($sql)
    {
        $result = $this->con->prepare($sql);
        $result->execute();
        return $result->fetch(PDO::FETCH_ASSOC);
    }
    public function selectAll($sql)
    {
        $result = $this->con->prepare($sql);
        $result->execute();
        return $result->fetchAll(PDO::FETCH_ASSOC);
    }
    public function selectColum($sql)
    {
        $result = $this->con->prepare($sql);
        $result->execute();
        return $result->fetchAll(PDO::FETCH_COLUMN);
    }
    public function insertar($sql, $array)
    {
        $result = $this->con->prepare($sql);
        $data = $result->execute($array);
        if ($data) {
            $res = $this->con->lastInsertId();
        } else {
            $res = 0;
        }
        return $res;
    }
    public function save($sql, $array)
    {
        $result = $this->con->prepare($sql);
        $data = $result->execute($array);
        if ($data) {
            $res = 1;
        } else {
            $res = 0;
        }
        return $res;
    }

    public function delete($sql, $array)
    {
        try {
            $result = $this->con->prepare($sql);
            $data = $result->execute($array);
            if ($data && $result->rowCount() > 0) {
                $res = 1;
            } else {
                $res = 0;
            }
            return $res;
        } catch (PDOException $e) {
            return 0;
        }
    }

    public function quoteValueQuery($value)
    {
        if ($value === null) {
            return 'NULL'; // Devuelve 'NULL' para valores nulos, válido en SQL
        }
        return $this->con->quote($value); // Usa PDO::quote para otros valores
    }
}

User / IP	: 216.73.216.146
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64