PHP Classes
elePHPant
Icontem

MySQLi sample test: Execute MySQL queries using MySQLi extension

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2010-04-05 (5 years ago) RSS 2.0 feedNot enough user ratingsTotal: 526 All time: 5,236 This week: 1,359Up
Version License PHP version Categories  
mysqli-sample-test 1GNU General Publi...5.0PHP 5, Databases
Description Author  

This is a simple class that can be used to execute MySQL queries using MySQLi extension.

It can establish a connection to a given MySQL server.

The class can also execute a given SQL query and return the query results handle.

If an error occurs, the class can send an e-mail message to the e-mail address of an administrator.

Picture of sarmad Mahar
Name: sarmad Mahar <contact>
Classes: 1 package by
Country: Pakistan Pakistan
Age: 31
All time rank: 293938 in Pakistan Pakistan
Week rank: 1504 Up27 in Pakistan Pakistan Up

Details provided by the author  
Author: Sarmad mahar
Email:  sarmad.mahar@gmail.com , sarmad.mahar@hotmail.com , sarmad.mahar@yahoo.com

Description: This class is developed to use mysqli class


Features:

- Implementation of mysqli class 
- Sent email to admin if any query goes wrong without knowing vistors 
- Track querry errors 




Step 1: Open db.inc.php Change value of blow Variables

var $host="localhost";
var $user="root";
var $pass="";
var $db="DATA_BASE_NAME";
var $adminEmail="sarmadmahar@gmail.com";


Step 2: test.php  change blow query "select your table I have articles table on my localhost"

$result=$db->Executequery("select * from articless");
  Files folder image Files  
File Role Description
Plain text file db.inc.php Class Database class
Accessible without login Plain text file readme.txt Doc. Read me
Accessible without login Plain text file test.php Example mysqli class implementation

 Version Control Unique User Downloads Download Rankings  
 0%Total:526All time:5,236
 This week:0This week:1,359Up
 User Comments (1)  
 
This is great, simple but great
5 years ago (Vermaas)
77%StarStarStarStar