php 接口实例
public function getProductType() {
$mustFiled = array( //必要参数
'company_id' => "公司ID"
);
foreach ($mustFiled as $k => $v) { //判断是否所有必要参数都已上传
if (empty($_REQUEST[$k]) || !isset($_REQUEST[$k])) {
$result["code"] = "0";
$result["msg"] = $v . "参数必须填写";
exit(json_encode($result, JSON_UNESCAPED_UNICODE));
}
}
$param = " AND is_commun = 'Y'";
if (isset($_REQUEST["is_commun"]) && !empty($_REQUEST["is_commun"])) {
$param = '';
}
//根据传递过来的company_id获取对应数据
$info = $this->db->query("SELECT `id`,`product_name`,`is_commun`,`is_common`,`remark` FROM product_type WHERE (is_common = '1' " . $param . ") OR company_id = '" . intval($_REQUEST["company_id"]) . "' and `is_delete` = '1'")->result();
$result["code"] = "1";
$result["msg"] = "获取成功";
$result["result"] = $info;
exit(json_encode($result, JSON_UNESCAPED_UNICODE));
}
/*******************own***********************/
<?php
$db_config = require("data/common.inc.php");
$con = @mysql_connect($cfg_dbhost,$cfg_dbuser,$cfg_dbpwd) or die('数据库连接失败:'.mysql_error());
mysql_query("set names 'gb2312'",$con);
mysql_select_db($cfg_dbname,$con) or die('选择数据库失败:'.mysql_error());
if(!$con) {
die('Could not connect: '. mysql_error());
}
$mustFiled = array( //必要参数
'keyword' => "关键词"
);
foreach ($mustFiled as $k => $v) { //判断是否所有必要参数都已上传
if (empty($_REQUEST[$k]) || !isset($_REQUEST[$k])) {
$result["code"] = "0";
$result["msg"] = $v . "参数必须填写";
exit(json_encode($result, JSON_UNESCAPED_UNICODE));
}
}
$info = "";
$sql = "select keyword from dede_search_keywords where keyword like '%".$_REQUEST['keyword']."%'";
$resault=mysql_query($sql,$con);
while($a = mysql_fetch_array($resault)){
if(!empty($a)){
$info .= $a[0].',';
}
}
$result["code"] = "1";
$result["msg"] = "获取成功";
$result["result"] = $info;
exit(json_encode($result, JSON_UNESCAPED_UNICODE));
?>