PHP Classes
elePHPant
Icontem

RemoteSQL: Provides client-side access to server-side DB

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 (8)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2002-09-25 (12 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 1,132 All time: 3,123 This week: 2,088Up
Version License Categories  
sql_link 1.0GNU General Publi...Databases
Description Author  

This Visual Basic and PHP combination allows you to remotely execute and retreive SQL queries to and from your online databases. The VB code makes http requests to an online script (written in PHP) which executes your query and returns the result. The queries and results are encrypted using rc4 encryption, which is now free for use (no patent fees apply), and the PHP script can be configured to only accept queries from a specific IP address.
Very special thanks to:
Mukul Sabharwal [mukulsabharwal@yahoo.com] for a PHP implementation of RC4
David Midkiff (mdj2023@hotmail.com) for a VB implementation of RC4
Klemens Schmid - http://www.schmidks.de/ for the XMLHTTP30 usage code

Picture of Pablo Gazmuri
Name: Pablo Gazmuri <contact>
Classes: 2 packages by
Country: United States United States
Age: ???
All time rank: 1353182 in United States United States
Week rank: 1587 Down176 in United States United States Up

Details provided by the author  
REMOTE SQL using php4 and VB6
Created by Pablo Gazmuri [pablo@gazmuri.net] in September 2002

Very special thanks to:
Mukul Sabharwal [mukulsabharwal@yahoo.com] for a PHP implementation of RC4
David Midkiff (mdj2023@hotmail.com) for a VB implementation of RC4
Klemens Schmid - http://www.schmidks.de/ for the XMLHTTP30 usage code

This Visual Basic and PHP combination allows you to remotely execute and 
retreive SQL queries to and from your online databases.  The VB code makes 
http requests to an online script (written in PHP) which executes your 
query and returns the result.  The queries and results are encrypted using 
rc4 encryption, which is now free for use (no patent fees apply), and the PHP 
script can be configured to only accept queries from a specific IP 
address.

This code provides the basis for building back-end client-side components 
(in VB of course).  The idea is that a VB application is much more 
responsive than web-based administration tools, and things like category 
or menu manipulation (via the VB tree view control) are much more user-friendly 
in a client-side app than in their cumbersome web-based 
counterparts.  The code could be extended to allow for binary data uploads 
as well, although a good VB FTP class could accomplish the same thing.

For those of you who abhor Microsoft, I apologize and invite you to create 
a Java client (I initially developed this for a larger VB App)

To use the VB portion of this project, you must add a reference to 
Microsoft XML version 3.0 (msxml3.dll) to the project file

Although the project references msxml3.dll, you will also need msxml3a.dll 
and msxml3r.dll installed to run this code.

You can download these .dll's from microsoft if they are not already on 
your system.

The PHP code is designed for use with a MySQL database, but could easily 
be modified for use with other databases.

NB - You need to set the encryption keys in both the VB source (Query.bas) 
and your PHP file (sql-link.php).  They must be the same string, and 
should not be words found in the dictionary.  The longer the string, the better the encryption.
  Files folder image Files  
File Role Description
Accessible without login Plain text file class.rc4crypt.php Aux. Mukul Sabharwal's RC4 Implementation
Plain text file class.sql_link.php Class Main Class File
Accessible without login Plain text file clsRC4.cls Aux. Visual Basic RC4 class
Accessible without login Plain text file Form1.frm Example Visual Basic Example Form
Accessible without login Plain text file Project1.vbp Example Visual Basic Project File
Accessible without login Plain text file Query.bas Aux. Visual Basic Module
Accessible without login Plain text file README.TXT Doc. Read me first
Accessible without login Plain text file sql-link.php Example Example Usage

 Version Control Unique User Downloads Download Rankings  
 0%Total:1,132All time:3,123
 This week:0This week:2,088Up