Advertisement
kiojiotisha

migrate

Aug 19th, 2019
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.71 KB | None | 0 0
  1. function update_data_migration()
  2.     {
  3.         $driver_migration = $this->get_driver_migration();
  4.         foreach($driver_migration as $data )
  5.         {
  6.             $query = "
  7.                UPDATE users SET username = ?
  8.                WHERE id = ?
  9.            ";
  10.             $this->db->query($query, array(md5($data->hp. microtime(). $data->email), $data->id));
  11.         }
  12.     }
  13.  
  14.     function get_driver_migration()
  15.     {
  16.         $driverMigration = $this->db->query(
  17.             "
  18.                SELECT *
  19.                FROM users
  20.                WHERE create_date = '2019-08-07 09:55:55'
  21.                AND user_type_id = 50
  22.            "
  23.         )->result();
  24.  
  25.         return $driverMigration;
  26.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement