如何使用php创建查询

TFC 发表于 Dev

TFC

我尝试通过使用php下拉列表获取查询后的列表。我的代码现在看起来像这样：

     $con = mysql_connect($server,$user_name,$password,$database);
     $db_found = mysql_select_db($database, $con);
     if ($db_found) {
     print "Database Found ";
     }
     else {
     print "Database NOT Found ";
     }

     $result = mysql_query($con,$db_found,"SELECT
     connection_log.user,count(*)  
     as 'connection_count', sum(TIMESTAMPDIFF(MINUTE,
     connection_log.logondate,connection_log.logoffdate)) 
     as `connection_time`
     FROM connection_log 
     INNER JOIN users 
     ON connection_log.user=users.user WHERE users.groups 
     LIKE '%cpg_sirket_dyo%' 
     and connection_log.logondate>='2015-09-01 00:00:00' 
     and connection_log.logoffdate<'2015-10-01 00:00:00' 
     group by connection_log.user 
     order by connection_count desc");
     while ($row = mysql_fetch_array($result)) {  
     echo $row['name']."<br />";  
     }

但是，当我运行此php时，出现如下所示的错误：

找到的数据库PHP警告：mysql_query（）期望最多2个参数，第22行的/var/www/html/test.php中给出3个PHP警告：mysql_fetch_array（）期望参数1是资源，在/ var中给出null /www/html/test.php，第23行

你有什么主意吗

衣服

mysql_query

mysql_query（字符串$ query [，resource $ link_identifier = NULL]）

只需要两个参数

1）您的查询。

2）MySQL连接

您只需在mysql_query中删除数据库名称，还可以交换查询和连接的位置

 $result = mysql_query("SELECT....",$con);

在列和表名中使用反引号代替引号

更正您的问题

     SELECT
     connection_log.user,count(*)  
     as `connection_count`, sum(TIMESTAMPDIFF(MINUTE,
     connection_log.logondate,connection_log.logoffdate)) 
     as `connection_time`
     FROM connection_log 
     INNER JOIN users 
     ON connection_log.user=users.user WHERE users.groups 
     LIKE '%cpg_sirket_dyo%' 
     and connection_log.logondate>='2015-09-01 00:00:00' 
     and connection_log.logoffdate<'2015-10-01 00:00:00' 
     group by connection_log.user 
     order by connection_count desc