drugs-prices.php

<?php

$user = 'root';
$password = 'root';
$db = 'globalcollapse';
$host = 'localhost';
$port = 3306;

$link = mysqli_init();
$success = mysqli_real_connect(
  $link,
  $host,
  $user,
  $password,
  $db,
  $port
);

for ($i = 1; $i <= 5; $i++) {
  $drug = mysqli_query($link, "SELECT * FROM `drugs` WHERE `id` = '$i' LIMIT 1");
  $row = mysqli_fetch_assoc($drug);
  $pastprice = $row['price'];
  $min = $row['min'];
  $max = $row['max'];
  $newprice = rand($min, $max);
  mysqli_query($link, "UPDATE `drugs` SET `price` = '$newprice', `past_price` = '$pastprice', `updated` = now() WHERE `id` = '$i'");
}

mysqli_close($link);
header("Location: https://www.google.com");

?>