This post covers the Prepared Statements section of the Databases chapter when studying for the Zend PHP 7 Certification.
Many databases support the concept of prepared statements. They can be thought of as a kind of compiled template for the SQL that an application wants to run, that can be customised using variable parameters. Some ...
This post covers the Joins section of the Databases chapter when studying for the Zend PHP 7 Certification.
An SQL JOIN clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to each.
The main types ...
This post covers the SQL section of the Databases chapter when studying for the Zend PHP 7 Certification.
SQL is a standard language used for accessing and manipulating databases. Within a database there consists one of more tables.
A primary key is a field in a table which uniquely identifies each row/record in a database ...
This post will demonstrate how to programmatically create an order in Magento 2 Open Source version 2.2 using both guest and registered customers. There is a possibility that the code will work with other versions of Magento 2, however it has not been tested with them.
The code shown below will be contained within a ...
There may be occasions where you need to modify core Magento functionality using an external script. You might do this to import and export data from Magento or to add, modify or remove data quickly. To bootstrap and use Magento 2 in an external file requires a few lines of code to be added at ...
When your WordPress system states there is an new version available to update, you can upgrade WordPress within the admin itself. However, if you have a WordPress site on a production environment, then understandably you might be a bit cautious about upgrading WordPress on a live site without any testing. Should you version control your ...
When developers set up test environments of production websites, often the database dump used for the development site contains real customer and order data. Usually this data should be removed from development environments for security reasons. You might also fail tests from compliance scanning software. To create a Magento database dump without sensitive data is ...
When using MAMP and the phpMyAdmin interface provided, there may be times when you struggle to import and export large databases, perhaps due to timeout issues. Importing and Exporting Databases in MAMP using a command line interface will eradicate any problems with large database files.
MAMP provides mysql and mysqldump executable files within the Applications/MAMP/Library/bin ...
To go about testing PayPal Express sandbox orders in Magento 2 using the API Signature credentials is similar to how you test them in Magento 1. Simply get your details from your PayPal account and copy them into the Magento 2 admin.
Testing PayPal Express sandbox in Magento allows you to check for any ...
The checkout and the integrated payment methods are a crucial part of the Magento application. The inbuilt PayPal payment methods that Magento provides allow payments to be taken through PayPal, and it is vital to ensure the configuration is working correctly before using PayPal in live mode. Testing PayPal Express Sandbox in Magento can be ...