8
rated 0 times
[
13]
[
5]
/ answers: 1 / hits: 22210
/ 11 Years ago, tue, august 20, 2013, 12:00:00
I am attempting to refresh a table i have as the variables in there are constantly updated and i want to re-update those variable every few seconds. I have already done up code on my part by giving the table an id and creating a div for it. The code will explain what i actually. Thanks in Advance ! Added Var Table ,Var Refresher, table id is tableID . however the code still wont reload my table !Any ideas??
Test.php
<html>
<head>
<script src=https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js></script>
<script type='text/javascript'>
var table = $('#tableID');
// refresh every 5 seconds
// var refresher = setInterval(function() { table.load(refreshable); }, 5000);
var refresher = setInterval(table.load.bind(table, refreshable.php), 5000);
//var refresh = setInterval($(#tableID)).load('refreshable.php'),3000);
setInterval(function() {
clearInterval(refresher);
}, 1800000);
</script>
</head>
<body>
<div id=tableID>
<?php include_once'refreshable.php'; ?>
</div>
</body>
</html>
refreshable.php
<?php
require_once 'connect.php';
include 'start.php';
include 'functions.php';
header(Cache-Control: no-cache,no-store);
$query = SELECT * FROM opentrades; //You don't need a ; like you do in SQL
$result = mysql_query($query);
echo <table border = '1px' >; // start a table tag in the HTML
echo <tr><td> . Order Number . </td><td> . Selection . </td><td> . Date . </td><td> . Type . </td><td> . Size . </td><td> . Bid Price . </td><td> . Offer Price . </td><td> .Stop Loss . </td><td> . Take Profit . </td><td> .Profit/Loss(USD).</td><td> .Close.</td></tr> ; //$row['index'] the index here is a field name
while($row = mysql_fetch_assoc($result)){ //Creates a loop to loop through results
if ($row['selection']=='eur/usd')// TO RETRIEVE BID AND OFFER FOR EACH ROW
{
$bidpricepl=$bid;
$offerpricepl=$bid1;
}
elseif ($row['selection']=='usd/jpy')
{
$bidpricepl=$bid2;
$offerpricepl=$bid3;
}
elseif ($row['selection']=='usd/cad')
{
$bidpricepl=$bid4;
$offerpricepl=$bid5;
}
elseif ($row['selection']=='eur/jpy')
{
$bidpricepl=$bid6;
$offerpricepl=$bid7;
}
elseif ($row['selection']=='eur/chf')
{
$bidpricepl=$bid8;
$offerpricepl=$bid9;
}
elseif ($row['selection']=='gbp/usd')
{
$bidpricepl=$bid10;
$offerpricepl=$bid11;
}
elseif ($row['selection']=='aud/usd')
{
$bidpricepl=$bid12;
$offerpricepl=$bid13;
}
elseif ($row['selection']=='usd/chf')
{
$bidpricepl=$bid14;
$offerpricepl=$bid15;
}
if ($row['type']==buy)
{
$minipipskiller='10';
$offeropen=$row['offerprice'];
$pips=$offerpricepl-$offeropen;
$closedb=$offeropen;
$pips1=round($pips, 6);
$pips2 = str_replace('.', '', $pips1);
if ($pips2<0)
{
$pips2 = str_replace('-', '', $pips2);
$pips2 = ltrim($pips2, '0');
$pips2 = -1 * abs($pips2);
}
else {
$pips2 = ltrim($pips2, '0');
}
$pips3=$pips2/$minipipskiller;
}// PIP COUNTING
elseif ($row['type']==sell)//FOR PIP COUNTING
{
$minipipskiller='10';
$bidopen=$row['bidprice'];
$pips=$bidopen-$bidpricepl;
$closedb=$bidopen;
$pips1=round($pips, 6);
$pips2 = str_replace('.', '', $pips1);
if ($pips2<0)
{
$pips2 = str_replace('-', '', $pips2);
$pips2 = ltrim($pips2, '0');
$pips2 = -1 * abs($pips2);
}
else {
$pips2 = ltrim($pips2, '0');
}
$pips3=$pips2/$minipipskiller;
}
$ticksize= 0.0001;// FOR PROFIT AND LOSS
$lot1 = 100000;
$sizecalc=$row['size'] * $lot1;
if ($row['type']==buy)
{
$profitandloss=$sizecalc*$ticksize*$pips3; //per TRADE
}
if ($row['type']==sell)
{
$profitandloss=$sizecalc*$ticksize*$pips3; //per TRADE
}
$zero= '0';
if($profitandloss<$zero) {
$profitText = <div style=color: red;>$profitandloss</div>;
} elseif ($profitandloss>$zero) {
$profitText = <div style=color: green;>$profitandloss</div>;
}
$sum+= $profitandloss;
echo <tr><td> . $row['trade_id'] .
</td><td> . $row['selection'] .
</td><td> . $row['date'] .
</td><td> . $row['type'] .
</td><td> . $row['size'] .
</td><td> . $row['bidprice'] .
</td><td> . $row['offerprice'] .
</td><td> . $row['stoploss'] .
</td><td> . $row['takeprofit'] .
</td><td> . $profitText .
</td><td><a href ='delete.php?id=.
$row['trade_id'].'>X</a>
</td></tr>;
$profitandloss=0;
if($sum<$zero) {
$sumText = <div style=color: red;>$sum</div>;
} elseif ($sum>$zero) {
$sumText = <div style=color: green;>$sum</div>;
}
}
echo </table><br>;
?>
More From » php