I'm pretty much an amature at PHP trying to help a friend. Can you look through this script and find why the information entered is not being saved to the sql. I believe I need an sql update but my friend who is a better coder than I said no.
Thanks.
Max
Code: Select all
<?php
include('./includes/load_database.php');
connect_mysql();
$userid = $_GET['uid'];
$sql = "SELECT * FROM `cj_orders` WHERE `sid` LIKE 'zgnw\_%\_$userid\_%\_%'";
$result = mysql_query($sql);
$i = 0;
while($records = @mysql_fetch_array($result)){
$user_orders["$i"]['rate'] = $records['commissionAmount'];
$user_orders["$i"]['store'] = ucwords($records['advertiserName']);
$user_orders["$i"]['date'] = substr($records['eventDate'], 0, 10);
$user_orders["$i"]['sale'] = '$'.number_format($records['saleAmount'], 2);
$user_orders["$i"]['sid'] = $records['sid'];
$user_orders["$i"]['zpoints'] = $records['zpoints'];
$user_orders["$i"]['status'] = $records['status'];
$user_orders["$i"]['type'] = 'CJ';
$i++;
}
$sql = "SELECT * FROM `pm_orders` WHERE `sid` LIKE 'zgnw\_%\_$userid\_%\_%'";
$result = mysql_query($sql);
while($records = @mysql_fetch_array($result)){
$user_orders["$i"]['rate'] = $records['commissionAmount'];
$user_orders["$i"]['store'] = ucwords($records['adname']);
$user_orders["$i"]['date'] = $records['date'];
$user_orders["$i"]['sale'] = '$'.number_format($records['saleAmount'], 2);
$user_orders["$i"]['sid'] = $records['sid'];
$user_orders["$i"]['zpoints'] = $records['zpoints'];
$user_orders["$i"]['status'] = $records['status'];
$user_orders["$i"]['type'] = 'PM';
$i++;
}
$sql = "SELECT * FROM `revu_orders` WHERE `sid` LIKE 'zgnw\_%\_$userid\_%\_%'";
$result = mysql_query($sql);
while($records = @mysql_fetch_array($result)){
$user_orders["$i"]['rate'] = $records['rate'];
$user_orders["$i"]['store'] = ucwords($records['name']);
$user_orders["$i"]['date'] = substr($records['date'], 0, 10);
$user_orders["$i"]['sale'] = 'Offer'; //number_format($records['saleAmount'], 2);
$user_orders["$i"]['sid'] = $records['sid'];
$user_orders["$i"]['zpoints'] = $records['zpoints'];
$user_orders["$i"]['status'] = $records['status'];
$user_orders["$i"]['type'] = 'RU';
$i++;
}
$sql = "SELECT * FROM `zogo_credits` WHERE `sid` LIKE 'zgnw\_%\_$userid\_%\_%'";
$result = mysql_query($sql);
while($records = @mysql_fetch_array($result)){
$user_orders["$i"]['rate'] = $records['commission'];
$user_orders["$i"]['store'] = ucwords($records['name']);
$user_orders["$i"]['date'] = substr($records['date'], 0, 10);
$user_orders["$i"]['sale'] = 'Credit';
$user_orders["$i"]['sid'] = $records['sid'];
$user_orders["$i"]['zpoints'] = $records['zpoints'];
$user_orders["$i"]['status'] = $records['status'];
$user_orders["$i"]['type'] = 'ZP';
$i++;
}
$sortArr = array();
foreach ($user_orders as $key => $value ){
$sortArr[ $key ] = $value['date'];
}
arsort( $sortArr );
$resultArr = array();
echo '<form action="?page=userdetails&uid='.$userid.'" method="post">';
echo '<table border="0" width="95%" class="tdstyle1">';
echo '<tr><td class="datum1"><b>Store:</b></td><td class="datum1"><b>Sale:</b></td><td class="datum1"><b>Commission:</b></td><td class="datum1"><b>Date:</b></td><td class="datum1"><b>Points:</b></td></tr>';
if(count($user_orders)){
$i = 0;
$commission = 0;
foreach ($user_orders as $key => $value ){
echo '<tr>';
echo '<td class="datum1"><input type="text" value="'.$user_orders[$key]['store'].'"></td>';
echo '<td class="datum1"><input type="text" value="'.$user_orders[$key]['sale'].'"></td>';
echo '<td class="datum1"><input type="text" value="$'.number_format($user_orders[$key]['rate'],2).'"></td>';
echo '<td class="datum1">'.$user_orders[$key]['date'].'</td>';
echo '<td class="datum1"><span class="clgreen"><b><input type="text" value="'.$user_orders[$key]['zpoints'].'"></b></span></td>';
echo '</tr>';
$commission += $user_orders[$key]['rate'];
$i++;
}
echo '<tr><td colspan="4" class="datum1"><b>Total Commission: $'.number_format($commission, 2).'</b></td></tr>';
}else{
echo '<tr><td colspan="4" class="datum1">No recent activity.</td></tr>';
}
echo '<tr><td colspan="2">'.'<input type="submit" value="Save Details" name="savedetails">'.'</td></tr>';
echo '</table>';
echo '<input type="hidden" name="func" value="savedetails">';
echo '<input type="hidden" name="userid" value="'.$userid.'">';
echo '</form>';
disconnect_mysql();
?>