[Summary view] [Print] [Text view]

   1  <?
   2  include_once "MDB.php";
   3  include_once "base.php";
   4  
   5  if (!empty($HTTP_POST_VARS))
   6   {
   7    if ($HTTP_POST_VARS['action'] == "todoadd")
   8      todo_add($HTTP_POST_VARS);
   9   }
  10  
  11  parse_str($HTTP_SERVER_VARS['QUERY_STRING'], $query_tab);
  12  if (!isset($query_tab["action"]))
  13    todo_list();
  14  else if ($query_tab["action"] == "todoedit")
  15    todo_edit($query_tab);
  16  exit;
  17  
  18  function dbconnect()
  19   {
  20    $db = MDB::connect("mysql://gasell:4ansdeja@localhost/gasellwww");
  21    if (MDB::isError($db))
  22      echo "PROUT la db!";
  23    return($db);
  24   }
  25  
  26  function todo_list()
  27   {
  28    global $login_status;
  29    global $user;
  30    
  31    $db = dbconnect();
  32    $dbresult = $db->query("SELECT num,owner,date,titre FROM todolist WHERE id='0' AND status='1'");
  33    $nbtodo = $db->numrows($dbresult);
  34    if ($nbtodo > 0)
  35     {
  36      $todolist = $db->fetchAll($dbresult);
  37      print_r($data);
  38     }
  39    require "todolist.inc";
  40    exit;
  41   }
  42  
  43  function todo_edit($query_tab)
  44   {
  45    global $login_status;
  46    global $user;
  47    
  48    $db = dbconnect();
  49    $dbresult = $db->query("SELECT num,owner,titre,texte FROM todolist WHERE num='".$query_tab['num']."'");
  50    $data = $db->fetchAll($dbresult);
  51    $todo_titre = $data[0][2];
  52    $todo_texte = $data[0][3];
  53    $todo_num   = $data[0][0];
  54    
  55    $dbresult = $db->query("SELECT num,owner,date,titre,texte FROM todolist WHERE id='".$query_tab['num']."' AND status='1'");
  56    $nbtodo = $db->numrows($dbresult);
  57    if ($nbtodo > 0)
  58      $todolist = $db->fetchAll($dbresult);
  59    
  60    require "todoedit.inc";
  61    exit;
  62   }
  63  
  64  function todo_add($params)
  65   {
  66    global $login_status;
  67    global $user;
  68    global $query_tab;
  69    
  70    $db = dbconnect();
  71    $cols = "owner,id,status,date,titre,texte";
  72    $vals = "'".$user."','".$params['base']."','1','2004-01-01','".$params["titre"]."','".$params['texte']."'";
  73    $requette = "INSERT INTO todolist(".$cols.") VALUES (".$vals.")";
  74    echo $requette;
  75    $dbresult = $db->query($requette);
  76    todo_list();
  77   }
  78  ?>