Skip to main content

Posts

Showing posts from June, 2015

Final Keyword in PHP

Final method: A final method is a method that cannot be overridden. To declare a method as final, you need to prefix the function name with the ‘final’ keyword. eg: class Teacher {     final public function attendance() {       echo "Teacher attendance called";    } } class Student extends Teacher {    //this will cause Compile error    public function attendance() {        echo "Student attendance called";    } } $st = new Student(); $st->attendance(); Results in Fatal error: Cannot override final method Teacher::attendance() final class: A final class is a class that cannot be extended. To declare a class as final, you need to prefix the ‘class’ keyword with ‘final’. Example below. final class Teacher {    public function attendance() {       echo "Teacher attendance called";    } } //this will cause Compile error class Student extends Teacher { } $c = new Student(); $c->attendance(); Results in Fatal err

Mysql Union

The UNION set operator is used for combining data from two tables which have columns with the same datatype.When a UNION is performed the data from both tables will be collected in a single column having the same datatype. Rules: The number of columns appears in the corresponding SELECT statements must be equal. The columns appear in  the corresponding positions of each SELECT statement must have the same data type or at least convertible data type. You cannot use the union operator on text and image columns. Notes: Union -- returns with no duplicate rows Union all -- retruns with duplicate rows (No. of rows returned = No. of rows in Query1 + No. of rows in Query 2) Example: Suppose you want to combine data from the  student and teacher tables into a single result set, you can UNION operator as the following query: SELECT studentNumber id, contactLastname name FROM student UNION SELECT teacherNumber id,firstname name FROM teacher Here is the output: id nam

Searching with Ajax pagination Cakephp

Searching with Ajax pagination Cakephp Step 1 : View File <script> $(document).ready(function(){ $(".pagination a, .header a").on('click',function(){ $('#content').load(unescape($(this).attr("href")),function(){ }); return false;   }); }); </script> <div id="content"> <?php echo $this->Form->create('User',array('type'=>'GET')); echo $this->Form->input('User.name',array('id'=>'name','error'=>array('class'=>'error'),                     'required'=>false,'value'=>@$_GET['data']['User']['name'])); echo $this->Form->input('User.email',array('id'=>'email','error'=>array('class'=>'error'),                     'required'=>false,'value'=>@$_GET['data'

Cakephp Ajax Pagination

Cakephp Ajax Pagination Cakephp Ajax pagination works same like normal pagination , the difference is that it load the pages without refreshing Controller index function public function index(){         $this->paginate = array('limit'=>5,'order'=>'User.id desc');   $userDetail = $this->paginate('User'); $this->set('userDetail',$userDetail); if($this->RequestHandler->isAjax()){ // check the type of request $this->layout = ''; $this->autoRender = false; $this->render('index');  // render the same view } } User index view // script to load page by ajax <script> $(document).ready(function(){ $(".pagination a, .header a").on('click',function(){ $('#content').load(unescape($(this).attr("href")),function(){ }); return false;   }); }); </script> <div id="content"> // show the