php search engine suggestion -
hello wanted ask question, right starting work search engine, can suggest functions or ways how start or use making search engine database users username.it can search 1 symbol in words write 'k' , searches usernames starting username 'k'. example: http://postimg.org/image/sg84ny3w3/
tried:
private function search() { global $database; if(isset($_post['s'])) { if($_post['s'] == '1' || $_post['s'] == '2' || $_post['s'] == '3') $type = $_post['s']; $database->getsearchdata($type, $_post['xs']); } else if(!preg_match("/[^0-9a-za-z]/", $_post['xs'])){ $error = "you entered invalid data"; } return false; } html:
<div id="content"> <div style="padding:20px"> <?echo $error;?> <form action="index.php?mod=highscore&t=search" method="post" accept-charset="utf-8"> <div class="title_box"><div class="title_inner"> searching for? </div></div> <div class="title2_box"><div class="title2_inner"> <p> <table width="80%"> <tr> <td><input type="radio" name="s" value="1"></td> <td>player</td> </tr> <tr> <td><input type="radio" name="s" value="2"></td> <td>guild (name)</td> </tr> <tr> <td><input type="radio" name="s" value="3"></td> <td>guild (guild tag)</td> </tr> <tr> <td>text:</td> <td colspan="2"><input type="text" name="xs" size="30" maxlength="30" value=""></td> </tr> <tr> <td colspan="3"><input type="submit" value="search" class="button3" name="search"></td> </tr> </table> </p> </form> </div></div> <br /> <?if($functions->search() == false) {?> <div class="title_box"><div class="title_inner"> results </div></div> <div class="title2_box"><div class="title2_inner"> <p> <table width="50%"> <tr> <td>player</td> <td>level</td> <td>total honour</td> </tr> <tr><td class="f" colspan="2">no results</td></tr></table> </p> </div></div> <?} else {?> <div class="title_box"><div class="title_inner"> results </div></div> <div class="title2_box"><div class="title2_inner"> <p> <table width="50%"> <tr> <td>player</td> <td>level</td> <td>total honour</td> </tr> <tr><td class="f" colspan="2"><?$functions->search();?></td></tr></table> </p> </div></div> <?}?> </div> <script type='text/javascript'>var tickerarray = new array();function doticker(){ n=new date(); if (tickerarray.length > 0) { (i = 0; < tickerarray.length; i++) { if (isnan(document.getelementbyid(tickerarray[i]["id"]))) { var e = document.getelementbyid(tickerarray[i]["id"]); s = tickerarray[i]["sek"]; m = 0; h = 0; d = 0; if (s < 0) e.innerhtml = "---"; else { var timetxt = s + " s"; if (s > 59) { m = math.ceil(s / 60); s = s-m * 60; timetxt = m + " m"; } if (m > 59) { h = math.ceil(m / 60); m = m - h * 60; timetxt = h + " h"; } if (h > 24) { d = math.ceil(h / 24); h = h-d * 24; timetxt = d + " d"; } e.innerhtml = timetxt; tickerarray[i]["sek"]--; } } } window.settimeout("doticker();",999); } }doticker();</script> </div>
select * users username 'k%' return user records username starts k
select * user username '%k%'
will return user records containing character k
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like
Comments
Post a Comment