Category Covered

Basic mysql stored procedure  

DELIMITER $$ CREATE PROCEDURE `areslog_shanghai`.`albumItems`() BEGIN END$$ DELIMITER ; another example ------------------- DELIMITER $$ USE `areslog_shanghai`$$ DROP PROCEDURE IF EXISTS `albumItems`$$ CREATE DEFINER=`root`@`localhost` PROCEDURE `albumItems`() BEGIN SELECT * FROM areslog_shanghai.nite_parties; END$$ DELIMITER ;
 
By: Tech writer  |   Total Read: 1704  |   Read more..

How to drop or delete mysql stored procedure  

DROP PROCEDURE IF EXISTS `albumItems`;
 
By: Tech writer  |   Total Read: 2579  |   Read more..

Cakephp containable conditions in pagination  

cakephp containable with complex condition, limit on related model. $this->paginate = array( 'limit' => 20, 'order' => array('NiteParty.date' => 'ASC'), 'contain' => array( 'Item' => array( 'conditions' => array( 'Item.id' => 3 ), 'limit' => 2, ), 'NitePartyPicture' => array( 'limit' => 3, ) ) ); $niteparties = $this->paginat
 
By: Tech writer  |   Total Read: 2216  |   Read more..

Cakephp login is not working on internet explorer  

If you see that your cakephp login is not working on internet explorer then modify the following information.   /app/Config/core.php Configure::write('Session', array( 'defaults' => 'php', 'cookieTimeout' => 0, 'cookie' => 'newNameSESSION', ));
 
By: Tech writer  |   Total Read: 1133  |   Read more..

Multiple selection dropdown list limit controll  

 I have a multiple selection dropdown list. I want to controll the limit using jquery so i just use the following jquery and its work fine for me.   $(document).ready(function() { $('#ItemOptions option').click(function() { var items = $(this).parent().val(); if (items.length > 3) { alert("You can only select 3 values at a time"); $(this).removeAttr("selected"); } })
 
By: Tech writer  |   Total Read: 1631  |   Read more..

PHP forcely stop a loop  

If you want to stop a loop forcely just use break; to stop for($dayCounter=0; $dayCounter<=21;$dayCounter++){ break; }
 
By: social worker  |   Total Read: 929  |   Read more..

how to get a date after 45 days  

If you want a date after some date in php just use the code $start = date('Y-m-d');
$end = date("Y-m-d", strtotime($start ." +45 day") );
 
By: Tech writer  |   Total Read: 870  |   Read more..

cakephp call function within controller  

For example you have the following function that you want to use inside another function public function token(){ echo $this->Auth->user('id'); } Here is another function where you are going to use the given token function public function counter(){ $this->token(); }
 
By: Tech writer  |   Total Read: 2820  |   Read more..

কমলাপুরে শীতবস্ত্র বিতরণে এক ভযংকর অভিগতা  

এমন একটা ঘটনা যা শেয়ার না করে পারছিনা । আমি একটা সোসাইটি ইর  সাথে সম্পৃক্ত যে সোসাইটি টি চলে সম্পর্ণ নিজেদের আর্থিক সহাযটাই । তো এবার আমরা টাকা সংগ্রহ করে শীতের কাপড় কিন
 
By: Tech writer  |   Total Read: 3371  |   Read more..

Send mail in cakephp2  

If you want to send mail using cakephp 2.x version then this tutorial will help you. Add the following line App::uses('CakeEmail', 'Network/Email');   Use the following code on your function   $email = new CakeEmail(); $email->from(array('noreply@'.env('SERVER_NAME') => 'Sales Tracking Software')); $email->to($user['User']['username']); $email->subject('Reset password Mail'); $email->template('recoverpassword')
 
By: Tech writer  |   Total Read: 1032  |   Read more..
Top 15 Posts
Google+