Learn to add drop unique key in Mysql. Create and alter unique key using multiple column, using SQL syntax and live examples and step by step explanation.
Most newbies make mistake by not creating primary-foreign key relationship between tables. They just assume table column as primary-foreign which leads to many error later on. In this tutorial you will learn the write sql to create foreign keys and join tables.
If you are looking for a way to force download file in PHP try this snippet. PHP function to get the mime type of the file. Download file with proper validation & error messages.
List of all countries name with ISD and ISO code in SQL and CSV format and available for download.
Create month and year dropdown list dynamically using php.
Default parameters in function comes handy for developers in cases where most of the time a certain parameter value is used.