/**
Begin SQL transaction
@return NULL
**/
function begin()
{
parent::begintransaction();
$this->trans = TRUE;
}
/**
* Begin SQL transaction
* @return bool
**/
function begin()
{
$out = parent::begintransaction();
$this->trans = TRUE;
return $out;
}
<html>
<body>
<?php
$userid = $_REQUEST['userid'];
$email = $_REQUEST['email'];
$nome = $_POST['nome'];
try {
$host = "db.ist.utl.pt";
$user = "******";
$password = "******";
$dbname = $user;
$db = new PDO("mysql:host={$host};dbname={$dbname}", $user, $password);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->begintransaction();
echo $userid;
echo $email;
echo $nome;
$date = date('Y-m-d H:i:s');
$sql = "INSERT INTO sequencia(userid,moment) VALUES ({$userid},'{$date}') ;";
$db->query($sql);
$sql2 = "select contador_sequencia from sequencia where contador_sequencia >= ALL(select contador_sequencia from sequencia);";
$contador_seq = $db->query($sql2);
foreach ($contador_seq as $row) {
$seqid = $row['contador_sequencia'];
$sql2 = "SELECT pagecounter + 1 as pg FROM(SELECT userid, pagecounter, nome, idseq, ativa FROM pagina WHERE pagecounter >= ALL(SELECT pagecounter FROM pagina)) a;";
$page_counter = $db->query($sql2);
foreach ($page_counter as $row) {
$pg_count = $row['pg'];
$sql3 = "INSERT INTO pagina(userid,pagecounter,nome,idseq,ativa) VALUES ({$userid}, {$pg_count} , '{$nome}', {$seqid},1);";
echo $sql3;
$db->query($sql3);
