protected function CheckOldEntrances()
{
$conn = new MysqlConection();
$result = $conn->RawQuery("call ProcGetOldEntrace()");
if (count($result) >= 1) {
foreach ($result as $key => $value) {
parent::Delete("sales_entradas", "id_entrada LIKE " . $value['id_entrada']);
}
}
}
public function FindTask($query)
{
return parent::RawQuery($query, PDO::FETCH_CLASS);
}
public function GetAllDatatables()
{
return $db_tables = parent::RawQuery("show tables ", \PDO::FETCH_NUM);
}
public static function get_paises()
{
$mysql = new MysqlConection();
return $paises = $mysql->RawQuery("SELECT PAI_PK as id , PAI_NOMBRE as nombre FROM pais");
}
<?php
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
include '/Conf/Include.php';
$conn = new MysqlConection();
$values = $conn->GetformatQuery("select * from datos");
$values = $conn->RawQuery("select * from datos", PDO::FETCH_ASSOC);
$values = $conn->Query("select * from datos");
echo "<pre>";
print_r($values);
echo "</pre>";
$find = $conn->Find("datos", "Id = 8", array("Nombre" => "name", "valor" => "value"));
echo "<br><br><br><pre>";
print_r($find);
echo "</pre>";
public function get_login()
{
$this->QUERY = "SELECT * FROM login WHERE id_usuario LIKE '{$this->ID_USER}'";
$data = parent::RawQuery($this->QUERY);
return $data[0];
}
