Ok I am getting results however it is not returning records that contain the value of the session
the results only return if the field contains nothing but the value of the session
In the SQL I changed the = to LIKE but it did not work
Here is the code
<?php
error_reporting(E_ALL);
ini_set('display_errors','on');
?>
<?php
session_start();
if(isset($_GET['SearchTag'])) {
$_SESSION["SearchTerm"] = $_GET['SearchTag'];
$_SESSION["SearchTerm"] = preg_replace("#[^0-9a-z]#i","",$_SESSION["SearchTerm"]);
}
?>
<?php require_once('Connections/Connections.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php
$Search = new WA_MySQLi_RS("Search",$Connections,0);
$Search->setQuery("SELECT * FROM siteezy_posts WHERE Post LIKE ?");
$Search->bindParam("s", "".(isset($_SESSION['SearchTerm'])?$_SESSION['SearchTerm']:"") ."", "-1"); //colname
$Search->execute();
?>