-
Notifications
You must be signed in to change notification settings - Fork 0
/
cr.php
31 lines (29 loc) · 1.16 KB
/
cr.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<!doctype php manual "-//by the PHP Documentation Group//en">
<!doctype odbc manual "-//by microsoft corp.//en">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<link rel="stylesheet" href="shablon.css" type="text/css">
<title>abonet report for day/month</title>
<?php
include("config/local.php");
$arr = get_defined_vars();
$i = mysql_connect ($mysql_host,$mysql_user,$mysql_password); $e=mysql_select_db ($mysql_db_name);
$query = 'SELECT * FROM tmp_temp';
$a = mysql_query ($query,$i);
if ($a) $uy = mysql_fetch_row ($a);
while ($uy)
{
//$query = 'INSERT INTO data (type, date, value, flat, source, prm) VALUE (\'2\',\''.$uy[0][0].$uy[0][1].$uy[0][2].$uy[0][3].$uy[0][5].$uy[0][6].$uy[0][8].$uy[0][9].'000000\',\''.$uy[1].'\',\'0\',\'10\',\'4\')';
$uy[0][12]='0';
$query = 'INSERT INTO data (type, date, value, flat, source, prm) VALUE (\'2\',\''.$uy[0].'\',\''.$uy[1].'\',\'0\',\'10\',\'4\')';
echo $query.'<br>';
$r = mysql_query ($query,$i);
$uy = mysql_fetch_row ($a);
}
?>
</td></tr>
</table>
</body>
</html>