如何通过会话发布SQL变量并在下一页中获得它 - how to post SQL variable through session and get it in next page

how to post SQL variable through session and get it in next page

本文关键字：一页会话何通过变量 SQL | 更新日期: 2023-09-27

我想通过会话发布$dataHeadArr值，并在下一页获得它。

<?php 
if(isset($_POST["search"]))
{ $storename=$_POST["StoreName"];
    $dataHeadArr=$db->query("SELECT *FROM  `opening_stk`");?>

为您发布的页面添加

<?php 
    if(isset($_POST["search"])){
        session_start(); 
        $storename=$_POST["StoreName"];
        $dataHeadArr=$db->query("SELECT * FROM  `opening_stk`");
        while($row=mysql_fetch_assoc($dataHeadArr)){
           $allRows[]=$row;
        }
        $_SESSION['dataHeadArr']=$allRows;
    }
?>

对于要检索变量的页面，请放置

<?php
   session_start();
   $dataHeadArr=$_SESSION['dataHeadArr'];
   //This mysql result been parsed already, so you should be 
   //able to access values when you loop through it from here
   for($i=0;$i<count($dataHeadArr); $i++){
       echo "Printing row ".$i."</br>";
       foreach($dataHeadArr[$i] as $key=>$item){ 
            //Prints out all value for the row
            echo $item[$key]."</br>";
       }
       echo "</br>";
   }
?>

您可以在POST或SESSION数组中设置它，然后在下一页检索它。ex -

$_POST['dataHeadArr']=$dataHeadArr;

存储…

$_SESSION['dataHeadArr'] = 'Whatever';

然后简单地检索…

if(isset($_SESSION['dataHeadArr'])){
    echo $_SESSION['dataHeadArr'];
}

确保调用session_start();