Forum Moderators: coopster

Message Too Old, No Replies

I need to create an interactive calendar?!

         

Carol

1:13 pm on Dec 7, 2007 (gmt 0)

10+ Year Member



Good morning:

I really need some assistance and would appreciate any input. I basically create static sites and I have concentrated on the 508 standards and using CSS. I was just tasked at my job to create a front end for:

“a program that prepares documents, calendars and various other functions. The program is written in Visual Basic and uses Access drivers (not the program just the drivers) as a database….They want to have an interactive calendar on the website so clients could go to the website and schedule their own appointments…This will require the clients to enter certain information prior to the appointment being confirmed. That information would, then, be imported into the database so it wouldn't need to be typed again.”

I have to use PHP, I have recently bought a bunch of php books off of Amazon but I really don’t know where to start.

At this point I’m looking for direction. Possibly a check list of what I need to get in order first. Then can anyone suggest a tutorial/book? Luckily I have a month but I have a feeling I will need 2……

Thank you!

coopster

4:39 pm on Dec 7, 2007 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Welcome to WebmasterWorld, Carol.

Sounds as if you are new to PHP. It also sounds as if your management team is somewhat new to the internet in terms of scalability. MS Access is not a very good database to be using for web applications. I'm not saying it won't work, but I will say it won't work well -- sooner or later you are going to have issues.

Have you and/or the team considered open source calendar software?

Carol

4:53 pm on Dec 7, 2007 (gmt 0)

10+ Year Member



Oh thank you for responding. Sigh...I will be learning .php on the fly so I am BRAND NEW! I new I would have to create things but this is a tough first project. So far maintenance is a snap so I was lulled into a false sense of security. I have been combing the internet for a solution and I just can't find anything that I understand. I just ran into this:
[squirrelmail.org...]

Does that look like something I should invest time into deciphering?

I don't think management would be against buying something off the shelf if it was inexpensive. Do you have anything in mind?

Thank you so much!

Carol

3:16 pm on Dec 10, 2007 (gmt 0)

10+ Year Member



I've been doing a lot of research and it looks to me like you can't use PHP when the dbse is written in Visual Basic and uses Access drivers (not the program just the drivers). It has tp be in mysql, Am I correct?

PHP_Chimp

6:12 pm on Dec 10, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



PHP will interact with a lot of databases not just mysql.
PHP can use the ODBC [uk3.php.net] drivers.

Carol

6:29 pm on Dec 10, 2007 (gmt 0)

10+ Year Member



Maybe Dreamweaver and PHP are the problem. I picked up the Dreamweaver Bible this weekend and it has ASP using the ODBC drivers and PHP with mysql

Thank you for the info. I will keep digging