/home/desid573/p1.desidrivers.com.au
Edit: /home/desid573/p1.desidrivers.com.au/generateNumbers.php (1532B)
connect_error);
$qcon=mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
$query = "SELECT * FROM `desid573_eway_codes`.`links` ORDER BY `id` DESC";
$result = $conn->query($query);
$row = $result->fetch_assoc();
$start = $row["ref"];
$query = "INSERT INTO `desid573_eway_codes`.`links` (`id`, `ref`, `link`) VALUES ";
$user_details = array();
for($i = 1; $i < 10000; $i++){
increment($start);
$user_details[] = "(NULL,'".$start."','')";
}
$query .= implode(",", $user_details);
$result = $conn->query($query);
if(!$result) {
echo $conn->error;
}
function increment(&$string){
$last_char=substr($string,-1);
$rest=substr($string, 0, -1);
switch ($last_char) {
case '':
$next= 'a';
break;
case 'z':
$next= 'A';
break;
case 'Z':
$next= '0';
break;
case '9':
increment($rest);
$next= 'a';
break;
default:
$next= ++$last_char;
}
$string=$rest.$next;
}