'php---mysql simple application---online dictionary'

'php---mysql simple application---online dictionary'_PHP tutorial

WBOY

Release： 2016-07-14 10:06:45

Original

914 people have browsed it

[html]

Insert title here

Insert title here

[php] view plaincopyprint?

class DicTool{

    private $conn;
    private $host = "localhost";
    private $user = "root";
    private $password = "123";
    private $db = "test";

    //构造函数，初始化数据，连接数据库
    function __construct(){

        $this->conn = mysql_connect($this->host, $this->user, $this->password);
        if (!$this->conn){
            die("连接数据库失败".mysql_error());
        }
        //选择数据库
        mysql_select_db($this->db,$this->conn);
        mysql_query("set names utf8");
    }

    function findchword($enword){

        $sql = "select * from words where enword ='".$enword."'limit 0,10";

        $res = mysql_query($sql,$this->conn) or die(mysql_error());

        if (!$res){
            return 0;//失败
        }else{

            $row = mysql_fetch_assoc($res);
            return $row['chword'];
        }
    }

}

class DicTool{

private $conn;
private $host = "localhost";
private $user = "root";
private $password = "123";
private $db = "test";

//Constructor, initialize data, connect to database
function __construct(){

$this->conn = mysql_connect($this->host, $this->user, $this->password);
if (!$this->conn){
Die("Failed to connect to database".mysql_error());
}
//Select database
mysql_select_db($this->db,$this->conn);
mysql_query("set names utf8");
}

}
[php]
header("Content-Type: text/html; charset=UTF-8");
Include_once 'DicTool.class.php';

$dicTool = new DicTool();

If (isset($_POST['enword'])){
                                                                   $chword = $dicTool->findchword($_POST['enword']);
If ($chword){
echo $_POST['enword']."The corresponding Chinese meaning is: ".$chword."
";
         }else{
echo "No results found!
";
         }
}else{
echo "No input obtained!
";
}
echo "Click to return
";