1. If the table’s engine is InnoDB change it to MYISAM.2. Add FULLTEXT INDEX on the column that you plan to search. For example “title” in table “tbl_articles”. ALTER TABLE ‘tbl_articles’ ADD FULLTEXT (‘title’)
public function search(){ $query = $this->request->data[‘Articles’][‘search’]; $escapedQuery = $this->Article->getDataSource()->value($query); $data = $this->Paginator->paginate(‘Article’, array(“MATCH (Article.title) AGAINST ($escapedQuery)”) ); $this->set(‘articles’, $data); }
Goto “Device manager” from “Control Panel”. Double click “Network adapters” to expand it. Select your LAN card. Right click on it and goto “Properties”. In properties windows click “Advanced” Tab. Then select “Network Address”. After that click on “Value” radio button. Enter the MAC address in “Value” textbox. Click […]
FutureLearn offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.FutureLearn offers you a powerful new way to learn online. […]
Add this to the bottom of the page. <a href=”#” class=”back-to-top”><span class=”glyphicon glyphicon-arrow-up” aria-hidden=”true”> </span></a> <style> .back-to-top { position: fixed; bottom: 2em; right: 0px; text-decoration: none; color: #000000; background-color: rgba(235, 235, 235, 0.80); font-size: 28px; padding: 1em; display: none; } […]
Following is the default cakephp paginator sorting label.<?php echo $this->Paginator->sort(‘company_id’); ?> We can change it as follows <?php echo $this->Paginator->sort(‘company_id’,’Name of the Company’); ?>
