In the end, you should have the following files: As I mentioned earlier, I'll be uploading the finished product.
is because in case the user modifies the URL parameter into a non-existing number(in our case we only have 2 rows/id's), we can display a prompt in which the data doesn't exist.
Now try clicking the edit link into the first row and it should display like this: Complete code: Congratulations! Looking back to the CRUD, we have now done creating(adding), reading(displaying), and updating(editing) records. For this part it's just relatively the same as what we have done on edit but what differs is just the SQL statement.
It does not check for leap years or invalid dates at the end of short months.
As we've seen before, creating re-usable functions can significantly reduce the size of your Java Script code.
For example, when the date is checked, the return value, , is an array with elements 1 through 3 containing the day, month and year components of the input string.
For the time check, the array returned includes the hour (pos 1), minutes (pos 2) and, optionally, the am/pm string (pos 3).
In this case, we've created a stand-alone functions which will validate a date field: In each case the value passed to the function is the form field rather than the field value.
This routine DOES NOT check that the date or time input values are valid, just that they match the required format (d/m/y and h:m). Once you're in control of the input format, it's a lot easier to check that the values are actually valid.
The function has been improved now so that the day, month and year values are checked to ensure that they're in the right ball-bark (ie. Also the year must be between 1902 and the current year.
The Ajax Request class is a simple one we've created and use on a number of projects.