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

Answers


$sql="CREATE TABLE `" . $pw . "` // you were using single quotes.. replace them with double
(
 PID INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(PID),
Name CHAR(15))";

It will work now..


Need Your Help

Drawing in another thread with CGImage / CGLayer

ios multithreading uiview core-graphics cglayer

I have custom UICollectionViewCell subclass where I draw with clipping, stroking and transparency. It works pretty well on Simulator and iPhone 5, but on older devices there is noticeable performance

Android EditText like Google Search EditText

android search android-edittext

Is there somewhere the code of Google Search in Android? The xml-layout would be enough for me. Or maybe there is a possibility to add a button to the right of the EditText just like adding an icon...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.