Unable to create table using PDO PHP

Question

I am trying to create a table using PDO my connection is fine as i just tested it with try catch block. But i am unable to create any table in my DB

function loadData($table)
{

$conn = new PDO("mysql:host=localhost;dbname=anlyatics_db", "root", "");
$query = "CREATE TABLE if not exists $table); ";
$stmt = $conn->prepare($query);
if ($stmt)
{
    $stmt->execute();
}
}

Do you get an error? A blank screen? What happens when this code runs? Is there anything in $stmt->ErrorInfo()? — andrewsi
– andrewsi, Commented Oct 23, 2013 at 17:28

Jeroen · Accepted Answer · 2013-10-23 17:33:16Z

3

Based on your comment:

" it contains name for the table e.g at the moment it has CDM_2011"

I would say you need to add columns to your create statement. I don't think you can have a create statement without column definitions.

answered Oct 23, 2013 at 17:33

Jeroen

1,0121 gold badge7 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

noobie-php Over a year ago

yeah looks legit need to have look at it

Jeroen Over a year ago

just to see if this is the issue, try this: CREATE TABLE if not exists $table (id int);

Jeroen Over a year ago

oh right: after $table you have a closing bracket, you nowhere have an opening bracket either

noobie-php Over a year ago

Marking it correct as table cant be created without column definiton and marking your post correct is for the face you point it out 1st.

JoDev · Accepted Answer · 2013-10-23 17:36:46Z

1

Have you got the CREATE right?? See here for a MySQL User management?

For my part, I'm not sure that create table from PHP is safe!...

To retrieve the error, use

$conn->errorInfo();

PHP MANUAL

EDIT

Have you tried to put at least 1 column? As you can see here, MySQL CREATE statement needs 1 column...

edited Oct 23, 2013 at 17:36

answered Oct 23, 2013 at 17:30

JoDev

6,9231 gold badge25 silver badges37 bronze badges

2 Comments

noobie-php Over a year ago

the solution you mentioned returns Array ( [0] => 00000 [1] => [2] => )

JoDev Over a year ago

Ok so in the array : ([0]=>00000, [1]=>, [2]=>)) the first mean : SQLSTATE, and it is 0... So no error returned.

Collectives™ on Stack Overflow

Unable to create table using PDO PHP

2 Answers 2

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related