HalimZamal

cd ~
sudo apt-get update

1. Install PHP and Nginx

#apt-get install software-properties-common

sudo apt-get -y install nginx php7.0 php7.0-fpm php7.0-mbstring php7.0-xml git composer

2. Config Nginx

HalimZamal

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

HalimZamal

// Thank you for your support! https://www.buymeacoffee.com/Developers
// Find detailed tutorial with screenshots here: https://medium.com/@ipradeep/mysql-to-google-spreadsheet-1d5a09d787a4


// Write data from Google Spreadsheet into MySQL 
//https://medium.com/@ipradeep/google-spreadsheet-to-mysql-f0c390bc9e5f

function myMySQLFetchData() { 
  
  var conn = Jdbc.getConnection('jdbc:mysql://127.0.0.1:3306/employee_db', 'username', 'pass'); // Change it as per your database credentials

HalimZamal

Deploy your site with git

This gist assumes:

• you have a local git repo
• with an online remote repository (github / bitbucket etc)
• and a cloud server (Rackspace cloud / Amazon EC2 etc)
  • your (PHP) scripts are served from /var/www/html/
  • your webpages are executed by apache
• apache's home directory is /var/www/