Advertisement
Guest User

Untitled

a guest
Aug 14th, 2017
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.28 KB | None | 0 0
  1. $statement = $connection->prepare("SELECT `players`.`internal_ID`, `players`.`mmr` FROM libert_gigantic.`players` ORDER BY `players`.`name` ASC LIMIT 0, 500;");
  2. //$statement->bindValue(':start', $count, PDO::PARAM_INT);
  3. $statement->execute();
  4. $statement->debugDumpParams();
  5. $totalcount = $statement->rowCount();
  6. //echo $totalcount;
  7. //file_put_contents("C:\\file.txt",$totalcount);
  8. while($row = $statement->fetch()){
  9.     $statement = $connection->prepare("INSERT INTO $database.`mmr_tracking` (`mmr_tracking`.`internal_ID`, `mmr_tracking`.`mmr`, `mmr_tracking`.`date`) VALUES (:playerid, :playermmr, :todaysdate)");
  10.     $statement->bindValue(':playerid', $row['internal_ID'], PDO::PARAM_STR);
  11.     $statement->bindValue(':playermmr', $row['mmr'], PDO::PARAM_INT);
  12.     $statement->bindValue(':todaysdate', $timestamp, PDO::PARAM_STR);
  13.     $statement->execute();
  14. }
  15.  
  16. $host = 'localhost'; // IP of the server MySQL is running on
  17. $port = 3306; // This is the default port for MySQL
  18. $dbusername = '<valid>'; // The username used to access the database
  19. $dbpassword = '<valid'; // The above users password
  20. $dsn = "mysql:host=$host;port=$port;dbname=$database;charset=utf8;";
  21. $connection = new PDO($dsn, $dbusername, $dbpassword);
  22. $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement