PS. jag är ny på PHP
Ett stycke php-kod:
<?php
session_start();
include('pages/config.php');
// search.php
if (isset($_POST['submit'])) {
$search_string = strToLower(trim($_POST['string']));
$query = "SELECT id,username,name FROM members WHERE username LIKE '%{$search_string}%' OR name LIKE '%{$search_string}%' ORDER BY name";
$result = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) == 0) {
echo("Din sökning gav 0 träffar!");
}
else {
$hits = mysql_num_rows($result);
echo("Din sökning gav {$hits} träffar!");
echo("<br><br>");
echo("Sökresultat:<br><br>\n");
while($row = mysql_fetch_assoc($result)) {
echo("<a href=\"presentation.php?id={$row['id']}\">{$row['username']} ({$row['name']})</a><br>\n");
}
echo("<a href=\"search.php\">Ny sökning</a>\n");
}
} else {
?>
<form method="post" action="search.php">
Sökord:<br>
<input type="text" size="30" name="string"><br>
<input type="submit" value="Sök" name="submit">
</form>
<?
}
?>
Ingen status
