PHP Classes

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

Recommend this page to a friend!
  Info   View files View files (8)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 1,142 All time: 3,302 This week: 232Up
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: 1455218 in United States United States
Week rank: 420 Up49 in United States United States Up

Details

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,142
This week:0
All time:3,302
This week:232Up