Click here to Skip to main content
Click here to Skip to main content

C# MYSQLWrapper Class and PHPWrapper-Script

, 7 Nov 2007
Rate this:
Please Sign up or sign in to vote.
Accessing the MYSQL Database at your webspace from any remote computer
Screenshot - wrapper.jpg

Introduction

The MYSQLWrapper class is a small and simple-to-use solution for accessing server side MySQL databases at a standard webspace that supports PHP and MYSQL.
I thought it would be useful because many of you have got those cheap PHP/MYSQL supported sites and want to use data at the client side.
SQL queries and non query commands proceed as follows:

  1. The client side C# program passes the needed SQL command to the server side script using HTTP request.
  2. The server side script performs SQL statement and returns the result, if there is any, back to the client.
  3. Now the client parses the returned data and creates a Resultset that behaves similar to the sqlDataReader.

Using the Code

In order to implement this, you have to check two main parts:

  1. The PHP Script
    • FTP the PHP Script up to your site
    • Make changes to the script regarding specific MYSQL Server information, shown in this line of wrapper.php:
     $W->assign("mysql.mydomain.com","sqluser","sqlpwd",$database,$statement);
  2. The client class
    • Add the CL_MYSQLWrapper class to your project and make sure that you use namespace MYSQLWrapper like this:
     using MySQLWrapper;

    Now you can use wrapper class easily to perform DDL, DQL and DML statements like this:

    // Instantiate Wrapper Class with your script URL
    MySQLWrapper W = new MySQLWrapper("http://www.mydomain.com/wrapper.php");
    
    // Query server side db and get your resultset
    MSWRecordSet R = W.Query("MYDB", "SELECT * FROM t_persons");
    
    // Print out results, in this case the field f_name
    while (R.Read())
    {
        Console.WriteLine(R.Fields["F_Name"].ToString );
    }
    
    // Make a non query and update something.
    W.NonQuery("MYDB", "UPDATE t_persons SET F_Name='nobody'");

History

  • 7th November, 2007: Initial post

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

cellarjay
Software Developer
United States United States
No Biography provided

Comments and Discussions

 
GeneralNeed mysql database also to see it working Pinmembersudhirpatel24-Nov-10 2:04 
Generalwrapper.php corrections to working Pinmemberwerner.kremer21-Nov-07 13:38 
GeneralSecurity PinmemberMarkus Foss13-Nov-07 22:17 
GeneralRe: Security Pinmembercellarjay15-Nov-07 10:54 
GeneralRe: Security PinmemberMarkus Foss15-Nov-07 22:29 
GeneralRe: Security PinmemberTorstenFrings16-Nov-07 4:57 
Questionwhat about the transfer of binary Data? Pinmemberloungedj8-Nov-07 9:44 
AnswerRe: what about the transfer of binary Data? Pinmembercellarjay12-Nov-07 8:43 
AnswerRe: what about the transfer of binary Data? Pinmemberwerner.kremer24-Feb-08 10:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.1411023.1 | Last Updated 7 Nov 2007
Article Copyright 2007 by cellarjay
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid