Software Engineering

After 3 years, I am using Laravel again at work. Laravel has extensive documentation but sometimes it can be a bit verbose. Here are command to get you started as soon as possible. This assumes pretty much fresh install of MacOS. Install Homebrew Check the official site for latest command /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" Install PHP 7.1 brew install homebrew/php/php7 Install MariaDB brew install mariadb Set MariaDB to start as service at the end of installation. ...

SELECT w1.website_id, w1.name as website_name, s1.store_id, s1.name as store_name, p1.entity_id as product_id, p1.sku, pname.value as product_name, url.value as url_path, small_image.value as small_image, msrp.value as msrp_price, price.value as price, p1.created_at as product_created_at, p1.updated_at as product_updated_at, visibility.value as visibility, pstatus.value as status, case when (pstatus.value = 1 and visibility.value > 1 ) then 1 else 0 end as enable_flag, c1.entity_id as category_id, cname.value as category_name, c1.parent_id, c1.created_at as category_created_at, c1.updated_at as category_updated_at FROM catalog_product_entity p1 inner join eav_attribute p_attr ON p1.entity_type_id = p_attr.entity_type_id and p_attr.attribute_code = 'name' inner join catalog_product_entity_varchar pname ON pname.entity_id = p1.entity_id and pname.attribute_id = p_attr.attribute_id inner join eav_attribute p_attr2 ON p1.entity_type_id = p_attr2.entity_type_id and p_attr2.attribute_code = 'url_path' inner join catalog_product_entity_varchar url ON url.entity_id = p1.entity_id and url.attribute_id = p_attr2.attribute_id and pname.store_id = url.store_id inner join eav_attribute p_attr3 ON p1.entity_type_id = p_attr3.entity_type_id and p_attr3.attribute_code = 'small_image' inner join catalog_product_entity_varchar small_image ON small_image.entity_id = p1.entity_id and small_image.attribute_id = p_attr3.attribute_id and pname.store_id = small_image.store_id inner join eav_attribute p_attr4 ON p1.entity_type_id = p_attr4.entity_type_id and p_attr4.attribute_code = 'msrp' inner join catalog_product_entity_decimal msrp ON msrp.entity_id = p1.entity_id and msrp.attribute_id = p_attr4.attribute_id and pname.store_id = msrp.store_id inner join eav_attribute p_attr5 ON p1.entity_type_id = p_attr5.entity_type_id and p_attr5.attribute_code = 'price' inner join catalog_product_entity_decimal price ON price.entity_id = p1.entity_id and price.attribute_id = p_attr5.attribute_id and pname.store_id = price.store_id inner join eav_attribute p_attr6 ON p1.entity_type_id = p_attr6.entity_type_id and p_attr6.attribute_code = 'visibility' inner join catalog_product_entity_int visibility ON visibility.entity_id = p1.entity_id and visibility.attribute_id = p_attr6.attribute_id and pname.store_id = visibility.store_id inner join eav_attribute p_attr7 ON p1.entity_type_id = p_attr7.entity_type_id and p_attr7.attribute_code = 'status' inner join catalog_product_entity_int pstatus ON pstatus.entity_id = p1.entity_id and pstatus.attribute_id = p_attr7.attribute_id and pname.store_id = pstatus.store_id inner join catalog_category_product ccp ON ccp.product_id = p1.entity_id inner join catalog_category_entity c1 ON c1.entity_id = ccp.category_id inner join eav_attribute c_attr ON c1.entity_type_id = c_attr.entity_type_id and c_attr.attribute_code = 'name' inner join catalog_category_entity_varchar cname ON cname.entity_id = c1.entity_id and cname.attribute_id = c_attr.attribute_id and pname.store_id = cname.store_id inner join catalog_category_product_index store1 ON store1.product_id = p1.entity_id and store1.category_id = c1.entity_id inner join core_store s1 ON store1.store_id = s1.store_id inner join core_website w1 ON s1.website_id = w1.website_id

I have been playing with OpenShift for past several hours. It looks great. But a while back I started to get 503 Internal Server error. When I checked logs using rhc tail , I saw this error: Layer 7 Wrong Status, Invalid Response 404. I spent an hour or so troubleshooting. Turns out the issue was Netbeans had added src/main/web/app/WEB-INF/jboss-web.xml when I ran the application locally on my machine. I committed this file, thinking I might need it. Deleting it from repo fixed the issue. ...

if ($num == (int) $num) { // It's whole } else { // It's not }

/** * Cleans up multi-dimensional arrays. * 1st dimension is a simple index * 2nd dimension includes the desired keys * * @param mixed $array * @param mixed $keysToInclude */ public function cleanUpArray($array, $keysToInclude) { $returnArray = array(); $i = 0; foreach($array as $item){ foreach($keysToInclude as $key){ $returnArray[$i][$key] = $item[$key]; } $i++; } return $returnArray; }

Are you tired of checking data in your code before inserting? Well MySQL procedures are here to rescue. This simple procedure shows how you can do that: CREATE PROCEDURE ` update_insert_user ` ( IN uid2 int ) BEGIN DECLARE last_login2 DATETIME; SELECT ` last_login ` INTO last_login2 FROM ` user ` WHERE ` uid ` = uid2 LIMIT 1 ; IF last_login2 IS NULL THEN INSERT INTO ` user ` ( ` uid ` , ` last_login ` ) values (uid2, now()); ELSE UPDATE ` user ` SET ` last_login ` = now() WHERE ` uid ` = uid2 LIMIT 1 ; END IF ; END

Just spent 3 hours debugging a session bug in my webapp. CodeIginter was creating a brand new session with each page load. The issue was a misconfiguration with my config file. Fix was simple, in /application/config/config.php, make sure correct domain is set for $config['cookie_domain'].

Query Saving is a feature of CI’s database class that stores the results of every query in memory until the controller is finished executing. As it turns out, in version 1.6.0, the ability to turn this off was added. The addition of the save_queries variable is listed in the Change Log, but as of the latest release of 2.0.0 last week, it still hasn’t made the documentation. $this->db->save_queries = FALSE; via Undocumented CodeIgniter | Green Egg Media. ...

I tried to login to my server tonight but kept getting following error message: ssh_exchange_identification: Connection closed by remote host The fix was simple, at least if you have access to server via cPanel. Just restart sshd service via cPanel/WHM.

Using sar, you can also collect all performance data on an on-going basis, store them, and do historical analysis to identify bottlenecks. via 10 Useful Sar (Sysstat) Examples for UNIX / Linux Performance Monitoring.