Hi.
I have a database named 'Forums' with a table named 'forumlist'. The fields in the table are 'id', 'name', 'link', and 'keys'.
I am trying to search the database in either the 'name' or 'keys' field and display the matches.
I am getting this error:
Parse error: syntax error, unexpected T_STRING, expecting ']' in C:\xampp\htdocs\search3.php on line 51 (The define fields)
<html>
<head>
<title>My Forum Search</title>
<style type="text/css">
table {
background-color: #CCC
}
th {
width: 150px;
text-align: left;
}
</style>
</head>
<body>
<h1>Forum Search</h1>
<form method="post" action="search3.php">
<input type="hidden" name="submitted" value="true" />
<label>Search Category:
<select name="category">
<option value="keys">Keyword</option>
<option value="name">Name</option>
</select>
</label>
<label><input type="text" name="criteria" /></label>
<input type="submit" />
</form>
<?php
if (isset($_POST['submitted])) {
DEFINE ('DB_USER', 'root');
DEFINE ('DB_PSWD', '******');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'Forums');
$dbcon = mysqli_connect(DB_HOST, DB_USER, DB_PSWD, DB_NAME);
$category = $_POST['category'];
$criteria = $_POST['criteria'];
$query = "SELECT * FROM forumlist WHERE $category LIKE '$criteria'";
$result = mysqli_query($dbcon, $query) or die ('Error retrieving data')
echo "<table>";
echo "<tr> <th>Name</th><th>Link</th> </tr>";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
echo "<tr><td>";
echo $row['name'];
echo "</td><td>";
echo $row['link'];
echo "</td></tr>";
}
echo "</table>";
} // end of main if state
?>
</body>
</html>
Thanks in advance