Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class myClass {
- var $link, $result;
- function db_connect($server, $user, $pass, $database) { // ->db_connect("localhost", "user", "pass", "db");
- if(!$this->link = mysql_connect($server, $user, $pass)) {
- $this->error("Could not connect: " . mysql_error());
- }
- if(!mysql_select_db($database, $this->link)) {
- $this->error("Could not select database: " . mysql_error());
- }
- return true;
- }
- function error($error) {
- $string_error = date("d/m/Y - H:i:s ") . " (" . $_SERVER['REMOTE_ADDR'] . ")\n" . $error . "\n\n";
- $file = "errors.txt";
- $file = fopen($file, 'a') or die("Fejl, h�ndelsen kunne ikke logges!");
- fwrite($file, $string_error);
- die("Der er opst�et en uventet fejl. H�ndelsen er blevet logget og Administrator vil blive informeret.");
- }
- function getRows() { // while($row = $con->getRows()) { echo $row['id']; }
- return mysql_fetch_assoc($this->result);
- }
- function query($sql) {
- if(!$this->result = mysql_query($sql, $this->link)) {
- $this->error("mysql_query error: " . mysql_error());
- }
- }
- function getQuery($table, $what="*", $end="") { // ->getQuery("info", "*", "ORDER BY navn ASC");
- $sql = "SELECT $what FROM $table $end";
- $this->query($sql);
- }
- function cntRows() { // echo ->cntRows();
- return mysql_num_rows($this->result);
- }
- function insQuery($table, $column_data) { // ->insert("info", "navn='Navn', adresse='Adresse'");
- $sql = "INSERT INTO $table SET $column_data";
- $this->query($sql);
- }
- function delQuery($table, $where, $is) { // ->delete("info", "id", "1");
- $sql = "DELETE FROM $table WHERE $where = '$is'";
- $this->query($sql);
- }
- function updQuery($table, $what, $with, $where, $is) { // ->updQuery("info", "navn", "Navn", "id", "1");
- $sql = "UPDATE $table SET $what = '$with' WHERE $where = '$is'";
- $this->query($sql);
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement