PDA

View Full Version : اتصال به MSSQL توسط php



hosha92
پنج شنبه 04 شهریور 1395, 00:37 صبح
سلام دوستان
من میخوام توسط PHP به بانک اطلاعاتی که روی یک سرور با IP مشخصی هست متصل بشم .
کسی میتونه راهنمایی کنه ؟
از این کد هم استفاده کردم اما خطا میده :
Failed to get DB handle: could not find driver Failed to get DB handle: could not find driver




<?phpclass pdo_dblib_mssql{
private $db; private $cTransID; private $childTrans = array();
public function __construct($hostname, $port, $dbname, $username, $pwd){
$this->hostname = $hostname; $this->port = $port; $this->dbname = $dbname; $this->username = $username; $this->pwd = $pwd;
$this->connect(); } /* public function __construct($hostname, $port, $dbname, $username, $pwd){
$this->hostname = 'localhost'; $this->port = '80'; $this->dbname = 'ourdomain'; $this->username = 'root'; $this->pwd = '';
$this->connect(); } */ public function beginTransaction(){
$cAlphanum = "AaBbCc0Dd1EeF2fG3gH4hI5iJ6jK7kLlM8mN9nOoPpQqRrSsTt UuVvWwXxYyZz"; $this->cTransID = "T".substr(str_shuffle($cAlphanum), 0, 7);
array_unshift($this->childTrans, $this->cTransID);
$stmt = $this->db->prepare("BEGIN TRAN [$this->cTransID];"); return $stmt->execute();
}
public function rollBack(){ while(count($this->childTrans) > 0){ $cTmp = array_shift($this->childTrans); $stmt = $this->db->prepare("ROLLBACK TRAN [$cTmp];"); $stmt->execute(); }
return $stmt; }
public function commit(){
while(count($this->childTrans) > 0){ $cTmp = array_shift($this->childTrans); $stmt = $this->db->prepare("COMMIT TRAN [$cTmp];"); $stmt->execute(); }
return $stmt; }
public function close(){ $this->db = null; }
public function connect() { try { $this->db = new PDO ("dblib:host=$this->hostname:$this->port;dbname=$this->dbname", "$this->username", "$this->pwd"); } catch (PDOException $e) { return $this->logsys .= "Failed to get DB handle: " . $e->getMessage() . "\n"; } }
}

Unique
پنج شنبه 04 شهریور 1395, 01:16 صبح
این پست (http://www.geekfarsi.com/%D8%A7%D8%AA%D8%B5%D8%A7%D9%84-%D9%88-%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87-%D8%A7%D8%B2-%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87-%D8%AF%D8%A7%D8%AF%D9%87-mssql-%D8%AF%D8%B1-php/75) میتونه کمکت کنه.

hosha92
پنج شنبه 04 شهریور 1395, 01:53 صبح
این پست (http://www.geekfarsi.com/%D8%A7%D8%AA%D8%B5%D8%A7%D9%84-%D9%88-%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87-%D8%A7%D8%B2-%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87-%D8%AF%D8%A7%D8%AF%D9%87-mssql-%D8%AF%D8%B1-php/75) میتونه کمکت کنه.

ممنونم داداش