How to execute queries in remote servers

Question

I am trying to insert data to a web site from the code of another web site. How can I use the mysql_connect() command for that. Can I use the IP address of the first web site in the second web site code?

Please help me

How can I accept an answer ? I have clicked in "Useful " – user1467983 Jun 25 '12 at 06:54 — user1467983, Jun 25 '12 at 06:54
somebody is trying NAUGHTY stuff! – Adi Jun 25 '12 at 06:54 — Adi, Jun 25 '12 at 06:54

score 1 · Answer 1 · answered Jun 25 '12 at 06:56

Yes, you can use a remote MySQL server with mysql_connect(). Use mysql_connect() according to the PHP manual (http://php.net/manual/de/function.mysql-connect.php) and use your server's IP as $server. However, make sure the MySQL port is accessible from remote on the MySQL server (port 3306).

score 0 · Answer 2 · answered Jun 25 '12 at 07:06

For inserting data in the database you need to connect the database

Selecting DATABASE

you need to just connect the server on which the db exist in which we are inserting

<?php

$link = mysql_connect('ip or server of the db in which inserting', 'mysql_user', 'mysql_password');
if (!$link) {
    die('Not connected : ' . mysql_error());
}

// make myDB the current database 
$db_selected = mysql_select_db('myDB', $link);
if (!$db_selected) {
    die ('Can\'t use myDB: ' . mysql_error());
}
?>

for inserting records in another website , you need to just connect the server and DB of that particular website, and fire Queries.

let me know if more..

How to execute queries in remote servers

2 Answers2