Guest User

Untitled

a guest
Apr 11th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. $sDatabase = 'ddaevolution';
  2. $sDsn = 'mysql:host=217.70.188.223;dbname=ddaevolution';
  3. $sUser = 'hyperprodda';
  4. $sPass = 'oihf58463vilfkhn';
  5.  
  6. $PDO = new PDO( $sDsn, $sUser, $sPass );
  7. $PDO->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
  8.  
  9.  
  10. $sData = "";
  11. $sTable = $_GET['table'];
  12. $sQuery = "SHOW CREATE TABLE $sTable";
  13. $sResult2 = $PDO->query($sQuery);
  14.  
  15. $aTableInfo = $sResult2->fetch(PDO::FETCH_ASSOC);
  16.  
  17. $sData .= $aTableInfo['Create Table'] . ";\n";
  18.  
  19. $sData .= "\n\n--
  20. -- Gegevens worden uitgevoerd voor tabel `$sTable`
  21. --\n\n";
  22.  
  23.  
  24. $sQuery = "SELECT * FROM $sTable\n";
  25.  
  26. $sResult3 = $PDO->query($sQuery);
  27.  
  28. while ($aRecord = $sResult3->fetch(PDO::FETCH_ASSOC)) {
  29.  
  30. // Insert query per record
  31. $sData .= "INSERT INTO $sTable VALUES (";
  32. $sRecord = "";
  33. foreach( $aRecord as $sField => $sValue ) {
  34. $sRecord .= "'$sValue',";
  35. }
  36. $sData .= substr( $sRecord, 0, -1 );
  37. $sData .= ");\n";
  38. }
  39. echo $sData;
Add Comment
Please, Sign In to add comment