PDO SQL DUMP

$sDatabase = '';
$sDsn = '';
$sUser = '';
$sPass = '';
 
$PDO = new PDO( $sDsn, $sUser, $sPass );
$PDO->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
 
$sQuery = "SHOW tables FROM " . $sDatabase;
$sResult = $PDO->query($sQuery);
$sData = "
-- PDO SQL Dump --
 
SET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\";
 
--
-- Database: `$sDatabase`
--
 
-- --------------------------------------------------------
";
 
while ($aTable = $sResult->fetch(PDO::FETCH_ASSOC)) {
 
  $sTable = $aTable['Tables_in_' . $sDatabase];
 
  $sQuery = "SHOW CREATE TABLE $sTable";
 
  $sResult2 = $PDO->query($sQuery);
 
  $aTableInfo = $sResult2->fetch(PDO::FETCH_ASSOC);
 
  $sData .= "\n\n--
-- Tabel structuur voor tabel `$sTable`
--\n\n";
  $sData .= $aTableInfo['Create Table'] . ";\n";
 
  $sData .= "\n\n--
-- Gegevens worden uitgevoerd voor tabel `$sTable`
--\n\n";
 
 
  $sQuery = "SELECT * FROM $sTable\n";
 
  $sResult3 = $PDO->query($sQuery);
 
  while ($aRecord = $sResult3->fetch(PDO::FETCH_ASSOC)) {
 
    // Insert query per record
    $sData .= "INSERT INTO $sTable VALUES (";
    $sRecord = "";
    foreach( $aRecord as $sField => $sValue ) {
      $sRecord .= "'$sValue',";
    }
    $sData .= substr( $sRecord, 0, -1 );
    $sData .= ");\n";
  }
 
}