How to list MySQL tables using PHP
The following code lists all tables in a MySQL database:
Using PHP and SimpleXML to manipulate XML
SimpleXML is a SAX XML parser. It represents an XML document as a hierarchical set of objects and properties where each element is an object and each attribute is an…
Quick introduction to MongoDB
MongoDB is document based NoSQL database. This means that: it has no schema it has no relations it is agile and scaleable stores information in nested documents of two-dimensional key/value…
PHP date arithmetic
strtotime() function can be used for date arithmetic. Following are some examples: Get next date Prints Get previous month Prints Go back 5 years Prints
Quick introduction to Laravel 5
Laravel is a free and open-source PHP web framework like CodeIgniter and Zend. It is built on the Model-View-Controller (MVC) architectural pattern. It has very good documentation and training material.…
PHP foreach by value vs foreach by reference
When you use a foreach loop, PHP creates a copy of the current element you are using in your loop. Any changes you make to this element is not saved…
Quick way to find out which log file is logging errors
On development systems it is common practice to have different log file to log PHP error logs for different tools and different versions of the same tool. Generally it is…
Escaping string before inserting into MySQL
If a string contains a single quote, it will generate an error. mysqli->real_escape_string() escapes quotes for MySQL. See example:
Converting string to date in PHP
Converting strings to dates in PHP requires the use of two functions. strtotime function converts the string to an epoch timestamp. date function converts the timestamp to the desirable date…
Type casting in PHP
PHP does not support explicit type definition in variable declaration. For example, you CANNOT declare a variable as follows: In PHP, a variable’s type is determined by the context in…