Jump to content

Blank Page Displayed


Recommended Posts

The below is only returning one user from the database, it should be generating a list of all users in the database.

 

elseif($_GET['do']=="edit"){

  if(isset($_GET['id'])){
  $id=(int)$_GET['id'];

  $edit_user_query="SELECT * FROM $tbl_name WHERE $tbl_name.donor_id=$id";
  $edit_user_result=mysql_query($edit_user_query);
    while($edit_user_row=mysql_fetch_array($edit_user_result)){
    extract($edit_user_row);
    }
  $credits_query="SELECT * FROM donors_credits WHERE donor_id=".$id." ORDER BY id";
  $credits_result=mysql_query($credits_query);
    while($credits_row=mysql_fetch_array($credits_result)){
    $credits[]=$credits_row['credit'];
    }
  $credit=implode(",",$credits);

  $section.=' - Edit User: '.$username.'';
  $content.='
  <div class="main">
  <div class="main_header">Edit User - '.$username.'</div>
  <div class="user_form">
   <form action="./.php" method="post">
    <p><label>Name:</label> <input type="text" name="name" size="30" value="'.$name.'" /></p>
    <p><label>E-Mail:</label> <input type="email" name="email" size="32" value="'.$email.'" /></p>
    <p><label>Amount:</label> <input type="text" name="amount" size="8" value="'.$amount.'" /></p>
    <p><label>Username:</label> <input type="text" name="username" size="30" value="'.$username.'" /></p>
    <p>
    <label>Level:</label> 
    <select name="level">
    <option value=""'.(empty($level) ? ' selected="selected"' : '').'></option>
    <option value="nickel"'.($level=="nickel" ? ' selected="selected"' : '').'>Nickel</option>
    <option value="copper"'.($level=="copper" ? ' selected="selected"' : '').'>Copper</option>
    <option value="bronze"'.($level=="bronze" ? ' selected="selected"' : '').'>Bronze</option>
    <option value="silver"'.($level=="silver" ? ' selected="selected"' : '').'>Silver</option>
    <option value="gold"'.($level=="gold" ? ' selected="selected"' : '').'>Gold</option>
    <option value="platinum"'.($level=="platinum" ? ' selected="selected"' : '').'>Platinum</option>
    <option value="palladium"'.($level=="palladium" ? ' selected="selected"' : '').'>Palladium</option>
    </select> (Blank if something other than Donation)
    </p>
    <p>
    <label>User Level:</label> 
    <select name="user_level">
    <option value="0"'.($admin=="0" ? ' selected="selected"' : '').'>No Account</option>
    <option value="1"'.($admin=="1" ? ' selected="selected"' : '').'>Credit Purchase</option>
    <option value="2"'.($admin=="2" ? ' selected="selected"' : '').'>Donation</option>
    <option value="3"'.($admin=="3" ? ' selected="selected"' : '').'>Moderator</option>
    <option value="4"'.($admin=="4" ? ' selected="selected"' : '').'>Admin</option>
    </select>
    </p>
    <p><label>Credit:</label> <input type="text" name="amount" size="30" value="'.$credit.'" /></p>
    <p><label>Password:</label> <input type="text" name="username" size="30" value="'.$password.'"  /></p>
    <p><label>Confirm Password:</label> <input type="text" name="username"  size="30" /></p>
    <p><input type="submit" value="Submit" name="Submit" /></p>
   </form>
  </div>
  </div>
  ';
  }
  else{
  $user_list_query="SELECT * FROM $tbl_name";
  $user_list_result=mysql_query($user_list_query);
    while($user_list_row=mysql_fetch_array($user_list_result)){
    extract($user_list_row);
   $content='<div><a href="./index.php?admincp=users&do=edit&'.$donor_id.'">'.(!empty($username) ? ''.$username.'' : ''.$name.'').'</a></div><br />';
    }
  }
}

 

 

EDIT: Solved. $content has to be concatenated.

Link to comment
https://forums.phpfreaks.com/topic/241375-blank-page-displayed/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.