php 保存数据到不同表,使用MySQL和PHP将数据分成两个不同的数据库表

创建2个表：

CREATE TABLE product (

id INT NOT NULL PRIMARY KEY,

name VARCHAR() NOT NULL

);

CREATE TABLE options (

product_id INT NOT NULL PRIMARY KEY,

color VARCHAR(30),

size VARCHAR(10),

price DECIMAL(10,2)

);取得&在表中插入记录：

$result1 = mysql_fetch_assoc(mysql_query('SELECT * from ProductTemp GROUP BY ProductID', $conn));

$result2 = mysql_fetch_assoc(mysql_query('SELECT * from ProductTemp', $conn));

foreach( $result1 as $v ) {

$retval1 = mysql_query("INSERT INTO product VALUES('$v['ProductID']','$v['Product Name']')", $conn);

if(!$retval1) {

echo 'Could not enter data into table product: ' . mysql_error();

exit;

}

}

foreach( $result2 as $v ) {

$retval2 = mysql_query("INSERT INTO options VALUES('$v['ProductID']','$v['Color']','$v['Size']' , $v['Price'])", $conn);

if(!$retval2 ) {

echo 'Could not enter data into table options: ' . mysql_error();

exit;

}

}