假设有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);
?>
新闻热点
疑难解答