MySql

How to calculate age from date of birth MySQL query

Sometimes, you need to extract age from database of a person or it can be an employee or anyone, then we try to find a technique to fetch the date of birth details, although we can calculate the age via PHP or any language that a developer use to develop application writing some lines of… Read More »

What is maximum length for MySQL TEXT field type?

If you are wondering about MySQL TEXT field size limit and what types of TEXT fields are available then this tutorial is for you. TEXT datatype are stored outside of the table and just having a pointer to the location of the actual storage. TEXT datatype could store much more information than VARCHAR or CHAR… Read More »

How to get last insert ID in Codeigniter

I assume, you must be creating a website where you are looking to get last insert id of executed INSERT query in parent table and then you want to store the last inserted ID in your child table as a foreign key. In this post, i am going to share with you guys a small… Read More »

How to get file name from a URL using PHP

Are you creating an application in which you require a functionality that will copy the file from a given URL and then store into a directory and while coping the file you want to get filename of from given URL and then you want rename that according to your requirement. Am I right? Here, I… Read More »