我创建了这个mysql表:
CREATE TABLE earthquakes (
id INT(20) AUTO_INCREMENT,
idserial VARCHAR(30),
milliseconds BIGINT,
latitude FLOAT,
longitude FLOAT,
magnitude FLOAT,
ipocentro FLOAT,
source VARCHAR(4),
region SMALLINT,
PRIMARY KEY(id),
INDEX indice_idserial(idserial),
INDEX indice_milliseconds(milliseconds),
INDEX indice_lat_lng(latitude,longitude),
INDEX indice_magnitude(magnitude),
INDEX indice_ipocentro(ipocentro)
);
而且我想将多维php数组插入到mysql表中,但是我不知道也想添加
id
。这是添加数组的代码:
//MULTIDIMENSIONAL ARRAY
$array_database= array(
array("2017-06-30-104",1498858541000,39.3322,-122.9027,2.11,0,"U",36)
);
//
foreach($array_database as $row) {
$idserial_db= mysql_real_escape_string($row[0]);
$milliseconds_db = mysql_real_escape_string($row[1]);
$latitude_db = mysql_real_escape_string($row[2]);
$longitude_db = mysql_real_escape_string($row[3]);
$magnitude_db = mysql_real_escape_string($row[4]);
$ipocentro_db= mysql_real_escape_string($row[5]);
$source_db= mysql_real_escape_string($row[6]);
$region_db= mysql_real_escape_string($row[7]);
$valori_db[] = "('$idserial_db',$milliseconds_db,$latitude_db,$longitude_db,$magnitude_db,$ipocentro_db,'$source_db',$region_db)";
}
$values = implode(',', $valori_db);
mysqli_query($connessione,"INSERT INTO earthquakes (idserial,milliseconds,latitude,longitude,magnitude,ipocentro,source,region) VALUES $values");
那我怎么加
ID
?非常感谢,对不起我的英语
编辑
也许我应该以这种方式添加
ID
: mysqli_query($connessione,"INSERT INTO earthquakes (id,idserial,milliseconds,latitude,longitude,magnitude,ipocentro,source,region) VALUES $values");
最佳答案
在声明中:
//MULTIDIMENSIONAL ARRAY
$array_database= array(
array("", "2017-06-30-104",1498858541000,39.3322,-122.9027,2.11,0,"U",36)
);
//
在循环:
$valori_db[] = " ('','$idserial_db',$milliseconds_db,$latitude_db,$longitude_db,$magnitude_db,$ipocentro_db,'$source_db',$region_db)";
在查询中:
mysqli_query($connessione,"INSERT INTO earthquakes (id,idserial,milliseconds,latitude,longitude,magnitude,ipocentro,source,region) VALUES $values");