此php代码是什么意思?
foreach ($data as $key => $val) {
$pre = ($i > 0) ? ', ' : '';
$columns .= $pre.$key;
$values .= $pre."'".$val."'";
$i++;
}
$query = "INSERT INTO ".$table." (".$columns.") VALUES (".$values.")";
它将阵列(键=>值)转换为插入SQL。
例如:
$array = array('date' => '2016-06-19 12:00:00', 'name' => 'Jamie');
将转换为:
INSERT INTO `table` (date, name) VALUES ('2016-06-19 12:00:00', 'Jamie');
实际代码是我认为...
$i = 0;
foreach ($data as $key => $val) {
$pre = ($i > 0) ? ', ' : '';
$columns .= $pre.$key;
$values .= $pre."'".$val."'";
$i++;
}
$query = "INSERT INTO ".$table." (".$columns.") VALUES (".$values.")";
在这里您可以写..
$pre = ($i > 0) ? ', ' : '';//this method is known as ternary Operator...
进入这个...
if($i > 0) //this is classic if else method...
{
$pre = ', ';
}
else
{
$pre ='';
}