security issue with form and mysql

[dhirajkumar41]

i have created a form. in which i want user to enter his/her full name. so how to confirm that it doesnot contain numbers or other special characters other than alphabets. i want to store it in mysql database. Pls help. Thanks

[Strider64]

        if (preg_match("/^[0-9a-zA-Z_]{5,}$/",$username) === 0) {
            echo 'Username must be bigger than 5 chars and contain only digits, letters and underscore';
        }

You could do something like the above with the digits removed from the preg_match statement?

[fastsol]

You could also use ctype_alpha() for only alphabet characters.