GitHub Cheat Sheet

SQL JOINS Cheat Sheet

GIT Cheat Sheet

How to setup Wordpress on Windows with XAMPP server

Hi, you might need a website, a blog, or a web app. You heard Wordpress but did not know how to start, this tutorial is perfect for you. First, you need to have a practice Wordpress site on your computer so that anytime-anywhere with your computer with you, you can try to play around with Wordpress.     

So today, I would like to make a tutorial for beginners on how to setup a Wordpress CMS on your local Windows machine.

If you do not have any web server installed on your machine, or in other case you like a windows development environment. You might need something like XAMPP or Cross-Platform (X), Apache (A), MariaDB (M), PHP (P) and Perl (P). Click here if you like to setup your XAMPP first. Of course there are other web server like MAMP, LAMP, and WAMP but for this tutorial I prefered XAMPP.

If you already installed and configured XAMPP you might see this page once you open http://localhost on your browser.

For beginners, XAMPP is an ideal local development environment, and its not meant for production deployments. As stated at XAMPP local dashboard page. However, if you need the real deal then XAMPP suggest to go here https://www.apachefriends.org/hosting.html

Let say you already setup your XAMPP.

1.) Open your web browser (in my case I have Google Chrome) then navigate to https://wordpress.org/download/

2.) Click Download Wordpress 4.9.1 (by the time of this post)

3.) Locate htdocs. Usually it is located at C:\xampp\htdocs
4.) Check wordpress filename. Initially it is a compressed zip file
5.) Click save button

6.) Once you have finished downloading a 9.9 MB wordpress-4.9.1.zip file, click the small down arrow button
7.) Then, click Show in folder menu (this will pop up the XAMPP htdocs window)

8.) Right click the wordpress-4.9.1 file then click Extract Here (using winrar)

9.) Then you will see Winrar extracting
10.) the wordpress folder

11.) Open your web browser and navigate to http://localhost/wordpress

12.) Select the language of your choice

13.) Then, click Continue button

14.) Click Let's go! button

Then you should see the next page which is related to database connection details. Skip this for a while because we need to make sure that the wordpress installation do not halt with errors due to the absence of the database that are needed by wordpress.

15.) So wee need add wordpress database first. Open another browser or another tab of the Google chrome browser and navigate to http://localhost/phpmyadmin

16.) Login the root account

17.) Then click Go button

18.) Now you should logged-in to the phpMyAdmin and click New button

19.) Type the name of the database that you need to add. This time type wordpress

20.) Then, click Create button

21.) Now go back to the previous page(wordpress installation page) wherein you are about to fill up some database connection details. Fill up all the information needed to create the connection of wordpress to its database. For this instance please follow below:

• Database Name : wordpress
• Username: root
• Password: [the password you have setup for root]
• Database Host: localhost (leave as is)
• Table Prefix : wp_ (leave as is)

22.) Click Submit button

23.) Now click Run the installation button.

24.) On my local XAMPP server, it just take almost 5 seconds to show up with this page. You just need to fill up the information needed for the final setup of wordpress.

• Site Title : [your choice of website title] 
• Username : [your initial wordpress admin user]
• Password : [your initial wordpress admin password]
• Your Email : [provide your initial wordpreass admin email address]
• Search Engine Visibility : [just leave uncheck if you to discourage search engine to index your site, anyway this is just your development environment setup, so either way should OK]

25.) Finally, click Install Wordpress button, and wait for wordpress to finish the installation process

26.) After waiting for almost 2 minutes, wordpress installation successfully finished. Then click on the Log In button to proceed.

27.) Then type your Login credentials

28.) And click the Log In button

29.) Congratulations! you are now Logged in to the Wordpress administration page

30.) To logout, hover the mouse on the upper right corner of wordpress administration page

31.) Then click Log Out menu

33.) Then you will be redirected to http://localhost/wordpress/wp-login.php?loggedout=true, or you may go to http://localhost/wordpress/wp-admin to Login again

32.) To see your wordpress site open a Google chrome browser and navigate to http://localhost/wordpress

The wordpress front page has a one page design by default. Changes you made in the administration page will be affected the front page.

On my future articles:

• How to create customized themes on Wordpress
• How to create plugins

References:

wordpress.org

Moodle: Network setup using dynamic or multiple IP in wwwroot

If you have multiple NIC to be used for local and public access. Sometimes you are facing this kind of problem in Moodle. All you have to do is change a PHP variable in config.php inside moodle web directory.

$CFG->wwwroot

value with :

$CFG->wwwroot = 'http://'.$_SERVER["HTTP_HOST"];

Special Characters

Alt + 0153..... ™... trademark symbol
Alt + 0169.... ©.... copyright symbol
Alt + 0174..... ®....registeredtrademark symbol
Alt + 0176 ...°......degre­e symbol
Alt + 0177 ...±....plus-or­-minus sign
Alt + 0182 ...¶.....paragraph mark
Alt + 0190 ...¾....fractio­n, three-fourths
Alt + 0215 ....×.....multi­plication sign
Alt + 0162...¢....thecent sign
Alt + 0161.....¡......upside down exclamation point
Alt + 0191.....¿.....­upside down question mark
Alt + 1...........smiley face
Alt + 2 ......☻.....bla­ck smiley face
Alt + 15.....☼.....su­n
Alt + 12......♀.....female sign
Alt + 11.....♂......m­ale sign
Alt + 6............s­pade
Alt + 5.............­Club
Alt + 3............. ­Heart
Alt + 4.............­Diamond
Alt + 13......♪.....e­ighth note
Alt + 14......♫......­beamed eighth note
Alt + 8721.... ∑.... N-ary summation (auto sum)
Alt + 251.....√.....s­quare root check mark
Alt + 8236.....∞.....­infinity
Alt + 24.......↑.....­up arrow
Alt + 25......↓......­down arrow
Alt + 26.....→.....ri­ght arrow
Alt + 27......←.....l­eft arrow
Alt + 18.....↕......u­p/down arrow
Alt + 29......↔... left right arrow

How to make linux ghost image

Creating or Restoring a drive image locally

1. Boot to the G4L CD. Select the newest kernel.
2. Once everything loads, you will see some disclaimers. Hit "enter" until you get to a command prompt.
3. Type "g4l" and hit enter to run G4L. Select "YES" to accept the disclaimer.
4. Select "RAW Mode", then "Local Use"
5. Select "Pick drive", then choose the drive where the image file will be saved (or where it is located, if you are restoring)
6. Select "config filename".
   1. If you are backing up, enter the name of the image file you will create.
   2. If you are restoring, enter the name of the image file you want to restore.
7. Begin the operation
   1. If you are backing up a drive/partition, select "backup". Choose the drive or partition to backup.
   2. If you are restoring, select "restore". Choose the drive or partition you want to restore to.
      

There are a few other options here for special circumstances. For instance, if you are backing up to a FAT32 or similar partition, you may want to turn on File splitting to avoid going over file size limitations. If you are backing up or restoring an NTFS partition (and only the partition, not the whole drive), you can use NTFSClone backup/restore to save time and space. You can also choose a method of compression to use on the image file; the default, lzop, is recommended.
NOTE: you must restore with the same compression setting you saved with. I recommend putting the compression method in the image file name, e.g. "myharddrive.img.lzop". Also, normal backup/restore is incompatible with NTFSClone backup/restore. If you use NTFSClone, you might want to note that in the filename as well, e.g. "myWindowsDrive.ntfs.img.lzop". 

Install nano on pfSense

 pkg_add -r ftp://ftp-archive.freebsd.org/pub/FreeBSD-Archive/ports/i386/packages-8.1-release/Latest/nano.tbz  

or

on terminal
ssh to your pfsense

then, copy paste the code above
and press enter

then, try nano by typing nano

congrats, you will get nano editor on pfsense

How to fix Starting emulator for AVD 'androidname' PANIC: Could not open: androidname on MAC OSX

On MAC OSX you may encounter this error when you programming in android using Android SDK on Eclipse Kepler. This happens when you logged in to your root account and by trying to run a specific android avd and nothing happens.

Starting emulator for AVD 'androidname'
PANIC: Could not open: androidname

Install PFSense+Lusca-Cache in VirtualBox and use a separate virtual drive as its cache

pfSense is an another type of protection for our vulnerable network. A modular router that can be customize base on your network needs. It has the ability to act as a router or a firewall, or even your cache server which means all your youtube, facebook, and other sites has being temporarily saved in a storage and soon if someone in your LAN access the same website it can instantly retrive or view without the irony of web page reload or to buffer the video again. That's why your internet might become faster

How to Triple boot MacOSX Mountain Lion, Windows 7, and Ubuntu

Triple boot

MAC Mountain Lion, Windows 7, and Ubuntu 12.04

Ok.

I need to write this tutorial while it’s still fresh in my mind. I’m very happy that once again after days of hard work, I finally succeeded this challenge. To boot three (3) different operating system is too hard, aside  they aren’t play nice with each other you must also consider some hardware issues.