Basta ya de buscar por todo internet porque has llegado al sitio justo, poseemos la solución que quieres recibir pero sin complicaciones.
Ejemplo 1: barra de búsqueda en php mysqli
mysql_connect("localhost","root","")ordie("Error connecting to database: ".mysql_error());/*
localhost - it's location of the mysql server, usually localhost
root - your username
third is your password
if connection fails it will stop loading the page and display an error
*/mysql_select_db("tutorial_search")ordie(mysql_error());/* tutorial_search is the name of database we've created */?>DOCTYPEhtmlPUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="http://www.w3.org/1999/xhtml"><head><title>Search resultstitle><metahttp-equiv="Content-Type"content="text/html; charset=utf-8"/><linkrel="stylesheet"type="text/css"href="style.css"/>head><body>$query=$_GET['query'];// gets value sent over search form$min_length=3;// you can set minimum length of the query if you wantif(strlen($query)>=$min_length)// if query length is more or equal minimum length then$query=htmlspecialchars($query);// changes characters used in html to their equivalents, for example: < to >$query=mysql_real_escape_string($query);// makes sure nobody uses SQL injection$raw_results=mysql_query("SELECT * FROM articles
WHERE (`title` LIKE '%".$query."%') OR (`text` LIKE '%".$query."%')")ordie(mysql_error());// * means that it selects all fields, you can also write: `id`, `title`, `text`// articles is the name of our table// '%$query%' is what we're looking for,% means anything,for example if$query is Hello
// it will match "hello", "Hello man", "gogohello", if you want exact match use `title`='$query'// or if you want to match just full word so "gogohello" is out use '% $query %' ...OR ... '$query %' ... OR ... '% $query'if(mysql_num_rows($raw_results)>0)// if one or more rows are returned do followingwhile($results=mysql_fetch_array($raw_results))// $results = mysql_fetch_array($raw_results) puts data from database into array, while it's valid it does the loopecho""
.$results['title']."".$results['text']."
Ejemplo 2: barra de búsqueda en php mysqli
<!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</title><meta http-equiv="Content-Type" content="text/html; charset=utf-8"/><link rel="stylesheet" type="text/css" href="style.css"/></head><body><form action="search.php" method="GET"><input type="text" name="query"/><input type="submit" value="Search"/></form></body></html>Puedes añadir valor a nuestra información asistiendo con tu veteranía en las críticas.
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)