Posts

OpenCart 3.0.2.0 cache issue Resolve

https://github.com/vqmod/vqmod/issues/128 https://github.com/vqmod/vqmod/issues/135 usmanalimaan Fiverr Seller Experienced Developer with a demonstrated history of working in the computer software industry. I have two year plus working experience in web development using php frameworks like Cakephp, Laravel and codeigniter and using php versions 5 and 7 , mysql , sqllite . Do have hand on practice with Restful apis. Strong engineering professional with a Bachelor’s Degree focused in Bscs from GC University Lahore.

how to update entire Category price in OpenCart

Image
We will do this by directly updating into databases Here are Steps to do this 1>Search Category by Name here is script SELECT * FROM `oc_category_description` WHERE name in ("Clothing" , "Kids dresses") 2> No get Products Prices and Special price by just provide category id SELECT   pc .product_id , category_id , p .product_id , ps .product_id , p .price , ps .price   FROM   oc_product   as   p   join   `oc_product_to_category`   as   pc   on   pc .product_id = p .product_id   JOIN `oc_product_special`   as   ps   on   p .product_id = ps .product_id   WHERE   pc .category_id = 415 3> Now its time to update prices of all Products once by updating price and special price UPDATE  oc_product as p join `oc_product_to_category` as pc on pc.product_id=p.product_id JOIN `oc_product_special` as ps on p.product_id=ps.product_id SET ps.price=0 WHERE pc.category_id=656 U...

What is ORM and Which ORM is used by CakePhp

Object Relational Mapping Object Relational Mapping, commonly referred to as its abbreviation ORM, is a technique that connects the rich objects of an application to tables in a relational database management system. Using ORM, the properties and relationships of the objects in an application can be easily stored and retrieved from a database without writing SQL statements directly and with less overall database access code. Source: http://guides.rubyonrails.org/active_record_basics.html An ORM (Object Relational Mapper) is the layer that sits between your database and your application. In Object Oriented Programming, you work with Objects as your main point of reference. source:  http://culttt.com/2014/06/18/whats-difference-active-record-data-mapper/

Valid Resource or URl

How to install Sublime Text 3 How to install Xampp from Fedora  or https://askubuntu.com/questions/679685/chmod-cannot-access-xampp-linux-x64-5-6-12-0-installer-run-no-such-file-or-d

OPEN Cart Find Parent Categories and there Child Categories list in Ms Excel export

OPEN Cart Find Parent Categories and there Child Categories list in Ms Excel export SELECT   pd . `name` , cd . `name`   FROM   `oc_category`   as   ct   left   JOIN   `oc_category`   as   pt   ON   ct . `parent_id`   =   pt . `category_id`   left   JOIN   `oc_category_description`   cd   ON   ct . `category_id` =   cd . `category_id`   left   JOIN   `oc_category_description`   pd   ON   pt . `category_id`   =   pd . `category_id`   ORDER   BY   pd .name

ACl implementation in Cakephp

Basic understanding what ACl is in Cakephp

how to get direct urls

Get end urls from deep link