<?php
$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());
}
$stime = date('Y-m-d H:i:s',mysql_real_escape_string($_GET['opentime']));

$query = sprintf("insert into trade values ('%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",
mysql_real_escape_string($_GET['ticket']),
$stime,
mysql_real_escape_string($_GET['pair']),
mysql_real_escape_string($_GET['position']),
mysql_real_escape_string($_GET['lot']),
mysql_real_escape_string($_GET['openprice']),
mysql_real_escape_string($_GET['sl']),
mysql_real_escape_string($_GET['tp'])
);
$query_ok = mysql_query($query);
if(!$query_ok) {
	die('Query error: '.mysql_error());
}
mysql_close($link);
?>