Profile plugin - populating select, & checkboxes

I'm 90% sure, after going through the threads, that you can't use php code to display records from other tables to populate Select dropdowns, checkboxe options etc, so that users can amend or add to their current selections shown using profile plugin.

If true i would have to manually create html/php script which is basically the same as the new registration form i created, which is up and working fine, and use a UPDATE sql query?? instead of INSERT via chronoforms, I query this as is there any code to tell it should use UPDATE instead of SELECT as in when you update using the profile plugin in a form, or will i have do this and add code to prevent mysql injection myself.

I presume chonoform uses code to prevent this, and I would like to use this as well if possible, or give example of code used to prevent MYSQL injection.

tia MPH

Hi MyPetHamster,

The Profile Plug-in handles all the form elements including select boxes and drop-downs.

You do though have to be able to pass it an record identifier in the URL. Looking at your other post you seem not to want to do this - in that case you are in for some hand-coding.

Bob

I did try to use php to retrieve data from a different table to populate select dropdown (basically the same as new registration form, but with username showing as text, and captcha removed), but it throws up eval(80) error message where it had a simple <?php echo '<option value="'blahphpcode'">blah blah</option>'; ?> statement???

Hi MyPetHampster,

Then there is an error in the code. Exactly what message do you get? and what code are you using?

Bob

Just to clarify something, I am using the profile plugin to gather data from jos_user table,and another table which stores extra profile details when the user registers, also a third table that stores options that the user can select through drop down.

WHICH table do i link to in profile plugin? in this edit profile page i wish to give the user the usual options from the default joomla options from user details, where they can change email (this may not be included as i am using email address as username), password (with confirm password input), plus drop down, checkbox box options from the other table with the currently chosen options highlighted.

Now i managed to get everything to show on edit profile page, and when the user is logged in, it will show their details. At the last strange I began to think should i be connected to jos_user table, rather than extra_details table?? I did change to jos_table and when you use {usename} it does show the user name but i can't get name or email to show using same method in input values

example
<input class="cf_inputbox required validate-email" maxlength="150" size="30" title="" id="sn_email" name="sn_email" type="text" value="{email}" />

so i don't won't to go getting this to work using jos_user table, when I should stick with extra_details table.

Tia MPH

Edit: is there other plugins i should be using, I know I should not be using the registration plugin? from what i have read.