Posts related to web development
You can use the following command to get the last row from a MySQL table: SELECT * FROM table ORDER BY field DESC LIMIT 1 Explanation: table – table name field – table field This command orders the table by DESCENDING order and limits the number of rows returned to […]
If you ever come across the need of randomly select rows from a MySQL table: SELECT * FROM table WHERE field1 = value ORDER BY RAND() LIMIT x Explanation: table – table name field1 – table field value – value you want field1 to be x – number of rows […]
There are several ways of validating an email address format. Normally, I do it the following way: 1. I first define the regular expression for the email format: define (“FORMAT”,”^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$”); 2. To validate the email address provided is correct: if ( !eregi (FORMAT, $email)) echo “The email provided has an […]
When developing a script wether if it’s in PHP or any other language you should always consider the security aspect. I’m sure the last thing you want is to get your script (and ultimately your data) hacked. To make sure this does not happen there are a few steps you […]
Sometimes you happen to have a problem with one of your MySQL queries and you simply can’t seem to understand why. Well, one thing that helps is to use the mysql_error() function. This function returns the message of the MySQL error you’re getting. Example: $action = “INSERT INTO table (name, […]
Copyright © 2024 Rui Miguel Feio