假设有10个网站,分布在各地,它们的库存要同步,而数据库不支持远程连接。
我们要实时地取得服务器的库存数,可以通过很多种方法,我所知道的有以下几种:
·curl方式
·socket方式
·php5中的soap方式
以下分别给出示例来实现它:
curl方式
client.php
<?php
$psecode = ’nde005’;
$website = ’www.abc.com’;
$amt = 1;
$pwd = 123456;
$ch = curl_init();
$curl_url = "http://ics1.server.com/index.php?web=" . $website .
"&pwd=" . $pwd . "&action=check&pseid=" . $psecode .
"&amt=" . $amt;
curl_setopt($ch, curlopt_url, $curl_url);
curl_setopt($ch, curlopt_post, 1);
curl_setopt($ch, curlopt_returntransfer, 1);//不直接输出,返回到变量
$curl_result = curl_exec($ch);
$result = explode(’,’, $curl_result);
curl_close($ch);
print_r($result);
?>
服务器端只需按一定的格式输出,然后客户端按此格式接收就可以了如:
echo "ok," . $fpsecode . "," . $fbalance ;//以逗号分隔
socket方式
这个要借助第三方类库httpclient,可以到这里下载:http://scripts.incutio.com/httpclient/
<?php
require_once ’class/httpclient.php’;
$params = array(’web’ => ’www.abc.com’,
’pwd’ => ’123456’,
’action’ => ’check’,
’pseid’ => ’nde005’,
’amt’ => 1);
$pagecontents = httpclient::quickpost(’http://ics.server.com/index.php’, $params);
$result = explode(’,’, $pagecontents);
print_r($result);
?>
php5中的soap方式
server.php
<?php
function getquote($fpsecode) {
global $dbh;
$result = array();
try {
$query = "select fprice, fcansale, fbalance, fbaltip from tblbalance where upper(trim(fpsecode)) = :psecode limit 1";
$stmt = $dbh->prepare($query);
$stmt->execute(array(’:psecode’ => strtoupper(trim($fpsecode))));
$stmt->bindcolumn(’fprice’, $fprice);
$stmt->bindcolumn(’fcansale’, $fcansale);
$stmt->bindcolumn(’fbalance’, $fbalance);
$stmt->bindcolumn(’fbaltip’, $fbaltip);
while($row = $stmt->fetch(pdo_fetch_bound)) {
//
}
} catch (pdoexception $e) {
echo $e->getmessage();
}
return $fprice; //你可以返回一个数组
}
$dsn = ’pgsql:host=192.168.*.* port=5432 dbname=db user=123456 password=123456’;
try {
$dbh = new pdo($dsn);
} catch (pdoexception $e) {
die(’connection failed: ’ . $e->getmessage());
}
ini_set("soap.wsdl_cache_enabled", "0"); // disabling wsdl cache
$server = new soapserver("stockquote.wsdl"); //配置文件
$server->addfunction("getquote");
$server->handle();
?>
stockquote.wsdl
<?xml version =’1.0’ encoding =’utf-8’ ?>
<definitions name=’stockquote’
targetnamespace=’http://example.org/stockquote’
xmlns:tns=’ http://example.org/stockquote ’
xmlns:soap=’http://schemas.xmlsoap.org/wsdl/soap/’
xmlns:xsd=’http://www.w3.org/2001/xmlschema’
xmlns:soapenc=’http://schemas.xmlsoap.org/soap/encoding/’
xmlns:wsdl=’http://schemas.xmlsoap.org/wsdl/’
xmlns=’http://schemas.xmlsoap.org/wsdl/’>
<message name=’getquoterequest’>
<part name=’symbol’ type=’xsd:string’/>
</message>
<message name=’getquoteresponse’>
<part name=’result’ type=’xsd:float’/>
</message>
<porttype name=’stockquoteporttype’>
<operation name=’getquote’>
<input message=’tns:getquoterequest’/>
<output message=’tns:getquoteresponse’/>
</operation>
</porttype>
<binding name=’stockquotebinding’ type=’tns:stockquoteporttype’>
<soap:binding style=’rpc’
transport=’http://schemas.xmlsoap.org/soap/http’/>
<operation name=’getquote’>
<soap:operation soapaction=’urn:xmethods-delayed-quotes#getquote’/>
<input>
<soap:body use=’encoded’ namespace=’urn:xmethods-delayed-quotes’
encodingstyle=’http://schemas.xmlsoap.org/soap/encoding/’/>
</input>
<output>
<soap:body use=’encoded’ namespace=’urn:xmethods-delayed-quotes’
encodingstyle=’http://schemas.xmlsoap.org/soap/encoding/’/>
</output>
</operation>
</binding>
<service name=’stockquoteservice’>
<port name=’stockquoteport’ binding=’stockquotebinding’>
<soap:address location=’http://192.168.3.9/php5/server.php’/>
</port>
</service>
</definitions>
client.php
<?php
$client = new soapclient("stockquote.wsdl");
$result = $client->getquote("nde005");
print_r($result);
?>
Java Asp PHP .Net XML C/C++ CGI VB Jsp J2ee J2se J2me EJB Servlet Tomcat Resin Struts Weblogic Eclipse ANT GUI JMS Web servise IDEA Webphere Hibernate Spring Jboss Applet Swing Socket Javamail Perl Ajax P2P 安全 模式 框架 测试 开源 游戏
Windows XP Windows 2000 Windows 2003 Windows Me Windows 9.x Linux UNIX 注册表 操作系统 服务器 应用服务器