How to Dynamically Add a New Column to a MySQL Table with User Input in PHP?

Adding a New Column to a MySQL Table

You aim to dynamically add a new column to your existing MySQL table using PHP. To achieve this, you'll need to alter the table's structure using an SQL statement.

In your sample code, you're trying to add a new column named newq:

mysql_query("ALTER TABLE `assessment` ADD newq INT(1) NOT NULL AFTER `q10`");

However, the q10 column does not exist in your table. To correct this, you can use the following syntax:

mysql_query("ALTER TABLE `assessment` ADD `q6` INT(1) NOT NULL AFTER `q5`");

This will add a new column named q6 to your assessment table after the q5 column.

Now, to capture the user input from a textbox and dynamically add the new column, you can use the following code:

<?php 

if (isset($_POST['submit'])) {
  $newq = $_POST['newq'];

  // Generate the SQL query dynamically
  $query = "ALTER TABLE `assessment` ADD `{$newq}` INT(1) NOT NULL AFTER `q5`";

  // Execute the query
  mysql_query($query);
}

?>

<form method="post" action="">
  <input type="text" name="newq" size="20">
  <input type="submit" name="submit" value="Submit">
</form>

By following these steps, you can dynamically add new columns to your MySQL table based on user input.

The above is the detailed content of How to Dynamically Add a New Column to a MySQL Table with User Input in PHP?. For more information, please follow other related articles on the PHP Chinese website!