Dreamweaver and PHP

Yes, you can use Dreamweaver to create PHP pages so this may be a good choice of development environment.

Personally I haven't used it but from what I can find on the web it looks straightforward enough:

http://webdesign.about.com/od/dreamweaverhowtos/ss/dw_dynamic_site.htm

http://www.articlesbase.com/business-articles/using-php-buttons-in-dreamweaver-74804.html

Developer Needed - Design Stage Complete!

Justin

As you will see from the below I have completed the data model. I have also created the MySQL scripts and successfully created a database on another server which I have access to.

I have also created some simple PHP pages to show you how to connect it! All in all very good progress.

It may not look much but it's taken a lot of time to get this far, it's important that the database model is properly and professionally designed.

When can we meet to discuss? We need a developer to help write the PHP pages.

If you get me a few days of developers time I will design and project manage for you for free.

Gavin

Sales and Enquiry Module - Revised Database Model

Added tables and relationships for the Sales Enquiry and Follow Up module. Integrated into the existing application.

Have created MySQL table creation scripts so can easily create MySQL database. Now we need a PHP programmer to write the front end code.

Thoughts?

The Sales Enquiry & Follow Up Module

Hi Gavin,

The first module we need to complete is the Sales Enquiry & Follow Module. We need to script it in PHP and MYSQL.

Cheers

Relationship Diagram

A first attempt at the relationship diagram. Let's discuss on Thu ....

A Plan .......

Fail to plan? Plan to fail ....

How's this for a high level plan?

1. Design database schema on paper (Gavin and Justin)
2. Code database schema in MS Access (Gavin)
3. Design Simple Forms: (Gavin)
- Basic Customer Information
- Instructor Information
- Course Schedule
- Individuals participation
- Registration / class start screen

4. Populate basic data. Let's start with the 7.15 and 8.15 social salsa courses and trial with this. The course is run regularly and a fair few participants (Justin)
5. Trial the system for a few week, noting issues or improvements (Justin)
6. Plan additional features
- Magnetic strip / barcode / RFID solution
- Adding billing information
- Reports (e.g. those not regularly attending)
- Stored value (for buying drinks and services etc)
7. Implement addition features
8. Port system over to MySQL / PHP solution and make web based. Add additional security etc.

Thoughts?

Integrating Bar Code or Magnetic Scanners with DB's

The most simple way is to use a keyboard "wedge". This converts the output from the scanning device into a keyboard like input.

All you do is open up a form in Access, make sure the cursor is on the search field (can be ensured bu only having that field enabled) and then scan the card. The wedge converts the output into text in the field as if the user has typed it in:

Check out

http://www.barcodehq.com/wedge-readers.html

A software version exists:

http://www.sharewareconnection.com/titles/keyboard-wedge.htm