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();







};



?>