Apr
15
2006
New work begins on AutoAppointment UPDATE

I originally helped create this web site a few years ago (mainly created the scheduler form). 

Right now I'm just working on the most important part of the web site, the scheduler form.  This time the form writes and pull info from a database so it's a lot more functional and well managed.  You can check out the form here >> AutoAppointment Schedule.  The form is mostly done, minus a few cosmedic/informative details.  If any willing people want to try it out, go a head.  I need a good selection of people to fill out this form and try to break it any way possible.  You can just fill it out with fake info and let me know of any issues or suggestions you have.

Obviously, the rest of the site has not even been started yet.  I'm trying to tackle the toughest part first then move onto the simplier parts.  So because of this new "job", all other web site work will have to stop for now (sorry ps3passion, webnv, and mmo portal).

UPDATE:  I always forget how fun it is to create an HTML that writes to a database using php.  Writing the intial code is easy, it's thinking of all the crazy things people might do with this form that I have to worry about.  One of the most worrisome items is the preventions of sql injections.  Don't want anyone pulling confedential info from the database now do we.

UPDATE 2:  Cool, the form is pretty much done.  No more entering random characters Paul and Founder.  Through the magic of php and preg_match, now only certain characters can be entered into fields.  And don't try running any scripts as strip_tags takes car of that.  Try it again . . . . if you dare!  But seriously, this form is still in testing, so test away and let me know of any other issues.  Thanks a bunch. (Ok, actually only the first couple of form pages are done.  Gawd php roxxxorss!!)

Author's Pic
// Article Summary
This article was published 2y 8mon ago on Saturday, April 15, 2006 11:42 pm by Nick Villescas. It was published under the following topics: Design and with the following tags: Auto Appointment, coding, updates. So far this article has received 206 hits with 4 comments.
4 comments
2y 8mon ago // April 16, 2006 12:22 am
Paul // guest

Gravatar
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/domains/autoappointment.com/web/schedule/schedule.php on line 422

This is on the insurance info page.
2y 8mon ago // April 16, 2006 5:34 pm
Nick Villescas // author

Gravatar
Cool, thanks Paul.  This is why I post this stuff, because I have trouble thinking outside sometimes.

Cool, so I need to set allowable characters.
2y 8mon ago // April 17, 2006 3:28 am
Founder // guest

Gravatar
Seems to accept foreign characters such as "é" and "µ", good job there Chap.
2y 8mon ago // April 17, 2006 6:36 pm
Nick Villescas // author

Gravatar
Well I'm probably going to get rid of support for that.  They really only want letters (a-z) and numbers (0-9).
Add your comment
// required


Allowed Tags // <a><ul><ol><li><strong><em><blockquote> // required


This form is protected from spam by Akismet. Comments are Gravatar enabled and also moderated.