As we are using triggers in PostgreSQL to fill Created Date or Modified Date with current date time, you need to ensure that you set the correct time zone for your location. By default PostgreSQL gives UTC date time.
I faced a situation where I had to change a column type from Boolean to Integer. And I wanted to rename the column name. For example, we have table that has a boolean column "bDeleted". I have to remane "dDeleted" to "iDeleted" and all boolean values need to convert into 0 and 1. Then you have to run below PostgreSQL queries.
While upload images from mobile devices like Android/ iPhone with mobile camera, images will be shown in wrong orientation. To avoid this, you need to know image original orientation. “exif_read_data” function return image Orientation information.
1. New Doctype: The simpler doctype declaration is just one of the many novelties in HTML5. Now you need to write only: and this is it. The syntax of HTML5 is compatible with HTML4 and XHTML1, but not with SGML(Standard Generalized Markup Language). 2. Geolocation: Best known for use on mobile devices, geolocation is coming with HTML5.
If you need to get array unique values from array use “array_unique” function. But while dealing with multi-dimensional associate array, this “array_unique” will not work. Use bellow function to get unique values from associate array.
PHPExcel library to provide an “Export to Excel” function in a website. So that the user can export the data into an Excel 2007/2013 file. We can draw the images inside the excel column. PHP Excel library provides this feature. It's easy to use.
Two of the many comparison operators used by PHP are '==' (i.e. equal) and '===' (i.e. identical). The difference between the two is that '==' should be used to check if the values of the two operands are equal or not. On the other hand, '===' checks the values as well as the type of operands.
I made a quick little example to read a YouTube user’s video feed that really easy to use. To request a feed of all videos uploaded by another user, send a GET request to the following URL. This request does not require authentication. https://gdata.youtube.com/feeds/api/users/userId/uploads. In the URL above, you should replace the text userId with the user's YouTube user ID.
The Bootstrap 3 grid comes in 4 sizes. Tiny (for smartphones .col-xs-), Small (for tablets .col-sm-), Medium (for laptops .col-md-) and Large (for laptops/desktops .col-lg-). The 3 grid sizes enable you to control grid behavior on different devices like desktop, laptops, tablet, smartphone, etc..,