This is just a quick and simple project that you can finish in a few minutes or an hour.
I just want you to add a simple validation in this form:
http://www.prcboardexamresults.com/sms/
CellNumberPre+CellNumber+alerton+email wasn’t validated if it exists in the Database.
CellNumberPre = cnp
CellNumber = cn
AlertOn = alerton
Email = email
Here’s the MySQL database table sample:
CREATE TABLE IF NOT EXISTS `sms_subscribers` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default ”,
`email` varchar(255) NOT NULL default ”,
`cnp` varchar(255) NOT NULL default ”,
`cn` varchar(255) NOT NULL default ”,
`alerton` varchar(255) NOT NULL default ”,
PRIMARY KEY (`id`),
UNIQUE KEY `id_2` (`id`),
KEY `id` (`id`)
)
I just want you to validate cnp+cn+alerton+email if it exists in the database.
These are the specific validations that I want you to add in the form:
1. If CNP+CN+ALERTON+EMAIL already exists, then “You already subscribed to our SMS updates for ‘ALERTON’ “
2. If CNP+CN already exists, the “You already subscribe to our ‘ALERTON’ updates, do you wish to subscribe for another update?”
3. If EMAIL already exists, the “Your cellphone number ‘CNP+CN’ already subscribed to our ‘ALERTON” updates, please use another cellphone number”
4. All fields are required.
The HTML form is completely separated from the PHP. I don’t want any modifications in the form. I just want to add some features, like AJAX validation. The message “You already subscribed to our SMS updates for ‘ALERTON’ ” should be above the form. Just validate in an AJAX way. I know you know what I mean.
That’s it.
I have attached you the HTML and PHP wherein you can add the AJAX validation thingy.
That’s all. My project budget is around $10 to $25. Post your lowest bid and delivery time.