Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class dbUtil{
- public $mysqli; //variabile di connessine db da usare per eseguire le query
- private $lastQuery;// conservo l'ultima query eseguita per utilizzarla per estrarre id, o numrows ecc...'
- function __construct(){
- $this->mysqli = new mysqli(DB_HOST, DB_USER, DB_PWD, DB_NAME);
- if($this->mysqli->connect_error) die("Failed to connect to MySQL: (". $this->mysqli->connect_errno. ")".$this->mysqli->connect_error);
- }
- //chiusura connessione db
- public function closeDb(){
- $this->mysqli->close();
- }
- // esecuzione query
- // return niente
- public function query($sql){
- if($sql != ""){
- $mysqli = $this->mysqli;
- $sql = str_replace("<", "<", $sql);
- $sql = str_replace(">", ">", $sql);
- $sql = str_replace("&", "&", $sql);
- if( !$this->lastQuery = $mysqli->query($sql) ) echo ERR_QUERY.$sql.$mysqli->error;
- }
- }
- //estrazione dati fetch_row
- //return
- public function fetchRow() {
- return $this->lastQuery->fetch_row();
- }
- //estrazione dati fetch_array
- //return
- public function fetchArray() {
- return $this->lastQuery->fetch_array();
- }
- //estrazione dati fetch_row
- //return
- public function fetchAssoc() {
- return $this->lastQuery->fetch_assoc();
- }
- //resistuisc eil numero di record della query eseguita
- public function numRows(){
- return $this->lastQuery->num_rows;
- }
- //restituisce l'ultimo id inserito
- public function insertId() {
- return $this->mysqli->insert_id;
- }
- //stampa un'array nel tag pre
- public function pre($array) {
- echo "<pre>";
- print_r($array);
- echo "</pre>";
- }
- }
- public function query1($user,$password){
- $mysqli = $this->mysqli;
- $user1=$mysqli->real_escape_string($user);
- $pass=$mysqli->real_escape_string($password);
- $sql = "SELECT * FROM ".TABLE_USER2." WHERE Username='".$user1.”’ AND Password='".$pass."'";
- if( !$this->lastQuery = $mysqli->query($sql) ) echo ERR_QUERY.$sql.$mysqli->error;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement