problem insert data into database

hai guys,i have problem here to insert data into database,i have registration form that connect with existing joomla users table..i have form like this [attachment=1]field.png[/attachment]
i have problem at check box,i want to insert value 1 into database,if the user click the check box...

on my second question is i have this field in database,[attachment=0]table.png[/attachment]..this joomla requirement when user register,how to insert value in this field in database..i need to insert code or what..please help me

Hi anuaromar ,

You need to make sure that you have value="1" in the check box attributes.

Bob

that really helps. got the same problem

Hi anuaromar ,

You need to make sure that you have value="1" in the check box attributes.

Bob

thnks,you help me a lot..but how about my 2st question??
to insert value for the field usertype,block,sendEmail,gid,registerDate,lastvisitDate,activation,params on the jos_users table database using new registration form that created with chronoengine

Hi anuaromar ,

Use the ChronoForms Joomla Registration Plugin with your form to get this handled automatically. There's a Tutorial from the Tutorials link above.

Bob

Hi anuaromar ,

Use the ChronoForms Joomla Registration Plugin with your form to get this handled automatically. There's a Tutorial from the Tutorials link above.

Bob

dear greyhead,i have use chronoforms joomla registration plugin to get it handle automatically,but when i click joomla registration plugin,i only get 5 field of my form crated like this picture ,[attachment=1]table.png[/attachment]so i have match the of field with the name of the form,,,it's ok but in database it insert 2 data like this picture [attachment=0]data.png[/attachment]

i have follow the instruction,,you can see in the 1st data i get gender,newsletter,event,country value but cannot get password gid,register date value and 2nd data it inverse with the 1st data..sorry for my english...🙂

Hi anuaromar,

Please check the Tutorial for Joomla Registration from the Tutorials link above..

Bob

dear greyhead,i have follow all the instruction on joomla registration form tutorial,in the tutorial it create new table in my case i use existing joomla user registration table and add some field on the table,can i do like that??

so,the result for what i have done like the previous post...

Hi anuaromar,

I've no idea what you are doing.

The Joomla Registration plugin doesn't create a new table it uses jos_users.

You don't appear to have any input names in the plugin configuration.

**Do Not** add extra fields to the com_users table, use a new table.

Bob

oic,i understand now..means if we need to insert extra fields we need to use new table..cannot add new field in the com_users,the joomla register plugin automatically insert the extra data in the new table and com_user data that have foreign key cf_user_id on the new table right,..hmm thnks bob 🙂

Hi anuaromar,

Yes, excpet that you need to create a DB Connection on the form to save the extra data to your new table (the plugin doesn't do that for you).

To view and edit the data you can use the Profile plugin but you need to add extra code to save the User info to the Joomla User Object.

Bob

ok.where can i get profile plugin and what the extra code i need to save the user info..please guide me bob, i appreciate what u have done

Hi anuaromar ,

The Profile plugin comes with ChronoForms like the Joomla Registration plugin.

The code is a bit more complicated but has been posted here before.

Bob

ok,thnks i will search for it..but in my case i have 2 table jos_user and the new table that store extra field for the registration,how to select and update the table using profile plugin

please anyone..show me how to view and update data on database using profile plugin..i'm stuck on that..its urgent i need to submit my work

hi bob,i use profile plugin to view and edit..but profile plugin only get 1 table to view and edit..in my case i have to table to edit..so i need to insert some code to make profile plugin can view and edit both table,where should i insert the code..

for view data,i only can retrieve/view value from table that have been declare on profile plugin..do u have suggestion to me to retrieve/view data from both table because in the table i can see it save userid (id=cf_user_id)

so,when i try to edit information and submit,the profile plugin not update the information but it insert new data in database 😟..

Hi anuaromar,

so,when i try to edit information and submit,the profile plugin not update the information but it insert new data in database

You must include the Unique ID of the record that you are editing in the form so that ChronoForms knows which record to update. If you don't then a new record will be added.

Bob