Get values from php page

Question

I've made a database,and for each row I've created a new php page and saved some values in the DB table.

Now, I want to insert the values from the PHP page that I've forgot to insert in the DB.

I only have 3 values. I know for each row the PHP page (url) from where I need to grab the values.

The values show up in the php page like this

   <table>
        <tr>
            <td>
            Column1
            </td>
            <td>
            Value-c1
            </td>
        </tr>

        <tr>
            <td>
            Column2
            </td>
            <td>
            Value-c2
            </td>
        </tr>

        <tr>
            <td>
            Column3
            </td>
            <td>
            Value-c3
            </td>
        </tr>

</table>

The page containg this table has other content too. I just need to take Value-c1 and insert it into Column1 in the MySQL table.

How can I get the content of the PHP page (having the URL) and also get the specific values that I want.

EDIT:

I have multiple static PHP pages (like 100) and I want to make a PHP script that will go through all the pages (I know their urls) and get from each page the values from the table and insert them into a DB.

Is that clear now? :D

You can't get the content of that table using php. You would need to use a form or javascript (AJAX). Now if I understand correctly you have parameters in your URL that you would like to retrieve. To do this access the `$_GET` superglobal like so echo `$_GET['param'];` — martynthewolf, May 25 '11 at 12:20

score 1 · Accepted Answer · edited May 23 '17 at 12:12

1

What you need is called sreen (or web) scraping. See http://en.wikipedia.org/wiki/Web_scraping for details.

Take a look at

How do you parse and process HTML/XML in PHP?
html scraping and css queries
http://www.bradino.com/php/screen-scraping/ - this a simple text parser (uses strpos&regexp). Its recommended to avoid these as they are pretty hard to maintain, but it may be easier in your specific case(as you already have the files, and its unlikely you have different formats for them)

for more answers

edited May 23 '17 at 12:12

Community

1
1

answered May 25 '11 at 12:30

Quamis

10,924
12
50
66

Thanks, I've spent like 1hour and made a crawler to get the data I wanted. :) – XCS May 29 '11 at 11:24

score 0 · Answer 2 · answered May 25 '11 at 12:31

0

The Easiest would probaly be to use Regex to get all the tr blocks from the page. You can then loop all the rows and run another Regex pattern to get the Column1 and the Value value.

answered May 25 '11 at 12:31

Johann du Toit

2,609
2
16
31

Get values from php page

2 Answers2