php - query working with like statement but not with fulltext mysql index -


am trying create search engine enable users data search. tried using in sql query , works. want use mysql fulltext index in code below not displaying data when search. table created myislam fulltext index enabled. below code

<?php include('searchajax_db.php'); if($_post) {     $q=mysql_real_escape_string($_post['search']);     $sql_res=mysql_query("select * articles match(title,body) against ('$q')          order match(title,body) against ('$q')");      //$sql_res=mysql_query("select id,title,body articles title '%$q%' or body '%$q%' ");     //     if($sql_res === false) {         die(mysql_error()); // todo: better error handling     }      while($row=mysql_fetch_array($sql_res)) {         $ut=$row['title'];         $ub=$row['body'];         $b_ust=''.$q.'';         $b_emb=''.$q.'';         $final_u = str_ireplace($q, $b_ust, $ut);         $final_e = str_ireplace($q, $b_emb, $ub); ?> <div class="show" align="left"> <?php echo '<a  data-role="button" data-transition="fade" data-icon="arrow-r" data-iconpos="right" data-inline="true" href=profile.php?id='.htmlentities($row["id"], ent_quotes, "utf-8") .' title="click find ">'.'<font color=orange></font>'.''  ?> <?php echo '<font color=greenyellow>' ?> <span class="name"><?php echo htmlentities($final_u, ent_quotes, "utf-8"); ?></span>&nbsp;<br/> <?php echo htmlentities($final_e, ent_quotes, "utf-8"); ?><br/> <?php echo '</font>' ?> </div> <?php }} ?>

you don't need use match everywhere. condition determine rows retrieved table. right after select choose columns rows displayed. order determines column , direction rows sorted by.

this example sufficient:

select title, body articles match(title,body) against ('$q') order title asc

i note should use prepared statements pdo or mysqli better protection using mysql_real_escape_string.


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more