[go: up one dir, main page]
Menu ▾ ▴

[r99]: / tags / 1.3 / modify.php  Maximize  Restore  History

Download this file

70 lines (64 with data), 2.7 kB 

 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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
<?php

# $Id: modify.php 86 2010-10-05 12:19:27Z rediculum $

#

# Includes

####################################################################

include("includes/session.inc.php");

include("includes/layout.inc.php");

include("includes/functions.inc.php");

include("includes/db.inc.php");

include("includes/variables.inc.php");



# Main

#####################################################################?>

<html>

<head>

<?php echo "$headtitle $head";?>

</head>

<body>

<div id=menu>

<?php include("includes/menu.inc.php");?>

</div>

<div id=mainframe>

<table bgcolor="#FFFFFF">

<tr><td valign=top align=left width=500>



<?

if ($_POST[table] == verbuchungen) {

	if ($_POST[tag] == '' || $_POST[betrag] == '' || $_POST[q_id] == '' || $_POST[hk_id] == '' || $_POST[sk_id] == '' || $_POST[text] == '') {

       		echo " <font color=red> $ERROR: $entry $is_not_complete !";

	}

} else {

	if ($_POST[betrag] == '' || $_POST[q_id] == '' || $_POST[hk_id] == '' || $_POST[sk_id] == '' || $_POST[text] == '') {

       		echo " <font color=red> $ERROR: $entry $is_not_complete !";

	}

}

if ($_POST[q_id] == "2" && $_POST[hk_id] == "1") {

	echo " <font color=red> $ERROR: $earn $cannot $be $expenditures";

} else {

       	mysql_query("UPDATE $_POST[table] SET tag='$_POST[tag]',monat='$_POST[monat]',jahr='$_POST[jahr]',betrag='$_POST[betrag]',q_id='$_POST[q_id]',hk_id='$_POST[hk_id]',sk_id='$_POST[sk_id]',shared='$_POST[shared]',text='$_POST[text]' WHERE id='$_POST[id]'") or die (mysql_error());

       	echo "$entry <i>$_POST[id]</i> mutiert";



       	echo "<table border=0 cellpadding=4 cellspacing=0>";

       	echo "<tr align=right bgcolor=\"#EEEEEE\">";

       	print("<td><b> $date</td>

               	<td align=left><b> $entrytext</td>

               	<td><b> $amount</td>

               	<td align=left><b> $source</td>

               	<td align=left><b> $category</td>

               	<td><b> $shared_s</td>

       	");



	$quelle = mysql_fetch_row(mysql_query("SELECT q_id,q_name FROM quelle WHERE q_id='$_POST[q_id]'"));

	$subkategorie = mysql_fetch_row(mysql_query("SELECT sk_id,sk_name FROM subkategorien WHERE sk_id='$_POST[sk_id]'"));

	$hauptkategorie = mysql_fetch_row(mysql_query("SELECT hk_id,hk_name FROM hauptkategorien WHERE hk_id='$_POST[hk_id]'"));

       	print("<tr align=right>

               	<td> $_POST[tag].$_POST[monat].$_POST[jahr]</td>

               	<td align=left> $_POST[text]</td>

               	<td> $_POST[betrag]</td>

               	<td align=left> $quelle[1]</td>

               	<td align=left> $hauptkategorie[1]_$subkategorie[1]</td>

               	<td> $_POST[shared]</td>

	");

}?>

</td></tr>

</table>

</div>

</body>

</html>