Automatically add fields/columns to a MySQL database

– 05/11/2010Posted in: MySQL, PHP

To take the fields from a form and build a database on the fly do the following:

foreach($_POST as $var => $value)
{
$squery = "ALTER TABLE `table_name` ADD COLUMN `$var` varchar(255)";
// then run query here
}

Like this? Maybe you could buy me a coffee.

Tags: database, form, input, insert, MySQL, php, table

Web Developer based in the UK. Click here if you want to work with me

Start the ball rolling by posting a comment on this article!

Buy me a coffee

Found anything useful? Maybe you could buy me a coffee
Spammers!

If you are going to put nonsense comments on my articles at least have the decency to click one of these adverts while you are here.

Even if you are a regular visitor you click a couple of ads while you are here - you might find something you want.
You May Also Like…
Cloud
accessibility block browser cache chrome chunk cms concrete5 CSS curl database date error file firefox form get href ie image input iphone javascript JQuery link magento MODx myqsl MySQL php post profile Revolution select Server session snippet spellcheck spelling table textarea tinymce w3c wordpress xml
Info

Yes, the images are ambiguous;
Yes, they came from Google images;
No, I didn't get permission to use them*;
I know Magento called isn't Magneto;

And...
Why do spammers who hit this site do it with such a bizarre use of the English language?;