copy a table

[byronghislain]

I will like to copy a table being from another site to put it on my page.
Thus if the table of the external site is modified, my table changes alone while being based on the other.

Is this possible?


ps: excuse me for my english but i speak french

[djr33]

It is possible, using PHP.

<?php include('http://the.com/the/page.htm'); ?>

That would include the whole page into your page where that code is. I would suggest having just the table in a document.

For example:

table.txt:
<table>...my data here...</table>

On both page 1 and page 2:
<?php include('table.txt'); ?>

It would be a lot more work to first extract the table and then place it into a new page. If you need this, we can probably help, though.
You could use file_get_contents('the.txt') and then split it using string functions, like substr, strpos, etc.

[byronghislain]

in fact the problem is that I is not the possibility of modifying the source page in which the table is that I have need.
Thus it will be necessary that I make a which page either duplicates the table, or that information of table source sent directly in my base of data so that don&#233;es replace themselves in the new table.

(if that is possible with another language that the php, that will also go)

[djr33]

No reason to use another language. you need a serverside language, like PHP, and there's nothing wrong with using PHP.

It's just hard.

<?php
$f = file_get_contents('http://whatever.com/stuff/page.htm');
echo substr($f,strpos($f,'<table>'),strpos($f,'</table>',strpos($f,'<table>'))-strpos($f,'<table>'));
?>

That will find the first instance of the characters "<table>" in the source code of that page, and continue until the first instance after of "</table>".

This isn't very reliable, though, because you must find the RIGHT instance of the table and the right close tag. I suggest looking at those two functions, strpos and substr, and finding a way to use them to find the right table on the page.
If you happen to know it says "options:" and the table is after that, for example, you could use that as a marker, and make sure that it only finds results after "options:".

[byronghislain]

Thus that will enable me to find the beacon table
do I have compri well?

here there is plusior table on the page, and that which I have need, is not the first.

Thus thanks must then to the name to give to the table, I have easy not?

[djr33]

You must find a way to distinguish the table.
Find a set of characters in the source code that will always be there and is as close as possible to the table you want.
You could link to the page and I could check.

[byronghislain]

apparently it is identical table with each time a beacon <br> enters

but it is a table has two lines.

Thus perhaps that I can use the first line containing the title of the table in order to copy the second line which contains the essential contents

[djr33]

Sure.
You need a CLEAR marker that will never change, and you can get any data you want in relation to that.

The computer doesn't see tables. It just sees characters. So you can tell it to look for "t" before "a" before "b" before "l" before "e", etc., but it won't be able to guess what you want.

You will need a clear marker before and after (after can be less clear as long as it is the first instance after the start), or a position and length, etc.

[byronghislain]

thus I can say to him to take into account of beacon TD being after such word text (as the title) until the end of this beacon.

Is this well that?

[Twey]

The computer doesn't see tables. It just sees characters.

Unless you use a DOM parser. Then it sees elements.

<?php include('http://the.com/the/page.htm'); ?>

Now this is a very bad idea. That HTML page will be included -- and executed as PHP code. It effectively gives the owner of the remote server access to your server with the access rights of the server process -- which is enough to much up your files and probably steal a database password or two, at least.