如何在变量内部循环 [英] How to loop inside a variable

问题描述

我有一个数组，其中包含要创建的表的列名，该表是从excel工作表中获得的.

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

我尝试过类似的事情

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

它返回错误，并说Parse error: syntax error, unexpected 'foreach'与while循环相同

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

如何使用数组中的列名创建表.以及如何设置每个列数据类型的唯一性(INT，VARCHAR，..)

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,..)

推荐答案

您要像这样构建sql字符串:

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 .=")";

这篇关于如何在变量内部循环的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！