The form code :
<form method="post">
<input type="text" name="q" />
<input type="submit" name="search" value="Find Workorder" class="btn btn-success"/>
</form>
example php code :
include 'database.php';
$pdo = Database::connect();
$sql = 'SELECT whatever FROM wherever ORDER BY id DESC';
$rows = $pdo->query($sql);
foreach ($pdo->query($sql) as $row)
{
echo
whatever
}
if ($q)
{
$sql2 = 'SELECT whatever FROM wherever WHERE whatever LIKE '%$q%' ORDER BY id DESC';
$rows = $pdo->query($sql);
foreach ($pdo->query($sql) as $row)
{
echo
whatever
}
I keep on getting an undefined variable error, when the variable "q" is obviously being defined whenever a _POST is made, does anyone know why this is?