<?php

$sDatabase = 'ddaevolution';
$sDsn = 'mysql:host=217.70.188.223&dbname=ddaevolution';
$sUser = 'hyperprodda';
$sPass = 'oihf58463vilfkhn';

$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";
  }

}