File Manager

✏️ Edit File: /var/www/vhosts/dzfarer.com/httpdocs/admin/includes/bd.php

<?php
require_once('config.php');

class MySQLDatabase {
	
	private $connection;
	public $der_req;
	private $magic_quotes_active;
	private $real_escape_string_exists;
	
  function __construct() {
    $this->ouvre_connection();
		$this->magic_quotes_active = false;

$this->real_escape_string_exists = function_exists( "mysqli_real_escape_string" );
  }

public function ouvre_connection() {
		$this->connection = mysqli_connect(DB_HOST, DB_USER, DB_PASS);
		if (!$this->connection) {
			die("la connexion à la Base de données a échoué " . mysqli_error());
		} else {
			$db_select = mysqli_select_db($this->connection, DB_SCHEMA);
			if (!$db_select) {
				die("Sélection de la base de données a échoué: " . mysqli_error());
			}
		}
		mysqli_set_charset($this->connection,"utf8mb4");
	}

public function fermer_connection() {
		if(isset($this->connection)) {
			mysqli_close($this->connection);
			unset($this->connection);
		}
	}

public function requete($sql) {
		$this->der_req = $sql;
		
		$result = mysqli_query( $this->connection,$sql);
		$this->confirm_requete($result);
		return $result;
	}

public function beginTransactions() {
    mysqli_query($this->connection, "set autocommit = 0");
    mysqli_query($this->connection, "START TRANSACTION");
}

public function commitTransactions() {
    mysqli_query($this->connection, "COMMIT");
    mysqli_query($this->connection, "set autocommit = 1");
}

public function rollbackTransactions() {
    mysqli_query($this->connection, "ROLLBACK");
    mysqli_query($this->connection, "set autocommit = 1");
}	
	public function escape_value( $value ) {
		if( $this->real_escape_string_exists ) { // PHP v4.3.0 or higher
			// undo any magic quote effects so mysql_real_escape_string can do the work
			if( $this->magic_quotes_active ) { $value = stripslashes( $value ); }
			$value = mysqli_real_escape_string($this->connection, $value );
		} else { // before PHP v4.3.0
			// if magic quotes aren't already on then add slashes manually
			if( !$this->magic_quotes_active ) { $value = addslashes( $value ); }
			// if magic quotes are active, then the slashes already exist
		}
		return $value;
	}
	
	private function confirm_requete($result) {
		if (!$result) {
	    $output = "Requête de base de données a échoué:" . mysqli_error($this->connection) . "<br /><br />";
	    $output .= "dernier requet SQL : " . $this->der_req;
	    die( $output );
		}
	}
	
// doit cahanger ces fonctions on cas de changement de SGBD	
public function fetch_array($result_set) {
    if ($result_set instanceof mysqli_result) {
        return mysqli_fetch_array($result_set);
    } else {
        die("Erreur dans fetch_array(): le paramètre fourni n'est pas un résultat MySQL valide.<br>Requête en cause : " . $this->der_req);
    }
}

public function fetch_object($result_set) {
    if ($result_set instanceof mysqli_result) {
        return mysqli_fetch_object($result_set);
    } else {
        die("Erreur dans fetch_object(): le paramètre fourni n'est pas un résultat MySQL valide.<br>Requête en cause : " . $this->der_req);
    }
}

public function num_rows($result_set) {
      return mysqli_num_rows($result_set);
    }
	
	public function num_fields($result_set){
	 return mysqli_num_fields($result_set);
	}
  
    public function insert_id() {
     // le dernier id a insérie 
     return mysqli_insert_id($this->connection);
    } 
  
    public function affected_rows() {
       return mysqli_affected_rows($this->connection);
    }
	
	public function connection(){
	return  $this->connection;
	}

}

$database = new MySQLDatabase();
$bd =& $database;

Batal

⬅ Naik ke admin 16 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘accounts.php	php	11.6 KB	2025-06-19 09:58	✏️ Edit 👁️ View
🐘bd.php	php	3.6 KB	2025-06-19 09:12	✏️ Edit 👁️ View
🐘commune.php	php	6.5 KB	2025-06-22 12:40	✏️ Edit 👁️ View
🐘config.php	php	314 B	2025-06-17 09:09	✏️ Edit 👁️ View
🐘db_backup_library.php	php	6.7 KB	2025-06-17 09:07	✏️ Edit 👁️ View
🐘faq.php	php	8.9 KB	2025-06-25 14:01	✏️ Edit 👁️ View
🐘fonction.php	php	5.3 KB	2025-06-17 09:07	✏️ Edit 👁️ View
🐘fonctions.php	php	10.1 KB	2025-06-17 09:07	✏️ Edit 👁️ View
🐘guides.php	php	6.1 KB	2025-07-01 17:58	✏️ Edit 👁️ View
🐘initialiser.php	php	989 B	2025-06-29 20:52	✏️ Edit 👁️ View
🐘lieux_visite.php	php	8.8 KB	2025-07-09 22:05	✏️ Edit 👁️ View
🐘parametre.php	php	10.1 KB	2025-06-17 09:07	✏️ Edit 👁️ View
🐘session.php	php	3 KB	2025-06-17 09:07	✏️ Edit 👁️ View
🐘stores.php	php	5.8 KB	2025-06-28 21:06	✏️ Edit 👁️ View
🐘transports.php	php	8.5 KB	2025-06-22 12:22	✏️ Edit 👁️ View
🐘villes.php	php	5.5 KB	2025-06-17 09:07	✏️ Edit 👁️ View