2. PHPRunner General questions
  3. [SOLVED]  Problems with registration page
This topic is locked
[SOLVED]

 Problems with registration page

 		11/9/2011 10:30:41 AM
PHPRunner General questions
A
 ant author

Im running PHPRunner 6.0 and am trying to set up a planner for various users. Each user will only have access to his records.

I've created a seperate table users for passwords with;

SELECT

ID,

Username,

Password

FROM user
I then have personalinfo table;

SELECT ID,

First Name,

Last Name,

Date of Birth,

ID Number,

Email,

Home Phone,

Business Phone,

Mobile Phone,

Fax Number,

UserID

FROM personalinfo
The users table is linked to the personal info table and works fine as the login user only sees his data. The problem is with the other tables is the database, how do I limit them to only the data they input as the login settings only applies to one table. Im not sure if Im missing something, tried linking the user table to the other tables and also using the personalinfo table to link to the other tables.
The other problem I have when registering new users I get the following error even though the user is registered. (not sure if its because Im testing on localhost)
php error happened

Technical information

Error type 2

Error description fsockopen() [function.fsockopen]: unable to connect to localhost:25 (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. )

URL 127.0.0.1/myplanner/output/register.php?

Error file C:\USB-Server\root\myplanner\output\libs\phpmailer\class.smtp.php

Error line 132

SQL query insert into user (Username, Password) values ('new2', 'password2')
C
 		cgphp 11/9/2011

Check this article: http://xlinesoft.com/phprunner/docs/advanced_security_settings.htm
Sergey Kornilov admin 11/9/2011

It looks like you do not have a mail server running at localhost. As Cristian pointed you need to specify your SMTP server address under Security->User Login settings.
C
 		chuckbower 11/9/2011

Antoine,
On the security page, I would think you could choose each table from the individual drop-down and apply the security such that only each user could see their own rows. Of course, that means that the user field has to be a column in each table.
Chuck
A
 		ant author 11/10/2011



Antoine,
On the security page, I would think you could choose each table from the individual drop-down and apply the security such that only each user could see their own rows. Of course, that means that the user field has to be a column in each table.
Chuck



Thanks for the quick response. I been following Christian link but im doing something wrong. I also checked the security settings but can't find anywhere to link multiple table to user settings, thats why I linked it to personal and then linked personal to the others.
Please excuse me im still a bit of a novice, below is the printscreen for my setup
DATABASE TABLES


LOGIN PAGE


LOGIN SETTINGS


ADVANCED SECURITY


USER GROUP SECURITY
A
 		ant author 11/11/2011

I've figured out what what Chuck was saying, , you need to go back each time to the advanced page on the security table and set each table up individually for the userid
The problem I have now is that the the only way I know how to add the records for each user is to link the tables otherwise you have to manually type in the linked UserID.
I know there should be a simple way around this but due to my lack of programming skills I need some advice....
Thanks