Thursday, 22 August 2013

Random table name generator

Random table name generator

I am trying to write a script that will randomly generate a "name", and
use the variable assigned as the table name. However i am not able to
create the table i get the error "table was not created:". I listed my
code below. Thanks for any help you can give me.
$con =
mysqli_connect("localhost","placeholder","placeholder","placeholder");
//or die ('unable to connect');
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
//create random database name
$alpha = "abcdefghijklmnopqrstuvwxyz";
$alpha_upper = strtoupper($alpha);
$numeric = "0123456789";
$special = ".-+=_,!@$#*%<>[]{}";
$chars = "";
if (isset($_POST['length'])){
// if you want a form like above
if (isset($_POST['alpha']) && $_POST['alpha'] == 'on')
$chars .= $alpha;
if (isset($_POST['alpha_upper']) && $_POST['alpha_upper'] == 'on')
$chars .= $alpha_upper;
if (isset($_POST['numeric']) && $_POST['numeric'] == 'on')
$chars .= $numeric;
if (isset($_POST['special']) && $_POST['special'] == 'on')
$chars .= $special;
$length = $_POST['length'];
}else{
// default [a-zA-Z0-9]{9}
$chars = $alpha . $numeric;
$length = 6;
}
$len = strlen($chars);
$pw = '';
for ($i=0;$i<$length;$i++)
$pw .= substr($chars, rand(0, $len-1), 1);
// the finished table name
$pw = str_shuffle($pw);
//using the $pw variable for the table name
$sql="CREATE TABLE `' . $pw . '` (
PID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(PID),
Name CHAR(15))";
if (mysqli_query($con,$sql))
{
echo "table created successfully";
}
else
{
echo "table was not created:" . mysqli_error($sql);
}
//TODO create XML file
mysqli_close($con);

No comments:

Post a Comment