mt-admin Files · include/mysql.php

Make a stripped-down stylesheet for the editor to use.

darkmorford - - Load All Authors

File last commit:

c1e4c31f199d

d3add6d85bd7

Download file

             mysql.php
        
                    50 lines
            
             | 1.1 KiB
            
                | text/x-php
            
             |
                PhpLexer
            
             / include / mysql.php
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content

      <?php

      class MysqlStore {

      	var $link;

      	function connect($server,$user,$pass,$dbname) {

      		$this->link = @mysql_connect($server, $user, $pass)

      			or mtdie('Could not connect to the database server.');

      		@mysql_select_db($dbname, $this->link)

      			or mtdie('Could not open the megatokyo database.');

      		if( !$this->link ) mtdie('Could not connect to the database server.');		

      	}

      	function query($sql, $showerror = true ) {

      		$r = mysql_query( $sql, $this->link );

      		if( false === $r && $showerror ) echo mysql_error();

      		return $r;

      	}

      	function getAll($sql) {

      		if( $r = $this->query( $sql ) ) {

      			$ret = array();

      			while( $row = mysql_fetch_object( $r ) ) {

      				$ret[] = $row;

      			}

      			return $ret;

      		}

      	}

      	function getRow($sql) {

      		if( $r = $this->query( $sql ) ) {

      			if( false === $r ) {

      				echo mysql_error();

      				return false;

      			}

      			if( mysql_num_rows( $r ) == 0 ) return false;

      			return mysql_fetch_object( $r );

      		}

      	}

      	function getOne($sql) {

      		if( $r = $this->query( $sql ) ) {

      			if( mysql_num_rows( $r ) == 0 ) return false;

      			$ret = mysql_fetch_row( $r );

      			return $ret[0];

      		}

      	}

      }

      ?>

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings

				<?php


				class MysqlStore {
				var $link;
				function connect($server,$user,$pass,$dbname) {
				$this->link = @mysql_connect($server, $user, $pass)
				or mtdie('Could not connect to the database server.');
				@mysql_select_db($dbname, $this->link)
				or mtdie('Could not open the megatokyo database.');
				if( !$this->link ) mtdie('Could not connect to the database server.');
				}


				function query($sql, $showerror = true ) {
				$r = mysql_query( $sql, $this->link );
				if( false === $r && $showerror ) echo mysql_error();
				return $r;
				}

				function getAll($sql) {
				if( $r = $this->query( $sql ) ) {
				$ret = array();
				while( $row = mysql_fetch_object( $r ) ) {
				$ret[] = $row;
				}
				return $ret;
				}
				}

				function getRow($sql) {
				if( $r = $this->query( $sql ) ) {
				if( false === $r ) {
				echo mysql_error();
				return false;
				}
				if( mysql_num_rows( $r ) == 0 ) return false;
				return mysql_fetch_object( $r );
				}
				}

				function getOne($sql) {
				if( $r = $this->query( $sql ) ) {
				if( mysql_num_rows( $r ) == 0 ) return false;
				$ret = mysql_fetch_row( $r );
				return $ret[0];
				}
				}
				}

				?>