Ad:

PHP Discussion Thread
Unsolved
Views: 361

Aug 22nd, 2009

Database results from one site to another

Expand Post »

Looking at the source code of this website:

http://superdialcouk.dmshop.biz/numb...9-14_8068_0003

What code do i copy and paste to get that table of telephone numbers on my website, the numbers need to remain dynamic in thesense tat if theyre purchased from the site given above - they then should not be viewable on my site.

Similar Threads

question on SEO and database-driven site integration... in PHP
How to SEO a large database driven site in Search Engine Optimization
Best CMS for database driven site in PHP
mod_rewrite Joomla database driven site in Linux Applications and Software
submiting info into a database for retrieval! in PHP

caps_lock

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

43 posts
since Nov 2008

Permalink

Aug 22nd, 2009

Re: Database results from one site to another

curl

Dsiembab

Reputation Points: 18

Solved Threads: 2

Junior Poster

Offline

156 posts
since Mar 2007

Permalink

Aug 24th, 2009

Re: Database results from one site to another

Well to retrieve the entire page use file_get_contents() then preg_match_all() to filter to that table. Below is an example

php Syntax (Toggle Plain Text)
<?
$var=file_get_contents('http://superdialcouk.dmshop.biz/numbers/0207/choose.php?dmb1_SessRef=2009-08-22_15-29-14_8068_0003');
$var=preg_match_all('/<table class="vert_centered_leaded" style="width: 100%;".*<tr>.*<tr>.*<\/tr>(.*<\/table>)/Us',$var,$array);
//print_r($array);
$var='<table class="vert_centered_leaded" style="width: 100%;">'.$array[1][0];
unset($array);
echo $var;
?>
<?
$var=file_get_contents('http://superdialcouk.dmshop.biz/numbers/0207/choose.php?dmb1_SessRef=2009-08-22_15-29-14_8068_0003');
$var=preg_match_all('/<table class="vert_centered_leaded" style="width: 100%;".*<tr>.*<tr>.*<\/tr>(.*<\/table>)/Us',$var,$array);
//print_r($array);
$var='<table class="vert_centered_leaded" style="width: 100%;">'.$array[1][0];
unset($array);
echo $var;
?>

Usually I only use curl if it involves pinging or posting to a server.

Last edited by cwarn23; Aug 24th, 2009 at 4:31 am. Reason: code tag syntax

cwarn23

Sponsor

Featured Poster

Reputation Points: 410

Solved Threads: 258

Occupation: Genius

Offline

3,004 posts
since Sep 2007

Permalink

Aug 24th, 2009

Re: Database results from one site to another

fopen

Quote ...

If PHP has decided that filename specifies a registered protocol, and that protocol is registered as a network URL, PHP will check to make sure that allow_url_fopen is enabled. If it is switched off, PHP will emit a warning and the fopen call will fail.

Also if someone gets wary of the ip address that the request is being made from your server ip could get blacklisted. with curl you can change the headers being sent to mirror googlebot or what not. Then none would be the wiser.

Dsiembab

Reputation Points: 18

Solved Threads: 2

Junior Poster

Offline

156 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Cache-Control help

Next Thread in PHP Forum Timeline: Isnt displaying database results

DaniWeb Message

Cancel Changes

User Name
Password