close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Tabular Display of multiple Records filtered by UserID

Thread began 6/04/2009 5:10 pm by Kevin373660 | Last modified 6/08/2009 9:27 pm by Kevin373660 | 1599 views | 8 replies |

Kevin373660

Tabular Display of multiple Records filtered by UserID

On my user_Profile.php (parents), I need to display all of their sub-user accounts (kids names). I would like to do this like an expanding table with a horizontal row for each sub-user record (according to the number of sub-users name & nickname). I also need to allow user’s links/buttons, from their profile page, to add/update/remove sub accounts and to make purchases for each sub-user independently. Using WebAssist, separate registration and profile pages have already been created can be linked to. I have separate db tables, one for users and one for sub-users, using MySQL InnoDB.

I have read the guides but I am not sure if I will get the results that I want. Which WebAsssit Tool should I use? DataAssist – Repeat Selection?

Sign in to reply to this post

Ray BorduinWebAssist

Run DataAssist for the kids names database table. Specify the user_Profile.php page as the results page and don't create a search page.

Then after the wizard runs go to the profile page and add code so that the kids names table is filtered by the same session variable you are using at login to filter the parents recordset on that page.

You will have to update the insert page to store the session variable for the associated parent when inserting child records as well.

Sign in to reply to this post

Kevin373660

Sorry to be a bug, but do I run DataAssist Wizard, DataAssist Search Wizard, DataAssist Search server behavior, or DataAssist Repeating Table? I started, but then realized that have not used any at this point and I am not sure how to determine which I need.

Sign in to reply to this post

Ray BorduinWebAssist

DataAssist wizard

Sign in to reply to this post

Kevin373660

Thanks Ray, I have used the DataAssist Wizard and created the pages (less the search page). Up to this point I had created all the pages using SecurityAssist and with your kind assistance was passing the parents userID via the login $_SESSION to the kids_registration page.

With DataAssist, the new pages pulls from the db tbl a row for each kid sub-account under the main user account and places their information into a row in the table. This was the resault that I wanted. View and update pages work using the DataAssist created pages which pass the individual kidSID through the url. This does not seem to provide the level of security that I need for handling the user/member accounts. I would prefer to send each of the kids account information pulled into the table to the next page veiw/update/delete using the $_SESSION. Is there a way to put their information into a session variable/value (I am still not 100% clear on how to set these up) depending on which kid the parent wants to view/edit/delete? Below is the code for a typical link. Is it just a matter of editing this link code to set that particular kids values?

<td><a href="member_Profile.php?kidSID=<?php echo(rawurlencode($row_WADAtbl_members['kidSID'])); ?>" title="View"><img border="0" name="View<?php echo(rawurlencode($row_WADAtbl_members['kidSID'])); ?>" id="View<?php echo(rawurlencode($row_WADAtbl_members['kidSID'])); ?>" alt="View" src="../../WA_DataAssist/images/Pacifica/Refined_zoom.gif" /></a></td>

Sign in to reply to this post

Ray BorduinWebAssist

This would work in conjunction with the login from SecurityAsssit. Any session variables stored during login would be available to filter recordsets or insert records into the database in dataassist.

I don't think you would edit the link. I think you would possibly edit the Recordset or the Insert server behaviors so that they use the Session directly to filter out or insert record values.

Sign in to reply to this post

Kevin373660

Ray, I'm sure that you are right, but I am a little lost. On the parents_Profile page c/w the new kid's table, I have the kids recordset filtered by the parent's userSId=Session Variable userSID. In my mind I was going to link from the parents_Profile to to members_Profile (created before with SecurityAssist) page. Perhaps you are thinking changing settings on using the member_Update page to acomplish the same resaults? I do not want people to see the member id in the url (so that they can not simply edit someonelses kid's profile.

You have mentioned setting and filtering the recordsets. I get confused about, "I do what to which page?" Please clairify with each step separatly so that I can follow. Thank you.

Sign in to reply to this post

Ray BorduinWebAssist

I don't have a bunch of steps. Just use a session variable instead of or on top of the url parameter to filter your recordset.

Sign in to reply to this post

Kevin373660

Thank you Ray for your assistance with seting the $_SESSION value for the KidSID. I have been trying to figure that out for two weeks. I was able to set and pass the value on to the kids profile page. I will have to setup the navigation buttons but the primary function works fine.

With multipule sub-members (kid accounts) I found that the kidID value increments depending with the number of records viewd/retrived in the table based on the $row_WADAtbl_members['kidSID'])); value. Without requiring extra coding at this time, I was able to reduce the ($maxRows_WADAtbl_tablename = 1;) maximum number of records viewed to 1. This allows for the variable to be set correctly for each record viewed and proceed to update/view/delete. The navigation buttons allow you view the remainder of the records.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...