[insert_php]
$db_arr = array(
‘local’ => array(
‘host’ => ‘localhost’,
‘user’ => ‘root’,
‘name’ => ‘laslomitas’,
‘psw’ => ”,
),
‘hipopotamo’ => array(
‘host’ => ‘localhost’,
‘user’ => ‘i786580_wp1’,
‘name’ => ‘i786580_wp1’,
‘psw’ => ‘W(rKyX5(tZZYNCu7zh(74~.4’,
),
‘laslomitas’ => array(
‘host’ => ‘localhost’,
‘user’ => ‘i786580_wp8’,
‘name’ => ‘i786580_wp8’,
‘psw’ => “Q@3TY0*ChKJJBeXSj(*00(^3′)”,
),
);

$server_db = “hipopotamo”;

defined(“DB_HOST”) ? null : define(“DB_HOST”, $db_arr[$server_db][‘host’]);
defined(“DB_USER”) ? null : define(“DB_USER”, $db_arr[$server_db][‘user’]);
defined(“DB_NAME”) ? null : define(“DB_NAME”, $db_arr[$server_db][‘name’]);
defined(“DB_PASSWORD”) ? null : define(“DB_PASSWORD”, $db_arr[$server_db][‘psw’]);

$db = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die(mysql_error());

mysql_select_db(DB_NAME, $db);
mysql_query(“SET NAMES ‘utf8′”);

try {
global $current_user;
get_currentuserinfo();
//echo $current_user->ID;
//echo $current_user->user_login;
//$ID = ‘16273829’;
//$current_user->user_login = ‘16905633’;
$alum = “SELECT * FROM dt_alumnos WHERE alum_ci_p =”.$current_user->user_login;
// echo $alum;
$exec = mysql_query($alum) or die(mysql_error());
while ($a = mysql_fetch_assoc($exec)) {
// print_r ($a);
echo “

“.$a[‘alum_nombre’].”

“;
echo ‘

‘;
$cxcobrar = “SELECT f_monto,f_interes,f_abono,f_descuento,f_fecha,f_fechavenc,f_descripcion,(f_monto + f_interes – f_abono – f_descuento) as saldo FROM dt_vfctac WHERE alum_cod =”.$a[‘alum_codigo’];
//echo $cxcobrar;
$montoT = 0;
$interesT = 0;
$abonoT = 0;
$descuentoT = 0;
$saldoT=0;
//$d = new DateTime($r[‘hist_fact_fecha’]);
$query = mysql_query($cxcobrar) or die(mysql_error());
while ($r = mysql_fetch_assoc($query)) {
// print_r ($r);
echo ‘

‘;
$montoT +=$r[‘f_monto’];
$interesT+=$r[‘f_interes’];
$abonoT+=$r[‘f_abono’];
$descuentoT+=$r[‘f_descuento’];
$saldoT+=$r[‘saldo’];

}
echo “

“;
}
echo “

“;
echo “

“;
echo “

Monto	Interes	Abono	Descuento	Fecha	Fecha de Vencimiento	Descripción	Saldo
BsF. ‘.number_format($r[‘f_monto’],2,’,’,’.’).’	BsF. ‘.number_format($r[‘f_interes’],2,’,’,’.’).’	BsF. ‘.number_format($r[‘f_abono’],2,’,’,’.’).’	BsF. ‘.number_format($r[‘f_descuento’],2,’,’,’.’).’	‘.$r[‘f_fecha’].’	‘.$r[‘f_fechavenc’].’	‘.$r[‘f_descripcion’].’	BsF. ‘.number_format($r[‘saldo’],2,’,’,’.’).’
							BsF. “.number_format($saldoT,2,’,’,’.’).”

“;

} catch (Exception $ex) {
echo $ex;
}
[/insert_php]