<?php
$mysqlhost="127.0.0.1";//数据库地址
$user="root";//数据库用户名
$password="root";//数据库密码
$db_name="ciku";//数据库表名字
$ciku = mysql_connect($mysqlhost,$user,$password);
if (!$ciku)
{
die('不能连接到词库数据库!');
}
mysql_select_db($db_name, $ciku);
$type=$_GET["type"];
if($type == "add"){
$que=$_GET["que"];
$ans=$_GET["ans"];
mysql_query("INSERT INTO ciku (question, answer, time)
VALUES ('".$que."', '".$ans."', '".date("Y/m/d")."')");
}else if($type == "answer"){
$que=$_GET["que"];
$cikuser = mysql_query("SELECT * FROM ciku
WHERE question='".$que."'");
while($answer = mysql_fetch_array($cikuser)){
echo $answer['answer'];
echo "/-/";
}
}else if($type == "del"){
$que=$_GET["que"];
mysql_query("DELETE FROM ciku WHERE question='".$que."'");
}else if($type == "create"){
$sql = "CREATE TABLE ciku
(
question varchar(999),
answer varchar(999),
time varchar(999)
)";
echo "初始化成功!";
mysql_query($sql,$ciku);
}
mysql_close($ciku);
?>
http://您的空间域名/ciku.php?type=create 来创建您的词库表 一定要访问!!!
---- http://您的空间域名/ciku.php?type=answer&que=XXX //查询答案
---- http://您的空间域名/ciku.php?type=add&que=XXX&answer=XXX //添加词库
---- http://您的空间域名/ciku.php?type=del&que=XXX //删除相关词库