HOWTO - Sashipa development

How to access to the DBMS through a PHP.

You already have a Sashipa application. You wish to use a PHP for talking with the DBMS. You can't directly access the DBMS.

First operations to do are on the PHP file:

Edit the file <melbalab-home>/samples/melba_phpserver.php.
Complete connection information in the createConnection() function, at the end of file.
Add your security tests on SQL queries. Work carefully because this PHP can be an important security fail.
Put the PHP on the right place in your PHP server.

Now you can check your PHP is accessible from a browser. The PHP has to return an error message. If there isn't any response, try another URL or configure your PHP server. Keep the URL: you need it just below.

Here is the Sashipa code to modify, in the element <serverSet>.<server>:

  <dbConnection type='externalViaUrl' dbmsType='-your-dbms-type-'>
    <dbConnectionString>http://your-web-site/melba_phpserver.php</dbConnectionString>
    <user></user>
    <password></password>
  </dbConnection>

NB: user and password values are ignored (!). So it's not genius for security.

Rebuild. Your application is ready to access to your PHP.

Remark: here the PHP is just a way for accessing the database. So we could use the PHP with architecture that we prefer.

Top