Advertisement
Guest User

Untitled

a guest
May 2nd, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. <?php
  2. $user = "root";
  3. $pass = "";
  4. try {
  5. $dbold = new PDO('mysql:host=localhost;dbname=old', $user, $pass);
  6. $dbnew = new PDO('mysql:host=localhost;dbname=new', $user, $pass); // $dbnew nice man
  7. foreach($dbold->query('SELECT * from users') as $user) {
  8. $insertUser = $dbnew->prepare('INSERT INTO users (email) VALUES (:email) ()');
  9. $insertUser->bindParam(':email', $user['email']);
  10.  
  11. $insertUser->execute();
  12. }
  13. $dbh = null;
  14. } catch (PDOException $e) {
  15. print "Error!: " . $e->getMessage() . "<br/>";
  16. die();
  17. }
  18.  
  19. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement