Page 1 of 1

Editing User Info While Going through multiple functions

Posted: Mon Jan 26, 2009 1:27 pm
by CoolAsCarlito
One problem however my problem is when I have it lists the handlers names with the link to the edit handler function. Its already inside one function with the list of handlers then it goes to another function but how do i tell it with that link with the edit to pass along the corresponding username id?

List of the handlers:

Code: Select all

function handlers() {
   print '<h1 class=backstage>Handler Management</h1><br />';
   print "<h2 class=backstage>Handlers :: <a href=\"#\" onclick=\"ajaxpage('addhandler', 'content'); return false;\">Add New</a></h2><br />";
   print '<table width="100%" class="table1">';
   print '<tr class="rowheading">';
   print '<td width=30>&nbsp;</td>';
   print '<td>Username</td>';
   print '<td>Surname</td>';
   print '<td>First Name</td>';
   print '<td>E-Mail</td>';
   print '</tr>';
   $query = "SELECT * FROM users";
   $result = mysql_query ( $query ); // Run The Query
   if ($result) {
      // Fetch and print all records.
      $i = 0;
      while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) {
         $sClass = 'row2';
         if ($i ++ & 1) {
            $sClass = 'row1';
         }
         printf ( "<tr class=\"%s\">", $sClass );
         print "<td valign=\"top\" align=\"center\" width=\"30\"><a href=\"#\" onclick=\"ajaxpage('edithandler', 'content'); return false;\">Edit</a></td>";
         printf ( "<td valign=\"top\">%s</td>", $row [username] );
         printf ( "<td valign=\"top\">%s</td>", $row [surname] );
         printf ( "<td valign=\"top\">%s</td>", $row [firstname] );
         printf ( "<td valign=\"top\">%s</td>", $row [email] );
         print '</tr>';
      }
   }
   print '</table><br />';
   print '<h2 class=backstage><form method=POST><input type=hidden name=action value=mainmenu><input type=submit value="Return to Main Menu" class=button200></form></h2>';
}
Here's the edit handler function:

Code: Select all

function edithandler() {
   $query = "SELECT * FROM `users` WHERE `username`='".$username."'";
   $result = mysql_query($query);
   if(mysql_num_rows($result) <= 0){
   echo("Error, Could not gather user information from database;");
   }else{
   $User = mysql_result($result,0); // Grab row 0 from $result. (first match, should only b 1 anyway)
   print '<h1 class=backstage>Handler Management</h1><br />';
   print '<h2 class=backstage>Edit Handler Details</h2><br />';
   print '<form name="edithandler" method="post" action="backstage.php" id="edithandler">';
   print '<table width="100%" class="table2">';
   print '<tr>';
   print '<td width=120 class=rowheading>Username:</td><td class=row3><input type=text name=login class=fieldtext490 value="'.$row['username'].'"></td>';
   print '</tr>';
   print '<tr>';
   print '<td class=rowheading>Password:</td><td class=row3><input type=password name=password class=fieldtext490 onfocus="this.select()" value=""></td>';
   print '</tr>';
   print '<tr>';
   print '<td class=rowheading>Surname:</td><td class=row3>';
   print '<input type=text name=surname class=fieldtext490 value="'.$row['surname'].'"></td>';
   print '</tr>';
   print '<tr>';
   print '<td class=rowheading>Firstname:</td>';
   print '<td class=row3><input type=text name=firstname class=fieldtext490 value="'.$row['firstname'].'"></td>';
   print '</tr>';
   print '<tr>';
   print '<td class=rowheading>Email:</td>';
   print '<td class=row3><input type=text name=email class=fieldtext490 value="'.$row['email'].'"></td>';
   print '</tr>';
   print '<tr>';
   print '<td class=rowheading>AIM:</td>';
   print '<td class=row3><input type=text name=aim class=fieldtext490 value="'.$row['aim'].'"></td>';
   print '</tr>';
   print '<tr>';
   print '<td class=rowheading>MSN:</td>';
   print '<td class=row3><input type=text name=msn class=fieldtext490 value="'.$row['msn'].'"></td>';
   print '</tr>';
   print '<tr>';
   print '<td class=rowheading>Forum ID:</td>';
   print '<td class=row3><input type=text name=forumid class=fieldtext490 value="'.$row['forumid'].'"></td>';
   print '</tr>';
   print '<tr>';
   print '<td class=rowheading>Account:</td>';
   print '<td class=row3><select name=enabled class=selection>';
   print '<option value=1>Enabled</option><option value=0>Disabled</option>';
   print '</select></td>';
   print '</tr>';
   print '<tr>';
   print '<td class=rowheading>Administrator:</td>';
   print '<td class=row3><select name=isadministrator class=selection>';
   print '<option value=1>Yes</option><option value=0>No</option>';
   print '</select></td>';
   print '</tr>';
   print '<tr>';
   print '<td class=rowheading>Default Character:</td>';
   print '<td class=row3></td>';
   print '</tr>';
   print '</table><br />';
   print '<input type=checkbox name=deletehandler> <span class=table1heading>Delete Handler?</span><br /><br />';
   print '<input type="submit" value="Save Handler" class="button" name="edithandler"></form><br />';
   print '<form method=POST><input type=hidden name=action value=handler><input type=submit value="Return to Handler List" class=button200></form><br />';
   print '<h2 class=backstage>Characters<br /><br /><form method=post><input type=hidden name=action value=handler><input type=hidden name=routine value=addcharacter><input type=hidden name=option value=0><input type=hidden name=id value="130"><select name=characterid class=dropdown>';
   print '<option value=0>- Select -</select>&nbsp;&nbsp;<input type=submit value="Add" class=button></form></h2><br />';
   print '<br /><br />';
   print '<h2 class=backstage><form method=POST><input type=hidden name=action value=mainmenu><input type=submit value="Return to Main Menu" class=button200></form></h2>';
}
}