ID: 39858
Comment by: barney dot hanlon at markettiers4dc dot com
Reported By: develar at gmail dot com
Status: Assigned
Bug Type: PDO related
Operating System: Windows XP SP2
PHP Version: 5.2.0
Assigned To: wez
New Comment:
That would technically be a workaround rather then a fix. The issue is
still there, and switching to ODBC is not necessarily a good or
acceptable solution. Also as we have taken onboard the Zend Framework
prior to beginning work on Zend Platform, creating non-standard
solutions doesn't sound like a forward step.
However, until the PHP team pull their fingers out and assess PDO to
work with Windows properly, I may have to implement it. Thank goodness
that the partnership with Microsoft will force PHP to stop treating IIS
as a perochial platform and get proper support.
Previous Comments:
------------------------------------------------------------------------
[2007-02-19 18:45:52] denis dot podgurskiy at cofelab dot ru
Hi once again.
Step by step instruction how to work with MySQL sp/transaction under
Win XP SP 2
1. Install MySQL ODBC driver.
2. Create database with tables in InnoDB format (to support transaction
- see my.cnf).
3. Create DSN with connection to your database (see Admin
tools->ODBC).
4. Enable pdo_odbc within php.ini file.
5. Use this to create connection
if(strstr($_SERVER['SERVER_SOFTWARE'],'Win')){
$this -> Db = new PDO("odbc:DSN=MY_MySQL_ODBC;", user,
password);
} else {
$this -> Db = Zend_Db::factory( PDO_MYSQL);
6. When the sp has been executed do not forget to fetch the statement:
$command -> execute();
do {
$rows = $command->fetchAll();
} while ($command -> nextRowset());
That's all. This code will work under win/nix without any diffireneces
- checked by me.
If you still have any problems - just email me and I'll contact you by
ICQ/Skype to help (I spent four weeks to solve it).
Regards, Denis
------------------------------------------------------------------------
[2007-02-15 13:56:39] mike at we11er dot co dot uk
Thanks for the help Denis, although I can't personally implement this
workaround...
For the time being I have hacked in lines of code to create a new
database connection before calling certain stored procedures.
Now, PLEASE could a developer or someone RESPOND and acknowledge this
bug, and let us know what is going on!?
I've been stuck with this bug for months and months with no help
whatsoever from the PHP guys.
------------------------------------------------------------------------
[2007-02-07 09:25:31] denis dot podgurskiy at cofelab dot ru
It works under Nix as well. So, good luck.
------------------------------------------------------------------------
[2007-02-06 17:13:57] denis dot podgurskiy at cofelab dot ru
One more thing - you need to install MySQL ODBC driver to work with
MySQL in this example: see dsn string. I use named DSN - XMS_MySQL
based on MySQL ODBC 3.51.12 Win driver.
------------------------------------------------------------------------
[2007-02-06 17:11:33] denis dot podgurskiy at cofelab dot ru
Well, some updates. The previous approach doesn't work with
transactions at all - see Init method. After long investigation I can
say the next:
Windows XP SP/2
Apache 1.3/PHP 5.2/MySQL/5.**
MySql tables should be in InnoDB (possibly BDB) format - MYISAM doesn't
support transactions yet.
Class to work with DB:
<?php
/**
* eXtended Management System
*
* LICENSE
*
* This source file is subject to the new BSD license that is bundled
* with this package in the file LICENSE.txt.
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to [EMAIL PROTECTED] so we can send you a copy immediately.
*
*
* @category Xms
* @package Xms_Core
* @copyright Copyright (c) 2006 CoFe Lab. (http://www.cofelab.ru)
* @license http://www.cofelab.ru/license
*/
class Xms_Do
{
/* Begin class */
/**
* @var Zend Db factory object.
*/
public $Db;
/**
* @var array
*/
private $_params;
/**
* @var string. Type of the PDO object.
*/
private $_config;
/**
* Construct
* @param object. Zend config object.
*/
public function __construct( $config )
{
Zend::loadClass('Zend_Db');
$this -> _config = $config -> database;
$this -> _params = array ('host'=> $this -> _config -> host,
'port' => $this ->
_config -> port,
'username' => $this ->
_config -> username,
'password' => $this ->
_config -> password,
'dbname' => $this ->
_config -> name,
PDO::ATTR_PERSISTENT
=> true);
$this -> Init();
}
/**
* Init database connection
*/
public function Init()
{
if(strstr($_SERVER['SERVER_SOFTWARE'],'Win')){
$this -> Db = new PDO($this -> _config -> odbc, $this
-> _config ->
username, $this -> _config -> password);
} else {
$this -> Db = Zend_Db::factory( $this -> _config ->
type, $this ->
_params);
}
$this -> Db -> query("SET NAMES '".$this -> _config ->
charset."'");
$this -> Db -> query("SET CHARACTER SET '".$this -> _config ->
charset."'");
}
private function InitOdbc(){
}
/**
* Execute stored procedure.
* @param string. Stored procedure's name.
* @param array. DbParameter objects.
*/
public function ExecuteStoredProcedure($spName, $args)
{
//echo $spName;
$ch = ',?';
$sp_str = "";
if(sizeof($args) > 0) {
$arr = array_fill ( 1, sizeof($args),null);
$sp_str = 'CALL '.$spName.' (?'.implode($ch,
array_values($arr)).')';
}
else{
$sp_str = 'CALL '.$spName.'()';
}
$command = null;
$command = $this -> Db -> prepare( $sp_str );
$count = 1;
$var = '@SiteId';
foreach($args as $key => $par ){
if(!is_object($par)) {
trigger_error('Wrong parameters type in
:'.$spName, E_USER_ERROR);
}
if($par -> parType == 'OUTPUT'){
$command -> bindParam($count, $var, $par ->
type, $par -> size,
array(
PDO::ATTR_EMULATE_PREPARES =>
true) );
} else {
$command -> bindParam($count, $par -> value,
$par -> type, $par ->
size, array(
PDO::ATTR_EMULATE_PREPARES =>
true) );
}
$count ++;
}
$command -> execute();
$rows = array();
if($command != null){
$rows = $command -> fetchAll();
$command -> closeCursor();
$command -> nextRowset();
//$this -> Init();
}
$command = null;
return $rows;
}
/**
* Desturctor.
*/
public function __destruct()
{
$this -> Db = null;
}
/* End class */
}
Config file (uses Zend config to read it):
<database>
<type>Pdo_Mysql</type>
<host>localhost</host>
<port>3307</port>
<username>root</username>
<password></password>
<name>xms</name>
<charset>utf8</charset>
<odbc>odbc:DSN=XMS_MySQL;</odbc>
</database>
Wrapper for DB parameter
<?php
/**
* XMS Framework
*
* LICENSE
*
* This source file is subject to the license that is bundled
* with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://xms.cofelab.ru/license/
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to [EMAIL PROTECTED] so we can send you a copy immediately.
*
* @category Xms
* @package Xms_Core
* @copyright Copyright (c) 2006 Cofelab Russia.
(http://www.cofelab.com)
* @license http://xms.cofelab.ru/license/
*/
class Xms_Db_Parameter
{
/**
* Presents name of the class.
* @staticvar string
*/
public static $ClassName = "Xms_Db_Parameter";
/**
* Presents name of the class.
* @staticvar string
*/
public $name;
public $value;
public $type;
public $size;
public $parType;
public function __construct($name, $value, $type, $size)
{
$this -> name = $name;
$this -> value = $value;
$this -> type = $type;
$this -> size = $size;
}
}
An example:
try{
$this -> _modDO -> Db -> beginTransaction();
$_siteId = null;
$parSiteUrl = new Xms_Db_Parameter('Url', $args ->
siteadddomain,
PDO::PARAM_STR, 100);
$parSiteDesc = new Xms_Db_Parameter('Description',
$args ->
siteadddescription, PDO::PARAM_STR, 255);
$rows = $this -> _modDO -> ExecuteStoredProcedure(
Xms_Constants ::
$prcSiteAddItem, array('Url'=>$parSiteUrl, 'Description' =>
$parSiteDesc));
$node ="<siteadddomain><value>".$args ->
siteadddomain."</value><error sysmes='siteadddomainerrex'
/></siteadddomain>";
$this -> _modDO -> Db -> commit();
} catch(Exception $e) {
echo $e -> getMessage();
$this -> _modDO -> Db -> rollBack();
}
PS. Not tested under Nix yet - I'll update the topic.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/39858
--
Edit this bug report at http://bugs.php.net/?id=39858&edit=1
