Jump to content

Update not updating


HDFilmMaker2112

Recommended Posts

The below code is not updating the data when I enter additional credits into the "New Credits" input box: The page returns blank, with the data being inserted into the DB with a donor_id of 0.

 

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'];
}
if(count($credits) > 0){
$credit=implode(", ",$credits);
}

if(!empty($amount)){
$amount=number_format($amount, 2, '.', ',');
}

$section.=' - Edit User: '.$username.'';
$content.='
<div class="main">
<div class="main_header">Edit User - '.(!empty($username) ? ''.$username.'' : ''.$name.'').'</div>
<div class="user_form">
<form action="./index.php?admincp=users&do=process&source=edit&id='.$id.'" 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="credit_old" size="30" value="'.$credit.'" disabled="disabled" /></p>
    <p><label>New Credits:</label> <input type="text" name="credit" size="30" /></p>
    <p><label>Password:</label> <input type="text" name="password" size="30" value="'.$password.'"  /></p>
    <p><input type="submit" value="Submit" name="Submit" /></p>
</form>
</div>
</div>
';
}

elseif($_GET['do']="process"){
$source=sanitize($_GET['source']);
$name=sanitize($_POST['name']);
$email=sanitize($_POST['email']);
$amount=amount_verify(sanitize($_POST['amount']));
$username=sanitize($_POST['username']);
$level=sanitize($_POST['level']);
$password=kam3($_POST['password']);
$admin=sanitize($_POST['user_level']);
$credits=sanitize($_POST['credit']);
$credits=explode(",",$credits);
array_walk($credits, 'trim_value');

if($amount=="00" || $amount==".00"){
$amount="";
}
elseif($_GET['source']=="edit"){
$insert_id=$_GET['id'];
$edit_user_query="UPDATE $tbl_name username='$username', name='$name', level='$level', amount='$amount', password='$password', admin='$admin', email='$email' WHERE donor_id='$insert_id'";
mysql_query($edit_user_query);
if(!empty($credits)){
$CreditArray = array();
foreach($credits as $credit){
$CreditArray[] = "('$credit',$insert_id)";
}
if(mysql_affected_rows()==1){
$content.='<div class="center">User Edited.</div>';
}
if (count($CreditArray) > 0 ){
$credit_array_query="INSERT $tbl_name2 (credit,donor_id) VALUES " . implode(',',$CreditArray);
mysql_query($credit_array_query);
}
}
}
}

Link to comment
https://forums.phpfreaks.com/topic/241973-update-not-updating/
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.