image thumbnail

Matlab to MySQL Interface

version 1.0.0.0 (82 KB) by Luigi Rosa
Matlab to MySQL interface using a PHP script

4.6K Downloads

Updated 16 May 2007

View License

MySQL is an open-source database server designed for robustness and speed. On the MySQL home page you can read all about it. To interface to the server, you need a client program which implements the specific MySQL protocol. Then you can execute queries using standard Structured Query Language (SQL). For mathematical and statistical analysis, the best way to use the data is to download it directly into Matlab (for example using Robert Almgren's interface available at http://mmf.utoronto.ca/resrchres/mysql/ ).

Unfortunately many web servers do not allow users to access MySQL server from remote applications for safety reasons. In this case this limitation can be solved interfacing MySQL server with a php script called by Matlab application.

The php script executes the list of MySQL commands given by Matlab, and eventually returns also some output values (in case of SELECT command). This php script has to be available at the remote server (uploaded via FTP protocol). This php script receives the list of MySQL commands submitted by Matlab using POST method. Matlab in fact can read the content of an URL passing information to the server as part of the request with GET or POST methods using urlread command.

Index Terms: Matlab, source, code, php, MySQL, interface, interfacing, database, SQL, connection, server, http, request, script.

For more details please visit

http://www.advancedsourcecode.com/matlabphpmysql.asp

Luigi Rosa
Via Centrale 35
67042 Civita Di Bagno
L'Aquila - ITALY
mobile +39 320 7214179
web site http://www.advancedsourcecode.com

Cite As

Luigi Rosa (2021). Matlab to MySQL Interface (https://www.mathworks.com/matlabcentral/fileexchange/15002-matlab-to-mysql-interface), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2006a
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!