add details into existing column

[ferlicia]

i have a existing table and let the user add another column in the table, how does the user input go into the database?

i  can create the column but do not know how to insert the user input.

[irkevin]

"i have a existing table and let the user add another column in the table"

 

You mean you let the user alter you database tables?

 

i  can create the column but do not know how to insert the user input.

 

Maybe and INSERT

 

INSERT INTO tableName(your_fields) VALUES(your_values)

[darkfreaks]

no she wants to create a TABLE column using MYSQL

 

 

try this:

 

 

ALTER TABLE table_name ADD (column_name varchar(number here));

 

[ferlicia]

lets say i have a table inside the database, name database. i have id, name, price. after that i decide to let the user add a column name quantity, i can create the column already. however, i tried to insert the user input data into the column, it cannot be done because there is an error message. the message is, Column count doesn't match value count at row 1. this is my code,

 

<?php

 

include 'dbFunctions.php';

 

$coulmnname = $_POST['columnname'];

$addname = $_POST['addname'];

$query = "INSERT INTO table ($columnname) VALUES ('".$addname."')";

$status = mysqli_query($link,$query) or die(mysqli_error($link));

 

if($status){

    $message = " addded sucessfully";

}

else{

    $message = "Unable to add";

}

[WebStyles]

typo in $coulmnname

[ferlicia]

i have corrected the typo, but it is still the same.

 

[WebStyles]

is you database table actually called 'table' ? you need to correct that.

[darkfreaks]

look i am confused are you trying to add a column or a row? if you want a column you need to look into the ALTER TABLE syntax. otherwise if your adding a row into MYSQL use INSERT INTO

 

 

[WebStyles]

My guess is ferlicia wants to add a row of data, for 2 reasons:

 

1. Because ferlicia said "i  can create the column but do not know how to insert the user input. "

2. because letting users freely add columns do tables is such a bad idea that I'd rather think option 1 is the correct one. 

 

So what you need ferlicia, (as said before by irkevin) is something like: mysql_query("INSERT INTO `tableName` (`field1`,`field2`,`filed3`) values ('$value1','$value2','$value3')");

and make sure you have the correct table name:

$field = trim($_POST['columnname']);
$addname = trim($_POST['addname']);
$query = "INSERT INTO `CHANGE_THIS_TO_YOUR_TABLE_NAME` ($field) VALUES ('$addname')";
$status = mysqli_query($link,$query) or die(mysqli_error($link));