查询两个 SQL 条目? [英] Query two SQL entries?

问题描述

我有一个 SQL 数据库，我正在尝试使用 PHP 进行查询.它用于用户帐户，我需要测试数据库中是否存在某个用户名和密码组合.

I have a SQL database I'm trying to query with PHP. It's for user accounts and I need to test if a certain username and password combination exist in the database.

目前，我可以使用以下方法检查用户名是否存在:

Currently, I can check if just a username exists by using:

 <?php
session_start();

include "config.php";

if($_POST['nameQuery']) {

$query = "SELECT * FROM ichatlogin WHERE name = '" .$_POST['nameQuery']. "'";  
$result = mysql_query($query);  
    if (mysql_num_rows($result) > 0) { 
        //User exists
        echo '1'; 
    } else { 
        mysql_query($query);
    //User does not exist
    echo '0'; 
    }
}
?>

谢谢！

推荐答案

您可以根据需要进行任意数量的逻辑比较.根据需要将它们与 AND 或 OR 组合.

You can make as many logical comparisons as you need. Combine them with AND or OR as appropriate.

$name = mysql_real_escape_string($_POST['nameQuery']);
$password = mysql_real_escape_string($_POST['password']);

$query = "SELECT * FROM ichatlogin WHERE name = '$name' AND password = '$password' LIMIT 1";

这篇关于查询两个 SQL 条目?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！