You have to build the GMP extension from the PHP source code. First install Autoconf and GMP using Homebrew.
brew install autoconf gmpDownload and unpack PHP.
| DROP TABLE IF EXISTS time_dimension; | |
| CREATE TABLE time_dimension ( | |
| id INTEGER PRIMARY KEY, -- year*10000+month*100+day | |
| db_date DATE NOT NULL, | |
| year INTEGER NOT NULL, | |
| month INTEGER NOT NULL, -- 1 to 12 | |
| day INTEGER NOT NULL, -- 1 to 31 | |
| quarter INTEGER NOT NULL, -- 1 to 4 | |
| week INTEGER NOT NULL, -- 1 to 52/53 | |
| day_name VARCHAR(9) NOT NULL, -- 'Monday', 'Tuesday'... |
| #!/bin/bash | |
| # ------------------------------------------------- | |
| # Make site directory | |
| # Download WP and install WP to site directory | |
| # Set WP configuration | |
| # Configure NGINX for new domain-name | |
| # ------------------------------------------------- | |
| # apt-get update |
| # Use with EXTREME CAUTION | |
| DELETE FROM wp_users WHERE ID IN ( SELECT user_id FROM wp_usermeta | |
| WHERE meta_key = 'wp_capabilities' AND meta_value LIKE '%subscriber%' | |
| AND user_id NOT IN ( SELECT user_id FROM wp_usermeta | |
| WHERE meta_key = 'billing_first_name' AND meta_value != '' | |
| AND user_id IN ( SELECT user_id FROM wp_usermeta | |
| WHERE meta_key = 'wp_capabilities' AND meta_value LIKE '%subscriber%' ) ) ) | |
| DELETE FROM wp_usermeta WHERE user_id IN ( SELECT user_id FROM wp_usermeta |
| <?php | |
| class Common | |
| { | |
| /*--------------------- $_GET & $_POST ----------------- START */ | |
| /** | |
| * Get $_GET content, array or array item in filtered way | |
| * | |
| * @param object $parameter could be array or array item |
| { | |
| "preset": "psr12", | |
| "rules": { | |
| "align_multiline_comment": true, | |
| "array_indentation": true, | |
| "array_syntax": true, | |
| "blank_line_after_namespace": true, | |
| "blank_line_after_opening_tag": true, | |
| "combine_consecutive_issets": true, | |
| "combine_consecutive_unsets": true, |
sudo apt install mysql-client
or
sudo apt-get install mysql-client
; PHP's default character set is set to UTF-8.
| /** | |
| * Create a Symfony response for the given exception. | |
| * | |
| * @param \Exception $e | |
| * @return mixed | |
| */ | |
| protected function convertExceptionToResponse(Exception $e) | |
| { | |
| if (config('app.debug')) { | |
| $whoops = new \Whoops\Run; |
| // ------------------------------------------------------------------------------------------------------------------// | |
| // vWorkApp Core Library | |
| // ------------------------------------------------------------------------------------------------------------------// | |
| var vWorkAppScript = vWorkAppScript || {}; | |
| vWorkAppScript.host = "api.vworkapp.com"; | |
| vWorkAppScript.apiToken = "PUT YOUR API KEY HERE" | |
| (function() { |