PHP：POST接口，插入POST数据到mysql数据库

一、接口代码

1.1 创建数据库的SQL语句

DROP TABLE IF EXISTS `test`.`domain_statistics_result`;
CREATE TABLE  `test`.`domain_statistics_result` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain` varchar(256) DEFAULT NULL,
  `statistics_ts` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `statistics_count` int(11) NOT NULL DEFAULT '0',
  `update_ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
, PRIMARY KEY (`id`));

1.2 代码

<?php
        if (!empty($_GET))
        {
                extract($_GET);
        }

        if (!empty($_POST))
        {
                extract($_POST);
        }

        $conn = mysql_connect('localhost', 'root', 'love') or die("cann't connect to mysql." . mysql_error());
        mysql_select_db('test', $conn) or die("cann't connect to db test" . mysql_error());

        $content = file_get_contents("php://input");
        //print "php post response: " . $content . "\n";
        //{"ts":"2016-01-12-16:50:21", "data":{"www.baidu.com":100, "www.360.cn":200, "www.alipay.com":300}}
        $list = explode("\n", $content);
        foreach($list as $line)
        {
                if (empty($line))
                {
                        continue;
                }

                $line_json = json_decode($line, true);

                $statistics_ts = $line_json['ts'];
                $data_arr = $line_json['data'];
                foreach($data_arr as $domain=>$statistics_count)
                {
                        $sql = "insert into domain_statistics_result(domain, statistics_ts, statistics_count) values(\"$domain\", \"$statistics_ts\", $statistics_count)";
                        if (FALSE == mysql_query($sql))
                        {
                                print "error:" . mysql_error() . "\n";
                        }
                }

                //以下是别的地方的代码，与本代码毫无关系，不过可以参照其中的SQL方法的调用
                //$sql = "select * from probe_result where agent_ip = $sip and pcache_ip = $dip";
                //$res = mysql_query($sql);
                //if (mysql_num_rows($res) == 0)
                //{
                //      mysql_free_result($res);

                //      $sql = "insert into probe_result(agent_ip, pcache_ip, probe_result, probe_info) values($sip, $dip, $state, $info)";
                //      mysql_query($sql);
                //      continue;
                //}

                //while ($row = mysql_fetch_array($res))
                //{
                //      if ($row["probe_result"] != $state)
                //      {
                //              $sql = "update probe_result set probe_result = $state, probe_info = $info  where agent_ip = $sip and pcache_ip = $dip";
                //              mysql_query($sql);
                //      }
                //}
                //mysql_free_result($res);

        }

        mysql_close($conn);
?>

二、测试POST接口

1.2 curl测试post

        curl 的 -d 是提交post的数据。

curl 192.168.175.131/upload.php -d "{\"ts\":\"2016-01-12-16:50:21\", \"data\":{\"www.baidu.com\":100, \"www.360.cn\":200, \"www.alipay.com\":300}}"