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]; }