How to loop inside a variable

Question

I have an array containing column names of a table i want to create which i got from an excel sheet.

I tried something like this

$sql = "CREATE TABLE IF NOT EXISTS ".$month."-".date('Y')."(
    ".foreach($tableColumnNames as $columnName){
         echo $columnName." VARCHAR(200) NULL,";
      }
."
)";

It returns error saying Parse error: syntax error, unexpected 'foreach' same thing with while loops

How can i create Table with column names i have in an array. And How can i set each column data type unique (INT,VARCHAR,..)

you shouldent use echo, you want to concatenate the values

user557846
– user557846

2015-11-22 20:09:08 +00:00
Commented Nov 22, 2015 at 20:09 — user557846
– user557846, Commented Nov 22, 2015 at 20:09

user557846 · Accepted Answer · 2015-11-22 20:10:41Z

2

you want to build the sql string like so:

$sql = "CREATE TABLE IF NOT EXISTS ".$month."-".date('Y')."(";

    foreach($tableColumnNames as $columnName){
         $sql .= $columnName." VARCHAR(200) NULL,";
      }
$sql=rtrim($sql,',');//remove last comma
$sql .=")";

answered Nov 22, 2015 at 20:10

user557846

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

5 Comments

Skyyy Over a year ago

How can i remove comma(,) from sql last column name else it give me errors.

user557846 Over a year ago

refresh, i added that in

Skyyy Over a year ago

it removes comma(,) from whole string not just from last column

user557846 Over a year ago

are you sure you put it in the right place? it is outside the foreach

Skyyy Over a year ago

Sorry My mistake.. it was inside loop. Now everything works fine

Collectives™ on Stack Overflow

How to loop inside a variable

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related