Ver Mensaje Individual
  #1 (permalink)  
Antiguo 10/01/2013, 16:34
Avatar de leeja
leeja
 
Fecha de Ingreso: octubre-2005
Mensajes: 82
Antigüedad: 18 años, 6 meses
Puntos: 0
Uso de transacciones con mysql desde PHP

esto funciona:

$objDataBase = new Class_SuperDataBase(Class_Interface_DataBase::USER INSERT);
$objDataBase->beginTransaction();

$objDataBase->executeQueryUpdate("INSERT INTO perupez_def_phone_type VALUES(null,'xxx4','2013-01-10 11:24:53',1)");
$objDataBase->executeQueryUpdate("INSERT INTO perupez_def_phone_type VALUES(null,'xxx5','2013-01-10 11:24:53',1)");
$objDataBase->executeQueryUpdate("INSERT INTO perupez_def_phone_type VALUES(null,'xxx6','2013-01-10 11:24:53',1)");

$objDataBase->commit();

pero esto no me funciona:

$objDataBase = new Class_SuperDataBase(Class_Interface_DataBase::USER INSERT);
$objDataBase->beginTransaction();
$arraySetVariable = array('InPhoneTypeName');
$arrayValueVariable = array ('xxx3') ;
$arrayTypeDataVariable = array (Class_Object::DATA_STRING);
$arraySizeDataVariable = array (10) ;
$objDataBase->executeUpdateStoreProcedure('def_add_phoneType' , $arraySetVariable, $arrayValueVariable, $arrayTypeDataVariable, $arraySizeDataVariable);
$arrayValueVariable = array ('xxx4') ;
$objDataBase->executeUpdateStoreProcedure('def_add_phoneType' , $arraySetVariable, $arrayValueVariable, $arrayTypeDataVariable, $arraySizeDataVariable);
$arrayValueVariable = array ('xxx5') ;
$objDataBase->executeUpdateStoreProcedure('def_add_phoneType' , $arraySetVariable, $arrayValueVariable, $arrayTypeDataVariable, $arraySizeDataVariable);

$objDataBase->commit();
__________________
www.datasegura.net