Problème d'insertion mysql/php

//préparation de la requête et des variables
$mail = "***@***";
$downloaded = 0;
$title = "test_title7199999000";
$href = "href17";

$sql = "INSERT INTO `records` 
                (`mail`, `downloaded`, `title`, `href`, `reg_date`) 
         VALUES (:mail,:downloaded, :title, :href , now())";

$datas = array(':mail'=>$mail, ':title'=>$title, ':href'=>$href );

//Execution de la requete
try{
  $requete = $bdd -> prepare($sql) ;
  $requete->execute($datas) ;
}catch(Exception $e){
  // en cas d'erreur :
   echo " Erreur ! ".$e->getMessage();
   echo " Les datas : " ;
  print_r($datas);
}

$host='localhost';
$user='root';
$password='Jt4qFA39v24.3f';
$db = "admin_mstorF"

$dsn = "mysql:host=localhost;dbname=m$db";


$pdo = new PDO($dsn, $user, $password);

$stm = $pdo->query("SELECT VERSION()");

$version = $stm->fetch();

echo $version[0] . PHP_EOL;



$pdo = new PDO($dsn, $user, $password);


try {
    $conn = new PDO("mysql:host=$host;dbname=$db", $user, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // begin the transaction
    $conn->beginTransaction();
    // our SQL statements
	
	
$sql = "INSERT INTO `records` 
                (`mail`, `downloaded`, `title`, `href`, `reg_date`) 
         VALUES (:mail,:downloaded, :title, :href , now())";
    $conn->exec($sql);
   // commit the transaction
    $conn->commit();
    echo "New records created successfully";
    }
catch(PDOException $e)
    {
    // roll back the transaction if something failed
    $conn->rollback();
    echo "Error: " . $e->getMessage();
    }

$conn = null;

<?php
//-------------------------------------------------//
//Affichage des erreurs PHP
//-------------------------------------------------//
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);


//-------------------------------------------------//
//connexion à la bdd
//-------------------------------------------------//
$host='localhost';
$user='root';
$password='Jt4qFA39v24.3f';
$db = "admin_mstorF"
try{
  $bdd =new PDO('mysql:host='.$host.';dbname='.$db.'; charset=utf8', $user, $password);
  // Activation des erreurs PDO
  $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
  $bdd->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch(PDOException $e) {
  die('Erreur : ' . $e->getMessage());
}



//-------------------------------------------------//
// requête SELECT 
//-------------------------------------------------//
try{
  $stm = $bdd->query("SELECT VERSION()");
  $version = $stm->fetch();
  echo $version[0] . PHP_EOL;
}catch(Exception $e){
  echo "Erreur : ".$e->getMessage();
}


//-------------------------------------------------//
// Requête INSERT
//-------------------------------------------------//
//préparation de la requête et des variables
$mail = "***@***";
$downloaded = 0;
$title = "test_title7199999000";
$href = "href17";

$sql = "INSERT INTO `records` 
                (`mail`, `downloaded`, `title`, `href`, `reg_date`) 
         VALUES (:mail,:downloaded, :title, :href , now())";

$datas = array(':mail'=>$mail, ':title'=>$title, ':href'=>$href );

$bdd->beginTransaction();

//Execution de la requete (chaque EXECUTION est à mettre dans un bloc TRY/CATCH)
try{  
  $requete = $bdd -> prepare($sql) ;
  $requete->execute($datas) ;
  $bdd->commit();
  echo "New records created successfully";
}catch(Exception $e){
  // en cas d'erreur :
   $bdd->rollback();
   
   echo " Erreur ! ".$e->getMessage();
   echo " Les datas : " ;
  print_r($datas);
}

//-------------------------------------------------//
// Requête INSERT
//-------------------------------------------------//
//préparation de la requête et des variables
$mail = "***@***";
$downloaded = 0;
$title = "test_title7199999000";
$href = "href17";

$sql = "INSERT INTO `records` 
                (`mail`, `downloaded`, `title`, `href`, `reg_date`) 
         VALUES (:mail,:downloaded, :title, :href , now())";

$datas = array(':mail'=>$mail, ':title'=>$title, ':href'=>$href );

$bdd->beginTransaction();

//Execution de la requete (chaque EXECUTION est à mettre dans un bloc TRY/CATCH)
try{  
  $requete = $bdd -> prepare($sql) ;
  $requete->execute($datas) ;
  $bdd->commit();
  echo "New records created successfully";
}catch(Exception $e){
  // en cas d'erreur :
   $bdd->rollback();
   
   echo " Erreur ! ".$e->getMessage();
   echo " Les datas : " ;
  print_r($datas)
?>

dans mon précédent message, c'est bon, j'avais juste pour les 2 parties de mon code ?

$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

//-------------------------------------------------//
//connexion à la bdd
//-------------------------------------------------//
$host='localhost';
$user='root';
$password='Jt4qFA39v24.3f';
$db = "admin_mstorF";
try{
  $bdd =new PDO('mysql:host='.$host.';dbname='.$db.'; charset=utf8', $user, $password);
  // Activation des erreurs PDO
  $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
  $bdd->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);

  echo "<br> Connexion à la bdd : OK !";
  
} catch(PDOException $e) {
  die('Erreur : ' . $e->getMessage());
}

<?php
//-------------------------------------------------//
//Affichage des erreurs PHP
//-------------------------------------------------//
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);

//-------------------------------------------------//
//connexion à la bdd
//-------------------------------------------------//

$host='localhost';
$user='root';
$password='Jt4qFA39vf';
$db = "admin_mstor";

//connexion à la bdd
try{
  $bdd =new PDO('mysql:host='.$host.';dbname='.$db.'; charset=utf8', $user, $password);
  // Activation des erreurs PDO
  $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
  $bdd->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);

  echo "<br> Connexion à la bdd : OK !";
  
} catch(PDOException $e) {
  die('Erreur : ' . $e->getMessage());
}

$db = "admin_mstor";

echo

<html>
 <head>
  <title>Test PHP</title>
 </head>
 <body>
 <?php echo '<p>Bonjour le monde</p>'; ?>
 </body>
</html>

<?php
//-------------------------------------------------//
//connexion à la bdd
//-------------------------------------------------//


error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);



$host='localhost';
$user='root';


$password='';
$db = "admin_mstor";
//connexion à la bdd
try{
  $bdd =new PDO('mysql:host='.$host.';dbname='.$db.'; charset=utf8', $user, $password);
  // Activation des erreurs PDO
} catch(PDOException $e) {
    die('Erreur : ' . $e->getMessage());
}
  $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
  $bdd->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);

  echo "<br> Connexion à la bdd : OK !";