/
sqld.php
120 lines (58 loc) · 1.82 KB
/
sqld.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
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
<?php
function sqli(){
$db_host="localhost"; //连接的服务器地址
$db_user="text"; //连接数据库的用户名
$db_psw="123123"; //连接数据库的密码
$db_name="test"; //连接的数据库名称
$mysqli=new mysqli();
$mysqli->connect($db_host,$db_user,$db_psw,$db_name);
$mysqli -> query("SET NAMES utf8");
return $mysqli;
}
function selnum(){ //查文本总数
$mysqli=sqli();
$query="select count(*) from show_content";
$sqlld = $mysqli->query($query);
if($sqlld->num_rows>0){
$num = $sqlld->fetch_row();
}else{
echo "无法查出总条数!";
}
return $num[0];
$sqlld -> free();
$mysqli -> close();
}
function selcont(){ //显示文本
$mysqli = sqli();
$query = "select title,content from show_content order by id desc";
$sqlld = $mysqli->query($query);
if($sqlld->num_rows>0){
while ($row = $sqlld->fetch_array()) {
$cont_arr[] = $row;
//print_r($cont_arr);
//echo "<br/>";
}
}else{
echo "没有文本数据!";
}
return $cont_arr;
$sqlld -> free();
$mysqli -> close();
}
//selcont();
function seltime(){ //查文本日期
$mysqli=sqli();
$query="select rel_time from show_content order by id desc";
$sqlld = $mysqli->query($query);
if($sqlld->num_rows>0){
while ($row = $sqlld->fetch_array()) {
$cont_time[] = $row;
}
}else{
echo "无法查出日期!";
}
return $cont_time;
$sqlld -> free();
$mysqli -> close();
}
?>