Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $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'];
- $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\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;
Add Comment
Please, Sign In to add comment