PHP Classes
elePHPant
Icontem

mysqlc1: connect to a mysql database

Recommend this page to a friend!
  Info   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2006-01-29 (10 years ago) RSS 2.0 feedStar 17%Total: 766 All time: 4,224 This week: 1,089Up
Version License PHP version Categories
mysqlc1 1.0BSD License4.4.4Databases
Description Author

This class is a very simple wrapper to access MySQL databases.

It can connect to a MySQL database server, select the current work database, execute SQL queries and free its results.

Picture of
Name: <contact>
Classes: 1 package by
Country: United States United States
Age: 43
All time rank: 2559318 in United States United States
Week rank: 1353 Up139 in United States United States Up

Details
SMyCC [Pronounced "smEEk"]
Simple MySQL Connection Class)
 2005-2006 Steve Castle
http://www.stscac.com

Installation
------------
1. Unpack
2. Edit database.inc.php with your server specifications
3. Move to web folder
4. Include in all necessary files you want to connect to MySQL from
5. Make the calls (see below)

How to make the calls
---------------------
To run the MySQL Connection, you will have to call a new instance of the class
and tell it what function to run (where you want the connection to be made):

       $mysql = new mysql(); // This is the calling of class instance
       $mysql->connect(); // This is the calling of the class function

To Run a query on the database:

       // The Query here is a sample for this instance
       $mysql->query("SELECT * FROM table WHERE something='something_else'");
        
To Close the MySQL Connection (and free MySQL/Server memory):

       /*You Must have run the $mysql->query to be able to use the
       $mysql->end function
       */
       $mysql->end();
       
That's it!

Questions can be sent to me at steve@stscac.com
  Files folder image Files  
File Role Description
Accessible without login Plain text file database.inc.php Conf. Database connection fields. These need to be edited with your credientials
Accessible without login Plain text file LICENSE.txt Lic. License File. This software is part of the SC License.
Accessible without login Plain text file README.txt Doc. The Readme File. Installation Instructions can be found inside.
Plain text file smycc.class.php Class The main class. This is to be included in the file you want to query your database from.

 Version Control Unique User Downloads Download Rankings  
 0%
Total:766
This week:0
All time:4,224
This week:1,089Up
 User Ratings  
 
 All time
Utility:18%Star
Consistency:37%StarStar
Documentation:43%StarStarStar
Examples:-
Tests:-
Videos:-
Overall:17%Star
Rank:2970