by russimicro » Sat Aug 23, 2014 2:23 pm
// MANEJO DE BLOQUEO DE MULTIPLES TABLAS CON PHP_PDO
// LA TAREA ES BUSCAR EL EQUIVALENTE CON ADO.....
$conn->beginTransaction();
bloqueaTablaConsecutivo($conn,1) ;
// procesos ... insert , update , delete ,,,, etc
$conn->commit();
bloqueaTablaConsecutivo($conn,0) ;
//*******************************
function bloqueaTablaConsecutivo($conn,$lBloTab) {
$cSenEje = "UNLOCK TABLES;";
if ( $lBloTab == 1 ) {
$cSenEje = "LOCK TABLES consecutivos AS sec WRITE, transainventarios WRITE, conceptosinventarios AS con WRITE;";
};
$stmt=$conn->prepare($cSenEje);
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$stmt->execute();
$registros = $stmt->rowCount();
unset($stmt);
}
//*************************************************************
Johnson Russi