$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 );


$sData = "";
  $sTable = $_GET['table'];
	$limit1= $_GET['l1'];
	$limit2= $_GET['l2'];
  $sQuery = "SHOW CREATE TABLE $sTable";
  $sResult2 = $PDO->query($sQuery);

  $aTableInfo = $sResult2->fetch(PDO::FETCH_ASSOC);

  $sData .= $aTableInfo['Create Table'] . ";\n";

  $sData .= "\n\n--
-- Gegevens worden uitgevoerd voor tabel `$sTable`
--\n\n";


  $sQuery = "SELECT * FROM $sTable LIMIT $limit1, $limit2\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";
	echo $sData;
	$sData = "";
  }