only show the information of current user

Hi all,
I am new to joomla, i will appreciate if you can make answer more detail, better with screenshots ^^. Thanks in advance.

1. By chronoform tutorals, i successfully created a form for user registration. Of course with more information than the default one.

2. I would like to show up the registered information at website by chronoconnectivity.
I can manage to show up all the registered users on the website.
Now, i would like to show up the information related to the login user only. I guess some work should be done on the following page
[attachment=0]ss.jpg[/attachment]
Maybe at "Query related settings" and "connection view settings" parts. Can someone show me how?

Best Regards

Hi zhazhago,

ChronoConnectivity is really intended for getting a list of entries from a database table. If you want just one then the Profile Plugin for ChronoForms may better.

You can do this with ChronoForms by using this code in the WHERE box

<?php
$user =& JFactory::getUser();
echo "WHERE `cf_user_id` = ".$user->id;
?>

NB You may need to replace cf_user_id with the column name for the user id in your table if you did not create it with ChronoForms.

Bob

Thanks for the fast answer.

I paste the codes like this:

[attachment=1]ss.jpg[/attachment]

but it doesnot work

The db table is designed like this

[attachment=0]s1.jpg[/attachment]

And the code for body is

<strong>{text_1}</strong><br>
<br>
<maintext>
<br>
tutor {text_2}'s information is shown as following:
<br>
Email: {text_6}
<br>
Password: {text_8}
<br>
Gender: {select_11}
<br>
{edit_record}
<br>
Prefered Location: {select_12}
<br>
</p>

both header and footer is empty.

Any idea which part goes wrong?

Hi zhazhang,

That all looks OK to me. Are you sre that you have a record for the current user?

What do you actually see on the CC page?

Bob

Hi bob,

I am pretty sure this user exist, see this

[attachment=1]users.jpg[/attachment]

By place "this is header~" and "this is footer~" at Header and Footer part, the CC screenshot is this:

[attachment=0]CC.jpg[/attachment]

Hi zhazhago,

All looks Ok but something is wrong :-(

If you like, email or PM me the site URL and a SuperAdmin login and I'll take a quick look.

Bob

Hi zhazhago,

This is working OK I think.

In the table you are using there are only two records and these are both linked to User 63 so not other user will see any results. I changed these to User 62 (the SuperAdmin) so I could chedk and they both show up correctly if you are logged into the front-end as Superadmin.

Bob

Notes:
a) I changed the Front-end View permissions to all groups

b) I installed EasySQL so that I could see the database records from the site admin. It a free extension, you can either leave it or uninstall it.

Hi bob

i saw the problem. It is weird that two users with the same ID. However check their IDs through "User Management". It shows the two users have different IDs.

Whatever, it works. Thanks a lot man.

Btw, the profile plug-in you mentioned earlier, is it with CF or should i install it from somewhere?

Best Regards

Hi zhazhago,

The profile plugin is included in CF. See the plugins list at the left of the Forms Manager.

Bob

[attachment=0]pg.jpg[/attachment]

The one called profile page, right?

Any tutorials to follow?

Best Regards

Hi zhazhago,

Yes.

No tutorial, a few threads here and the plugin Help tab.

Bob