index.php
<?php include "DBConnection.php"; $stmt = $db->prepare(""); $stmt->execute();
DBConnection.php
<?php require 'DB.class.php'; try { $db = new DB("","","","",""); } catch(PDOException $e) { }
<?php include "DBConnection.php"; $stmt = $db->prepare(""); $stmt->execute();
<?php require 'DB.class.php'; try { $db = new DB("","","","",""); } catch(PDOException $e) { }
$pdo = new PDO('mysql:host=localhost;dbname=baza', 'root', 'root');
$pdo -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
<?php Class DB { public function __construct($server, $port, $username, $password, $database) { $this->Set($server, $port, $username, $password, $database); $this->$database=$this->Connect(); } protected function Set($server, $port, $username, $password, $database) { $this->server = $server; $this->port = $port; $this->user = $username; $this->pass = $password; $this->database = $database; } protected function Connect() { $pdo = new PDO('mysql:host='.$this->server.';dbname='.$this->database.';port='.$this->port, $this->user, $this->pass ); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } protected $server; protected $port ; protected $user; protected $password; protected $database; protected $db; } ?>
protected function Connect() { $pdo = new PDO('mysql:host='.$this->server.';dbname='.$this->database.';port='.$this->port, $this->user, $this->pass ); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return $pdo; }