Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mysql2077_12477'@'81.169.145.25' (using password: YES) in /mnt/web1/53/80/52073380/htdocs/quibui/mysql_inc.php on line 6
Access denied for user 'mysql2077_12477'@'81.169.145.25' (using password: YES)
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /mnt/web1/53/80/52073380/htdocs/quibui/mysql_inc.php:6) in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 26

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /mnt/web1/53/80/52073380/htdocs/quibui/mysql_inc.php:6) in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 26

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mysql2077_12477'@'81.169.145.25' (using password: YES) in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 29
Access denied for user 'mysql2077_12477'@'81.169.145.25' (using password: YES)
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 922

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 922

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 922

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 922

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 224

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 227
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 229

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 235

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 922

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 922

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 922

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 922

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 922

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 922

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 922

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 922

New Task

To Do

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 224

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 227
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 231

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/web1/53/80/52073380/htdocs/quibui/qb/functions_inc.php on line 235

Done


<?php
$SET_VERBOSE = 0;
include_once('../../../quibui/quibui_1.4.php');

$data_id = QB_HTTPVARS2ARRAY('id') ? QB_HTTPVARS2ARRAY('id') : '-1';
if ($data_id) {
    $qb_formcontent = QB_TABLE2ARRAY('qb_tasks', array('id'=>$data_id), '1');
} else {
    $qb_formcontent = QB_HTTPVARS2ARRAY();
}

    // erstellt/ändert datensätze
    $meldungen = QB_FORM2TABLE(
        'qb_tasks'
        ,array('id'=>$qb_formcontent['id'])
        ,array('done')
        ,array('title'=>QB_HTTPVARS2ARRAY('title'),
               'done'=>QB_HTTPVARS2ARRAY('done'),
               'created'=>QB_TIMEDATE2DATETIME('NOW')
        )
        ,array('save'=>QB_HTTPVARS2ARRAY('Speichern'),
               'delete'=>QB_HTTPVARS2ARRAY('Delete')
        )
        ,array('title'=>array(_QB_CHECK_PATTERN_EMPTY=>'Bitte Aufgabe eingeben!')
        )
        ,array('change'=>'tasks2.php'
              ,'delete'=>'tasks2.php'
        )
    );

    // erstellt/ändert datensätze
    $meldungen2 = QB_FORM2TABLE(
        'qb_tasks'
        ,array('id'=>$qb_formcontent['id'])
        ,array('done')
        ,array('done'=>QB_HTTPVARS2ARRAY('done'),
               'modified'=>QB_TIMEDATE2DATETIME('NOW')
        )
        ,array('save'=>QB_HTTPVARS2ARRAY('MarkDone'))
        ,array()
        ,array('change'=>'tasks2.php')
        );
?>
<html>
<head></head>
<body>
<center>
<h3>New Task</h3>
<?php
    if ($meldungen) {
       foreach ($meldungen as $meldung) {
        echo $meldung . "<br>";
      }
    }
?>
<form method="POST" action="tasks2.php">
<input type="text" name="title" id="title" value="<?php echo QB_SECUREPRINT($qb_formcontent['title']); ?>">
<input type="hidden" name="id" value="<?php echo QB_SECUREPRINT($qb_formcontent['id']); ?>">
<input type="submit" name="Speichern" value="Aufgabe hinzufügen">
</form>

<h3>To Do</h3>
<table cellpadding="4" border="1">
<?php
    foreach (QB_TABLE2ARRAY('qb_tasks', "done != 1 ORDER BY created") as $task) {
        echo "<tr><td><input type=\"checkbox\" onclick=\"document.location.href='?id=" . $task['id'] .
             "&MarkDone=true&done=1'\"></td><td>" .  QB_SECUREPRINT($task['title']) . "</td><td>" .
             "<a href=\"javascript:void(0)\" onClick=\"document.location.href='?id=" .
             $task['id'] . "'\">ändern</a></td><td>" .
             QB_DATETIME2ARRAY($task['created'], 'DD.MM.YYYY hh:mm') . "</td></tr>";
    }
?>
</table>
<br>
<h3>Done</h3>
<table cellpadding="4" border="1">
<?php
    foreach (QB_TABLE2ARRAY('qb_tasks', "done = 1 ORDER BY modified") as $task) {
        echo "<tr><td>" . QB_SECUREPRINT($task['title']) .
             "</td><td><a href=\"javascript:void(0)\" onClick=\"document.location.href='?id=" .
             $task['id'] . "&Delete=true'\">löschen</a></td><td>" .
             QB_DATETIME2ARRAY($task['modified'], 'DD.MM.YYYY hh:mm') . "</td></tr>";
    }
?>
</table>
</center>
<?php
    show_source("tasks2.php");
?>
</body>
</html>