Advertisement
Guest User

Untitled

a guest
Aug 4th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. <?php
  2. $source_db="avik_old";
  3. $new_db="avik_new";
  4.  
  5. mysql_connect("localhost","root","*****");
  6. mysql_select_db($source_db);
  7.  
  8. //mysql_select_db($new_db);
  9.  
  10. $get_users = mysql_query("SELECT * FROM avik_old.users");
  11. while ($rs = mysql_fetch_array($get_users,MYSQL_ASSOC)){
  12. $username = $rs['username'];
  13. $password = $rs['password'];
  14. $email = $rs['email'];
  15. $website = $rs['website'];
  16.  
  17. $sql_query = mysql_query("INSERT into avik_new.signup (username,pwd,email,website) values ('$username','$password','$email','$website')");
  18. }
  19.  
  20. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement