 |
|
รบกวนช่วยดูโค้ดนี้ให้หน่อยครับ
คือจะเอาข้อมูลจาก MySQL ไปใส่ยัง PostgreSQL
------------------------------------------------------------------
<?php
include("../jhcis_to_pgsql/include/config_jhcis.php");
$sqlSelect = " SELECT person.pcucodeperson AS pcucode,person.prename, person.fname, person.lname, person.birth,Year(Now())-Year(PERSON.birth) AS age, person.sex, person.hnomoi AS house, person.mumoi, person.idcard AS cid, personchronic.chroniccode AS chronic,
CONCAT(person.provcodemoi,person.distcodemoi,person.subdistcodemoi,person.mumoi) AS vhid
FROM person INNER JOIN personchronic ON person.pid = personchronic.pid
WHERE (((personchronic.chroniccode) Between 'e10' And 'e14.9')) AND
CONCAT(person.pid,person.pcucodeperson) not in (SELECT CONCAT(persondeath.pid,persondeath.pcucodeperson) FROM persondeath) and person.mumoi not like '00' AND person.hnomoi Not Like '0' ";
$querySelect = mysql_query($sqlSelect);
while($resultSelect = mysql_fetch_array($querySelect)){
include("../jhcis_to_pgsql/include/dbconn_pgsql.php");
$sqlIns = "insert ignore into dm_j values('$resultSelect[pcucode]','$resultSelect[prename]','$resultSelect[fname]','$resultSelect[lname]','$resultSelect[birth]','$resultSelect[age]','$resultSelect[sex]','$resultSelect[house]','$resultSelect[mumoi]','$resultSelect[cid]','$resultSelect[chronic]','$resultSelect[vhid]')";
$queryIns = $db->Execute($sql) or die($db->ErrorMsg());
}
if($queryIns)
echo "<font size = 3><center>นำเข้าข้อมูล เรียบร้อยแล้ว</center></font>";
?>
------------------------------------------------------------------------
ทำแล้วข้อมูลไม่เข้าเลย ช่วยด้วยครับ
Tag : PHP, MySQL, PostgreSQL
|
|
|
 |
 |
 |
 |
| Date :
2010-08-18 11:59:50 |
By :
pphat21 |
View :
785 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
