forked from Meituan-Dianping/SQLAdvisor
-
Notifications
You must be signed in to change notification settings - Fork 8
Expand file tree
/
Copy pathdb.php
More file actions
25 lines (25 loc) · 789 Bytes
/
Copy pathdb.php
File metadata and controls
25 lines (25 loc) · 789 Bytes
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
<?php
$mysql_server_name='192.168.148.9';
$mysql_username='admin';
$mysql_password='123456';
$mysql_database='sql_db';
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password) or die("error connecting") ;
mysql_query("set names 'utf8'"); //数据库输出编码
mysql_select_db($mysql_database); //打开数据库
$result = mysql_query("select ops_db,count(*) as count from operation group by ops_db");
$data="";
$array= array();
class User{
public $ops_db;
public $count;
}
while($row = mysql_fetch_array($result,MYSQL_ASSOC)){
$user=new User();
$user->ops_db = $row['ops_db'];
$user->count = $row['count'];
$array[]=$user;
}
$data=json_encode($array);
// echo "{".'"user"'.":".$data."}";
echo $data;
?>