permière page:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
|
.....
//création de la requête:
$sql = '
SELECT count( letter ) AS nbHDD, sum( total ) AS totalSize, hardware.ID, hardware.NAME, WORKGROUP, OSNAME, NAMEconst, OPENSPACE, SMANUFACTURER, SMODEL, PROCESSORT, MEMORY
FROM drives, hardware, bios
WHERE bios.HARDWARE_ID = hardware.ID
AND drives.HARDWARE_ID = hardware.ID
AND drives.type = "hard drive"
AND '.$_GET['searchCat'].' like "%'.$_GET['searchContent'].'%"
GROUP BY hardware.ID
ORDER BY '.$_GET['tri'];
.....
while($data = mysql_fetch_assoc($req))
{//affichage qui marche}
.......
//envoi vers la 2eme page:
<div id=includeExport>
<form action="page.php" method=POST>
<input type=hidden name="sql" value="'.$sql.'">
<input type=submit value="actionl">
</form>
</div>' |
2eme page:
1 2 3 4 5 6 7
| <?php
echo $_POST['sql'];
?>
//affiche la requête jusqu'à "AND drives.type =" |
Résultat quand je vais sur la 2eme page:
SELECT count( letter ) AS nbHDD, sum( total ) AS totalSize, hardware.ID, hardware.NAME, WORKGROUP, OSNAME, NAMEconst, OPENSPACE, SMANUFACTURER, SMODEL, PROCESSORT, MEMORY FROM drives, hardware, bios WHERE bios.HARDWARE_ID = hardware.ID AND drives.HARDWARE_ID = hardware.ID AND drives.type = You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5
Partager