mt-admin Files · include/mysql.php

Update include/*.php to use mysqli_* functions.

darkmorford - - Load All Authors

File last commit:

a17e7e96d006

2f20c7105050

Download file

             mysql.php
        
                    48 lines
            
             | 1.0 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 = @mysqli_connect($server, $user, $pass, $dbname)

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

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

      	}

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

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

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

      		return $r;

      	}

      	function getAll($sql) {

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

      			$ret = array();

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

      				$ret[] = $row;

      			}

      			return $ret;

      		}

      	}

      	function getRow($sql) {

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

      			if( false === $r ) {

      				echo mysqli_error();

      				return false;

      			}

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

      			return mysqli_fetch_object( $r );

      		}

      	}

      	function getOne($sql) {

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

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

      			$ret = mysqli_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 = @mysqli_connect($server, $user, $pass, $dbname)
				or mtdie('Could not connect to the database server.');
				if( !$this->link ) mtdie('Could not connect to the database server.');
				}

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

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

				function getRow($sql) {
				if( $r = $this->query( $sql ) ) {
				if( false === $r ) {
				echo mysqli_error();
				return false;
				}
				if( mysqli_num_rows( $r ) == 0 ) return false;
				return mysqli_fetch_object( $r );
				}
				}

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

				?>