Archive | PHP

PHP: Check if a URL exists with cURL

In my previous post about email validation one user pointed out that this will not actually validate if a website’s domain actually exists. Here is a simple function that will do just that, determine if a website exists using PHP and cURL. Edit: After searching a bit, I found another similar cURL solution that checks […]

Continue Reading 4

Getting Upcoming Birthdays From MySQL

Assuming you have a table called `users` with birthday as `bday` for the column name, this will pull all users who are having a birthday in the next 7 days. This is very useful if you want to showcase your member’s birthdays on your website. SELECT * FROM `users` WHERE DAYOFYEAR(curdate()) = dayofyear(`bday`) LIMIT 30; […]

Continue Reading 7

PHP5 Email Validation

In prior version of PHP you had to use some regex solution to validate an email address, now in PHP5 it’s as simple as: function isValidEmail($email){ return filter_var(filter_var($email, FILTER_SANITIZE_EMAIL), FILTER_VALIDATE_EMAIL); } if(isValidEmail(’[email protected]’)){ //valid } else { //not valid } I’ve been using PHP5 ever since it was released but didn’t look into the PECL Filter […]

Continue Reading 16

Sphinx : A MySQL full-text search engine

This has got to be one of the coolest things I have come across in a long time. Sphinx a standalone MySQL full-text search engine. I’ve been working with it for a couple weeks now and I must say, this thing is blazin’ fast. I was most impressed by performance on large data sets (60+ […]

Continue Reading 0