Page 1 of 1

Generate alert message from database value

Posted: Tue Oct 13, 2015 4:28 am
by finalsman
Please, I need help on a php/javascript codes that will enable a message alert prompted by system date time. I am designing an application and I have a "date" table in the database. It is a variable. I want an auto generated message alert or prompt when a value in the date database matches a date in the computer.

<tr>
<td><strong>End Date:</strong></td>
<td><input type="text" name="edatetxt" id="datepickerr" required="required"/></td>
</tr>
<tr>

a database

INSERT INTO `stu_tbl`(`stu_id`, `e_date`, ) VALUES ([11],[22-10-2015],)

Thanks

Re: Generate alert message from database value

Posted: Tue Oct 13, 2015 6:30 pm
by requinix
I'm not sure what the end goal is here, but probably
1. Load all the dates from the database
2. Put the dates into a Javascript array and put that on the page
3. When someone enters a date, check if the date is in the array
4. If so, show the message