$username='kpforex';
$password='123456';
$dbname = 'db_kpforex';
$link = mysql_connect('localhost', $username, $password);
if (!$link) {
die('Not connected : ' . mysql_error());
}
$db_selected = mysql_select_db($dbname, $link);
if (!$db_selected) {
die ('Error selecting forex db with msg: '.mysql_error());
}
$result = mysql_query("select * from trade ORDER BY opentime DESC");
?>
ticket |
open time |
pair |
position |
lot |
open price |
sl |
tp |
if(!$result)
{
die("Query failed");
}
while ($row = mysql_fetch_assoc($result)) {
echo ( "".$row['ticket']." | \n");
echo ( "".$row['opentime']." | \n");
echo ( "".$row['pair']." | \n");
echo ( "".$row['position']." | \n");
echo ( "".$row['lot']." | \n");
echo ( "".$row['openprice']." | \n");
echo ( "".$row['sl']." | \n");
echo ( "".$row['tp']." |
\n");
}
mysql_free_result($result);
?>