Insert data into mysql table when field names is changed dynamically?

Question

I was try this by using this code. used the while loop but there is no solutions.

$counter= 0;
  $result= $cid->query("SELECT ComName FROM catcom"); 
  echo $count=$result->num_rows;
  while ($row= $result->fetch_assoc()) {
      $field_value[] = $row;
      $counter++;
  }

Array store the name of the field $field_value[] is it possible to store data to data base, like this code if possible to how to write syntax.

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $import="INSERT into  $field_value[] values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]')";

Your Common Sense · Accepted Answer · 2015-07-15 08:42:43Z

1

Field names in a relational database should not change dynamically.
You have to learn relational architecture and design your database to make its fields stay firmly on their places, not running like ants before rain.

answered Jul 15, 2015 at 8:42

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

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

3 Comments

YOG_PHP Over a year ago

Sir, i am changing the name and update new field. '$sql = "ALTER TABLE commissions ADD $head_db_name VARCHAR(255) NOT NULL AFTER Comm_id";' and similar i am updating the field name query("UPDATE catcom SET ComName ='$head_db_name', ComFullName ='$head_name', cat_id ='$cat_value' WHERE CatComId = '$ComId'") == TRUE)

YOG_PHP Over a year ago

and it could be change any time by Update Field name.

YOG_PHP Over a year ago

Actually i want to store data by using the, Xls file and store into the database now , and every time the Xls file fields are changed, and according to file, DATA base field are changed, now tell me that how can i upload file ??

Collectives™ on Stack Overflow

Insert data into mysql table when field names is changed dynamically?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related