form with queries

I haven't found it on the forums but I really need it. I am quite new to PHP and MySQL.

I want a form where people can check different entries. These entries need to be fetched from a database, I have no clue on this. Anyone any suggestions?
Thanks!

Hi tnijman,

You can do this with ChronoForms - it's not difficult but it's not the simplest project for a beginner.

Can you say a bit more about what you want to do?

Bob

I have a table with different books in my database and people should be able to select several books and then I process it. It is for a company that sells secondhand schoolbooks, people should be able to print a invoice which is made on the internet with the books they want to sell to me. The invoice must include their value of the individual books and the total. They then take the invoice to a place where they can physically give the books.

The process after the form is another thing to tackle. But I'll be able to work that out. I already use a form to insert the books with chronoform in a private part on the front-end. And edit it with chronoconectivity in the front-end also private.

But how do I make the form? I read somewhere that it wasn't possible to make a dynamic form? Any ideas?
Thanks

Hi tnijman,

There are a few ways of doing this - perhaps the simplest is to make a public display with ChronoConenctivity but to include either a checkbox field so that people can select several books, or links to allow them to add one at a time.

Then pass this info to a ChronoForm that can process the info - a bit like a shopping cart. You'd save the data temporarily in the session data until they clicked a 'CheckOut' submit button, then process the cart as an order.

In the backend of ChronoForms you can send the emails and build your 'invoice page'.

As I said it's not trivial but it's perfectly 'doable'.

Bob

PS Or you could adapt one of the shopping cart programs (maybe VirtueMart) to do some or all of this.

PPS Or you could build a purpose built extension from scratch - more complex at the start but could be simpler in the long term if you are going to handle a lot of orders.

Thanks for the reply!

This is not exactly what I ment, because I understand what you say.

The books come from a database so the checkboxes are dynamic is this possible in chronoforms?
There is no need for a checkout just a simple way for clients to get a list of books with their information on their mail they want to sell to me.

Thanks in advance!

@tnijman, just as Bob said, a ChronoConnectivity to list the records and you can build any HTML with this, read the CConnectivity tutorial, you will be able to add your checkboxes, and a submit button and do what you need, it needs that you understand how CConnectivity works very well, you "may" need some hack to make things simpler at some point!

regards
Max