Prevent gaps/holes in a MySQL table AUTO_INCREMENT Primary Key field. Generally during the MySQL database development you create tables with a Primary Key, a very simple way to create a primary key is make it Auto-increment and unsigned integer with Not Null property right? I think most of you generally follow the above…
Tip #1 <?php $todayTimestamp = time(); /* Don’t Use.*/ $nextDay = $todayTimestamp + 86400; /* Do instead.*/ $nextDay = strtotime(‘+1 day’, $todayTimestamp); ?> The first one will not work exactly if you move into or out of daylight savings time. An extra problem is that the second example is more readable, specially if you add…
ACID(Atomicity Consistency Isolation Durability) is a set of properties that guarantee that database transactions are processed reliably. In the context of databases, a single logical operation on the data is called a transaction. Atomicity Atomicity is an all-or-none proposition. Modifications on the data in the database either fail or succeed. Each transaction is said…
On a normal server, there is a limit of mails, that can be sent in a day, but due to error or some issue if a large number of mails sent automatically from your server, and then they (gmail, hotmail yahoo and other) block the incoming mails from that server. This means that your…
String Validation Validate name, surname by the below function to restrict only letters and spaces. Validate numeric value by the below function to restrict only numbers,you can uncomment any line according to your need. Alphanumeric Characters Validation Below function validates alphanumeric characters.ctype is complete function library in PHP. Validation for URL Exist or not This…
Search Engine Optimization (SEO) is the process of improving the ranking in the search engine it involves editing its content, HTML, Images. Content is always king and it should be very relative to its specific keywords. Content portion itself of the web development process is vital to the overall success of the website and Google…
