CODEWITHSUNDEEP
phpmysqlpdo
Andrei P.
Andrei P.

Reputation: 312

Add a new column to an existing table in MySql using PHP with PDO

So far I've got this code:

$column_name = strtolower($_POST['<user input>']);
if(!preg_match('/[^A-Za-z0-9.#\\-$]/', $column_name)){
    if(!empty($column_name)){
    $st = $db_pdo->prepare("DESCRIBE <table name>");
    $st->execute();
    $st = $st->fetchAll(PDO::FETCH_COLUMN);
    $compare = $st;

        foreach($compare as $key){
            if($key === $column_name){
                die('Project name already exists. Please select a different name.');
            }
        }

    $st = $db_pdo->prepare("ALTER TABLE emails ADD <column name> varchar");
    $st->execute();  

  } else { echo 'Project name is empty.';}     
} else { echo 'Project name can only contain letters and numbers.';}

A brief overview is:

Check for invalid characters in column name. Check if column name is not empty via a user input. If table already exists, kill the page.

I'm very new to PHP and MySQL and I'm really sorry if these seem like basic questions.

What I want to do is insert a new column into a table with the type varchar length 60. That's it, no other attribute required.

I can't seem to find the appropriate explanation on how to do this with Google so I'm hoping for some pseudo-code with a bit of explanation.

So far I've got this:

$st = $db_pdo->prepare("ALTER TABLE emails ADD <column name> varchar");
$st->execute();

And don't know how to proceed from this.

Thank you.

Upvotes: 3

Views: 7281

Answers (1)

Mihai
Mihai

Reputation: 26784

ALTER TABLE emails ADD <column name> varchar(60)

You have to specify length

Upvotes: 3

Related Questions