Visual Paradigm Logo
     Build Quality Applications Faster, Better and Cheaper
 
Home | Products | Download | Documentation | Support | Resources | Partners | Quick Tour | Shop | Company |  
 
   Visual Paradigm Discussion Forum
  Login   [ Register ] Email: Password: Log me on automatically I lost my password  
Recent Topics
Advanced Search
PHP DBVA RElationships not working properly  
Forum Index -> DB Visual ARCHITECT (DB-VA)
Author Message
nomspes@gmail.com


Joined: 2007/03/23
Messages: 3

Offline

I designed a website pretty much around users and user permissions with DBVA-PHP Edition

What im trying to do seems like it should work.. I created a permission via this script

Code:
 <?
 include "config.php";
 
 $user = UsersDAO::loadUsersByORMID(1);
 echo $user . "<hr>";
 $permType = Permision_typesDAO::createPermision_types();
 $permType->setDescription('modules');
 Permision_typesDAO::save($permType);
 echo $permType . "<hr>";
 $cperm = PermissionDAO::createPermission();
 $cperm->setPermision_typespermissiontype($permType);
 $cperm->setDescription('news');
 PermissionDAO::save($cperm);
 echo $cperm . "<hr>";
 $perms = User_permissionsDAO::createUser_permissions();
 $perms->setPermission($cperm);
 $perms->setUser($user);
 User_permissionsDAO::save($perms);
 echo $perms . "<hr>";
 echo $user . "<hr>";
 ?> 



Then when I want to get a users User_permissions, i should be able to load the user and then type $user->getPermissions();

However that doesnt work so i tried a different method, load all User_Permissions and compare user objects.

Code:
 			
 $userperms = User_permissionsDAO::listUser_permissionsByQuery(null,null);
 foreach($userperms as $line)
 {
       print $line;
 }
  

Gives me a

User_permissions[user_permissionid=1 user=null permission=null created=0 created_by=0 updated=0 updated_by=0 deleted=0 deleted_by=0 ]User_permissions[user_permissionid=2 user=null permission=null created=0 created_by=0 updated=0 updated_by=0 deleted=0 deleted_by=0 ]


And in my database, I can see, userid = 1;

If anyone wants me to attach the ERD let me know.
 
Jick


Joined: 2005/04/29
Messages: 2880

Offline

Hi nomspes,

Thank you for your post. Please send us your project file for reproducing the problem. Please send to my Email address at:
jick@visual-paradigm.com

Best regards,
Jick

Visual Paradigm International Ltd.
http://www.visual-paradigm.com

Build Quality Applications Faster, Better and Cheaper
 
 
   Forum Index -> DB Visual ARCHITECT (DB-VA)
Go to:   
Powered by JForum 2.1.4 © 2005 - Rafael Steil