Posts

Showing posts with the label PROGRAMMING

Custom Routing- Rewriting .htaccess file

Image

Vagrantfile

Image
This Vagrant file will create virtual environment with mysql, php, apache installed on ubuntu17.

Design Patterns in PHP

Image

Language Neutral Formats

Image

TCP/IP Protocol Suite Explained

Image
Communication between 2 machines on a network are done through different protocol suits and TCP/IP is one of them. Well Explained in this video: tcp/ip layers LAYER FUNCTIONALITY Application Data that is sent by the user.             EX: Any script, file, form data etc., Transport Data from application layer is broken down into segments. Each segment is named with sequence id so that they are received and appended in the right order in the receiver end.  The transport header is added to each segment in this layer, which is having the destination and source address with the port number. Internet In this layer Internet header is added to segment, which contains source and destination IP address and routing information [How to reach receiver] Network In this layer Network header is added to segment, which contains source and destination physical address [mac address, ethernet] In this...

MySQL in Short

Image
NOTES : Remember to put a semicolon at the end of your SQL statements. The ; indicates that your SQL statment is complete and is ready to be interpreted. Strings must be in single quotes. The percent sign "%" can be used as a wild card to match any possible character that might appear before or after the characters specified.     ACTION QUERY Match any first names that start with ' Er ' SELECT  first, last, city   FROM  empinfo WHERE  first LIKE 'Er%'; Match any last names that end in a ' s ' SELECT first, last FROM empinfo WHERE last LIKE '%s'; Select rows where the first name equals ' Eric ' exactly SELECT *  FROM empinfo WHERE first = 'Eric'; Select last name, city, age from table whose age is greater than 30. SELECT last, city, age  FROM empinfo WHERE age > 30; Select first name, last name, age whos elast name consists of “ illia ”. SELECT fi...