| Усредненное движение валют - Скрипт чтения из базы (PHP) | << | >> |
define('DB_USER','*****');
define('DB_PASSWD','*****');
define('DB_NAME','*****');
define('DB_SERVER','localhost');
if(!mysql_connect(DB_SERVER,DB_USER,DB_PASSWD)){
echo "В настоящее время сервер базы данных недоступен.";
exit();
}
mysql_select_db(DB_NAME);
$sql = "select tm,$name_vlt1,$name_vlt2,$name_vlt3,$name_vlt4 from fibo order by tm desc limit 193";
$r=mysql_query($sql);
$rows = mysql_num_rows($r);
echo "hd = [\"Time\",\"$name_vlt1\",\"$name_vlt2\",\"$name_vlt3\",\"$name_vlt4\"]\n";
$lines = $rows/4;
settype($lines,"integer");
echo "lines = $lines\n";
for($i = 0; $i < $rows; $i++)
{
$r0 = mysql_result($r,$i,0);
$r0 = substr($r0,5,11); $r0[2] = '.';
$r1 = mysql_result($r,$i,1);
$r2 = mysql_result($r,$i,2);
$r3 = mysql_result($r,$i,3);
$r4 = mysql_result($r,$i,4);
echo "graphx[$i]=[\"$r0\",\"$r1\",\"$r2\",\"$r3\",\"$r4\"]\n";
}
|