Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $statement = $connection->prepare("SELECT `players`.`internal_ID`, `players`.`mmr` FROM libert_gigantic.`players` ORDER BY `players`.`name` ASC LIMIT 0, 500;");
- //$statement->bindValue(':start', $count, PDO::PARAM_INT);
- $statement->execute();
- $statement->debugDumpParams();
- $totalcount = $statement->rowCount();
- //echo $totalcount;
- //file_put_contents("C:\\file.txt",$totalcount);
- while($row = $statement->fetch()){
- $statement = $connection->prepare("INSERT INTO $database.`mmr_tracking` (`mmr_tracking`.`internal_ID`, `mmr_tracking`.`mmr`, `mmr_tracking`.`date`) VALUES (:playerid, :playermmr, :todaysdate)");
- $statement->bindValue(':playerid', $row['internal_ID'], PDO::PARAM_STR);
- $statement->bindValue(':playermmr', $row['mmr'], PDO::PARAM_INT);
- $statement->bindValue(':todaysdate', $timestamp, PDO::PARAM_STR);
- $statement->execute();
- }
- $host = 'localhost'; // IP of the server MySQL is running on
- $port = 3306; // This is the default port for MySQL
- $dbusername = '<valid>'; // The username used to access the database
- $dbpassword = '<valid'; // The above users password
- $dsn = "mysql:host=$host;port=$port;dbname=$database;charset=utf8;";
- $connection = new PDO($dsn, $dbusername, $dbpassword);
- $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement