Category Archives: Framework

E-commerce plateform

http://laravel.demo.aimeos.org/ Advertisements

Posted in Laravel | Leave a comment

Enable GZIP in wamp server

put in .htacces on main root directory <IfModule mod_deflate.c> <FilesMatch “\.(ico|jpg|jpeg|png|gif|js|css|html|php|txt|xml)$”> SetOutputFilter DEFLATE </FilesMatch> </IfModule>

Posted in Framework | Leave a comment

http://www.responsivefilemanager.com/demo.php

Posted in Laravel | Leave a comment

Yii2 htaccess – How to hide frontend/web and backend/web COMPLETELY

Step 1 Create .htaccess file in root folder, i.e advanced/.htaccess and write below code. Options +FollowSymlinks RewriteEngine On # deal with admin first RewriteCond %{REQUEST_URI} ^/(admin) <—— RewriteRule ^admin/assets/(.*)$ backend/web/assets/$1 [L] RewriteRule ^admin/css/(.*)$ backend/web/css/$1 [L] RewriteCond %{REQUEST_URI} !^/backend/web/(assets|css)/ <—— RewriteCond %{REQUEST_URI} ^/(admin) … Continue reading

Posted in Yii2 | Leave a comment

READ NUMBER AS WORD

function convertNumberToWord($num = false) { $num = str_replace(array(‘,’, ‘ ‘), ” , trim($num)); if(! $num) { return false; } $num = (int) $num; $words = array(); $list1 = array(”, ‘one’, ‘two’, ‘three’, ‘four’, ‘five’, ‘six’, ‘seven’, ‘eight’, ‘nine’, ‘ten’, ‘eleven’, … Continue reading

Posted in PHP | Leave a comment

Accesss Store Procedure

$GeneralSearch = ”; $DepartmentID = 0; $CategoryID = 0; $Brands = ”; $Instock = 0; $PriceLevel = 0; $MinPrice = 0; $MaxPrice = 500; $Sort = 0; $db = DB::connection()->getPdo(); $stmt = $db->prepare(“EXEC [dbo].[SP_Web_Search] ?,?,?,?,?,?,?,?,?”); $stmt->bindParam(1, $GeneralSearch); $stmt->bindParam(2, $DepartmentID); $stmt->bindParam(3, … Continue reading

Posted in Laravel | Leave a comment

Select CONCATE COLUMNS

$items = Item::join(‘Department’,’Item.DepartmentID’,’=’,’Department.ID’) ->select(DB::raw(‘CONCAT(Item.Name, Department.Name) as user_count’)) ->where([‘Item.Active’=>1,’Item.WebsiteShow’=>1])->get();

Posted in Laravel | Leave a comment