How to update Magento order status and state using REST API and PHP

Posted on October 12, 2018October 12, 2018 by admin

Here’s a snippet on how to update your Magento order status (or/and state) using Magento’s REST API and PHP via cURL. function sign($method, $url, $data, $consumerSecret, $tokenSecret) { $url = urlEncodeAsZend($url); $data = urlEncodeAsZend(http_build_query($data, ”, ‘&’)); $data = implode(‘&’, [$method, $url, $data]); $secret = implode(‘&’, [$consumerSecret, $tokenSecret]); return base64_encode(hash_hmac(‘sha1’, $data, $secret, true)); } function urlEncodeAsZend($value) Read more about How to update Magento order status and state using REST API and PHP[…]

QUICKTIP: IsNumeric() function equivalent in MySQL

Posted on January 30, 2018January 30, 2018 by admin

Here’s how to select all numeric values in a MySQL field and vice versa. We will use the REGEXP operator in MySQL and will try to mimic the ISNUMERIC() function of Transact-SQL. Filter all numerical values in a table field SELECT * FROM table WHERE col1 REGEXP ‘^-?[0-9]+$’ Filter all non-numerical values in a table Read more about QUICKTIP: IsNumeric() function equivalent in MySQL[…]

DFA Passport Appointment Calendar tool by NetPinoy

Posted on November 9, 2017November 9, 2017 by admin

NetPinoy has just launched an online realtime Department of Foreign Affairs Passport Appointment Calendar tool that can let you see DFA branches which have available dates for passport application and renewal appointment. You will be presented with a calendar layout page where you can see at first glance which DFA branches have the available dates. Read more about DFA Passport Appointment Calendar tool by NetPinoy[…]

How to fix “Cross-Origin Request Blocked” error

Posted on November 3, 2017 by admin

I had this problem when I am in the process of migrating my web services files into another server. My web services files on where the third party users connect to my application suddenly stopped working and had this error when connecting to them: Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote Read more about How to fix “Cross-Origin Request Blocked” error[…]

BCRemit Money Transfer from UK to Philippines review

Posted on October 18, 2017October 18, 2017 by admin

My experience with the new BCRemit Money Transfer from UK to Philippines is great. The exchange rate is very competitive and the transfer rates are very low compared to other money transfer facilities. Currently they are only processing from UK to Philippines, Great Britain pound to Philippines peso, but hopefully they can cater to other Read more about BCRemit Money Transfer from UK to Philippines review[…]

Cebu Pacific Air Flight 5J 461 veered off runway incident

Posted on October 14, 2017October 14, 2017 by admin

Cebu Pacific Air Flight 5J 461 from Manila going to Iloilo veered to the side of runway after landing at the Iloilo International Airport at around 11pm October 14, 2017. The aircraft is carrying 180 passengers and 6 crews are safe. Due to this incident, Iloilo International Airport has been closed temporarily. Flights that are Read more about Cebu Pacific Air Flight 5J 461 veered off runway incident[…]

How to center NextGen gallery thumbnails on layout

Posted on October 13, 2017October 13, 2017 by admin

If you are using NextGen Gallery (NGG Gallery) on your wordpress site as a gallery plugin, you would notice that the block of thumbnails in the page is not centered, and it makes the layout awful to view. here is a simple CSS modification on how to center it into your page div layout. This Read more about How to center NextGen gallery thumbnails on layout[…]

Google Maps not working when files are transferred to live hosting

Posted on October 2, 2017October 3, 2017 by admin

I had developed a website from the SinglePro theme and everything looks fine on localhost. However, when I had transferred the files to the live hosting, the Google Maps suddenly stopped working: I had looked at the console and I had seen error like this: “Google Maps API error: MissingKeyMapError https://developers.google.com/maps/documentation/javascript/ error-messages#missing-key-map-error” js:40:473 “Google Maps Read more about Google Maps not working when files are transferred to live hosting[…]

RyanTetek.com v2.0 is now online!

Posted on August 27, 2017 by admin

Way back 2009, 8 years ago, I had started RyanTetek.com as my portfolio site and to serve as a web development as well. Here’s a screenshot of it from archive.is (brings back memories and makes me feel nostalgic): I had also put it in maintenance mode around 2 years ago due to being very busy Read more about RyanTetek.com v2.0 is now online![…]