I'm doing a program that generates a template automatically, I'm using laravel and PHP 7.2.
I am saving an sql query in an array and then saving it in a SESSION, everything up to there works fine, the problem is that when consulting the data in another part of the code, they are lost and it seems that it does not save them from complete way, since if I execute a print r of the array in the first part of the code if it brings me the whole query, but if I do it in the second part of the code it does not, I leave the code and an example with the hope of that someone can help me, greetings!
<!DOCTYPE html>
<?php
$serverName = "192.168.1.150";
$database = "CCT";
$uid = 'sa';
$pwd = 'B1Admin';
try {
$conn = new PDO(
"sqlsrv:server=$serverName;Database=$database",
$uid,
$pwd,
array(
//PDO::ATTR_PERSISTENT => true,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
)
);
}
catch(PDOException $e) {
die("Error connecting to SQL Server: " . $e->getMessage());
}
session_start();
$variable=42896;
$consulta = "SELECT T0.BELNR_ID, T0.BELPOS_ID, t0.POS_ID, t0.ART1_ID, t0.ItemName, t0.DIN, t0.MENGE_VERBRAUCH,
t2.BaseDocNum, t2.BaseLine, t2.ItemCode, t2.ItemName, t2.U_beas_ver, t2.ZUSATZTEXT as 't2.ZUSATZTEXT', t2.GRUPPE,
t2.MENGE_VERBRAUCH, t2.ME_LAGER, t2.GEL_MENGE, t2.ANFZEIT, t2.ENDZEIT, t3.NumAtCard, t3.CardName,
t5.OnHand, t6.OnHand, t4.InvntryUom, t0.MATERIALKOSTEN, t2.ErfTStamp, t7.ZUSATZTEXT ,t8.Notes,
t9.VendorNum,t9.SerialNum,t10.QryGroup3
From BEAS_FTSTL T0
inner join BEAS_FTPOS t2 on t2.BELNR_ID=t0.BELNR_ID
left join ORDR t3 on t2.BaseDocNum=t3.DocNum
left join RDR1 t9 on t3.DocEntry=t9.DocEntry and t9.LineNum=t2.baseline
inner join OITM t4 on t0.ART1_ID=t4.ItemCode
inner join OITW t5 on t0.ART1_ID=t5.ItemCode and t5.WhsCode='1AP'
inner join OITW t6 on t0.ART1_ID=t6.ItemCode and t6.WhsCode='RECIBO'
inner join BEAS_FTHAUPT t7 on t2.BELNR_ID=t7.BELNR_ID
left join OCRD t8 on t3.CardCode=t8.CardCode
inner join OITM t10 on t2.ItemCode=t10.ItemCode
WHERE t2.MENGE<>t2.GEL_MENGE and t2.ABGKZ='N' and T0.BELNR_ID = {$variable} and t0.POS_ID= 10
ORDER BY t0.BELNR_ID,t0.POS_ID";
$resultado=$conn->query($consulta) or die("No puedo realizar la consulta");
$i=0;
while ($row = $resultado->fetch(PDO::FETCH_ASSOC)){
//Obtengo las claves del arreglo que en tu caso son los atributos de la tabla (id, nombre, etc)
$claves = array_keys($row);
//Recorro el arreglo de las claves para ir asignando los datos al arreglo con los nombres de los atributos
foreach($claves as $clave){
$arrayauxliar[$i][$clave]=$row[$clave];
}
$i++;
$_SESSION['row']=$row;
}
$consulta2="SELECT BEAS_FTPOS.BELNR_ID, BEAS_FTPOS.BELPOS_ID, BEAS_FTPOS.MENGE_VERBRAUCH, BEAS_FTPOS.GEL_MENGE, BEAS_FTAPL.POS_ID, BEAS_FTAPL.AG_ID, BEAS_FTAPL.APLATZ_ID, BEAS_PERS.PERS_ID, BEAS_PERS.NAME1, BEAS_PERS.NAME2, BEAS_PERS.NAME3
FROM CCT.dbo.BEAS_FTAPL BEAS_FTAPL, CCT.dbo.BEAS_FTPOS BEAS_FTPOS, CCT.dbo.BEAS_PERS BEAS_PERS
WHERE BEAS_FTAPL.BELNR_ID = BEAS_FTPOS.BELNR_ID AND BEAS_FTAPL.BELPOS_ID = BEAS_FTPOS.BELPOS_ID AND BEAS_FTAPL.APLATZ_ID = BEAS_PERS.APLATZ_ID AND ((BEAS_FTPOS.MENGE_VERBRAUCH<>GEL_MENGE))and BEAS_FTPOS.BELNR_ID = {$variable} ";
$resultado2=$conn->query($consulta2) or die("No puedo realizar la consulta");
$p=0;
while ($row2 = $resultado2->fetch(PDO::FETCH_ASSOC)){
//Obtengo las claves del arreglo que en tu caso son los atributos de la tabla (id, nombre, etc)
$claves2 = array_keys($row2);
//Recorro el arreglo de las claves para ir asignando los datos al arreglo con los nombres de los atributos
foreach($claves2 as $clave2){
$arrayauxliar2[$p][$clave2]=$row2[$clave2];
}
$p++;
$_SESSION['row2']=serialize($row2);
print_r ($_SESSION['row2']);
}
?>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Orden de Prodccion</title>
<link rel="stylesheet" href="{{asset('css/style.css')}}" media="all" />
</head>
<body>
<header class="clearfix">
<div id="logo">
<img src="{{asset('img/logo.png') }}">
</div>
<div id="company">
<h3 class="name">Manufactura CCT</h3>
<div>Manufactura CCT, S. de R.L de C.V</div>
<div>Camino a las Cañadas # 900, Nave 4</div>
<div>Bosques de San Isidro CP 45133</div>
<div>Zapopan, Jalisco, Mexico</div>
</div>
<div id="company2">
<h3 class="name">Orden de Producción</h3>
<h3 class="name">Explosión</h3>
</div>
</div>
</header>
<header class="clearfix">
<main>
<div id="details" class="clearfix">
<div id="client">
<div class="to">Cliente: <?php echo $_SESSION['row']['CardName']; ?> </div>
<div class="name">Pedido: <?php echo $_SESSION['row']['BaseDocNum']; ?></div>
<div class="address">OC Cliente: <?php echo $_SESSION['row']['NumAtCard']; ?></div>
<div class="email">Observaciones: <?php echo $_SESSION['row']['t2.ZUSATZTEXT']; ?></div>
</div>
<div class="grid-container">
<div class="grid-container">
<div class="grid-item">Tipo</div>
<div class="grid-item">OP</div>
<div class="grid-item">POS</div>
<div class="grid-item">REV WO</div>
<div class="grid-item">Rev Actual</div>
<div class="grid-item">CR</div>
<div class="grid-item"><?php echo $_SESSION['row']['BELNR_ID']; ?></div>
<div class="grid-item"><?= $_SESSION['row']['BELNR_ID'] ?></div>
<div class="grid-item"><?php echo $_SESSION['row']['U_beas_ver']; ?></div>
<div class="grid-item"></div>
</div>
</div>
</div>
</div>
</header>
<header class="clearfix">
</header>
</body>
</html>
<?= print_r($_SESSION['row2']) ?>[![error][1]][1]