Php Scripts and Mysql functions
I have downloaded a program script called dotproject 2.1.2. I am using a linux server Fedora Core 8. My php version is php Version: 5.1, MySQL Version: 5.0, and Operating System Version: Linux, Browsers: Firefox and Internet Explorer 8.
I have created a drop down menu that echoes the information that is stored in a Project table. The field name is project_name and in that field table there are many projects that are associated with different companies but all the projects are listed in the table. I would like to assign one user to one or more projects that are listed from this echo drop down menu from the mysql project database. The database is called projects. The user table contains several fields named user_id, user_contact, user_username, user_password, user_parent, user_type, user_company, user_department, user_owner, and user_signature.
I am searching for a way to store the information that is assigned to one user from the list of projects displayed in the drop down menu. The list will vary with other entries of new projects that are being added. In this scenario projects never deleted or changed, but projects keep getting added as new projects come in to the database. I have listed below are the 3 php scripts: I have highlighted the parts that I have added to the orignal script
addedituser.php
PHP Code:
<?php /* ADMIN $Id: admin.class.php 5633 2008-03-12 11:14:40Z cyberhorse $ */ if (! defined ( 'DP_BASE_DIR' )){ 'You should not access this file directly.' ); $AppUI -> getModuleClass ( 'projects' )); /** class CUser extends CDpObject { $user_id = NULL ; $user_username = NULL ; $user_password = NULL ; $user_parent = NULL ; $user_type = NULL ; $user_contact = NULL ; $user_signature = NULL ; B ]var $project_users = NULL ; // var $user_projects = NULL; var $project_id = NULL ; // var $project_company = NULL; var $project_short_name = NULL ;[/ B ] /* var $user_first_name = NULL; function CUser () { $this -> CDpObject ( 'users' , 'user_id' ); check () { $this -> user_id === NULL ) { 'user id is NULL' ; $this -> user_password !== NULL ) { $this -> user_password = db_escape ( trim ( $this -> user_password ) ); // TODO MORE return NULL ; // object is ok } // This "breaks" check-in/upload if project is not present. } store () { $msg = $this -> check (); $msg ) { get_class ( $this ). "::store-check failed" ; B ] { $AppUI , $project_name ; $project_name ) { $this -> project_name = NULL ; $this -> CDpObject ( 'projects' , 'project_id' ); $project_available ; $project_available && $this -> project_name != 0 ) { $this -> addprojectTaskLog (); parent :: store (); B ] $q = new DBQuery ; $this -> user_id ) { // save the old password $perm_func = "updateLogin" ; $q -> addTable ( 'users' ); $q -> addQuery ( 'user_password' ); $q -> addWhere ( "user_id = $this -> user_id " ); $pwd = $q -> loadResult (); $pwd != $this -> user_password ) { $this -> user_password = md5 ( $this -> user_password ); addHistory ( $this -> _tbl , $this -> user_id , 'password changed' , 'Password changed from IP ' . $_SERVER [ 'REMOTE_ADDR' ]); $this -> user_password = null ; $ret = db_updateObject ( 'users' , $this , 'user_id' , false ); $perm_func = "addLogin" ; $this -> user_password = md5 ( $this -> user_password ); $ret = db_insertObject ( 'users' , $this , 'user_id' ); $ret ) { get_class ( $this ). "::store failed <br />" . db_error (); $acl =& $GLOBALS [ 'AppUI' ]-> acl (); $acl -> $perm_func ( $this -> user_id , $this -> user_username ); NULL ; delete ( $oid = NULL ) { $id = $this -> user_id ; $result = parent :: delete ( $oid ); $result ) { $acl =& $GLOBALS [ 'AppUI' ]-> acl (); $acl -> deleteLogin ( $id ); $q = new DBQuery ; $q -> setDelete ( 'user_preferences' ); $q -> addWhere ( 'pref_user = ' . $this -> user_id ); $q -> exec (); $q -> clear (); $result ; ?> <?php /* ADMIN $Id$ */ if (! defined ( 'DP_BASE_DIR' )) { 'You should not access this file directly.' ); $addPwT , $company_id , $dept_ids , $department , $min_view , $m , $a ; $user_id = intval ( dPgetParam ( $_GET , 'user_id' , 0 )); $user_id != $AppUI -> user_id && (! getPermission ( 'admin' , 'view' , $user_id ) getPermission ( 'users' , 'view' , $user_id ))) $AppUI -> redirect ( 'm=public&a=access_denied' ); $AppUI -> savePlace (); $_POST [ 'show_form' ])) { $add_pwt = dPgetParam ( $_POST , 'add_pwt' , 0 ); $AppUI -> setState ( 'addProjWithTasks' , $add_pwt ); $AppUI -> setState ( 'addProjWithTasks' , false ); $addPwT = $AppUI -> getState ( 'addProjWithTasks' ) ? $AppUI -> getState ( 'addProjWithTasks' ) : 0 ; $company_id = $AppUI -> getState ( 'UsrProjIdxCompany' ) !== NULL ? $AppUI -> getState ( 'UsrProjIdxCompany' ) : $AppUI -> user_company ; $company_prefix = 'company_' ; $_POST [ 'department' ])) { $AppUI -> setState ( 'UsrProjIdxDepartment' , $_POST [ 'department' ]); //if department is set, ignore the company_id field unset( $company_id ); $department = $AppUI -> getState ( 'UsrProjIdxDepartment' ) !== NULL ? $AppUI -> getState ( 'UsrProjIdxDepartment' ) : $company_prefix . $AppUI -> user_company ; //if $department contains the $company_prefix string that it's requesting a company and not a department. So, clear the if (!( mb_strpos ( $department , $company_prefix )=== false )) { $company_id = mb_substr ( $department , mb_strlen ( $company_prefix )); $AppUI -> setState ( 'UsrProjIdxCompany' , $company_id ); $department ); $_GET [ 'tab' ])) { $AppUI -> setState ( 'UserVwTab' , $_GET [ 'tab' ]); $tab = $AppUI -> getState ( 'UserVwTab' ) !== NULL ? $AppUI -> getState ( 'UserVwTab' ) : 0 ; // pull data $q = new DBQuery ; $q -> addTable ( 'users' , 'u' ); $q -> addQuery ( 'u.*' ); $q -> addQuery ( 'con.*, company_id, company_name, dept_name, dept_id' ); $q -> addJoin ( 'contacts' , 'con' , 'user_contact = contact_id' ); $q -> addJoin ( 'companies' , 'com' , 'contact_company = company_id' ); $q -> addJoin ( 'projects' , 'pro' , 'project_name = project_id' ); $q -> addJoin ( 'departments' , 'dep' , 'dept_id = contact_department' ); $q -> addWhere ( 'u.user_id = ' . $user_id ); $sql = $q -> prepare (); $q -> clear (); B ] // pull projects $q = new DBQuery ; $q -> addTable ( 'projects' ); $q -> addQuery ( 'project_id, project_name' ); $q -> addOrder ( 'project_name' ); $projects = arrayMerge ( array( 0 => '' ), $q -> loadHashList () ); [/ B ] db_loadHash ( $sql , $user )) { $titleBlock = new CTitleBlock ( 'Invalid User ID' , 'helix-setup-user.png' , $m , " $m . $a " ); $titleBlock -> addCrumb ( '?m=admin' , 'users list' ); $titleBlock -> show (); // setup the title block $titleBlock = new CTitleBlock ( 'View User' , 'helix-setup-user.png' , $m , " $m . $a " ); $canRead ) { $titleBlock -> addCrumb ( '?m=admin' , 'users list' ); $canEdit ) { $titleBlock -> addCrumb ( '?m=admin&a=addedituser&user_id=' . $user_id , 'edit this user' ); $canEdit || $user_id == $AppUI -> user_id ) { $titleBlock -> addCrumb ( '?m=system&a=addeditpref&user_id=' . $user_id , 'edit preferences' ); $titleBlock -> addCrumbRight ( '<a href="#" onclick="popChgPwd();return false">' . $AppUI -> _ ( 'change password' ) . '</a>' ); $titleBlock -> addCell ( '<input type="button" class=button value="' . $AppUI -> _ ( 'add user' ) '" onClick="javascript . '?m=admin&a=addedituser\';" />' ); $titleBlock -> show (); ?> <?php // security improvement: if ( $canEdit || $user_id == $AppUI -> user_id ) { ?> <?php echo $user [ 'user_id' ]; ?> ', 'chpwd', 'top=250,left=250,width=350, height=220, scrollbars=no'); <?php } ?> <?php echo $AppUI -> _ ( 'Login Name' ); ?> :</td> <?php echo $user [ 'user_username' ]; ?> </td> <?php echo $AppUI -> _ ( 'User Type' ); ?> :</td> <?php echo $AppUI -> _ ( $utypes [ $user [ 'user_type' ]]); ?> </td> <?php echo $AppUI -> _ ( 'Real Name' ); ?> :</td> <?php echo $user [ 'contact_first_name' ]. ' ' . $user [ 'contact_last_name' ]; ?> </td> <?php echo $AppUI -> _ ( 'Project Company' ); ?> :</td> <?php if ( getPermission ( 'companies' , 'access' , $user [ 'contact_company' ])) { '<a href="?m=companies&a=view&company_id=' . $user [ 'contact_company' ] . '" title="' . htmlspecialchars ( $user [ 'company_name' ], ENT_QUOTES ) . '">' . htmlspecialchars ( $user [ 'company_name' ], ENT_QUOTES ) . '</a>' ; htmlspecialchars ( $user [ 'company_name' ], ENT_QUOTES ); ?> <?php echo $AppUI -> _ ( 'Projects' ); ?> :</td> <?php ( $user [ "projects" ] ); ?> <?php echo $AppUI -> _ ( 'Department' ); ?> :</td> <?php echo @ $user [ 'contact_department' ]; ?> "><?php echo $user [ 'dept_name' ]; ?> </a> <?php echo $AppUI -> _ ( 'Phone' ); ?> :</td> <?php echo @ $user [ 'contact_phone' ]; ?> </td> <?php echo $AppUI -> _ ( 'Home Phone' ); ?> :</td> <?php echo @ $user [ 'contact_phone2' ]; ?> </td> <?php echo $AppUI -> _ ( 'Mobile' ); ?> :</td> <?php echo @ $user [ 'contact_mobile' ]; ?> </td> <?php echo $AppUI -> _ ( 'Address' ); ?> :</td> <?php echo @ $user [ 'contact_address1' ] $user [ 'contact_address2' ]) ? '<br />' . $user [ 'contact_address2' ] : '' ) '<br />' . $user [ 'contact_city' ] ' ' . $user [ 'contact_state' ] ' ' . $user [ 'contact_zip' ] '<br />' . $user [ 'contact_country' ] ?> </td> <?php echo $AppUI -> _ ( 'Birthday' ); ?> :</td> <?php echo @ $user [ 'contact_birthday' ]; ?> </td> <?php echo @ $user [ 'contact_icq' ]; ?> </td> <?php echo @ $user [ 'contact_aol' ]; ?> "><?php echo @ $user [ 'contact_aol' ]; ?> </a></td> <?php echo $AppUI -> _ ( 'Email' ); ?> :</td> <?php echo '<a href="mailto:' .@ $user [ 'contact_email' ]. '">' .@ $user [ 'contact_email' ]. '</a>' ; ?> </td> <?php echo $AppUI -> _ ( 'Signature' ); ?> :</strong></td> <?php echo str_replace ( chr ( 10 ), '<br />' , $user [ 'user_signature' ]); ?> <?php // force tabbed information boxes $min_view = true ; $oldViewPref = $AppUI -> getPref ( 'TABVIEW' ); $AppUI -> setPref ( 'TABVIEW' , 1 ); $tabBox = new CTabBox (( '?m=admin&a=viewuser&user_id=' . $user_id ), '' , $tab ); $tabBox -> loadExtras ( 'admin' , 'viewuser' ); $tabBox -> add ( DP_BASE_DIR . '/modules/admin/vw_usr_log' , 'User Log' ); $tabBox -> add ( DP_BASE_DIR . '/modules/admin/vw_usr_perms' , 'Permissions' ); $tabBox -> add ( DP_BASE_DIR . '/modules/admin/vw_usr_roles' , 'Roles' ); $tabBox -> show (); $AppUI -> setPref ( 'TABVIEW' , $oldViewPref ); ?> <?php /* ADMIN $Id: addedituser.php 5773 2008-07-21 15:04:07Z merlinyoda $ */ if (! defined ( 'DP_BASE_DIR' )) { 'You should not access this file directly.' ); $user_id = isset( $_GET [ 'user_id' ]) ? $_GET [ 'user_id' ] : 0 ; $user_id == 0 ) $canEdit = $canAuthor ; $canEdit ) $canEdit = $perms -> checkModuleItem ( 'users' , ( $user_id ? 'edit' : 'add' ), $user_id ); // check permissions if (! $canEdit && $user_id != $AppUI -> user_id ) { $AppUI -> redirect ( "m=public&a=access_denied" ); //$roles require_once DP_BASE_DIR . "/modules/system/roles/roles.class.php" ; $perms =& $AppUI -> acl (); $crole =& new CRole ; $roles = $crole -> getRoles (); // Format the roles for use in arraySelect $roles_arr = array(); $roles as $role ) { $roles_arr [ $role [ 'id' ]] = $role [ 'name' ]; $roles_arr = arrayMerge ( array( 0 => '' ), $roles_arr ); $q = new DBQuery ; $q -> addTable ( 'users' , 'u' ); $q -> addQuery ( 'u.*' ); $q -> addQuery ( 'con.*, company_id, company_name, dept_name' ); $q -> addJoin ( 'contacts' , 'con' , 'user_contact = contact_id' ); $q -> addJoin ( 'companies' , 'com' , 'contact_company = company_id' ); B ] $q -> addJoin ( 'projects' , 'pro' , 'project_name = project_id' );[/ B ] $q -> addJoin ( 'departments' , 'dep' , 'dept_id = contact_department' ); $q -> addWhere ( 'u.user_id = ' . $user_id ); $sql = $q -> prepare (); $q -> clear (); db_loadHash ( $sql , $user ) && $user_id > 0 ) { $titleBlock = new CTitleBlock ( 'Invalid User ID' , 'helix-setup-user.png' , $m , " $m . $a " ); $titleBlock -> addCrumb ( "?m=admin" , "users list" ); $titleBlock -> show (); $user_id == 0 ) $user [ 'contact_id' ] = 0 ; // pull companies $q = new DBQuery ; $q -> addTable ( 'companies' ); $q -> addQuery ( 'company_id, company_name' ); $q -> addOrder ( 'company_name' ); $companies = arrayMerge ( array( 0 => '' ), $q -> loadHashList () ); B ] // pull projects $q = new DBQuery ; $q -> addTable ( 'projects' ); $q -> addQuery ( 'project_id, project_name' ); $q -> addOrder ( 'project_name' ); $projects = arrayMerge ( array( 0 => '' ), $q -> loadHashList () ); [/ B ] // setup the title block $ttl = $user_id > 0 ? "Edit User" : "Add User" ; $titleBlock = new CTitleBlock ( $ttl , 'helix-setup-user.png' , $m , " $m . $a " ); $perms -> checkModule ( 'admin' , 'view' ) && $perms -> checkModule ( 'users' , 'view' )) $titleBlock -> addCrumb ( "?m=admin" , "users list" ); $user_id > 0 ) { $titleBlock -> addCrumb ( "?m=admin&a=viewuser&user_id= $user_id " , "view this user" ); $canEdit || $user_id == $AppUI -> user_id ) { $titleBlock -> addCrumb ( "?m=system&a=addeditpref&user_id= $user_id " , "edit preferences" ); $titleBlock -> show (); ?> <?php echo dPgetConfig ( 'username_min_len' ); ?> && form.user_username.value != '<?php echo dPgetConfig ( 'admin_username' ); ?> ') { <?php echo $AppUI -> _ ( 'adminValidUserName' , UI_OUTPUT_JS ) ; ?> " + <?php echo dPgetConfig ( 'username_min_len' ); ?> ); <?php if ( $canEdit && ! $user_id ) { ?> <?php echo $AppUI -> _ ( 'adminValidRole' , UI_OUTPUT_JS ); ?> "); <?php } ?> <?php echo dPgetConfig ( 'password_min_len' ); ?> ) { <?php echo $AppUI -> _ ( 'adminValidPassword' , UI_OUTPUT_JS ); ?> " + <?php echo dPgetConfig ( 'password_min_len' ); ?> ); <?php echo $AppUI -> _ ( 'adminPasswordsDiffer' , UI_OUTPUT_JS ); ?> "); <?php echo $AppUI -> _ ( 'adminValidFirstName' , UI_OUTPUT_JS ); ?> "); <?php echo $AppUI -> _ ( 'adminValidLastName' , UI_OUTPUT_JS ); ?> "); <?php echo $AppUI -> _ ( 'adminInvalidEmail' , UI_OUTPUT_JS ); ?> "); <?php echo $AppUI -> _ ( 'adminInvalidBirthday' , UI_OUTPUT_JS ); ?> "); <?php echo $AppUI -> _ ( 'adminInvalidBirthday' , UI_OUTPUT_JS ); ?> "); <?php echo $AppUI -> _ ( 'adminInvalidMonth' , UI_OUTPUT_JS ). ' ' . $AppUI -> _ ( 'adminInvalidBirthday' , UI_OUTPUT_JS ); ?> "); <?php echo $AppUI -> _ ( 'adminInvalidDay' , UI_OUTPUT_JS ). ' ' . $AppUI -> _ ( 'adminInvalidBirthday' , UI_OUTPUT_JS ); ?> "); <?php echo $AppUI -> _ ( 'adminInvalidYear' , UI_OUTPUT_JS ). ' ' . $AppUI -> _ ( 'adminInvalidBirthday' , UI_OUTPUT_JS ); ?> "); <?php echo $AppUI -> _ ( 'Please select a company first!' , UI_OUTPUT_JS ); ?> '); <?php echo intval ( $user [ "user_id" ]); ?> " /> <?php echo intval ( $user [ "contact_id" ]); ?> " /> <?php echo dPgetConfig ( 'username_min_len' ); ?> )" /> <?php echo dPgetConfig ( 'password_min_len' ); ?> )" /> <?php echo $AppUI -> _ ( 'Login Name' ); ?> :</td> <?php if (@ $user [ "user_username" ]){ '<input type="hidden" class="text" name="user_username" value="' . $user [ "user_username" ] . '" />' ; '<strong>' . $user [ "user_username" ] . '</strong>' ; '<input type="text" class="text" name="user_username" value="' . $user [ "user_username" ] . '" maxlength="255" size="40" />' ; ?> <?php if ( $canEdit ) { // prevent users without read-write permissions from seeing and editing user type ?> <?php echo $AppUI -> _ ( 'User Type' ); ?> :</td> <?php echo arraySelect ( $utypes , 'user_type' , 'class=text size=1' , $user [ "user_type" ], true ); ?> <?php } // End of security ?> <?php if ( $canEdit && ! $user_id ) { ?> <?php echo $AppUI -> _ ( 'User Role' ); ?> :</td> <?php echo arraySelect ( $roles_arr , 'user_role' , 'size="1" class="text"' , '' , true ); ?> </td> <?php } ?> <?php echo $AppUI -> _ ( 'Password' ); ?> :</td> <?php echo $user [ "user_password" ]; ?> " maxlength="32" size="32" /> </td> <?php echo $AppUI -> _ ( 'Confirm Password' ); ?> :</td> <?php echo $user [ "user_password" ]; ?> " maxlength="32" size="32" /> </td> <?php echo $AppUI -> _ ( 'Name' ); ?> :</td> <?php echo $user [ "contact_first_name" ]; ?> " maxlength="50" /> <input type="text" class="text" name="contact_last_name" value="<?php echo $user [ "contact_last_name" ]; ?> " maxlength="50" /></td> <?php if ( $canEdit ) { ?> <?php echo $AppUI -> _ ( 'Company' ); ?> :</td> <?php echo arraySelect ( $companies , 'contact_company' , 'class=text size=1' , $user [ "contact_company" ] ); ?> <?php echo $AppUI -> _ ( 'Projects' ); ?> :</td> <?php echo projectSelectWithOptGroup ( $projects , 'projects' , 'class="text" MULTIPLE size="10"' , $user [ "projects" ] ); ?> <?php } ?> <?php echo $AppUI -> _ ( 'Department' ); ?> :</td> <?php echo @ $user [ "contact_department" ]; ?> " /> <?php echo @ $user [ "dept_name" ]; ?> " size="40" disabled /> <?php echo $AppUI -> _ ( 'select dept' ); ?> ..." onclick="popDept()" /> <?php echo $AppUI -> _ ( 'Email' ); ?> :</td> <?php echo $user [ "contact_email" ]; ?> " maxlength="255" size="40" /> </td> <?php echo $AppUI -> _ ( 'Email' ). ' ' . $AppUI -> _ ( 'Signature' ); ?> :</td> <?php echo @ $user [ "user_signature" ]; ?> </textarea></td> <?php echo $user [ 'user_contact' ]; ?> "><?php echo $AppUI -> _ (array( 'edit' , 'contact info' )); ?> </a></td> <?php echo $AppUI -> _ ( 'Required Fields' ); ?> </td> <?php echo $AppUI -> _ ( 'back' ); ?> " onClick="javascript<?php if ( $canEdit && ! $user_id ) { ?> <?php echo $AppUI -> _ ( 'Inform new user of their account details?' ); ?> </label> <input type="checkbox" value="1" name="send_user_mail" id="send_user_mail" /> <?php } ?> <?php echo $AppUI -> _ ( 'submit' ); ?> " onclick="submitIt()" class="button" /> <?php } ?>
What I would like to happen, is that the addedituser.php insert and store the information from one or more projects into the projects mysql database. That is what I am trying to accomplished. After that is done, It echoes in the viewiser.php the inserted and stored parameters of the project names.
If you require an example, please contact me. I do need help with the correct syntax to make this work. Any ideas will be appreciated.
Thanks
Last edited by Nico; 06-04-10 at 04:18 AM .
Reason: Wrappers.
Linear Mode
