rendered paste body<?php class revo { var $table; var $id; var $title; var $imggroup; var $text; var $dDate; function revo(){ } function setData($tName,$tiName,$iGroup,$txtName,$ivalue="", $dDate = ""){ $this->table = $tName; $this->title = $tiName; $this->imggroup = $iGroup; $this->text = $txtName; if($ivalue != ""){ $this->id = $ivalue; } if($dDate != ""){ $this->dDate = $dDate; } } function insertData($title, $imggroup, $text, $date=""){ include 'config.php'; $stat = ""; $dbcon = db_con(); $sql = "INSERT INTO " . $dbname . "." . $this->table . " SET " . $this->title . "=\"" . $title . "\", " . $this->imggroup . "=\"" . $imggroup . "\", " . $this->text . "=\"" . $text . "\"" ; if($this->dDate !=""){ if($date !=""){ $sql = $sql . ", " . $this->dDate . "=\"" . $date . "\""; } } $dbact = mysql_query($sql); if(!$dbact){ $stat = "Error with Revo() class inserData <br> Error: " . mysql_error() ; mysql_close($dbcon); return $stat; } else { $stat = "Inserted data into " . $this-table . " successfully!"; mysql_close($dbcon); return $stat; } } function pullData($id="", $field="", $fSort="", $sBy="", $limit=""){ include 'config.php'; $all = false; if($id == "" && $field == "" && $fSort == "" && $sBy == "" && $limit ==""){ $sql = "SELECT * FROM " . $dbname . "." . $this->table . " ORDER BY " . $this->id . " DESC "; $all = true; } if($field == "" && $id == "" && $all == false){ $sql = "SELECT * FROM " . $dbname . "." . $this->table . " " ; if($fSort != ""){ $sql = $sql . " ORDER BY " . $fSort . " "; } if($sBy != ""){ $sql = $sql . $sBy; } if($limit != ""){ $sql = $sql . " LIMIT " . $limit; } } if($id != "" && $all == false ){ if($field != ""){ $sel = $field; }else{ $sel = "*"; } $sql = "SELECT " . $sel . " FROM " . $dbname . "." . $this->table . " WHERE " . $this->id . " = " . $id; } if($field != "" && $id =="" && $all == false ){ $sql = "SELECT " . $field . " FROM " . $dbname . "." . $this->table . " " ; if($fSort != ""){ $sql = $sql . "ORDER BY " . $fSort . " "; }else{ $sql = $sql . "ORDER BY " . $this->id . " "; } if($sBy != ""){ $sql = $sql . $sBy . " "; } if($limit != ""){ $sql = $sql . "LIMIT " . $limit; } } if($limit != "" && $fSort == "" && $field == "" && $all == false ){ if($sBy == ""){ $acdc = "DESC"; }else{ $acdc = $sBy; } $sql = "SELECT * FROM " . $dbname . "." . $this->table . " ORDER BY " . $this->id . " " . $acdc . " LIMIT " . $limit ; } $dbData = array(); $dbcon = db_con(); //echo($sql); $dbq = mysql_query($sql); if(!$dbq){ echo("Error With SQL Query <br> " . mysql_error()); return "error"; }else{ while($row = mysql_fetch_assoc($dbq)){ $dbData[] = $row; } mysql_close($dbcon); return $dbData; } } function delData($id){ include 'config.php'; //$dbcon = db_con(); $sql = "DELETE * FROM " . $dbname . "." . $this->table . " WHERE " . $this->id . " = " . $id; echo($sql); } }?>