Advertisement
Guest User

Untitled

a guest
Jan 5th, 2019
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.82 KB | None | 0 0
  1. <?php
  2.  
  3. $host = '127.0.0.1';
  4. $db   = 'cns';
  5. $user = 'root';
  6. $pass = '';
  7. $charset = 'utf8mb4';
  8.  
  9. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  10. $options = [
  11.     PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
  12.     PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  13.     PDO::ATTR_EMULATE_PREPARES   => false,
  14. ];
  15. try {
  16.      $pdo = new PDO($dsn, $user, $pass, $options);
  17.  
  18.      $start = strtotime('-1 month');
  19.      for ($i = 0; $i < 200000; $i++) {
  20.       for ($t = 1; $t <= 150; $t++) {
  21.         $pdo->query('
  22.         insert into
  23.          history_datas
  24.         set
  25.          created_at = "'.date('Y-m-d H:i:s', $start++).'",
  26.          coins_id = '.$t.',
  27.        ');
  28.        }die;
  29.       }
  30.      }
  31. } catch (\PDOException $e) {
  32.      throw new \PDOException($e->getMessage(), (int)$e->getCode());
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement