Ajit N

CONCAT_WS() function

MySQL CONCAT_WS() function is used to join two or more strings with a separator. The separator specified in the first argument is added between two strings. The separator itself can be a string. If the separator is NULL the result is NULL. Syntax : [crayon-58d31345ecc02619119205-i/] [crayon-58d31345ecc08207456415/]    Read more …
keithg

Site redirect non www to www within folder

Add in .htaccess   Without folder : [crayon-58d31345ed0b4559682785/]   With Folder : <IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{HTTP_HOST} !^www\. RewriteCond %{REQUEST_URI} ^/folder/ RewriteRule ^(.*)$ https://www.xyz.com/folder/$1 [R=301,L] </IfModule>Read more …

Get actual URL in Cakephp without replacing plus (+)

In Cake PHP If URL has plus(+) sign, and get url with $this->params. then + will be raplced with space. SO for getting actual URL just change your .htaccess Go to app/webroot/.htaccess replace RewriteRule ^(.*)$ index.php?url=$1 [QSA,L] to RewriteRule ^(.*)$ index.php?url=$1 [QSA,L,B]Read more …