close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Order History Question

Thread began 10/02/2010 1:28 pm by Gabriel Tiviroli | Last modified 10/04/2010 8:30 pm by Gabriel Tiviroli | 755 views | 2 replies

Miguel

first you would need a table for users where they will have a user Id number the auto incrimental int field and primary field of the table from there if you use only one table for all you can give them levels example of the table

USERID -------- INT 11 autonumeric and primary
NAMES -------- VARCHAR 150 not null
EMAIL -------- VARCHAR 150 not null
USERNAME ---- VARCHAR 100 not null
PASSWORD --- VARCHAR 100 not null
LEVEL --------- TINYINT default 2

Now when you use security assist you can asign for admin lvl has to be = 1
Normal user lvl = 2

This way you can filter wich user is an admin and wich is a normal user now for the history of each user the history table should have a related field in the database example

HISTORYID ----- INT 11 etc...
USERRELID ----- INT 11 not null
REST OF FIELDS for history

having a field to relate with the user tables is the key when you add a history u have to place the USERID then you can use session filters when creating the query to show the filter tell it to filter the list or data by $_SESSION['USERID'] to the field we named before as the related to that user, so your list of history will show for those logged users only with thier data, the rest of the data wont show

Remeber to check on security assist the sessions it creates for your user id

good luck let us know how it worked for you.

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...