close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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 | 757 views | 2 replies |

Gabriel Tiviroli

Order History Question

I have a problem to create an application. The issue is this: I'm doing with the tools of a site webassit a real estate or construction company. The idea is to have an administrator enter information where every buyer of a house that is paid in installments. Then the idea is also that the buyer can access a personal page using Security Assist which reflects their current situation of paying tuition, etc., data to be entered by the site administrator at a time. So, in this case do not use eCart because nothing is sold online, but if I need to do the history of each buyer so that the person can access to see the construction progress and status of your monthly payment. My question is how to apply Security Assist once given by the administrator username and password, each person can enter their own. I have watched the tutorial on how to make a purchase history, but it confuses me a little because the target is another. I do not know if you understand the proposition. From and appreciate any comments to help me get this straight

Sign in to reply to this post

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.

Sign in to reply to this post

Gabriel Tiviroli

Thanks!

Thanks Sade for your help!! i'm apreciate that!

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