php - 根据用户 ID 和密码条件选择数据库

Question

我有两个数据库，我想根据用户 ID 密码条件选择一个数据库，但现在它不适用于此条件。我怎样才能实现它？目前，仅选择第一个数据库，而不选择第二个数据库。

<?php
    if($_SESSION['s_activId'] == 'om' && isset($_SESSION['s_userType']) == 'om')
    {
      $dbName = "kal";
      $link = mysql_connect("localhost","root","");
      mysql_select_db($dbName) or die("colud not connect to database". mysql_error());
    }
    else if($_SESSION['s_activId'] == 'om' && isset($_SESSION['s_userType']) == 'om1')
    {
      $dbName = "kal1";
      $link = mysql_connect("localhost","root","");
      mysql_select_db($dbName) or die("colud not connect to database". mysql_error());
    }
?>

Answer 1

如果您在脚本中使用$_SESSION，则必须启动 session ，否则 session 不可见。

此外，如果测试需要一些修正，isset() 返回一个 bool 值，而不是数组中保存的数据。

<?php
// add this to gain access to the session
session_start();

if($_SESSION['s_activId'] == 'om' && 
   isset($_SESSION['s_userType']) && 
   $_SESSION['s_userType'] == 'om')
{
    $dbName = "kal";
    $link = mysql_connect("localhost","root","");
    mysql_select_db($dbName) or die("could not connect to database". mysql_error());
}
else if($_SESSION['s_activId'] == 'om' && 
        isset($_SESSION['s_userType']) && 
        $_SESSION['s_userType'] == 'om1')
{
    $dbName = "kal1";
    $link = mysql_connect("localhost","root","");
    mysql_select_db($dbName) or die("could not connect to database". mysql_error());
}

?>