JSFiddle - React, Tailwind, and code Playground
by Gonzalo
JavaScript
<?php
class DBHelper{
private $_dbHost = "localhost";
private $_dbUsername = "root";
private $_dbPassword = "gjpv";
private $_db = "grupovgi_vgi";
private $_dbgParametros = false;
public $CryptKey = "1hJ&7722ghsywtj!#5ljiu";
public $err = false;
public $errMessage = "";
private function OpenDB(){
mysql_connect($this->_dbHost, $this->_dbUsername, $this->_dbPassword, false, 65536);
mysql_select_db($this->_db) or die("Error de conexion a la base de datos ".mysql_error());
}
public function ExecuteScalar($query){
$this->err = false;
$this->errMessage = "";
$ret = null;
$rs = mysql_query($query);
if(mysql_errno()!=0){
$this->err = true;
$this->errMessage = mysql_error();
}
else{
if($row = mysql_fetch_array($rs, MYSQL_NUM))
$ret = $row[0];
}
//mysql_close();
return $ret;
}
public function ExecuteReader($query){
$this->err = false;
$this->errMessage = "";
$ret = null;
$rs = mysql_query($query);
if(mysql_errno()!=0){
$this->err = true;
$this->errMessage = mysql_error();
}
else
$ret = $rs;
return $ret;
}
public function ExecuteNonQuery($query, $id = false){
$r = -1;
$this->err = false;
$this->errMessage = "";
mysql_query($query);
if(mysql_errno()!=0){
$this->err = true;
$this->errMessage = mysql_error();
}
else{
if($id)
$r = $this->ExecuteScalar("select last_insert_id()");
}
if($id)
return $r;
}
public function ExecuteJsonCreate($query_obj){
$arr = array();
while($row = mysql_fetch_object($query_obj)){
$rowArr = array();
foreach($row as $key => $value)
$rowArr[$key] = utf8_encode($value);
$arr[] = $rowArr;
}
return json_encode($arr);
}
public function ExecuteSerieCreate($query_obj){
$arr = array();
while($row = mysql_fetch_object($query_obj)){
$rowArr = array();
foreach($row as $key => $value){
$rowArr[$key] = utf8_encode($value);
}
$arr[] = $rowArr;
}
return $arr;
}
public function...