Readme
-
Posts
33 -
Joined
-
Last visited
Everything posted by Readme
-
This is not possible?
-
It come "crossword database". If you can, please help.
-
How to make this: RED BOX IF I Search "Mobile" and choose 2 letters. Then result is Mobile LG IF 5 letters then Nokia Must use LEN or something? <?php mysql_connect("localhost", "", "") or die("Error connecting to database: ".mysql_error()); mysql_select_db("data") or die(mysql_error()); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Search results</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> </head> <body> <div class="container"> <form action="search.php" method="GET"> Search: <input type="text" name="query" /> <input type="submit" value="Search" /> </form> <div> <label>Search categories</label> <select> <option value="1">Search all</option> <option value="2">2 letters</option> <option value="4">3 letters</option> <option value="5">4 letters</option> <option value="6">5 letters</option> <option value="7">6 letters</option> </select> </div> <?php $query = $_GET['query']; $min_length = 2; if(strlen($query) >= $min_length){ $query = htmlspecialchars($query); $query = mysql_real_escape_string($query); $raw_results = mysql_query("SELECT * FROM articles WHERE (`title` LIKE '%".$query."%') OR (`text` LIKE '%".$query."%')") or die(mysql_error()); if(mysql_num_rows($raw_results) > 0){ while($results = mysql_fetch_array($raw_results)){ echo "<p><h3>".$results['title']."</h3>".$results['text']."</p>"; } } else{ echo "No results"; } } else{ echo "Minimum length is ".$min_length; } ?> </div> </body> </html>
-
I asking PHP code. Look @ demo
-
Hi! Who are the good people who make me a simple code?
-
Someone...
-
Not work or I make something wrong One checkbox coming up...
-
This functions used select data but I want use <input type="checkbox"/> Please help to modify. //----------get country via select option---------- function get_country() { $sql = "SELECT id,country FROM countries ORDER BY id ASC"; $res = mysql_query($sql); echo "<select id=\"country\" class=\"searchbox\" name=\"country\">"; echo "<option value=\"\">Select One</option>"; while ($row = mysql_fetch_assoc($res)){ echo "<option value=\"".$row['country']."\">".$row['country']."</option>"; } echo "</select>"; } //----------get countries via select option from users---------- function get_select_countries($id) { $id = secureInput($id); $sql = "SELECT country FROM countries ORDER BY country ASC"; $res = mysql_query($sql); $sql1 = "SELECT country FROM users WHERE id='".$id."'"; $res1 = mysql_query($sql1); $row1 = mysql_fetch_assoc($res1); if($row1){ echo "<select name=\"country\">"; echo "<option selected=".$row1['country']." value=\"".$row1['country']."\">".$row1['country']."</option>"; while ($row = mysql_fetch_assoc($res)){ echo "<option value=\"".$row['country']."\">".$row['country']."</option>"; } echo "</select>"; } else { echo "<select name=\"country\">"; while ($row = mysql_fetch_assoc($res)){ echo "<option value=\"".$row['country']."\">".$row['country']."</option>"; } echo "</select>"; } }