[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    Re: [PHP-DB] How can I get MySQL protocol information with PDO?
From:       Thodoris <tgol () kinetix ! gr>
Date:       2007-11-30 10:23:10
Message-ID: 474FE48E.1090009 () kinetix ! gr
[Download RAW message or body]



O/H Kazuhiro IIzuka ??????:
> Thanks Thodoris.
> 
> But this is not things I desired.I've already read php manual and known 
> about PDO::getAttribute() before I post my question.
> 
> When I get to server version,I can use $dbh->getAttribute(PDO::
> ATTR_SERVER_VERSION),but there are no attribute about mysql server 
> protocol.
> 
> I'm planing to make phpMyAdmin-clone with PDO.but I don't know PDO can 
> work instead of mysql/mysqli extension.and I couldn't find equivalent 
> function in PDO with mysql_get_proto_info(mysqli_get_proto_info).
> 
> // with mysql extension
> $link = mysql_connect($host,$user,$password);
> echo mysql_get_proto_info(); // returns 10 in my case.
> 
> but I cannot find the proper value like PDO::ATTR_SERVER_PROTOCOL in 
> PDO's getAttribute.
> 
> and PDO doesn't seems to use MySQL API's mysql_get_proto_info.
> 
> I check like this:
> /path/to/php-5.2.4/ext$ grep -r 'mysql_get_proto_info' mysql
> mysql/php_mysql.c:      PHP_FE(mysql_get_proto_info,             NULL)
> mysql/php_mysql.c:/* {{{ proto int mysql_get_proto_info([int 
> link_identifier])
> mysql/php_mysql.c:PHP_FUNCTION(mysql_get_proto_info)
> mysql/php_mysql.c:      RETURN_LONG(mysql_get_proto_info(&mysql->conn));
> mysql/php_mysql.h:PHP_FUNCTION(mysql_get_proto_info);
> Binary file mysql/.libs/php_mysql.o matches
> /path/to/php-5.2.4/ext$ grep -r 'mysql_get_proto_info' pdo*
> /path/to/php-5.2.4/ext$
> 
> I forgot to tell you my environment.
> 
> MySQL version: 5.0.27-standard-log
> PHP: 5.2.4 (upgrade in near future)
> Apache: 2.2.6
> 
>> You can retrieve some info for the mysql connection (server,driver etc) 
>> using PDO::getAttribute()
>>
>> For e.g. you can do something like that:
>>
>> <?php
>>   $dbhost = 'localhost';
>>   $dbuser = 'user_name';
>>   $dbpass = 'password';
>>   $db = 'database';
>>
>>   $dbh= new PDO('mysql:host='.$dbhost.';dbname='.$db, $dbuser, $dbpass);
>>
>>   echo $dbh->getAttribute(PDO::ATTR_DRIVER_NAME);
>>   echo "<br>";
>>   echo $dbh->getAttribute(PDO::MYSQL_ATTR_MAX_BUFFER_SIZE);
>>   echo "<br>";
>>   echo $dbh->getAttribute(PDO::ATTR_SERVER_VERSION);
>>   echo "<br>";
>>   echo $dbh->getAttribute(PDO::ATTR_CONNECTION_STATUS);
>> ?>
> 


Well Kazuhiro you should know that PDO is not exactly an alternative for 
mysql/mysqli but it was supposed to abstract the database details under 
an object. This is not totally yet happening but I think that you can 
use PDO instead of mysql/mysqli in any case. Well I have wrote many 
projects using it, and I think that if I wished to change the database 
from mysql to some other it would take just few changes in my code.

You can always post this in the developers list if you want more details 
on the matter and find out if any protocol attributes are to be supported.
-- 
Thodoris

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[prev in list] [next in list] [prev in thread] [next in thread]