0

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?

Steven
  • 687
  • 1
  • 10
  • 27

0 Answers0