微信公众平台消息接口开发（28）周公解梦

一、周公解梦

要能解梦，首先得有数据来源，很多网站目前都提供这样的功能，选择一家网站将其抓取下来，做成自己的数据库即可。我们抓取的数据在5000条左右。

例如 http://zhougongjiemeng.1518.com/，http://www.zgjm.org/

 

二、查询记录

在程序中直接查询对应的关键字，获取解梦内容即可

function getDreamInfo($content)
{
    if ($content == ""){
        return "梦见什么？";
    }
    if(isset($_SERVER['HTTP_APPNAME'])){        //SAE
        $mysql_host = SAE_MYSQL_HOST_M;
        $mysql_host_s = SAE_MYSQL_HOST_S;
        $mysql_port = SAE_MYSQL_PORT;
        $mysql_user = SAE_MYSQL_USER;
        $mysql_password = SAE_MYSQL_PASS;
        $mysql_database = SAE_MYSQL_DB;
    }else{
        $mysql_host = "127.0.0.1";
        $mysql_host_s = "127.0.0.1";
        $mysql_port = "3306";
        $mysql_user = "root";
        $mysql_password = "root";
        $mysql_database = "weixin";
    }

    $mysql_table = "dream";
    $mysql_state = "SELECT * FROM `".$mysql_table."` WHERE `title` LIKE '%".$content."%'";
    $con = mysql_connect($mysql_host_s.':'.$mysql_port, $mysql_user, $mysql_password);
    if (!$con){
        die('Could not connect: ' . mysql_error());
    }
    
    mysql_query("SET NAMES 'UTF8'");
    mysql_select_db($mysql_database, $con);
    $result = mysql_query($mysql_state);
    $contentStr = "周公不能解此梦";
    while($row = mysql_fetch_array($result))
    {
        if (isset($row["content"]) && ($row["content"] != "")){
            $contentStr = $row["content"];
        }
        break;
    }
    mysql_close($con);
    return $contentStr;
}

根据文字进入查询

 

效果演示