All pastes #351292 Raw Edit

Anonymous

public php v1 · immutable
·published 2007-02-12 02:06 UTC
rendered paste body
<?php	class revo {						var $table;		var $id;		var $title;		var $imggroup;		var $text;		var $dDate;		var $dSort;				function revo(){		}				function setData($tName,$tiName,$iGroup,$txtName,$sort,$ivalue="", $dDate = ""){			$this->table = $tName;			$this->title = $tiName;			$this->imggroup = $iGroup;			$this->text = $txtName;			$this->dSort = $sort;						if($ivalue != ""){				$this->id = $ivalue;			}						if($dDate != ""){				$this->dDate = $dDate;			}		}				function insertData($title, $imggroup, $text, $sort, $date=""){		include 'config.php';			$stat = "";			$dbcon = db_con();			$sql = "INSERT INTO " . $dbname . "." . $this->table . " SET " . $this->title . "=\"" . $title . "\", " . $this->imggroup . "=\"" . $imggroup . "\", " . $this->text . "=\"" . $text . "\", " . $this->dSort . "=\"" . $sort . "\"" ;					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;			$dbDel = mysql_query($sql);				if(!$dbDel){					echo("Error With Removing Data From " . $this->table . " Error <br> " . mysql_error());					mysql_close($dbcon);					return false;				}else {					mysql_close($dbcon);					return true;				}		}				function editData($id, $title, $text, $sort){			include 'config.php';			$dbcon = db_con();			$sql = "UPDATE " . $dbname . "." . $this->table . " SET " . $this->title . " = \"" . $title . "\", " . $this->text . " = \"" . $text . "\", " . $this->dSort . " = '" . $sort . "' WHERE " . $this->id . "='" . $id . "'";			$dbUpdate = mysql_query($sql);				if(!$dbUpdate){					echo("Error With Updating Data From " . $dbname . "." . $this->table . " <br> Error:" . mysql_error());					mysql_close($dbcon);					return false;				}else {					mysql_close($dbcon);					return true;				}		}					}?>