อ่านไฟล์ xmlได้แล้วค่ะ แต่ข้อมูลยังไม่เข้าไปใน sql server ค่ะ รบกวนด้วยค่ะ
อ่านไฟล์ xmlได้แล้วค่ะ แต่ข้อมูลยังไม่เข้าไปใน sql server ค่ะ มี error คือ Code (PHP) <?php
session_start();
$error=0;
include "connect.php";
$num_insert=0;
if(isset($_POST["SubmitForm"]))
{//start
$filename=strtolower($_FILES['file']['name']);
$find=strpos($filename,'xml');
$order=0;
if($find===false)
{
echo "<b><font color='#ff0000'>กรุณา upload file .xml เท่านั้น </font></b>";
}else
{//
if ( $_FILES['file']['error'] )
{
die("upload error ");
}
$dom = DOMDocument::load( $_FILES['file']['tmp_name'] );
$rows = $dom->getElementsByTagName('Row');
$row = 0;
print_r($dom);
//echo 'numfound='.$numfound.'</br/>';
foreach ($rows as $temp)
{
$col = 0;
if($row==0)
{
$row++; continue;
}
$cells = $temp->getElementsByTagName('Cell');
foreach( $cells as $cell )
{
if($col==0) $entity = $cell->nodeValue;
if($col==1) $install_date = $cell->nodeValue;
if($col==2) $contactno = $cell->nodeValue;
if($col==3) $customername = $cell->nodeValue;
if($col==4) $address = $cell->nodeValue;
if($col==5) $province = $cell->nodeValue;
if($col==6) $model = $cell->nodeValue;
if($col==7) $serial = $cell->nodeValue;
if($col==8) $saleentity = $cell->nodeValue;
if($col==9) $from_sale_code = $cell->nodeValue;
if($col==10) $from_sale_name = $cell->nodeValue;
if($col==11) $remark = $cell->nodeValue;
$col++;
}
if($entity!='')
{//if start entity
$sql_find="select * from rental_info_temp where serial='".$serial."' ";
$result_find=sqlsrv_query($con,$sql_find);
$num_found=sqlsrv_has_rows($result_find);
if($num_found==0||$num_found=="")
{
$order++;
$importcode=date('YmdHsA').$order;
if($remark=="")
{
$remark="-";
}
$sql="insert into rental_info_temp values('".$entity."',N'".$customername."',N'".$address."',N'".$province."','".$model."','".$serial."','".$install_date."','".$saleentity."',N'".$from_sale_code."',N'".$from_sale_name."','".$contactno."',N'".$remark."','".$importcode."')";
$result_query=sqlsrv_query($con,$sql);
//echo "yes sn=".$serial."=".$sql."</br>";
if(!$result_query)
{
$error+=1;
}else{
$num_insert+=1;
}
}else {//end if num_found
$sql_update="update rental_info_temp set entity='".$entity."',customername=N'".$customername."',address=N'".$address."',province=N'".$province."',model='".$model."',install_date='".$install_date."',saleentity='".$saleentity."',from_sale_code=N'".$from_sale_code."',from_sale_name=N'".$from_sale_name."',contactno='".$contactno."' where serial='".$serial."'";
$result_query=sqlsrv_query($con,$sql_update);
}//end else num found
}//end if entity
$row++;
} //end foreach
$_SESSION["insert"]=$num_insert;
move_uploaded_file($_FILES['file']['tmp_name'], "uploads/".$_FILES["file"]['name']);
header('Location:http://uccinfo:85/rental/import.php');
}//end if xml file
}//end if SubmitForm
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link type="text/css" href="css/default.css" rel="stylesheet"/>
<title>Import Excel File</title>
<script language="javascript" type="text/javascript">
function openDocDetail(url,width,height)
{
var windowWidth=width;
var windowHeight=height;
var centerWidth = (window.screen.width - windowWidth) / 2;
var centerHeight = (window.screen.height - windowHeight) / 2;
OpenWindow=window.open(url, "","menubar=no,toolbar=no,location=no,scrollbars=yes,status=no,resizable=no,width="+windowWidth+",height="+windowHeight+",top="+centerHeight+",left="+centerWidth);
}
</script>
</head>
<body>
<p><h2>Import ข้อมูลติดตั้งเครื่องเช่า</h2></p>
<form enctype="multipart/form-data" action="import_form.php" method="post">
<table width="95%" border="0" align="center" style="border-collapse:" >
<tr>
<td width="23%">เลือกไฟล์ (นามสกุล .xml) เท่านั้น</td>
<td><input type="file" name="file" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><label>
<input type="submit" name="SubmitForm" value="Submit" />
<input type="submit" name="Cancel" value="Cancel" />
</label></td>
</tr>
</table>
</form>
<ul id="menu">
<li><a href="#" onclick="javascript:openDocDetail('save_xml.php','1000','500');" class="txtlink">วิธี save file .xml</a></li>
<li><a href="upload_format.xls" class="txtlink">รูปแบบไฟล์สำหรับ import</a>
<li><a href="#" onclick="javascript:openDocDetail('all_upload.php','1100','500');" class="txtlink">ข้อมูลที่ import แล้ว</a></li>
<li><a href="manual/Manual_import.pdf" class="txtlink" target="_blank">คู่มือการ import</a></li>
<li><a href="http://uccinfo/request_install/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={EFC33510-6AA7-4842-99A2-C682CB3E983B}&View={8D7AB465-BE40-4E14-962C-BED9B5CAD2D3}&CacheControl=1&RootFolder=" onclick="GoToLinks(this) ;return false;" target="_self">Export</a></li>
</ul>
</body>
</html>
Tag PHP
Date :
2016-06-23 11:58:45By :
PhatsananView :
971Reply :
5
failed to open stream: Permission denied ตรงตัวครับ เน้นๆ ครับ (แปลนิดนึง)
Date :
2016-06-23 14:46:07By :
apisitp
ผมตอบไปในความเห็น 1 กระทู้ก่อนแล้วนะครับ
Date :
2016-06-24 13:05:42By :
Chaidhanan
Server 03
Load balance : Server 03
