Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- // error_reporting(E_ALL);
- $db_pass='yFYMZ5JGW8S657GQ';
- $db_host='localhost';
- $db_user='buh';
- $db_name='balance';
- print '<html><head>';
- print '<meta http-equiv="Content-Type" content="text/html; charset=utf-8">';
- print '<title>Таблица расчета проёба денег</title>';
- print '</head><body>';
- $query = 'SELECT * FROM balance.balance';
- $conn = mysql_connect($db_host, $db_user, $db_pass)
- or die("Couldn't connect");
- $query_res = mysql_query($query)
- or die ("Shit happens - " . $mysql_error());
- print '<table align="center" border=2>';
- print '<tr><td>Id</td><td>Дата</td><td>Доход/Расход</td><td>Сумма</td><td>Коммент</td></tr>';
- while ($array = mysql_fetch_row($query_res))
- {
- print '<tr>';
- foreach($array as $val => $key)
- {
- print'<td>'.$key.'</td>';
- }
- print '</tr>';
- }
- print '</table>';
- print '<br>';
- print '<align="center">';
- print '<form action="new_act.php">';
- print 'Введи сумму: <input type=text name="sum"> ';
- print 'Введите коммент: <input type=text name="comment"> ';
- print '<input type=radio name=type value=Расход checked>Расход';
- print '<input type=radio name=type value=Доход>Доход';
- print '<input type=submit value="YARRR!">';
- print '</form>';
- print '</align>';
- //$new_sum = $_GET['sum'];
- //$new_comm = $_GET['comment'];
- //$type = $_GET['type'];
- //$current_date = date("c");
- //$update_nal = 'INSERT INTO balance.balance (date,action,sum,comment) VALUES ('.$current_date.','.$type.','.$new_sum.','.$new_comm.')';
- //$query_res_update = mysql_query($update_nal);
- //or die("Shit happens - " . $mysql_error());
- print '</body>';
- print '</html>';
- mysql_free_result($query_res);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement