PHP SAP MYSQL

[rajkumar_gauthaman]

HI All,

I am extracting data from SAP based on the rfc call from php and then with taht data have to update mysql database using

PHP.

Kindly help me how do i proceed with PHP and MYSQL updation with the data from SAP

Also i have to install SAPRFC in linux kindly help

Thanks and Regards,

rkvrish

[Former Member]

Well first, if you've read any tutorials on the subject you have to connect PHP to your MySQL database

In newer versions of PHP you would want to use mysqli (MySQL Improved(basically for mysql servers above version 4)) , but you can still use the original MySQL method if you want to.

so you connect it like

$mysqli = new mysqli($host, $username, $password, $database_name);

When you connect then you can run queries on the database for what you need to do like insert data, fetch data etc...

This and the post above's link can get you started. As well here are some other useful PHP/MySQL guides:

http://php.net/manual/en/book.mysqli.php - Official PHP Documentation - bookmark this site.

http://www.phpro.org/tutorials/Introduction-to-PHP-and-MySQL.html

http://return-true.com/2010/04/using-php-mysqli-with-a-mysql-database-part-1/

On another note some of the best resources are by example, by examining the way some simple PHP systems, like user registration, are developed with PHP and MySQL

[Former Member]

Hi,

there are many tutorials on the web about PHP and MySql.

For example:

http://www.freewebmasterhelp.com/tutorials/phpmysql

Best regards,

Peter