| Server IP : 122.155.177.87 / Your IP : 122.155.177.87 Web Server : Apache/2 System : Linux cat177-87.static.lnwhostname.com 3.10.0-1160.62.1.el7.x86_64 #1 SMP Tue Apr 5 16:57:59 UTC 2022 x86_64 User : phunphin ( 1164) PHP Version : 5.3.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname,putenv,eval MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/phunphin/domains/phunphin.go.th/public_html/ |
Upload File : |
<?php
require_once("lastRSS.php");
// lastRSS object
$rss = new lastRSS;
// Encoding
$rss->cp = 'windows-874';
if (!isset($_deptsubId)) {
$_deptsubId = '';
}
/*
$rssurl = 'http://process3.gprocurement.go.th/EPROCRssFeedWeb/egpannouncerss.xml';
// RSS
$news = $rss->get($rssurl);
// insert Rss Data
foreach($news['items'] as $value ):
$egp_link = htmlspecialchars($value['link']);
$egp_title = htmlspecialchars($value['title']);
$pubDate = $value['pubDate'];
$num1 = strpos($egp_link,'projectId');
$egp_projectId = 0;//projectId
if ($num1 > 0) {
$egp_projectId = substr($egp_link,$num1+10,11); //֧ projectId ҡ link egp
}
if($egp_projectId > 0){
$sql_rss = "SELECT `egp_projectId` FROM `tbl_egp_rss` WHERE (`egp_projectId` = '$egp_projectId') ";
$result_rss = mysql_query($sql_rss);
$num_rows_rss = mysql_num_rows($result_rss);
if($num_rows_rss > 0){
//$sql = "update `tbl_egp_rss` set `egp_title`='$egp_title',`egp_link`='$egp_link',`egp_date`='$pubDate',`egp_update`=now() where (`egp_projectId` = '".$egp_projectId."')";
//$dbquery = mysql_query($sql) or die("öѹ֡ !A");
} else {
$sql = "insert into `tbl_egp_rss` (`id`,`egp_projectId`,`egp_title`,`egp_link`,`egp_date`,`egp_update`) values ('','$egp_projectId','$egp_title','$egp_link','$pubDate',now())";
$dbquery = mysql_query($sql) or die("öѹ֡ !B");
}
}
endforeach;
unset($news);
*/
$anounceType = array("P0","","B0","D0","W0","D","W","D","W"); //С
foreach($anounceType as $atype ):
$rssurl = 'http://process3.gprocurement.go.th/EPROCRssFeedWeb/egpannouncerss.xml?deptsubId='.$_deptsubId."&anounceType=".$atype;
// RSS
$news = $rss->get($rssurl);
// insert Rss Data
foreach($news['items'] as $value ):
$egp_link = $value['link'];
$egp_title = $value['title'];
$pubDate = $value['pubDate'];
$num1 = strpos($egp_link,'projectId');
$egp_projectId = 0;//projectId
if ($num1 > 0) {
$egp_projectId = substr($egp_link,$num1+10,11); //֧ projectId ҡ link egp
}
if($egp_projectId > 0){
$sql_rss = "SELECT `egp_projectId` FROM `tbl_egp_rss` WHERE (`egp_projectId` = '$egp_projectId') ";
$result_rss = mysql_query($sql_rss);
$num_rows_rss = mysql_num_rows($result_rss);
if($num_rows_rss > 0){
//$sql = "update `tbl_egp_rss` set `egp_title`='$egp_title',`egp_link`='$egp_link',`egp_date`='$pubDate',`egp_update`=now(),`egp_anouncetype`='$atype' where (`egp_projectId` = '".$egp_projectId."')";
//$dbquery = mysql_query($sql) or die("öѹ֡ !A ".$atype);
} else {
$sql = "insert into `tbl_egp_rss` (`id`,`egp_projectId`,`egp_title`,`egp_link`,`egp_date`,`egp_update`,`egp_anouncetype`) values ('','$egp_projectId','$egp_title','$egp_link','$pubDate',now(),'$atype')";
$dbquery = mysql_query($sql) or die("öѹ֡ !B ".$atype);
}
}
endforeach;
unset($news);
endforeach;
unset($anounceType);
?>