PHP - Parsing An Entire Html Table

Hi guys. I have been using the wikipedia API to retrieve information about a topic. Ive managed to get a response and retrieve the first section of the topic (in this case football)

Using this method - http://en.wikipedia.org/w/api.php?action=parse&page='.$search.'&redirects=1&format=json&prop=text&section=0');

However the first section that is retrieved includes the pictures and i just want to main text from the introduction.

The code that is sent back from wiki is this -
Code: [Select]
Array
(
    [parse] => Array
        (
            [text] => Array
                (
                    [*] => <div class="dablink">This article is about sports known as football.  For the ball used in these sports, see <a href="/wiki/Football_(ball)">Football (ball)</a>.</div>
<div class="thumb tright">
<div class="thumbinner" style="width:227px;"><a href="/wiki/File:Football4.png" class="image"><img alt="" src="http://upload.wikimedia.org/wikipedia/commons/thumb/d/d2/Football4.png/225px-Football4.png" width="225" height="274" class="thumbimage" /></a>
<div class="thumbcaption">
<div class="magnify"><a href="/wiki/File:Football4.png" class="internal" title="Enlarge"><img src="http://bits.wikimedia.org/skins-1.17/common/images/magnify-clip.png" width="15" height="11" alt="" /></a></div>
Some of the many different games known as football. From top left to bottom right: <a href="/wiki/Association_football">Association football</a> or soccer, <a href="/wiki/Australian_rules_football">Australian rules football</a>, <a href="/wiki/International_rules_football">International rules football</a>, <a href="/wiki/Rugby_Union" class="mw-redirect" title="Rugby Union">Rugby Union</a>, <a href="/wiki/Rugby_League" class="mw-redirect" title="Rugby League">Rugby League</a>, and <a href="/wiki/American_Football" class="mw-redirect" title="American Football">American Football</a>.</div>
</div>
</div>
<p>The game of <b>football</b> is any of several similar <a href="/wiki/Team_sport" title="Team sport">team sports</a>, of similar origins which involve advancing a ball into a goal area in an attempt to score. Many of these involve <a href="/wiki/Kick_(football)" title="Kick (football)">kicking</a> a ball with the foot to score a <a href="/wiki/Goal_(sport)" title="Goal (sport)">goal</a>, though not all codes of football using kicking as a primary means of advancing the ball or scoring. The most popular of these sports worldwide is <a href="/wiki/Association_football">association football</a>, more commonly known as just "football" or "soccer". Unqualified, the word <i><a href="/wiki/Football_(word)" title="Football (word)">football</a></i> applies to whichever form of football is the most popular in the regional context in which the word appears, including <a href="/wiki/American_football">American football</a>, <a href="/wiki/Australian_rules_football">Australian rules football</a>, <a href="/wiki/Canadian_football">Canadian football</a>, <a href="/wiki/Gaelic_football">Gaelic football</a>, <a href="/wiki/Rugby_league">rugby league</a>, <a href="/wiki/Rugby_union">rugby union</a> and other related games. These variations are known as "codes".</p>

I want the code that resides in the <p> tags. How would i go about parsing this and removing the rest. ive tried to get to work simple html dom parser but with no luck.

Any help would be greatly appreciated 

Thanks,

DIM3NSION

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=308636.0

Hey guys,

So when I put the following line of php on an html page:
Code: [Select]
echo '&reg';

I get the 'Registered' symbol. How do I turn this off? What is happening is that it is part of a longer string that represents an url and the URL is not rendering correctly due to the special character.

Thanks

So I have an interesting one for you guys this AM,
I first want to make it very clear that I am not scraping code, rather I am scraping data that is needed to import into a shopping cart system for someone.
I have a URL that I am trying to scrape required data off of, however it is not returning all the data that I want. I have created a function that uses preg_match_all() and regex and I am still having issues striping what I want.

here is a link to my test what I am wanting to strip from http://visualrealityink.com/dev/clients/rug_src/scrapeing/Rugsource/www.vendio.com/stores/Rugsource1/item/other/tribal-wool-3x5-shiraz-persian/lid=10363581.html

 I am wanting to grab all this data:

Quote

Item Number:      
K-686
Style :     Shiraz
Province :     Fars
Made In :     Iran
Foundation :     Wool
Pile :     100% Wool
Colors :     Red, Navy Blue, Ivory, Forest Green, Light Blue, Orange
Size (feet) :     4' 11" x  3' 4"
Size (Centimeter) :     155 x 103
Age :     20-25 Years Old
Condition :     Very Good
KPSI (knots per sq. inch) :     130 knots per square inch
Woven :     Hand Knotted
Shipping and Handling :     Free Shipping(For Mainland USA)
Est. Retail Value :     $2,700.00


Here is the code note that $url holds the link above.
Code: [Select]
$html = file_get_contents($url);

$newlines = array("\t","\n","\r","\x20\x20","\0","\x0B");

$html = str_replace($newlinews, "", html_entity_decode($html));
preg_match_all('/<tr><td width="50%" align="right"><font color="#800000"><b>[^\s ](.*?)<\/b><\/font><\/td><td width="50%" align="left">[^\s ](.*?)<\/td><\/tr>/', $html, $matches, PREG_SET_ORDER);

foreach($matches_label as $match){
$count = 0;
echo $match[$count];
echo "<br>";
$count++;

}
echo $count;
This returns the following
Quote

Style :   Shiraz
Province :  Fars
Foundation :   Wool
Colors :  Red, Navy Blue, Ivory, Forest Green, Light Blue, Orange
Size (feet) :  4' 11" x  3' 4"
Size (Centimeter) :  155 x 103
Age :   20-25 Years Old
Condition :  Very Good
Est. Retail Value :   $2,700.00
1


it is missing: Quote

Inventory Number : xxxxxxx
Made In: xxxxxxxx
Pile : xxxxxxxxxx
KPSI(Knots Per Inch) : xxxxxxxxxx
Woven : xxxxxxxxx
Shopping : xxxxxxxxxxx



You can see the script in action here -> http://visualrealityink.com/dev/clients/rug_src/scrapeing/scrape_tst.php

Thanks in advance for all of your help

Hello dear Community,

i have a document i need to parse it and spit out only this part of the table:

see http://schulnetz.nibis.de/db/schulen/schule.php?schulnr=67003&lschb=

how to i parse the stuff!? With perl or php?

Note i have the xpaths (see below) Sad that i cannot apply them on Simple DOM Parser since this Dom Parser does not work with Xpaths but with  CSS-Selectors:

Well i want to get all the data with that are within the table that name is called  class="fliess"

How to dump all the results?
BTW - thinking about the most elegant way, i think it is the most pretty way would be to do it with perl - So i can try it with HTML::TableExtract or....

Well what do you suggest - Which way to choose to do this [very] simple thing?


Look forward to hear from you!

see the xpaths:

Schule:  /html/body/center/table/tbody/tr[2]/td[1]
Stasse: /html/body/center/table/tbody/tr[3]/td[1]
Ort:     /html/body/center/table/tbody/tr[4]/td[1]
Tel:     /html/body/center/table/tbody/tr[5]/td[1]
Schulgliederungen:  /html/body/center/table/tbody/tr[6]/td[1]
Besonderheite: /html/body/center/table/tbody/tr[7]/td[1]
E-Mail: /html/body/center/table/tbody/tr[8]/td[1]
Schulnummer: /html/body/center/table/tbody/tr[9]/td[1]

Hello,

I need some help. Say that I have a list in my MySQL database that contains elements "A", "S", "C", "D" etc... Now, I want to generate an html table where these elements should be distributed in a random and unique way while leaving some entries of the table empty, see the picture below. But, I have no clue how to do this... Any hints?



Thanks in advance,
Vero

I know I'm doing it something right, but can someone tell me why only one table is showing up? Can you help me fix the issue?

Heres my code:


function showcoords()
{
echo"J3st3r's CoordVision";
$result=dbquery("SELECT alliance, region, coordx, coordy FROM ".DB_COORDFUSION."");
dbarray($result);
$fields_num = mysql_num_fields($result);

echo "<table border='1'>";
// printing table headers


    echo "<td>Alliance</td>";
    echo "<td>Region</td>";
    echo "<td>Coord</td>";


// printing table rows
while($row = mysql_fetch_array($result))
{
    

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row AS $Cell)
     echo "<tr>";     
     echo "<td>".$row['alliance']."</td>\n";
     echo "<td>".$row['region']."</td>\n";
     echo "<td>".$row['coordx'].",".$row['coordy']."</td>\n";
     echo "</tr>\n";
    
}
echo "</table>";
mysql_free_result($result);

}



I have 2 rows inserted into my coords table. Just frustrated and ignorant to php.

Hello everyone,

I have a general question about something that I've been thinking about doing but have not tried yet.  It involves including entire php pages rather than a short snippet of code.  Here's my situation:

I've created a website that caters to many different schools, each of which is assigned a sub-domain so that they have "their own" web site instead of going to one site and then clicking a link to get to their page.  Every site is identical with the exception of a few images.  The way I'm currently doing things is to upload every page of code into each folder the each website.  Doing it this way, I'm using a lot of disk space and each time I edit one page of code, I have to upload that page to every folder in my directory.  It's not too bad with only a few folders, but as more schools use my site, it could become a nightmare!

What I'm thinking about doing is to upload all my pages to the parent directory, then on each page in my folders for the sub-domains just include the corresponding page in the parent directory.  I will just keep the images for each sub-domain in the corresponding folder.  For example, the actual code for the index page in each of my sub-domain folders would be this:

Code: [Select]
<?php
include("../indexpage.inc.php");
?>


This way, I use less disk space and if I need to edit some code, I do it once, and upload it once to the parent directory, instead of having to upload it to each and every folder.

Does anyone see any problem with doing this?  Thanks for your opinion.

What I'm trying to do is get my $_SESSION to work throughout my website. I'm quite new to PHP, so the PHP Manual didn't make much sense to me, so I thought I'd post here! ^^   I've got my login script under /session/ and I want it to be able to display your username on the homepage (/), but it only works inside /session/.   If you are wondering, I am using PHP-Login Advanced.   Thank you, - Connor!
Edited by ConnorMcF, 26 January 2015 - 04:45 PM.

I have an array containing webpages.
$results = array(www.google.com, www.phpfreaks.com);
echo file_get_contents($results[0]);
echo file_get_contents($results[1]);
Is there anyway to just echo get_file_contents without putting in the position in the array as I have hundreds of variables in it?

This topic has been moved to Apache HTTP Server.

http://www.phpfreaks.com/forums/index.php?topic=320065.0

Is it possible to extract all links from a website (not a single webpage) by php? I am asking about the general idea, as I wish to customize: e.g. from a specified directory and certain domains only.

Thanks 

When i pass entire url in a get variable as
 
http://www.example.com/index.php?url=http://www.yahoo.com/

I am getting the following error

Forbidden

You don't have permission to access /index.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

But there is no problem when i use the following

http://www.example.com/index.php?url=www.yahoo.com/
http://www.example.com/index.php?url=yahoo.com/
http://www.example.com/index.php?url=yahoo&value=1

I am getting "Forbidden-error" only when i include "http://"(even if it is urlencoded) in get variables.
Can any one help me...

I'm trying to find a way to back up an entire servers file through PHP. I have a script that can take selected files into a zip file but I'm not sure how to make sure that when I loop through directory and files that I get every single file.

I was thinking of just foreach(glob('*') as $file up to 10 times but I'm hoping there's something more definite then that method...

Thanks

I hate array...   😞

So I had a block of code inside my photo-gallery.php script that took the path to my photos directory, and went to that directory, and then read all of the photo filenames into an array.  Then in my HTML, I iterate through this array to display all of the photos for my gallery.

Now I would like to move that code to an included file so multiple scripts can access it and always be working with the same array.

It seems to me that I need to encapsulate my code inside a function?

Then I could call my getPhotoFilesArray back to my callings cript, and use that array for whatever.

I haven't coded PHP in like 4 years and I am struggling to return the entire array back to my caling script.

This is what I have so far...

	function getPhotoFilesArray($photoPath){
	     $photoFiles = array();
	     <code to find corresponding files>
	     $photoFiles gets populated in a loop
	     return $photoFiles;
	}
	

 

Then in my calling script, I have...

	<?php
	     require_once('../../../secure_outside_webroot/config.php');
	     require_once(WEB_ROOT . 'utilities/functions.php');
	     getPhotoFilesArray($photoPath);
	     var_dump($photoFiles);
	

 

I get some error...

	Notice: Undefined variable: phtoFiles in photo-gallery.php line 133 (which is my var_dump).
	

 

<br>

Would appreciate help getting this to work!

 

 

Edited December 6, 2019 by SaranacLake