-
Notifications
You must be signed in to change notification settings - Fork 0
/
mysql.php
49 lines (41 loc) · 987 Bytes
/
mysql.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
<?php
// include('./functions.php');
// $host = '127.0.0.1';
// $user = 'root';
// $pass = 'root';
// $dbname = 'yanchu';
// $link = new mysqli($host,$user,$pass,$dbname);
// $res = $link->query('select * from yanchu_dailydata');
// $res = $res->fetch_all();
// dump($res);
class Mysql{
public $host;
public $user;
public $pass;
public $dbname;
public $link;
public function __construct($host='127.0.0.1',$user='root',$pass='root',$dbname='nianshou'){
$this->host = $host;
$this->user = $user;
$this->pass = $pass;
$this->dbname = $dbname;
$this->link = new mysqli($this->host,$this->user,$this->pass,$this->dbname);
}
public function __destruct(){
$this->link->close();
}
public function query($sql){
$res = $this->link->query($sql);
return $res->fetch_all();
}
public function add($sql){
$res = $this->link->query($sql);
return $res;
}
public function chaxun($sql)
{
$res = $this->link->query($sql);
return $res->fetch_assoc();
}
}
?>