Saturday, 17 February 2018

Solution: How to get single column value returning from mysql function 1

Are you using MySQL function? Is it returning any single value? Then you may confused, how to get that value from record set after executing query. You will get idea after reading this detailed post.

Okay... Let we write one simple function named mytest(), and make it returns TRUE. Then we will see how to get and assign that TRUE to our server side script variable. 
CREATE  FUNCTION `mytest`() RETURNS char(100) CHARSET utf8

To run this function we need to use this below query.
SELECT mytest();
After running this query, We will get an out put like this below screenshot.

MySQL function return

So, We can't consider mytest() as column name when your are trying to get the value TRUE from returned record set because of that parenthesis. Correct?

To solve this we are just going to assign Alice name to that function.
SELECT mytest() AS returnval;
After running this query, We will get an out put like this below screenshot.

Now, We can use returnval as a column name and we can able to get it's value TRUE from returned record set.

Have any doubt??? Feel free to comment here!!!

Saturday, 13 May 2017

Add number of days to a Date in javascript 0


Add number of days to a Date in javascript / Add number of days to current date in javascript


To add number of days to a Date, we need to convert our date string to a date object. Here we are going to use javascript inheritance property (prototype) to do that.

Actual function :

Date.prototype.addDays = function(days){
     return new Date(this.getTime()+days*24*60*60*1000);
In this function we are going to convert days to milliseconds using days*24*60*60*1000 and adding to our date object.

Code usage :

var ourDate = new Date('2014','11','12');
/*for current date just use below line of code instead of above line
var ourDate = new Date();
//Now we are going to add 100 days to our date object.
var futureDate = ourDate.addDays(100);

How to set root password for mysql server 0

Simply follow these two steps.

open command prompt or console. change control to in where mysql.exe is located. Mostly it will located inside mysql's bin directory.

You have to execute the following command

mysqladmin -u root password 'your_root_password'

replace 'your_root_password' with your desired password.

or simply you can run this sql command in your query window.

SET PASSWORD FOR root@localhost = PASSWORD('your_root_password');

Saturday, 14 May 2016

கண்ணாடியும் கவிஞனே! 1

கண்ணாடியும் கவிஞனே!

நீ உன்னை ரசிக்கும் அழகை ரசித்து,
முகம் பார்க்கும் கண்ணாடியும்;
முழுநேரே கவிஞன் ஆனதே!

Friday, 13 May 2016

மைசூர் பாக்கு பற்றி சில வரிகள் 0

அடடா  மைசூர் பாக்கு!

செதுக்கிய செவ்வகமே!
நெய்யில் குளித்த தங்கமே!
உன்னை வாயிலிட்ட பின்னாலே,
கரைந்து விட்டாய் தன்னாலே!

                                         - CJ Ramki

ஏழையின் ஏக்கம்!

பாகும் மாவும் இணைந்து பிறந்தாயே!
நாவிற்கு இனிமையாய் இருந்தாயே!
பணக்காரர்களிமிருந்து பிரிந்தாயே!
நீ ஏழையை பார்க்கும் நாள் எந்நாளோ!

                                       - காரை வேலன்

இப்படிக்கு மனசாட்சி! 1

இப்படிக்கு மனசாட்சி!

தேவையற்ற தனிமையை,
விளக்கமற்ற வெறுமையை
உன்னுள் உணர்கிறாய்!

உனக்கே உனக்காக உன்னுடன்
நான் இருப்பது அறியாமல்!

இப்படிக்கு மனசாட்சி!


Saturday, 27 February 2016

[Solution] How to limit text in php? 0

Do you wanna show limited text of long text content? if you are using php, then use this simple handy function, else use this logic to build your own function in your programming language.

Here is the procedure we used to create our handy function.

  • First we will apply strip_tags() function on our string to avoid breaking any html. 
  • And then compare our string length with limit parameter. If string length is lesser than limit parameter value, then return the same string. If it is greater than limit parameter value, then turncate the string using substr() function with our limit parameter.
  • To avoid breaking word, check the string ending with any words, If it is a separated with space,  then break it up.

Function definition:
function limitText($string, $limit=200, $concatStr){
     //strip tags to avoid breaking any html
     $string = strip_tags($string);
     if(strlen($string) > $limit){
          //turncate string
          $stringCut = substr($string,0,$limit+1);
          //make sure it ends in a word.
          //if the ending word is a long text and it exceeds the limit, then break it up
          $string = (strrpos($stringCut, ' '))?substr($stringCut,0,strrpos($stringCut, ' ')).$concatStr:$stringCut.$concatStr;
     return $string;
Function usage:
$limitedText = limitText($string, 100, '...');

Have any doubt, feel free to comment here!

Saturday, 11 July 2015

[Solution] Unable to load or find PHP extension php_intl.dll in WAMP 2

Recently I was started to working with CakePHP 3.x. The latest version of CakePHP needed intl extension to work with it. But I could not enable intl extension in my latest version of Wamp 2.5. So, I have got an error,

PHP Startup : Unable to load dynamic library C:/wamp/path/to/php/ext/php_intl.dll - The specified module could not be found.

We can solve it in a two ways.

Solution 1:

  1. Just go to C:/wamp/path/to/bin/php/php5.5.12/. Copy all the files starts with icu* and paste it into C:/wamp/path/to/bin/apache/apache2.2.22/bin/  directory.
  2. To enable intl extension,
    • Click on the wamp icon
    • Click on PHP
    • Click PHP extensions
    • Click on php_intl
  3. Now Restart All Services. 
Thats all... Your intl extension is enabled now... 

Solution 2:

  1. Just include the PHP directory into the system's PATH variable.
  2. Install the full Microsoft VC++ 2012 Runtime Redistributable package. Make sure to get the 32 bit version for 32 bit PHP builds.
Have any doubt, feel free to comment here!

Friday, 3 July 2015

How to use plug-in's component in our application controller - CakePHP 3 0

Here is a small How to about creating and using plugin component in application controller.

Here we are going to create 'TestingComponent' inside of 'Test' plugin, Then get 'Hello world' text from component function and print it from our application's controller.

first create 'TestComponent' class in 'YourCakeDirectory\Plugins\Test\src\Controller\Component\TestComponent.php'

Here is the most important thing we have to do with our plugin load in CakePHP bootstrap. Before calling plug-in component in application controller, we need to auto load it in CakePHP. If our plugin created using bake method, we should autoload this class in 'composer.json'. If our plugin was manually created, then we should use 'autoload' parameter as a value 'true' as a configuration parameter while loading this plugin in application's 'YourCakeDirecctory\Config\bootstrap.php'.
The bellow one is a way to load component in controller on the fly.
Now we are going to load plugin's component. So we need to use our plugin component name followed by plugin name and dot('.'). Here we are going to load 'TestingComponent' from the plugin 'Test'. So, the code will be like the bellow,

Now we will get the output of plugin's component string 'Hello World' which is echoed from our application's controller.

Have any doubt, feel free to comment here!

Monday, 4 May 2015

How to get relative path in javascript 0


We can't easily get relative paths in javascript as like server side scripts. We have use our own logic to get it. Hard coding server root path in javascript is really bad idea. So, We are going to get our server root path from already loaded resource.

Why I need this?

If you are going to do use redirection or want to load any other resource which is located another directory in your server root directory, you may need server root path. On that time you should need this.


 Assume, we are having "" and our assets in webroot directory. consider we have an external javascript file called "sample.js", add id attribute to your script tag.

And simply get the location of your javascript file during run time using javascript by parsing the DOM for the 'src' attribute that referred it:

Now we can call getRootPath() function to get the server root path. So, by our example our javascript function getRootPath() will return ""

We can also use this as webroot path by removing "webroot" string from the replace function. If we did this, we will get "" from the returned string.

Have any doubt, feel free to comment here!