extracting information from server database

[moleEE132]

I am trying to extract information from a server database to put it into my database.

how do i do so by using a URL?

 

thanks

[kenrbnsn]

More information is needed to effectively answer your question.

 

Ken

[moleEE132]

The database that i have with me do not have much info.

In order to have the rest of the info ( by not editing my database) i will need to get from the server.

Hence will need a url to link there.

 

Thanks

[trq]

You generally do not connect to database servers via urls. You need to provide allot more information though I suspect your not sure what your asking exactly.

 

Try not to tell us what you think you need to do, just describe your actual need.

[moleEE132]

Our own database don't have the full information that the user needed/wanted after doing a search but it will only show the basic information. Hence we want to know how do we get the rest of the information from a different website so that when user view the searched details, they are able to see the full information needed.

[trq]

So you want to steal content from another website? This has nothing to do with connecting databases (unless of course you can get permission to do that).

 

You need to Google 'screen scraping'.

[moleEE132]

Hi actually i do have the permission to access the database, but its too big therefore i am thinking of just "linking" my site to it. So that i am still able to get the information from it after doing a search.

There are people who suggests about HTTP commands to me like GET and POST but i'm not sure how to really do it.

 

thanks alot for your reply and advices.

 

[dezkit]

What are you trying to say? You want to get all the data from another sql database to your own? You may want to export the sql in the export tab in the other database.

[Pikachu2000]

What do you mean the database is "too big"?

[optikalefx]

@OP whatever website hosts the remote database, get them to write a small simple PHP script that acts like a private API.  That way you can use CURL to get data from the remote database.

 

Where $nvp below is a URL variable thing. like &db=customers&customer_id=1&fname=frank

 

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL,"http://www.website.com/page.php" );
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POST, 1);

// Set the request as a POST FIELD for curl.
curl_setopt($ch, CURLOPT_POSTFIELDS, $nvp);

// Get response from the server.
echo curl_exec($ch);

 

then BOOM using a URL to get data from a remote database.

[trq]

then BOOM using a URL to get data from a remote database.

 

That's all well and good, but if the OP has permission he may as well make a proper connection to the database and just use.

 

Unfortunately however, the OP isn't being very helpful with his questions / responses to other questions.

[optikalefx]

That's all well and good, but if the OP has permission he may as well make a proper connection to the database and just use.

 

Unfortunately however, the OP isn't being very helpful with his questions / responses to other questions.

 

From what i can gather OP has access but most likely not directly to the database.  Because it seems OP knows how to straight connect to a DB but for some reason this other DB isn't directly connectable.  Therefore it's probably on a remote system, and hes trying to connect and use it via a URL and that most closely resembles a remote HTTP request such as CURL.

 

I guess. lol.

 

[ajicles]

$ID = @$_GET['id'] ;
$db_host = 'Host';
$db_user = 'username';
$db_pwd = 'password';

$database = 'database';
$table = 'table';

if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

$result = mysql_query("SELECT id,post_content FROM $table WHERE id = '$ID'");
if (!$result) {
    echo 'Could not run query: ' . mysql_error();
    exit;
}
$row = mysql_fetch_row($result);

echo $row[1];

 

Something like that?

 

id and post_content are columns in the database just enter your own.

[moleEE132]

thank you optikalefx.

Ya that's exactly what i am trying to say, its only that i'm not sure how to put them in words properly.

Will try out your codes and update on the outcomes soon 

 

thanks again