PHP & MySQL 将 MySQL 中的数据保存到 php 中的 SESSIONS 中

Question

我遇到了一些问题，相信你们中的一位专家可以提供帮助:-p。

我的数据库中有以下表格:

b_管理员:

id
username
password
email
locationid

b_位置

id
name
description

登录脚本:

<?php

    // Inialize session
    session_start();

    // Connection to MySQL Database.
    include ('_includes/_dbconnection.php');
    include ('_includes/_dbopen.php');

    // Retrieve username and password from database according to user's input
    $login = mysql_query("SELECT * FROM b_admins WHERE (ausername = '" . mysql_real_escape_string($_POST['username']) . "') and (apassword = '" .           mysql_real_escape_string($_POST['password']) . "')");

    // Check username and password match
    if (mysql_num_rows($login) == 1) {

    // Set username session variable
    $_SESSION['username'] = $_POST['username'];

    // Set locationid session varaible //// Modified 12 April 2012.
    $_SESSION['locationid'] = $row_Recordset1["locationid"];

    $locationid = $_SESSION['locationid'];

    // Jump to secured page
    header('Location: _home.php');
    }

    else {

    // Jump to login page
    header('Location: index.php');
    }

    // Script Source: http://frozenade.wordpress.com/2007/11/24/how-to-create-login-page-in-php-and-mysql-with-session/

?>

我的主页脚本:

    // Check, if user is already login, if login proceed to _home.php
    if (isset($_SESSION['username'])) {
    header('Location: _home.php');
    }


    // Load Header file.
    include ('_includes/_header.php');

    // Template Construction.

    // Create Homepage Layout after $home01.
    $home01 = '<div id="imglogo"></div>
                <div id="container">
                <div class="top"> 
                <div id="logo">
                </div>
                <ul class="socialicons">
                </ul>
                </div>
                <div id="content" >
                <div id="home"> 
                <div class="latest">';


    // MySQL Load Location Name from MySQL database after $home02.
    $home02 = '<h3>';


    // Create Notification Area for the Administrator after $home03.
    $home03 = '&nbsp; Administrator Panel</h3><p>You are logged in to make changes to your Branch, only your Branch details can be changed  within this Administration Panel. You may proceed to make any changes using the menu at the bottom.</p></div>
                <!-- /Latest section -->

                <!-- News info section -->
                <ul class="news-info">
                <li><label>Users Registered</label>';


    //MySQL Load User count from MySQL database after $home04.
    $home04 = '<span>';


    // Close Template.
    $home05 = '</span></li>
                </ul>
                <!-- /News info section -->
                </div>        
                <!-- /Home --> 

                <!-- Menu -->
                <div class="menu">
                <ul class="tabs">
                <li><a href="_home.php" class="tab-home"></a></li>
                <li><a href="_events.php" class="tab-events"></a></li>
                <li><a href="_gallery.php" class="tab-portfolio"></a></li>
                <li><a href="_template_edit.php" class="tab-contact"></a></li>
                </ul>
                </div>
                </div>';

    ////////////////////////////////////////////////////////////////////////// Combining Template with MySQL Data.

    /// Build Home Page from MySQL database.

     $SQL = "SELECT * FROM b_admins, b_locations WHERE locationid ='$locationid'  LIMIT 0, 1";
            $result = mysql_query($SQL);

            while ($db_field = mysql_fetch_assoc($result)) {

                echo $home01;
                echo $home02;
                print $db_field['lcity'];
                echo $home03;
            }

    /// Build Home Page News Section from MySQL database.
                echo $home04;
    $SQL = "SELECT count( * ) as total_record  FROM `b_users` WHERE locationid = '$locationid'";
                echo $home05;

    /// Load Footer and Database close file.
    include ('_includes/_footer.php');
    include ('_includes/_dbclose.php');

?>

我想保存 b_admins 中的“locationsid”值，以便能够使用 SQL 从数据库中检索数据，其中“locationsid”与数据库 b_locations 中的表中的数据相同。

我还收到以下错误，我不知道如何在通过登录脚本登录时修复该错误:“http://localhost/xxxxx/_home.php 的网页导致了太多重定向。”

提前致谢:-)

Answer 1

看来你需要先获取记录你需要获取Mysql结果来获取记录

$row_Recordset1 = mysql_fetch_array($login, MYSQL_ASSOC);
$_SESSION['locationid'] = $row_Recordset1["locationid"];

主页也需要一个session_start()；否则它永远不会有效，因为仅在函数调用后加载页面时不存在 session

如果您仍然遇到 header 重定向，您可以使用 html 元刷新还要注意不要将重定向指向同一页面

希望对你有帮助