Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class MySQL{
- // Proprietatea 'credentials' este declarata protected,
- // deci poate fi folosita doar in interiorul clasei (MySQL) (in cazul nostru)
- protected $credentials = array(
- "hostname" => "localhost",
- "username" => "root",
- "password" => "",
- "database" => "mysql_con"
- );
- // Functia establishConnection() va returna obiectul de
- // care ne vom folosi pentru a ne conecta la baza de date
- // de fiecare data cand folosim o functie care vizeaza query-uri
- // de mysql
- public function establishConnection(){
- // Stabilirea conexiunii
- $connection = new mysqli( $this->credentials['hostname'],
- $this->credentials['username'],
- $this->credentials['password'],
- $this->credentials['database'] );
- // Verificam daca suntem conectati la baza de date
- // In cazul in care mysqli_connect_errno() returneaza TRUE,
- // nu suntem conectati. In acest caz, ucidem rularea.
- if( mysqli_connect_errno() ){
- die();
- }
- // In cazul in care mysqli_connect_errno() returneaza FALSE,
- // continuam algoritmul cu returnarea obiectului.
- return $connection;
- }
- }
- $mysql = new MySQL();
- $connection = $mysql->establishConnection();
- var_dump($connection);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement