ผม select ข้อมูลจากตารางเดิม แล้ว แอดลงตารางใหม่ แต่มันมาไม่ครับ
มันหายไป 3 เรคคอร์ด ลองรันอยู่หลายรอบก็เหมือนเดิม โค้ดก็ไม่มีเออเลอร์ด้วครับ
<?php
$db_name = "test";
$link = mysql_connect("localhost", "root", "12345") or die("Error connect to database.");
mysql_query("SET character_set_results=euc-jp");
mysql_query("SET character_set_client=euc-jp");
mysql_query("SET character_set_connection=euc-jp");
mysql_query("use $db_name;");
$i = 0;
$result1 = mysql_query("select * from data_h ;");
while ($dbarr = mysql_fetch_array($result1)) {
$i = $i + 1;
//id create update status htype mapping boi area name address builder contact kakakutai price min_price max_price min_size max_size menseki madori takasa takasa2 kansei message setsubi comment memo table r1 r2 r3 r4 r5 f0 f1 f2 f3 f4 f5 f6 f7 f8 f9 m1 m2 m3 m4 m5 m6 m7 imgAto imgAno imgBto imgBno imgCto imgCno imgDto imgDno imgEto imgEno bts subway service nhk pet i0 i1 i2 i3 i4 i5 i6 i7 a0 a1 a2 a3 a4 a5 a6 a7 additional visible iconx icony iconpos namej kigyou
echo $id[$i]=$dbarr['id'];
$create[$i]=$dbarr['create'];
$update[$i]=$dbarr['update'];
$status[$i]=$dbarr['status'];
$htype[$i]=$dbarr['htype'];
$mapping[$i]=$dbarr['mapping'];
$boi[$i]=$dbarr['boi'];
$area[$i]=$dbarr['area'];
$name[$i]=$dbarr['name'];
$address[$i]=$dbarr['address'];
$builder[$i]=$dbarr['builder'];
$contact[$i]=$dbarr['contact'];
$kakakutai1[$i]=$dbarr['kakakutai'];
$price[$i]=$dbarr['price'];
$min_price[$i]=$dbarr['min_price'];
$max_price[$i]=$dbarr['max_price'];
$min_size[$i]=$dbarr['min_size'];
$max_size[$i]=$dbarr['max_size'];
$menseki[$i]=$dbarr['menseki'];
$madori[$i]=$dbarr['madori'];
$takasa[$i]=$dbarr['takasa'];
$takasa2[$i]=$dbarr['takasa2'];
$kansei[$i]=$dbarr['kansei'];
$message[$i]=$dbarr['message'];
$setsubi[$i]=$dbarr['setsubi'];
$comment[$i]=$dbarr['comment'];
$memo[$i]=$dbarr['memo'];
$table1[$i]=$dbarr['table'];
$r1[$i]=$dbarr['r1'];
$r2[$i]=$dbarr['r2'];
$r3[$i]=$dbarr['r3'];
$r4[$i]=$dbarr['r4'];
$r5[$i]=$dbarr['r5'];
$f0[$i]=$dbarr['f0'];
$f1[$i]=$dbarr['f1'];
$f2[$i]=$dbarr['f2'];
$f3[$i]=$dbarr['f3'];
$f4[$i]=$dbarr['f4'];
$f5[$i]=$dbarr['f5'];
$f6[$i]=$dbarr['f6'];
$f7[$i]=$dbarr['f7'];
$f8[$i]=$dbarr['f8'];
$f9[$i]=$dbarr['f9'];
$m1[$i]=$dbarr['m1'];
$m2[$i]=$dbarr['m2'];
$m3[$i]=$dbarr['m3'];
$m4[$i]=$dbarr['m4'];
$m5[$i]=$dbarr['m5'];
$m6[$i]=$dbarr['m6'];
$m7[$i]=$dbarr['m7'];
$imgAto[$i]=$dbarr['imgAto'];
$imgAno[$i]=$dbarr['imgAno'];
$imgBto[$i]=$dbarr['imgBto'];
$imgBno[$i]=$dbarr['imgBno'];
$imgCto[$i]=$dbarr['imgCto'];
$a2[$i]=$dbarr['a2'];
$a3[$i]=$dbarr['a3'];
$a4[$i]=$dbarr['a4'];
$a5[$i]=$dbarr['a5'];
$a6[$i]=$dbarr['a6'];
$a7[$i]=$dbarr['a7'];
$additional[$i]=$dbarr['additional'];
$visible[$i]=$dbarr['visible'];
$iconx[$i]=$dbarr['iconx'];
$icony[$i]=$dbarr['icony'];
$iconpos[$i]=$dbarr['iconpos'];
$namej[$i]=$dbarr['namej'];
$kigyou[$i]=$dbarr['kigyou'];
$imgCno[$i]=$dbarr['imgCno'];
$imgDto[$i]=$dbarr['imgDto'];
$imgDno[$i]=$dbarr['imgDno'];
$imgEto[$i]=$dbarr['imgEto'];
$imgEno[$i]=$dbarr['imgEno'];
$bts[$i]=$dbarr['bts'];
$subway[$i]=$dbarr['subway'];
$service[$i]=$dbarr['service'];
$nhk[$i]=$dbarr['nhk'];
$pet[$i]=$dbarr['pet'];
$i0[$i]=$dbarr['i0'];
$i1[$i]=$dbarr['i1'];
$i2[$i]=$dbarr['i2'];
$i3[$i]=$dbarr['i3'];
$i4[$i]=$dbarr['i4'];
$i5[$i]=$dbarr['i5'];
$i6[$i]=$dbarr['i6'];
$i7[$i]=$dbarr['i7'];
$a0[$i]=$dbarr['a0'];
$a1[$i]=$dbarr['a1'];
}
mysql_close($link);
// -----------------------------------------------------------
$db_name = "test";
$link = mysql_connect("localhost", "root", "12345") or die("Error connect to database.");
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
mysql_query("use $db_name;");
//id create update status htype mapping boi area name address builder contact kakakutai price min_price max_price min_size max_size menseki madori takasa takasa2 kansei message setsubi comment memo table r1 r2 r3 r4 r5 f0 f1 f2 f3 f4 f5 f6 f7 f8 f9 m1 m2 m3 m4 m5 m6 m7 imgAto imgAno imgBto imgBno imgCto imgCno imgDto imgDno imgEto imgEno bts subway service nhk pet i0 i1 i2 i3 i4 i5 i6 i7 a0 a1 a2 a3 a4 a5 a6 a7 additional visible iconx icony iconpos namej kigyou
for ($n=1;$n<=$i;$n++) {
mysql_query("INSERT INTO data_h_new VALUES('$id[$n]','$create[$n]','$update[$n]',$status[$n],'$htype[$n]','$mapping[$n]','$boi[$n]','$area[$n]','$name[$n]','$address[$n]','$builder[$n]','$contact[$n]','$kakakutai[$n]','$price[$n]','$min_price[$n]','$max_price[$n]','$min_size[$n]','$max_size[$n]','$menseki[$n]','$madori[$n]','$takasa[$n]','$takasa2[$n]','$kansei[$n]','$message[$n]','$setsubi[$n]','$comment[$n]','$memo[$n]','$table1[$n]',$r1[$n],$r2[$n],$r3[$n],$r4[$n],$r5[$n],$f0[$n],$f1[$n],$f2[$n],$f3[$n],$f4[$n],$f5[$n],$f6[$n],$f7[$n],$f8[$n],$f9[$n],$m1[$n],$m2[$n],$m3[$n],$m4[$n],$m5[$n],$m6[$n],$m7[$n],$imgAto[$n],$imgAno[$n],$imgBto[$n],$imgBno[$n],$imgCto[$n],$imgCno[$n],$imgDto[$n],$imgDno[$n],$imgEto[$n],$imgEno[$n],'$bts[$n]','$subway[$n]','$service[$n]','$nhk[$n]','$pet[$n]','$i0[$n]','$i1[$n]','$i2[$n]','$i3[$n]','$i4[$n]','$i5[$n]','$i6[$n]','$i7[$n]','$a0[$n]','$a1[$n]','$a2[$n]','$a3[$n]','$a4[$n]','$a5[$n]','$a6[$n]','$a7[$n]','$additional[$n]','$visible[$n]',$iconx[$n],$icony[$n],'$iconpos[$n]','$namej[$n]','$kigyou[$n]');")or die(mysql_error());
}
mysql_close($link);
echo "ok";
?>
รบกวนเพื่อน ชาวออนไลน์ หรือเคยเจอแบบนี้ให้แนวคิดแก้ปัญหาหน่อยครับ
ผม select ข้อมูลจากตารางเดิม แล้ว แอดลงตารางใหม่ แต่มันมาไม่ครับ
มันหายไป 3 เรคคอร์ด ลองรันอยู่หลายรอบก็เหมือนเดิม โค้ดก็ไม่มีเออเลอร์ด้วครับ
<?php
$db_name = "test";
$link = mysql_connect("localhost", "root", "12345") or die("Error connect to database.");
mysql_query("SET character_set_results=euc-jp");
mysql_query("SET character_set_client=euc-jp");
mysql_query("SET character_set_connection=euc-jp");
mysql_query("use $db_name;");
$i = 0;
$result1 = mysql_query("select * from data_h ;");
while ($dbarr = mysql_fetch_array($result1)) {
$i = $i + 1;
//id create update status htype mapping boi area name address builder contact kakakutai price min_price max_price min_size max_size menseki madori takasa takasa2 kansei message setsubi comment memo table r1 r2 r3 r4 r5 f0 f1 f2 f3 f4 f5 f6 f7 f8 f9 m1 m2 m3 m4 m5 m6 m7 imgAto imgAno imgBto imgBno imgCto imgCno imgDto imgDno imgEto imgEno bts subway service nhk pet i0 i1 i2 i3 i4 i5 i6 i7 a0 a1 a2 a3 a4 a5 a6 a7 additional visible iconx icony iconpos namej kigyou
echo $id[$i]=$dbarr['id'];
$create[$i]=$dbarr['create'];
$update[$i]=$dbarr['update'];
$status[$i]=$dbarr['status'];
$htype[$i]=$dbarr['htype'];
$mapping[$i]=$dbarr['mapping'];
$boi[$i]=$dbarr['boi'];
$area[$i]=$dbarr['area'];
$name[$i]=$dbarr['name'];
$address[$i]=$dbarr['address'];
$builder[$i]=$dbarr['builder'];
$contact[$i]=$dbarr['contact'];
$kakakutai1[$i]=$dbarr['kakakutai'];
$price[$i]=$dbarr['price'];
$min_price[$i]=$dbarr['min_price'];
$max_price[$i]=$dbarr['max_price'];
$min_size[$i]=$dbarr['min_size'];
$max_size[$i]=$dbarr['max_size'];
$menseki[$i]=$dbarr['menseki'];
$madori[$i]=$dbarr['madori'];
$takasa[$i]=$dbarr['takasa'];
$takasa2[$i]=$dbarr['takasa2'];
$kansei[$i]=$dbarr['kansei'];
$message[$i]=$dbarr['message'];
$setsubi[$i]=$dbarr['setsubi'];
$comment[$i]=$dbarr['comment'];
$memo[$i]=$dbarr['memo'];
$table1[$i]=$dbarr['table'];
$r1[$i]=$dbarr['r1'];
$r2[$i]=$dbarr['r2'];
$r3[$i]=$dbarr['r3'];
$r4[$i]=$dbarr['r4'];
$r5[$i]=$dbarr['r5'];
$f0[$i]=$dbarr['f0'];
$f1[$i]=$dbarr['f1'];
$f2[$i]=$dbarr['f2'];
$f3[$i]=$dbarr['f3'];
$f4[$i]=$dbarr['f4'];
$f5[$i]=$dbarr['f5'];
$f6[$i]=$dbarr['f6'];
$f7[$i]=$dbarr['f7'];
$f8[$i]=$dbarr['f8'];
$f9[$i]=$dbarr['f9'];
$m1[$i]=$dbarr['m1'];
$m2[$i]=$dbarr['m2'];
$m3[$i]=$dbarr['m3'];
$m4[$i]=$dbarr['m4'];
$m5[$i]=$dbarr['m5'];
$m6[$i]=$dbarr['m6'];
$m7[$i]=$dbarr['m7'];
$imgAto[$i]=$dbarr['imgAto'];
$imgAno[$i]=$dbarr['imgAno'];
$imgBto[$i]=$dbarr['imgBto'];
$imgBno[$i]=$dbarr['imgBno'];
$imgCto[$i]=$dbarr['imgCto'];
$a2[$i]=$dbarr['a2'];
$a3[$i]=$dbarr['a3'];
$a4[$i]=$dbarr['a4'];
$a5[$i]=$dbarr['a5'];
$a6[$i]=$dbarr['a6'];
$a7[$i]=$dbarr['a7'];
$additional[$i]=$dbarr['additional'];
$visible[$i]=$dbarr['visible'];
$iconx[$i]=$dbarr['iconx'];
$icony[$i]=$dbarr['icony'];
$iconpos[$i]=$dbarr['iconpos'];
$namej[$i]=$dbarr['namej'];
$kigyou[$i]=$dbarr['kigyou'];
$imgCno[$i]=$dbarr['imgCno'];
$imgDto[$i]=$dbarr['imgDto'];
$imgDno[$i]=$dbarr['imgDno'];
$imgEto[$i]=$dbarr['imgEto'];
$imgEno[$i]=$dbarr['imgEno'];
$bts[$i]=$dbarr['bts'];
$subway[$i]=$dbarr['subway'];
$service[$i]=$dbarr['service'];
$nhk[$i]=$dbarr['nhk'];
$pet[$i]=$dbarr['pet'];
$i0[$i]=$dbarr['i0'];
$i1[$i]=$dbarr['i1'];
$i2[$i]=$dbarr['i2'];
$i3[$i]=$dbarr['i3'];
$i4[$i]=$dbarr['i4'];
$i5[$i]=$dbarr['i5'];
$i6[$i]=$dbarr['i6'];
$i7[$i]=$dbarr['i7'];
$a0[$i]=$dbarr['a0'];
$a1[$i]=$dbarr['a1'];
}
mysql_close($link);
// -----------------------------------------------------------
$db_name = "test";
$link = mysql_connect("localhost", "root", "12345") or die("Error connect to database.");
mysql_query("SET character_set_results=utf8");
mysql_query("SET character_set_client=utf8");
mysql_query("SET character_set_connection=utf8");
mysql_query("use $db_name;");
//id create update status htype mapping boi area name address builder contact kakakutai price min_price max_price min_size max_size menseki madori takasa takasa2 kansei message setsubi comment memo table r1 r2 r3 r4 r5 f0 f1 f2 f3 f4 f5 f6 f7 f8 f9 m1 m2 m3 m4 m5 m6 m7 imgAto imgAno imgBto imgBno imgCto imgCno imgDto imgDno imgEto imgEno bts subway service nhk pet i0 i1 i2 i3 i4 i5 i6 i7 a0 a1 a2 a3 a4 a5 a6 a7 additional visible iconx icony iconpos namej kigyou
for ($n=1;$n<=$i;$n++) {
mysql_query("INSERT INTO data_h_new VALUES('$id[$n]','$create[$n]','$update[$n]',$status[$n],'$htype[$n]','$mapping[$n]','$boi[$n]','$area[$n]','$name[$n]','$address[$n]','$builder[$n]','$contact[$n]','$kakakutai[$n]','$price[$n]','$min_price[$n]','$max_price[$n]','$min_size[$n]','$max_size[$n]','$menseki[$n]','$madori[$n]','$takasa[$n]','$takasa2[$n]','$kansei[$n]','$message[$n]','$setsubi[$n]','$comment[$n]','$memo[$n]','$table1[$n]',$r1[$n],$r2[$n],$r3[$n],$r4[$n],$r5[$n],$f0[$n],$f1[$n],$f2[$n],$f3[$n],$f4[$n],$f5[$n],$f6[$n],$f7[$n],$f8[$n],$f9[$n],$m1[$n],$m2[$n],$m3[$n],$m4[$n],$m5[$n],$m6[$n],$m7[$n],$imgAto[$n],$imgAno[$n],$imgBto[$n],$imgBno[$n],$imgCto[$n],$imgCno[$n],$imgDto[$n],$imgDno[$n],$imgEto[$n],$imgEno[$n],'$bts[$n]','$subway[$n]','$service[$n]','$nhk[$n]','$pet[$n]','$i0[$n]','$i1[$n]','$i2[$n]','$i3[$n]','$i4[$n]','$i5[$n]','$i6[$n]','$i7[$n]','$a0[$n]','$a1[$n]','$a2[$n]','$a3[$n]','$a4[$n]','$a5[$n]','$a6[$n]','$a7[$n]','$additional[$n]','$visible[$n]',$iconx[$n],$icony[$n],'$iconpos[$n]','$namej[$n]','$kigyou[$n]');")or die(mysql_error());
}
mysql_close($link);
echo "ok";
?>
รบกวนเพื่อน ชาวออนไลน์ หรือเคยเจอแบบนี้ให้แนวคิดแก้ปัญหาหน่อยครับ