PHP Data Tables
By Ashley Rosenthal on Tuesday, 28 January 2014
Posted in General Issues
Replies 4
Likes 0
Views 819
Votes 0
I am trying to create a table in phpMyAdmin (in my Go Daddy Control Panel). I successfully created the table but what I am trying to do is import information from my EasySocial users accounts. How do I populate my columns with their information? (for example I have a column for their UID that I would like automatically populated). I tried using Godaddy support with very little success because they weren't sure how the phpMyAdmin area worked. Any ideas?

(Just in case I remembered to include the site details this time)
If it would be more simple to answer this question that is fine:

How does the table ***_social_fields_data get it's information such as uid, field id, data, etc.

If I know how that gets it's data about our users then I can study that to answer my own question about getting that type of information into my new table.
Ashley Rosenthal
·
Tuesday, 28 January 2014 10:58
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

Are you looking to backup user data, or create a concurrent table that is used to store extra information about users every time a user updates/create his/her profile in your site?

Regarding how the fields data table get it's information, it is actually EasySocial injecting data into that table instead.

For a user, the storing data action is mainly in:

/administrator/components/com_easysocial/includes/user/user.php, in the function bindCustomFields().
Jason Rey
·
Tuesday, 28 January 2014 11:06
·
0 Likes
·
0 Votes
·
0 Comments
·
I am looking to store extra information about users every time a user updates/creates etc his or her profile................ (I am intending to use this table later for a formula that calculates an individual score for each user based on their education information/registration fields/etc... we're developing a new system for employer/employee search and these scores will play a factor in search results later)

For now it would just be helpful I think to know if I am able to have EasySocial inject this data into my table.
Ashley Rosenthal
·
Tuesday, 28 January 2014 11:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

In the latest version, we have app triggers that you can utilise, and you would most probably want to use the trigger "onUserProfileUpdate".

This trigger is EasySocial App Trigger, which means you will have to write an EasySocial app to achieve your purpose. You can refer to our developer documentation on writing an app at docs.stackideas.com
Jason Rey
·
Wednesday, 29 January 2014 10:35
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post