Forums

Plz help ... how to connect to databse

himanshuarora 07 Dec, 2010
Hi ,
I am new to chronoForms , I have managed to create a form using php and html
I have inserted the whole code into the 1st box and forms appears absolutely fine .

Please let me knw ... now how to connect this form to the database ...???

thanx ....🙂
rashmani 15 Dec, 2010
Hi there,

new to CF as well.
I've managed to install, create and deploy my first form smoothly (CF 3.2.0 and J. 1.5), by following tutorials on CF website ("Joomla Registration wit CF" and "Working with DB's". Everything's working fine, registration process works and registering users get their email.
I've a few questions tough:
- do I have to explicitely redirect Joomla to my registration form in file /site/components/com_user/views/register/tmpl/default.php? If yes, how? The tutorial includes an example with a static page and my Joomla knowledge doesn't suggest me the right move to take...
- from the database tutorial it's not clear to me if CF will actually add my form's fields to the table I select, expecially in the case I select table jos_users...
- again regarding form fields, any good tutorial about letting users edit their fields (once they get saved to the DB) from the user profile page?

Thanks for answering!
rash*
GreyHead 15 Dec, 2010
Hi rash*,

- do I have to explicitely redirect Joomla to my registration form in file /site/components/com_user/views/register/tmpl/default.php?


Yes, you either have to hack the code code or add code that will detect the register URL and use that to redirect the user. I don't understand the 'static' comment you made.

- from the database tutorial it's not clear to me if CF will actually add my form's fields to the table I select

Yes, if you have a DB Connection set uo. The DB tutorial is a bit old now.

expecially in the case I select table jos_users...

You should not add new columns to the jos_users table; instead add the data to a new table and link the two with the user id.

- again regarding form fields, any good tutorial about letting users edit their fields (once they get saved to the DB) from the user profile page?

There's a tutorial that you can buy here. Note that it's quote technical and needs some Joomla! PHP & MySQL knowledge.

Bob
rashmani 15 Dec, 2010
Hi Bob!

Wow, that was quick...

I don't understand the 'static' comment you made.


In the example, registrations are redirected to a should-be-static page (.html); not knowing Joomla API deeply enough, didn't know if that was the way for static pages while invoking a .php page or module would have been different.

You should not add new columns to the jos_users table; instead add the data to a new table and link the two with the user id.


Aah! That's clear enough to send on the right path through CF tabs and commands.
At least I hope so...
Thank you very much.

Oh, great website, btw!
rash*
This topic is locked and no more replies can be posted.