โดย เอาดะคุง » 13/04/2007 6:19 pm
foreach($_POST as $key => $value) {
$$key = $value;
}
หมายความว่าอย่างไรครับ เพราะมันอยู่บนสุดของโค๊ดครับ
////////// ข้างล่างนี้คือโค๊ดแบบเต็ม ๆ ครับ
foreach ($_POST as $key => $value){
$$key = $value;
}
$conn = mysql_connect (SQL_HOST,SQL_USER,SQL_PASS)
or die ('Could not connect to Mysql database. ' .mysql_error());
mysql_select_db(SQL_DB,$conn);
switch ($action){
case "Create Character":
$sql = "INSERT IGNORE INTO char_zipcode (id, city, state) " .
"VALUES ('$zip', '$city', '$state')";
$result = mysql_query($sql)
or die(mysql_error());
$sql = "INSERT INTO char_lair (id, zip_id, lair_addr) " .
"VALUES (NULL, '$zip', '$address')";
$result = mysql_query($sql)
or die(mysql_error());
if ($result) {
$lairid = mysql_insert_id($conn); //* mysql_insert_id ให้เพิ่ม ID ใน Mysql Auto นะก๊าบ
}
$sql = "INSERT INTO char_main (id,lair_id,alias,real_name,align) " .
"VALUES (NULL, '$lairid', '$alias', '$name', '$align')";
$result = mysql_query($sql)
or die(mysql_error());
if ($result) {
$charid = mysql_insert_id($conn);
}
if ($powers != "") {
$val = "";
foreach ($powers as $key => $id) {
$val[] = "('$charid', '$id')";
}
$values = implode(',', $val);
$sql = "INSERT IGNORE INTO char_power_link (char_id, power_id) " .
"VALUES $values";
$result = mysql_query($sql)
or die(mysql_error());
}
if ($enemies != '') {
$val = "";
foreach ($enemies as $key => $id) {
$val[] = "('$charid', '$id')";
}
$values = implode(',', $val);
if ($align = 'good') {
$cols = '(good_id, bad_id)';
} else {
$cols = '(bad_id, good_id)';
}
$sql = "INSERT IGNORE INTO char_good_bad_link $cols " .
"VALUES $values";
$result = mysql_query($sql)
or die(mysql_error());
}
$redirect = 'charlist.php';
break;
foreach($_POST as $key => $value) {
$$key = $value;
}
หมายความว่าอย่างไรครับ เพราะมันอยู่บนสุดของโค๊ดครับ
////////// ข้างล่างนี้คือโค๊ดแบบเต็ม ๆ ครับ
foreach ($_POST as $key => $value){
$$key = $value;
}
$conn = mysql_connect (SQL_HOST,SQL_USER,SQL_PASS)
or die ('Could not connect to Mysql database. ' .mysql_error());
mysql_select_db(SQL_DB,$conn);
switch ($action){
case "Create Character":
$sql = "INSERT IGNORE INTO char_zipcode (id, city, state) " .
"VALUES ('$zip', '$city', '$state')";
$result = mysql_query($sql)
or die(mysql_error());
$sql = "INSERT INTO char_lair (id, zip_id, lair_addr) " .
"VALUES (NULL, '$zip', '$address')";
$result = mysql_query($sql)
or die(mysql_error());
if ($result) {
$lairid = mysql_insert_id($conn); //* mysql_insert_id ให้เพิ่ม ID ใน Mysql Auto นะก๊าบ
}
$sql = "INSERT INTO char_main (id,lair_id,alias,real_name,align) " .
"VALUES (NULL, '$lairid', '$alias', '$name', '$align')";
$result = mysql_query($sql)
or die(mysql_error());
if ($result) {
$charid = mysql_insert_id($conn);
}
if ($powers != "") {
$val = "";
foreach ($powers as $key => $id) {
$val[] = "('$charid', '$id')";
}
$values = implode(',', $val);
$sql = "INSERT IGNORE INTO char_power_link (char_id, power_id) " .
"VALUES $values";
$result = mysql_query($sql)
or die(mysql_error());
}
if ($enemies != '') {
$val = "";
foreach ($enemies as $key => $id) {
$val[] = "('$charid', '$id')";
}
$values = implode(',', $val);
if ($align = 'good') {
$cols = '(good_id, bad_id)';
} else {
$cols = '(bad_id, good_id)';
}
$sql = "INSERT IGNORE INTO char_good_bad_link $cols " .
"VALUES $values";
$result = mysql_query($sql)
or die(mysql_error());
}
$redirect = 'charlist.php';
break;