-
Notifications
You must be signed in to change notification settings - Fork 0
/
connectSql.php
67 lines (60 loc) · 1.8 KB
/
connectSql.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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<?php
header('Content-type:application/json;charset:utf8');
$username = $_REQUEST['username'];
//echo $username;
$message = $_REQUEST['message'];
//echo $content;
class connMysql{
public $servername;
public $usernames;
public $password;
public $dbname;
public $conn;
public function __construct($servername,$usernames,$password,$dbname){
$this->servername = $servername;
$this->username = $usernames;
$this->password = $password;
$this->dbname = $dbname;
}
public function getConnection(){
try{
$dsn = "mysql:host=$this->servername;dbname=$this->dbname";
$this->conn = new PDO($dsn,$this->username,$this->password);
$this->conn->query('set names utf8');
}catch(PDOException $e){
echo $e->getMessage();
}
}
public function insertData($sql){
if($this->conn == null){
$this->getConnection();
}
$result = $this->conn->exec($sql);
echo $result;
$this->closeCon();
}
public function closeCon(){
$this->conn = null;
}
}
class realConnection extends connMysql{
public function __construct($servername,$usernames,$password,$dbname){
parent::__construct($servername,$usernames,$password,$dbname);
}
public function insertRealData($username,$message){
//$timeing = date("Y-m-d H:i:s");
$sql = "INSERT INTO chartingData(username, message) VALUES ($username,$message)";
//echo $sql;
$this->insertData($sql);
}
// public function insertRealData(){
// //$timeing = date("Y-m-d H:i:s");
// $sql = "INSERT INTO chartDatas(username, content) VALUES (1,2)";
// //$sql ='UPDATE `pariseTable` SET `num`=num+1 WHERE id=1';
// $this->insertData($sql);
// }
}
$connection = new realConnection('localhost','root','','chartDB');
$connection->insertRealData($username,$message);
// $connection->insertRealData();
?>