All pastes #593908 Raw Edit

Stuff

public text v1 · immutable
#593908 ·published 2007-06-28 16:34 UTC
rendered paste body
(C)Erik Bernoth aka sholvar 
  class  channel
  { 
    
    var $tid, $title, $descript, $items, $opt_top, $opt_pla, $opt_tim;
    
    // constructor
   function channel ($id=0)
   {
       if ($id > 0) 
           $this->get($id);
       else
       { 
           $this->tid = 0;
           $this->title = '';
           $this->descript = '';
           $this->opt_top = '';
           $this->opt_pla = '';
           $this->opt_tim = '';
       }
   }
    
   // load dataset
   function get($id)
   {
//     global $global_db_dbname;
//       
//     @mysql_pconnect($global_db_dbname);
//     $result = @mysql_db_query("dbname","SELECT * FROM Channel WHERE tid=$id");
//     if ($row = @mysql_fetch_row($result))
//     {
//           $this->tid = $row[0];
//           $this->title = $row[1];
//           $this->descript =$row[2];
//           $this->opt_top = $row[3];
//           $this->opt_pla = $row[4];
//           $this->opt_tim = $row[5];
//           $this->items = getItems($this->opt_top, $this->opt_pla, $this->opt_tim);
//     }//e.o.if fetch
      $this->tid = $id;
      $this->opt_pla = 'all';
      $this->opt_tim = 4;
      $this->title='shols blog'.$id;
      $this->descript = 'Blog von shol.net. id ist '.tid;
   }//e.o. get()
     
    // write dataset
   function set()
   {
     global $global_db_dbname;

     if ($this->tid > 0)
     {
       // ein UPDATE
       @mysql_pconnect($global_db_dbname);
       $result = @mysql_db_query("dbname","UPDATE Channel SET title='$this->title', descript='$this->descript', opt_top='$this->opt_top', opt_pla='$this->opt_pla', opt_tim='$this->opt_tim' WHERE tid=$this->tid");
     }else{
       // ein INSERT
       @mysql_pconnect($global_db_dbname);
       $result = @mysql_db_query("dbname","INSERT INTO Channel SET title='$this->title', descript='$this->descript', opt_top='$this->opt_top', opt_pla='$this->opt_pla', opt_tim='$this->opt_tim' )");
       $this->tid = @mysql_insert_id();
     }
   }

 } // end of class