TexasCHLforum.com

Okay, how about this approach? Would an eCommerce module work? I've looked at two or three that work with a CMS website (Joomla) and at least some allow the entry of the number of items "in stock" and they count down as people purchase them.

Since there will be no charge for the seminars, I could just enter "0" for the price. My concern is that this will cause a problem when it goes to PayPal, or some other payment processing company. The eCommerce feature could be useful later, if we decide to sell shirts, hats, etc. to promote the effort.

Any thoughts?
Chas.

Is the room spinning, or is it just me?

Thanks guys for the information and for letting me know that there are some things better left to people who know what they are doing. People will be depending upon this registration system to be sure they have a place at these events, so it cannot fail without disappointing a lot of folks. I need to rethink this venture.

Chas.

The Annoyed Man wrote:Why not just set the event site up as a Joomla installation, and then use one of the event registration plugins they have there?

I looked at some and read the reviews. The only one that looked promising was one by DT Registration, but it only works with 1.5 in legacy mode and I don't want to use legacy mode because of degraded performance.

Chas.

Thanks! Now tell me the truth. How long were you laughing?

Chas.

TheArmedFarmer wrote:Step 1: Create your table with an auto-increment primary key.

Code: Select all

CREATE TABLE `registrations` (
  `name` varchar(200) NOT NULL default '',
  `phone` varchar(200) NOT NULL default '',
  `etc` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`rid`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

Step 2: Insert into the database table the results from the registration form you setup.

Code: Select all

INSERT into registrations (name, address, etc) values ('$name','$address','$etc);

Step 3: Get the new unique ID from the insert you just made.

Code: Select all

SELECT LAST_INSERT_ID();

Step 4: That ID will be the confirmation number for the person to print.

Step 5: Find out how many rows (registrations) you have.

Code: Select all

SELECT COUNT(*) FROM registration

Step 6: If results of step 5 are the number that you want, then print a message saying registration is closed.

Easy peasy. :-)

I have a question for you programmers. I am learning php (very slowly, mind you) and I need some input on the concept of an event registration program or module to use on a website. This program will be used primarily for events that will be offered by Texas CHL Forum, Inc. (TCF) around Texas when this new organization becomes active after the first of the year.

I need some way to let people register on the Internet for the seminars and other events that this outreach and advocacy organization will put on. I simply won't have time to do that manually, especially during the legislative session. I've looked for commercial packages but the few that are available won't work on the website I'm setting up for TCF.

So from a conceptual viewpoint, am I on the right track? It seems to me that after setting up the mySQL5 database, I need to:

• Step one - Take input from the registration form and append it to the appropriate table;
  Step two - Increase the number of people registered by one each time the action in step one occurs and echo to the number of available slots to the web page;
  Step three - Echo a confirmation for the person to print;
  Step four - Reject input when the event is full and echo a notice that the class is full.

Obviously, this leaves out the operations to input the event number, description, etc. into the database.

Now I know you programmers are trying catch your breath from laughing at my novice description, but when you compose yourselves, let me know if I'm even on the right track. Also, is it possible to import an Access database and/or forms, queries, etc. into mySQL5? If so, I could use Access that is much more user friendly, then move it to mySQL5.

Let me say I really appreciate the offers I've received from a number of you folks to do some free programming. I just don't like doing that when you make a living that way.

Thanks for your input,
Chas.