<?php $amountWeekRow = $sql->query(query_last_week())->fetch(); $amountWeek = $amountWeekRow["value"]; $amountWeekRefRow = $sql->query(query_last_week_referals())->fetch(); $amountWeekRef = $amountWeekRefRow["value"]; $amountBeginningRow = $sql->query(query_since_beginning())->fetch(); $amountBeginning = $amountBeginningRow["value"]; $amountBeginningRefRow = $sql->query(query_since_beginning_referals())->fetch(); $amountBeginningRef = $amountBeginningRefRow["value"]; ?> <style> .stat { margin-top:10px; font-size: larger; padding: 16px; margin-bottom: 16px; border: 1px solid #e6e6e6; background: white; } </style> <div class="row"> <h3 id="lbl-your-stats" class="text-center">Your stats:</h3> <div class="col-sm-12"> <div class="row"> <div class="col-sm-6"><div class="col-sm-11 stat"><p id="lbl-satoshis-7-days">Satoshis given in the last 7 days:</p><div class="col-sm-12"><?php echo $amountWeek; ?> </div></div></div> <div class="col-sm-6"><div class="col-sm-11 col-sm-offset-1 stat"><p id="lbl-satoshis-7-days-as-referals">Satoshis given in the last 7 days as referals:</p><div class="col-sm-12"> <?php echo $amountWeekRef;
function xapo_statistics_callback() { global $wpdb; $amountWeekRow = $wpdb->get_results(query_last_week()); if (isset($amountWeekRow[0]->value)) { $amountWeek = $amountWeekRow[0]->value; } else { $amountWeek = 0; } $amountWeekRefRow = $wpdb->get_results(query_last_week_referals()); if (isset($amountWeekRefRow[0]->value)) { $amountWeekRef = $amountWeekRefRow[0]->value; } else { $amountWeekRef = 0; } $amountBeginningRow = $wpdb->get_results(query_since_beginning()); if (isset($amountBeginningRow[0]->value)) { $amountBeginning = $amountBeginningRow[0]->value; } else { $amountBeginning = 0; } $amountBeginningRefRow = $wpdb->get_results(query_since_beginning_referals()); if (isset($amountBeginningRefRow[0]->value)) { $amountBeginningRef = $amountBeginningRefRow[0]->value; } else { $amountBeginningRef = 0; } ?> <style> .stat { margin-top:10px; font-size: larger; padding: 16px; margin-bottom: 16px; border: 1px solid #e6e6e6; background: white; } div#wedevs_advanced p.submit input#submit { display :none ; } </style> <div class="row"> <h3 id="lbl-your-stats" class="text-center">Your stats:</h3> <div class="col-sm-12"> <div class="row"> <div class="col-sm-6"><div class="col-sm-11 stat"><p id="lbl-satoshis-7-days">Satoshis given in the last 7 days:</p><div class="col-sm-12"><?php echo $amountWeek; ?> </div></div></div> <div class="col-sm-6"><div class="col-sm-11 col-sm-offset-1 stat"><p id="lbl-satoshis-7-days-as-referals">Satoshis given in the last 7 days as referals:</p><div class="col-sm-12"> <?php echo $amountWeekRef; ?> </div></div></div> </div> <div class="row"> <div class="col-sm-6"><div class="col-sm-11 stat"><p id="lbl-satoshis-beggining">Satoshis given since the beggining of times:</p><div class="col-sm-12"><?php echo $amountBeginning; ?> </div></div></div> <div class="col-sm-6"><div class="col-sm-11 col-sm-offset-1 stat"><p id="lbl-satoshis-beggining-referrals">Satoshis given since the beggining of times (as referals):</p><div class="col-sm-12"><?php echo $amountBeginningRef; ?> </div></div></div> </div> </div> </div> <?php }
<?php /*try { $sql = new PDO($dbdsn, $mysqlUsername, $mysqlPassword, array(PDO::ATTR_PERSISTENT => true, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)); } catch(PDOException $e) { die($e->getMessage()); }*/ echo "antes"; $amountWeek = $sql->query(query_last_week())->fetch()["value"]; echo "paso week"; $amountWeekRef = $sql->query(query_last_week_referals())->fetch()["value"]; echo "paso week ref"; $amountBeginning = $sql->query(query_since_beginning())->fetch()["value"]; echo "paso amount beg"; $amountBeginningRef = $sql->query(query_since_beginning_referals())->fetch()["value"]; echo "paso amounr ref"; ?> <style> .stat { margin-top:10px; font-size: larger; padding: 16px; margin-bottom: 16px; border: 1px solid #e6e6e6; background: white; } </style> <div class="row"> <h3 class="text-center">Your stats:</h3> <div class="col-sm-12">