DB Resource Usage

Byalexrusin December 19, 2018

You can use the following query to see who is using your database resources

SELECT max(user) as user, count(*) as connections_count, db from information_schema.processlist GROUP BY db order by connections_count desc;

Share this article

PHP MySQL Development

API Client Design

Byalexrusin September 22, 2018September 23, 2018

When you extensively work with certain APIs, like Shopify’s for example, you will end up with bunch of functions that map to API’s endpoints. One of the approaches I have seen so far is to create an API class ShopifyApi and make those functions class methods. So it looks something like the figure below. I…

Share this article

PHP MySQL Development

Exporting/Importing MySQL database from/to Remote Server

Byalexrusin June 20, 2017June 21, 2017

Export database mysqldump -u dbuser -p databasename -h rds.amazonaws.com > backup.sql Import database mysql -u username -p -h rds.amazon.com databasename < backup.sql mysql –host=rds.amazonaws.com –user=dbuser –password=password databasename < backup.sql Share this article

Share this article

Laravel | PHP MySQL Development

Debugging Webhooks

Byalexrusin August 26, 2018September 22, 2018

A webhook is an HTTP callback, that occurs when something happens (a resource changes its state). Webhooks provide a way to build event-driven apps, because you can be notified about changes. Since webhooks require a publicly accessible URL to function they can be hard to test from your local machine. There are three main problems…

Share this article

PHP MySQL Development

Setting up a PHP Application

Byalexrusin May 6, 2019May 6, 2019

When setting up a new PHP application one should consider how to manage certain housekeeping tasks such as exception handling, logging, and mail notifications.

Share this article

PHP MySQL Development

Replace Funky Characters While Importing CSV

Byalexrusin August 19, 2018August 19, 2018

Sometimes uploaded text/csv file may have non-utf8 or other funky characters using the function below. public static function processUploadedBundles($request) { $content = file_get_contents($request->file(’uploadedFile’)->getRealPath()); $lines = explode(PHP_EOL, $content); $array = []; foreach ($lines as $line) { $arrayCsv = str_getcsv($line, ","); $arrayCsv = array_map(function($value){ return preg_replace(’/[\x00-\x1F\x7F-\xFF]/’, ”, $value); }, $arrayCsv); $array[] = $arrayCsv; } return…

Share this article

PHP MySQL Development | WordPress Development

Create WordPress User with Admin Privileges in MySQL

Byalexrusin July 23, 2017July 23, 2017

INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`) VALUES (’admin’, MD5(’password’), ‘User Admin’, ‘user@admin.com’, ‘0’); INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (SELECT MAX(id) FROM wp_users), ‘wp_capabilities’, ‘a:1:{s:13:"administrator";s:1:"1";}’); INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (SELECT MAX(id) FROM wp_users), ‘wp_user_level’, ’10’);INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`) VALUES…

Share this article

Similar Posts