PHP date function

Leave a reply

Some useful date hacks

  1. Display only date when receiving full datetime type from MySQL
echo date('Y-m-d',strtotime($mysql_datetime));

2. Add or subtract x days or months to a date.

link

Laravel Notes

Leave a reply

Useful Resources

  1. Official website
  2. Laravel 5 fundamental tutorials on laracasts
  3. Composer – dependency manager for PHP
    1. click on “Browse Package” to go to packagist.org to search for packages
  4. List of laravel resources – base project, cheat sheet, community etc
  5. Laravel cheat sheet
  6. Laravel cheat sheet 2
  7. Model & migration generator
  8. View generator

Quick notes (I’m using a Mac)

Downloading composer

  1. Run this in terminal
    1. curl -sS https://getcomposer.org/installer | php
  2. Once successful
    1. You got a message
    2. A file composer.phar on current directory
    3. To run the file, type
      1. php composer.phar
  3. Or move to globally accessible directory
    1. mv composer.phar /usr/local/bin/composer
  4. To download a package (example). This download requires Git to be installed
    1. composer require laravel/laravel
    2. wait for composer to download all the packages and update the .json file

Create a laravel project

  1. Run this command on terminal. You better set your current directory to web directory
    1. composer create-project –prefer-dist laravel/laravel blog

Commonly-used Artisan Command

  1. php artisan list (to list all artisan commands available)
  2. php artisan –version (to view laravel version)
  3. php artisan help <command_name> (to view help for a command)
  4. php artisan make
    1. php artisan make:controller <fooController> –resource (create a resource controller with default methods. i.e. index, show, create, store, edit, update, destroy)
    2. php artisan make:model Student –migration (will create a model of student and database migration of students table)
    3. php artisan make:migration create_users_table (will create a migration file in database/migration directory)
  5. php artisan migrate (to migrate database)
    1. php artisan migrate –seed (migrate database and load seeder)
    2. php artisan migrate:status
    3. php artisan migrate:refresh (remove all and remigrate)
    4. more about migration

  6. composer dump-autoload – to regenerate autoload files. especially when error run migrate or db seed. 

Package browsers

  1. packalyst.com (laravel only)
  2. packagist.org (php packages)

Some useful packages/sample applications

  1. laravel admin package – voyager
  2. open source laravel crm – flarepoint

Laravel Homestead and Valet

  1. Haven’t had time to go through yet
  2. Valet is not using vagrant and very simple
  3. Only run on mac

Other resources

  1. Laravel cheat sheet

Setting up Gmail to receive and reply email from other email

Leave a reply

Steps to set up

  1. to receive email from x email in gmail (forward)
  2. reply from gmail using that x email address

A. Setting up the forwarding (example below is from another gmail. If from other emails may be differeent. e.g. from zoho mail)

  1. Go to Settings > Forwarding and POP/IMAP
  2. Click on “Add a forwarding address”
  3. Complete the process

B. Setting up to reply via gmail

  1. Add account
    1. Settings > Accounts
    2. Click on “Add another email address you own”
    3. Fill up the forms
    4. Verify the email address by clicking on the link sent

 

DigitalOcean – Notes

Leave a reply

This is my notes on digital ocean.

Click here to register with DigitalOcean and get free USD10 to start using the service.

I used to install Ubuntu 14.04 with LAMP on it. With this also get SFTP ready.

Manage users and groups

Change root password. If logged in as root

  • passwd

Add new user

  • adduser is perl script to simplify original useradd function
  • command – adduser username_here
  • just answer all questions asked
  • This add user function will …
    • Create the user named username.
    • Create the user’s home directory (default is /home/username and copy the files from /etc/skel into it.
    • Create a group with the same name as the user and place the user in it.
    • Prompt for a password for the user.
    • Prompt for additional information on the user.
  • allow user for sudo mode (optional) – usermod -a -G sudo <your username>
  • add user to group – adduser username groupname
  • more on adduser
  • and more

Manage groups for user

  • list group – cat /etc/group
  • add user to group – adduser usrname groupname

Manage services

Connect to server via SSH, in terminal type the following:

  • ssh username@yourdomain_or_ip

To get default MySQL root password, write this in terminal. Remove the file once done change the MySQL root password.

  • cat /etc/motd.tail

To enter mysql console

  • mysql -u root -p

Secure MySQL server. Run following command and answer all the questions.

  • mysql_secure_installation

To change MySQL root password:

  • mysqladmin -u root -p’oldpassword’ password newpass

To only allow certain IP to access directly to database

  • edit file /etc/mysql/my.cnf
  • comment line with IP 127.0.0.1
  • restart service – service mysql restart
  • enter following command in mysql command line
    • type mysql -u root -p
    • enter password when asked
  • mysql> GRANT ALL ON database_name.* TO user@xx.xxx.xx.xx IDENTIFIED BY ‘your_password’;
    • xx.xxx.xx.xx is the remote IP to access the server

Enable .htaccess (mod rewrite)

  • enable mod rewrite – sudo a2enmod rewrite
  • update file /etc/apache2/apache2.conf
  • change Override none to Override all for web root directory
  • restart service

To restart services (can also use stop and start)

  • service mysql restart
  • service apache2 restart

Install sendmail service (used by PHP mail function)

  • apt-get install sendmail
  • Run the sendmail config and answer ‘Y’ to everything: sendmailconfig

Server general settings

Change permission for directory (especially for ‘upload’ directory)

  • chmod 755 /path/directorypath

Change the timezone. By default using US time zone

  • sudo dpkg-reconfigure tzdata
  • follow instruction on screen
  • check if the date is correct by typing – date

To turn off server

  • sudo shutdown -h now
  • OR
  • sudo poweroff

Check for disk utilization

  • to check for disk utilization
    • df -h
  • to check for huge files location
    • sudo du -a / | sort -n -r | head -n 10
  • check for huge file (another option)

    • find / -size +50M -ls

Securing the server

To update/upgrade OS

  • aptitude update
  • aptitude upgrade

Disable root login on SSH

  • edit /etc/ssh/sshd_config
  • set PermitRootLogin no
  • restart ssh – service ssh restart

Block IP’s from accessing certain services

Other measures:

  1. Disallow access to server via root username
  2. Disallow access directly to database from outside
  3. Close all unused ports. Left only web, SFTP, MySQL, SSH
  4. auto patch?

To explore

  • using VPN
  • using SSH key
  • creating ftp user to access only certain directory
  • virtual host (multiple domains for a server)
  • security for 777 chmod directory
  • change ssh port to different port (but still below 1024)
  • install fail2ban to protect against brute force attack

Additional tools

  1. Ansible.com
  2. Docker.com

Other reading and references

  1. Securing the server (SSH, VPN etc)
  2. Initial setup for Ubuntu 14.04

Editors

vi, vim, nano

Click here to register with DigitalOcean and get free USD10 to start using the service.

CodeIgniter – How to remove index.php in URL

Leave a reply

2 simple steps.

1. Create or update the .htaccess as follow

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php/$1 [L]

OR

RewriteEngine On
RewriteBase /app/
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /app/index.php [L]

OR
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?/$1 [L]

ErrorDocument 404 /index.php

2. Update the config/config.php file to this

$config[‘index_page’] = ”;

List of payment gateway

Leave a reply

Below are the list. Haven’t had time to review in details. Some for Malaysia, some other from outside but used by many countries including Malaysia.

Old players

  • ipay88.com
  • molpay.com
  • paypal.com (outside) – 3.9% + rm2 per transaction
  • 2checkout (outside)
  • senangpay.my – rm300/yr subscription, 2.5% for credit card, 1.5% for FPX
  • billplz.com – free registration, rm1.50 per transaction. no credit card
  • jompay.com.my (by BNM subsidiary)

Minimum bootstrap template using CDN

Leave a reply 
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
    <meta name="description" content="">
    <meta name="author" content="">
 
    <title>Title here</title>
 
    <!-- Bootstrap core CSS -->
    <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css" rel="stylesheet">
 
    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/html5shiv/3.7.2/html5shiv.min.js"></script>
      <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
  </head>
 
  <body>
 
    <div class="container">
 
      <div>
          <h1>Heading here</h1>
          <p>Content here</p>
      </div>
 
    </div><!-- /.container -->
 
 
    <!-- Bootstrap core JavaScript
    ================================================== -->
    <!-- Placed at the end of the document so the pages load faster -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
  </body>
</html>