PHP Classes
Icontem

Class: Remote MySQL Query


  Search   All class groups All class groups   Latest entries Latest entries   Top 10 charts Top 10 charts   Newsletter Newsletter   Blog Blog   Forums Forums   Help FAQ Help FAQ  
  Login   Register  
Recommend this page to a friend!
      Classes of Jeff Williams  >  Remote MySQL Query  >  Download  >  Support forum Support forum  >  RSS 1.0 feed RSS 2.0 feed Latest changes  >  Stumble It! Stumble It!  >  Bookmark in del.icio.us Bookmark in del.icio.us  
  Supplied by   Group folder image Groups   Detailed description  
  Rate classes User ratings   Applications   Files Files  

  • Supplied by:

    Picture of Jeff Williams
    Name: Jeff Williams is available for providing paid consulting. Contact Jeff Williams .
    Published packages: 5
    Country: United States United States - PHP jobs in United States
    Home page: ???
    Age: 37
    All time rank: 130
    Week rank: 44

    Browse this author's classes

  • Innovation Award:

    PHP Programming Innovation award nominee
    July 2007
    Number 5
    		 Sometimes it is necessary to perform queries to databases that are in remote servers. However, firewall rules prevent accessing those databases from outside the network where the respective server machines are located.

    This package provides a solution that circumvents that restriction. It uses a PHP script as a proxy in the same machine as the remote MySQL database server to perform remote queries via the Web.

    This way the remote database can be queried by client scripts from remote machines. To use this solution, the client scripts can be in PHP or any other language.

    Manuel Lemos

  • Groups:

    Group folder image PHP 5 Classes using PHP 5 specific features View top rated classes
    Group folder image Databases Database management, accessing and searching View top rated classes
    Group folder image Web services Web data clipping, SOAP or XML-RPC clients and servers View top rated classes

  • Detailed description:

    Easily execute queries on a remote MySQL server using only HTTP.

    It works by accessing a PHP script on the remote web server that executes queries based on passed in URL parameters.

    The client passes a secret key to the remote script to prevent unauthorized access.

    The remote script passes back the results to the requesting client using XML to marshal the data.

    The class parses the results XML data returned by the server script and returns an array.

    It, also, retrieves (into class variables) the number of records returned by the query and the time the query took to execute.

    The server script may be used to execute MySQL queries that can be retrieved by programs written in other languages besides PHP.

  • User ratings:

    Ratings
    Utility
    Consistency
    Documentation
    Examples
    Tests
    Videos
    Overall
    Rank
    All time:
    Perfect (100.0%)
    Good (95.8%)
    Sufficient (70.8%)
    Sufficient (75.0%)
    -
    -
    Sufficient (74.2%)
    61
    Month:
    Not yet rated by the users

  • Applications that use this class:

    No application links were specified for this class.
    Add link image If you know an application of this package, send a message to the author to add a link here.

  • Files:

    File Role Description
    Plain text file remote_query_server.php Aux. Server file
    Plain text file remotequery.class.php Class Client class
    HTML file class_help.html Doc. Help for class
    Accessible without login Plain text file example.php Example Example file
    Download all files: remotequery.tar.gz remotequery.zip
    NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.

 
  Advertise on this site Advertise on this site   Site map Site map   Statistics Statistics   Site tips Site tips   Privacy policy Privacy policy   Contact Contact  
For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2008 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products