Dette stykke PHP til evaluering

Hej Linux Hjerner :)

Jeg har lavet følgende stykke kode i PHP for at generere 20 tomme databaser til MySQL server, kig selv. :)
Det er for at kunne installere Joomla! vha. disse databaser

Det skal senere tilføjes et CSV spreadsheet :)

Og det skal senere laves med udfyldning af form :)

Jeg vil meget gerne have forslag til ændringer :)

Jeg modtager meget gerne krav til uddybninger hvis, nødvendigt :)

Mvh,
Thomas :)






< title>Database creation in PHP




<?php

$servername = "localhost";
$username = "username";
$password = "password";
$startDB= 0;
$endDB= 20;
$TJDB="prefixDB";
//$spreadsheetCSV="databases.csv";

for($DBnr = $startDB; $DBnr <= $endDB; $DBnr++){


// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

//$myDB=system("mkpasswd 'date +%N' ");

// Create DATABASE

$sql= "CREATE DATABASE ${TJDB}${DBnr};";

if ($conn->query($sql) === TRUE) {
echo "DATABASE created successfully";
} else {
echo "Error creating DATABASE: " . $conn->error;
}

// Create USER

$myUsername = system("mkpasswd 'date +%N' ");

$sql="CREATE USER ${myUsername}@localhost;";

if ($conn->query($sql) === TRUE) {
echo "USER created successfully";
} else {
echo "Error creating USER: " . $conn->error;
}
// Create PASSWORD

$myPassword = system("mkpasswd 'date +%N' ");

$sql="IDENTIFIED BY PASSWORD ${myPassword};";

if ($conn->query($sql) === TRUE) {
echo "PASSWORD created successfully";
} else {
echo "Error creating PASSWORD: " . $conn->error;
}
// GRANT ALL ON myDB.* TO USERNAME

$sql = "GRANT ALL ON ${TJDB}${myDB}.* TO ${myUsername}@localhost;";

if ($conn->query($sql) === TRUE) {
echo "Granting created successfully";
} else {
echo "Error creating GRANTING: " . $conn->error;
}
$conn->close();



};

?>