RyanTetek
News and updates that you might be interested in reading.
Before, I am using PHPExcel library to create, parse, and manipulate excel and csv files in Laravel. However, the project was officially deprecated in 2017 and permanently archived in 2019. The authors recommended migrating to PhpSpreadsheet as an alternative. Most of the functions of PhpSpreadsheet is similar to PHPExcel so it’s easy to transition between Read more about How to install PhpSpreadsheet in Laravel[…]
When you are using Laravel insertGetId() method to insert a record and retrieve the ID and is consistently 2147483647 value, but when you check the database it is not the normal value you would expect, it is because your PHP is running in 32bit mode and the range of the int value on this mode Read more about Laravel Database Query Builder insertGetId() method always returning 2147483647[…]
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[…]
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[…]
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[…]
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[…]
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 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[…]
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[…]
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[…]