想了解php–MySQL：查询带有关系的排行榜的新动态吗？本文将为您提供详细的信息，我们还将为您解答关于mysql与php关联查询的相关问题，此外，我们还将为您介绍关于apachephpmysqlph

想了解php – MySQL：查询带有关系的排行榜的新动态吗？本文将为您提供详细的信息，我们还将为您解答关于mysql与php关联查询的相关问题，此外，我们还将为您介绍关于apache php mysql php mysql 留言本应用实例第1/2页、Can''t connect to local MySQL server through socket ''/opt/lampp/var/mysql/mysql.sock'' (2)、Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock''、CentOS Nginx php mysql fastcgi MySQL PHP--yum的新知识。

• php – MySQL：查询带有关系的排行榜（mysql与php关联查询）
• apache php mysql php mysql 留言本应用实例第1/2页
• Can''t connect to local MySQL server through socket ''/opt/lampp/var/mysql/mysql.sock'' (2)
• Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock''
• CentOS Nginx php mysql fastcgi MySQL PHP--yum

php – MySQL：查询带有关系的排行榜（mysql与php关联查询）

我知道这是一个热门话题,但我仍然没有找到我正在寻找的东西.我想查询一个表

BOOKS_READ
id
user_id
book_id

格式化已列出最多书籍的用户的排行榜.当用户阅读书籍时,与书籍ID和用户ID匹配的记录将被记录到books_read表中.

是否可以对此查询的结果进行排名,从1开始,并考虑关系？

SELECT user_id, COUNT(*) AS book_count 
FROM books_read 
GROUP BY user_id 
ORDER BY book_count DESC LIMIT 10

如果出现平局,我想在结果中列出“=”符号.

例如,

rank  user_id  book_count  
=1    30       121
=1    17       121
 2    101      119
=3    11       104
=3    91       104

非常感谢您的帮助！我不介意使用PHP来处理其中的一些,但我对学习这些东西的直接sql解决方案非常感兴趣:-)

解决方法:

SELECT GROUP_CONCAT(user_id, book_count
FROM (
    SELECT user_id, COUNT(*) AS book_count 
    FROM books_read 
    GROUP BY user_id 
    ORDER BY book_count DESC
) AS T1
GROUP BY book_count
ORDER BY book_count

给你

user_id  book_count  
30,17       121
101         119
11,91       104

然后,您可以使用PHP来解析关系.

<?PHP
$rank = 1;

while ($row = MysqL_fetch_assoc($result)) {
    $users = explode(',', $row['user_id'];
    foreach ($users as $user) {
        echo 'Rank: ' . $rank . ' ' . $user . "\n;
    }
    $rank++;
}

?>

apache php mysql php mysql 留言本应用实例第1/2页

复制代码 代码如下:

立即学习“PHP免费学习笔记（深入）”；

$hostname_conn = "localhost";
$database_conn = "test";
$username_conn = "root";
$password_conn = "1981427";
$conn = mysql_connect($hostname_conn, $username_conn, $password_conn);
?>

复制代码 代码如下:

立即学习“PHP免费学习笔记（深入）”；

//该函数用于将一般字符串转换成SQL语句所需要的格式
function GetSQLValueString($theValue, $theType)
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "''" . $theValue . "''" : "NULL";
break;
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
}
return $theValue;
}
?>

复制代码 代码如下:

立即学习“PHP免费学习笔记（深入）”；

session_start();
//如果Session不存在，则跳转到Admin.php
if (!(isset($_SESSION[''MM_Username'']))) {
header("Location: admin.php");
exit;
}
?>

复制代码 代码如下:

立即学习“PHP免费学习笔记（深入）”；

// *** Validate request to login to this site.
session_start();
$loginFormAction = $_SERVER[''PHP_SELF''];
if (isset($accesscheck)) {
$GLOBALS[''PrevUrl''] = $accesscheck;
session_register(''PrevUrl'');
}
if (isset($_POST[''username''])) {
$loginUsername=$_POST[''username''];
$password=$_POST[''password''];
$MM_fldUserAuthorization = "";
$MM_redirectLoginSuccess = "adminmain.php";
$MM_redirectLoginFailed = "admin.php";
$MM_redirecttoReferrer = false;
mysql_select_db($database_conn, $conn);
$LoginRS__query=sprintf("SELECT adminname, password FROM admin WHERE adminname=''%s'' AND password=''%s''",
get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password));
$LoginRS = mysql_query($LoginRS__query, $conn) or die(mysql_error());
$loginFoundUser = mysql_num_rows($LoginRS);
if ($loginFoundUser) {
$loginStrGroup = "";
//declare two session variables and assign them
$GLOBALS[''MM_Username''] = $loginUsername;
$GLOBALS[''MM_UserGroup''] = $loginStrGroup;
//register the session variables
session_register("MM_Username");
session_register("MM_UserGroup");
if (isset($_SESSION[''PrevUrl'']) && false) {
$MM_redirectLoginSuccess = $_SESSION[''PrevUrl''];
}
header("Location: " . $MM_redirectLoginSuccess );
}
else {
header("Location: ". $MM_redirectLoginFailed );
}
}
?>

留言板 - 管理登陆

浏览留言 | 发表留言

当前1/2页 12下一页

以上就介绍了apache php mysql php mysql 留言本应用实例第1/2页，包括了apache php mysql方面的内容，希望对PHP教程有兴趣的朋友有所帮助。

Can''t connect to local MySQL server through socket ''/opt/lampp/var/mysql/mysql.sock'' (2)

ERROR 2002 (HY000): Can''t connect to local MySQL server through socket ''/opt/lampp/var/mysql/mysql.sock'' (2)

原因：系统盘满了

[root@localhost opt]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root
18G 17G 0 100% /
tmpfs 504M 0 504M 0% /dev/shm
/dev/sda1 477M 80M 372M 18% /boot
[root@localhost opt]#

解决：

删除大文件后，重启系统解决

[root@localhost mysql]# /opt/lampp/lampp status
Version: XAMPP for Linux 1.8.3-3
Apache is not running.
MySQL is not running.
ProFTPD is running.

df: 未处理文件系统
[root@localhost opt]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root
18G 17G 0 100% /
tmpfs 504M 0 504M 0% /dev/shm
/dev/sda1 477M 80M 372M 18% /boot
[root@localhost opt]#

[root@localhost ~]# /opt/lampp/lampp status
Version: XAMPP for Linux 1.8.3-3
Apache is not running.
MySQL is running.
ProFTPD is running.

转

xampp 无法启动mysql 找不到mysql.sock

  (2016-02-24 23:21:24)

转载▼

Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock''

MySQL已经被我移到数据盘了，本地连接数据库会报错：Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock''

但是远程是可以连接的，my.cnf设置mysql的根目录也改成了数据盘的地址，还要在加上client的参数，设置如下：

[client]
socket = /home/data/mysql/mysql.sock

之后重启下mysql就可以了

CentOS Nginx php mysql fastcgi MySQL PHP--yum

LANG=C yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers wget ftp://ftp.pbone.net/mirror/download.fedora.redhat.com/pub/fedora/epel/5/x86_64/epel-release-5-3.noarch.rpm wget http://rpms.famillecollet.com/el5.x86_64/remi-release-5-7.el5.remi.noarch.rpm rpm ?ivh epel*.rpm remi8.rpm yum --enablerepo=remi -y install php mysql mysql-server mysql-devel php-mysql php-cgi php-mbstring php-gd php-fastcgi nginx chkconfig nginx on yum install spawn-fcgi wget http://blog.12351.net/wp-content/uploads/2009/12/419.zip unzip 419.zip mv 419.sh /etc/init.d/php_cgi chmod +x /etc/init.d/php_cgi 启动php_cgi /etc/init.d/php_cgi start

关于php – MySQL：查询带有关系的排行榜和mysql与php关联查询的问题我们已经讲解完毕，感谢您的阅读，如果还想了解更多关于apache php mysql php mysql 留言本应用实例第1/2页、Can''t connect to local MySQL server through socket ''/opt/lampp/var/mysql/mysql.sock'' (2)、Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock''、CentOS Nginx php mysql fastcgi MySQL PHP--yum等相关内容，可以在本站寻找。