PHP - Extracting Data

so I'm working on this system which requires me to inject anime show names into a DB for an index.

I get them in this form:
[Kira-Fansub]_HIGHSCHOOL_OF_THE_DEAD_-_04_(BD_1920x1080_x264_AAC) [F0E73009].mkv

I need to get it in this form: Highschool Of The Dead

sometimes the words are space seperated.
the main part is to extract the text in between the ] and ( and with that i mean [stuff]extract this(other stuff) and sometimes it looks like this: [stuff]extract[stuff]

I have NO CLUE how to do this preg_match_all doesn't get me any further.. maybe in stages?

Hi guys,
This is my problem:
I have a csv file let's say have these values:

blue,1,2,3,4
red,8,5,6,7

I need to add thes values into a 2d array
to be able to use like this:
colors[1][2]=2
colors[2][4]=7

Where my first number is the row and the second number is the value within that row.

This is what I got so far

<?PHP
$i=0;
$j=0;
$file_handle = fopen("color-list.csv", "r");
while (!feof($file_handle) )
   {
   $colors = fgetcsv($file_handle, 10000);

for ($j=0; $j<=4; $j++)
               {
               $row[$i][$j]=$colors[$j];
                                        print row[$i][$j];
               }
$i++;
?>

For some reason this doesn't work. Maybe I am declaring the arrays wrong.

Thank you!

Hello all,

I have a problem I'm not sure how to tackle.  I have data in a database that looks looks like this:

Field1   |    Field2
AA        |    AA Row 1 Data
AA        |    AA Row 2 Data   
AA        |    AA Row 3 Data   
AB        |    AB Row 4 Data
AB        |    AB Row 5 Data
AB        |    AB Row 6 Data
AC        |    AB Row 7 Data
AC        |    AB Row 8 Data
AC        |    AB Row 9 Data
AC        |    AB Row 10 Data

I would like to grab and output JUST the first AA, AB, AC  and the the row data in field two?  So the loop would catch the first AA then when field1 data has changed it will output the first AB and so on... 

So the output would look like:

Row1:  AA : AA Row 1 Data
Row2:  AB : AA Row 4 Data
Row3:  AC : AA Row 7 Data

Is there a way to accomplish this?  Any help would be great!

Thanks!

I've only been studying PHP for a week now and have come across this problem which I'm sure there is a simple answer to, but I just can't figure it out and would appreciate some help. I've spent far too long on this minor issue already!

I have a table which contains a list of products, in this case books, which stores the date when each new item is added.
I have a query that then searches through this table and extracts the 6 most recent additions.

Here is the code I have so far:

Code: [Select]
$sql = mysql_query("SELECT * FROM products ORDER BY date_added DESC LIMIT 6");
$productCount = mysql_num_rows($sql); // count the output amount
if ($productCount > 0) {
while($row = mysql_fetch_array($sql)){
             $id = $row["id"];
$title = $row["title"];
$author = $row["author"];
$price = $row["price"];
$date_added = strftime("%b %d, %Y", strtotime($row["date_added"]));
$dynamiclist .= //My table showing the products
}
} else {
$dynamicList = "There are currently no Books listed in this store";
}
This works well when I need to display the 5 most recent products in a normal table fashion, one below another, on the page.

However, I want to display the products in a more personalised order. For example display the newest item in one section of the page and 3rd newest in another.

What is the best way to select an individual row from a query? To extract the details of the 2nd newest item to display in the header, for example.

Thanks for your help.

I have a string

Code: [Select]
<p>Bollywood romcom: a pair of wouldbe suicides choose the same bridge at the same time.</p><p><a href="http://www.dailyinfo.co.uk/reviews/venue/1320/Vue_Cinema">Vue Cinema</a> (<a href="http://www.myvue.com/cinemas/index.asp?SessionID=0D86903A19334C93A7491563A77862A3&cn=1&ln=1&ci=66" target="_blank">www.myvue.com/cinemas/index.asp?SessionID=0D86903A19334C93A7491563A77862A3&cn=1&ln=1&ci=66</a>), Ozone Leisure Park, Grenoble Road (next Kassam Stadium), Oxford OX4 4XP; Tel. 08712 240 240 (10p per min from BT).<br /> </p>
Using php i want to extract

Code: [Select]
http://www.myvue.com/cinemas/index.asp?SessionID=0D86903A19334C93A7491563A77862A3&cn=1&ln=1&ci=66
from the <a> tag.

I have already tried using

    
<?php

$pattern = "/<a href=\"([^\"]*)\">(.*)<\/a>/iU";
preg_match_all($pattern, $link, $matches);
var_dump($matches);
?> 

The output I get is

array
  0 =>
    array
      0 => string '<a href="http://www.dailyinfo.co.uk/reviews/venue/1320/Vue_Cinema">Vue Cinema</a>' (length=81)
  1 =>
    array
      0 => string 'http://www.dailyinfo.co.uk/reviews/venue/1320/Vue_Cinema' (length=56)
  2 =>
    array
      0 => string 'Vue Cinema' (length=10)

I have 2 sites.  1 site is a store the other is a blog.
The homepage of the store shows random product images.  Each image links to it's product page.

I'm using the code below to get data from the store homepage into a variable:
Code: [Select]
<?php
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, "http://www.somesite.com");
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    $output = curl_exec($ch);
curl_close($ch);
?>
I can echo $output and see the page displayed on my page.  So that part is working.

On the blog, I want to display random products and link them back to the store.

How can I extract just the images & their page links from the $output variable?

Hey all,

I wrote a crawler and have already written the string to extract links. i get a multidimensional array.
this is #13 for example

Array[0][13] => <a class="menuitem" href="/home-news.html" title="Home / News">Home / News</a>
Array[1][13] => /home-news.html

ok so far so good. Now I want to extract the name Home / News and write that into a database and the link as well. can i use the preg_match_all() to search an array? or how can i extract it?

Thanks so much! monkover

This topic has been moved to PHP Regex.

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

Hi,

I have an XML Feed which is using ID's or Types. I need to select the specific node and convert it to a variable.

Example XML Feed:

Code: [Select]
<tour>
<tourName>Amazon Riverboat Adventure</tourName>
<dossierCode>PVIIA</dossierCode>
<tripDetails>
<tripDetail type="StartFinish">ex Lima</tripDetail>
<tripDetail type="What's Included">Lots of stuff </tripDetail>
</tripDetails>
I have been extracting this data by using:

<?php
if(!$xml=simplexml_load_file('xmlfeed.xml')){
    trigger_error('Error reading XML file',E_USER_ERROR);
}
foreach ($xml->tourName as $tourname)
foreach ($xml->dossierCode as $agentcode)
?>

However I am unsure how I can extract the "ex lima" from StartFinish as $startfinish.

Can anyone help?

Many thanks!

Hey,

Having some troubles extracting data from simpleXML object.

var_dump outputs all the stuff correctly but when i try access data in the object, it just comes back empty.


$rss = "/data/rss/";
$rss = file_get_contents($rss); // simplexml_load_file() fails
$feed = new SimpleXMLElement($rss);

foreach($feed->item as $news) {
echo $news->title; // returns empty
}

echo $feed->item->title; // also is empty


so var_dump($feed) outputs this, shortened version:


object(SimpleXMLElement)#10 (2) { ["@attributes"]=> array(1) { ["version"]=> string(3) "2.0" } ["channel"]=> object(SimpleXMLElement)#11 (6) { ["title"]=> string(38) "Bradford Bulls Super League Rugby News" ["description"]=> string(75) "RSS Feed for the latest Bradford Bulls Super League rugby news and updates." ["link"]=> string(46) "http://www.superleaguefans.com/bradford-bulls/" ["language"]=> string(2) "en" ["pubDate"]=> string(26) "Sat, 03 Sep 13:42:39 +0100" ["item"]=> array(10){ [0]=> object(SimpleXMLElement)#12 (1) { ["title"]=> string(32) "Briggs and Walker in Bulls squad" } } } } 


so, $feed->item->title  should return the ["title"] contents, but it doesn't, driving me crazy.

what am i doing wrong? Any pointers will be much appreciated, thank you.

I need help on extracting of data from another website, commonly known as screen scrapping. I was able to do it with a basic created function, but it doesn't work for extracting data out from a table of another website.

I want to extract the data from each row and data of this site http://online.wsj.com/mdc/public/page/2_3021-usetf.html, so that I can put these data into my database.

My current code is

<?php
$data = file_get_contents('http://online.wsj.com/mdc/public/page/2_3021-usetf.html');
$regex = '/You(.+?) registered/';
preg_match($regex,$data,$match);
var_dump($match);
echo $match[1];
?>

Anyone has a script that I could modify to do that? Thanks!

I have a bunch of pdf's and I want to extract text from the last page of every pdf. I have a function to count the number of pages in each pdf.

Does anyone know of a way that I could extract file from a specified file and page number.
example:   getData('example.pdf', 54);

Hi

I'm learning php and trying to write a script to extract registration information from a large text file. Sadly my meagre knowledge of php is letting me down a bit. It's a case of knowing what you want the script to do but not having the knowlege of how to 'say it'.

So i was hoping that if I posted my code here someone could either give me a few pointers on where i am going wrong or suggest  a better way.

The text file data luckily has a recurring format as follows (for brevity i've only included one entry, which contains made up information):



From:   bella_done@yahoo.co.uk
Sent:   02 February 2011 22:50
To:   Jonny tum, patsy fells, dingly bongo
Subject:   Subject: Fun Run 2010

Categories:   Fun Run

Name: Bella Donna
 Address: 14 brondle avenue
 Postcode: cd83 1rg
 Phone: 0287343510
 Email: bella_don@yahoo.co.uk
 DOB: 15/11/1945
 Half or Full: Full fun run
 How did you hear: Took part in 2010

As you can see the data has a convenient boundary at the 'from' field and the colon (or so it occurred to me) so I created my script as follows:



// the string being analysed
$the_string = "
From:

bella_done@yahoo.co.uk
Sent:

02 February 2011 22:50
To:

Jonny tum, patsy fells, dingly bongo
Subject:

Subject: Fun Run 2010

Categories:

Fun Run

Name: Bella Donna 
 Address: 14 brondle avenue 
 Postcode: cd83 1rg 
 Phone: 0287343510 
 Email: bella_don@yahoo.co.uk 
 DOB: 15/11/1945 
 Half or Full: Full fun run 
 How did you hear: Took part in 2010";

// remove all formatting to work with a clean string

$clean_string = strip_tags($the_string);



// remove form field entries from the data and replace with commas and a ZZZ boundary

$remove_fields = array("Categories:" => "","Name:" => ",","Address:" => ",","Postcode:" => ",","Phone:" => 

",","Email:" => ",","DOB:" => ",","Half or Full:" => ",","How did you hear:" => ",","From:" => "ZZZ","Sent:" => 

",","To:" => ",",  );


$new_string = strtr("$clean_string",$remove_fields);


// split the data at the boundary ZZZ

$string_to_array = explode("ZZZ", $new_string);

$new_string2 = implode("</br>",$string_to_array);

echo $new_string2; 




$myFile = "address_list.csv";
 $fh = fopen($myFile, 'w') or die("can't open file");
 $stringData = $new_string2;
 fwrite($fh, $stringData);
 fclose($fh);




One major problem is when i write the new data to a csv file the csv contains spacings that cause it to be reproduced in a column form rather than as separate fields for each comma boundary.

So can anyone suggest either

a) a better way of extracting the data from the text file (doesn't need to be 100% clean and perfect)

b) How can i stop the spaces in the csv (i thought i would have fixed this when i stripped the tags from the string at the start??).

Any help would be greatly received by a newbie phper.

It's my first shot at performing anything moderately taxing so if I've made some blaring oversites I would very much welcome your wisdom!

Thank you

Drongo

Hi all,

I hope someone can help me out here as I think I am close but am not sure where to go from here.  The problem is:
I have a cms where a user can see a list of photos in the gallery.
I provide them the ability to select what photos they want to appear on a particular webpage.
The problem I have is that the user wants to be able to put the photos in whatever order they choose.

So, I have a form (see attached), the html code is:

          <table width="566px" cellspacing="0" border="0">              <tr>
                <td width="33%">
                  <div class="serviceCell">
<input type='checkbox' checked='checked' name='photos[][0]' value='119' />&nbsp;Bathroom Sin...
<img src="./images/help.gif" title="Enter an integer to signify the order in which this image will appear on the webpage." alt="Enter an integer to signify the order in which this image will appear on the webpage."/>&nbsp;<input type="text" size="2"  name="photos[][1]" value="0"/>                  </div>
                </td>
                <td width="33%">
                  <div class="serviceCell">
<input type='checkbox' checked='checked' name='photos[][0]' value='113' />&nbsp;Courtyard 1
<img src="./images/help.gif" title="Enter an integer to signify the order in which this image will appear on the webpage." alt="Enter an integer to signify the order in which this image will appear on the webpage."/>&nbsp;<input type="text" size="2"  name="photos[][1]" value="0"/>                  </div>
                </td>
                <td width="33%">
                  <div class="serviceCell">
<input type='checkbox' name='photos[][0]' value='114' />&nbsp;Courtyard 2
<img src="./images/help.gif" title="Enter an integer to signify the order in which this image will appear on the webpage." alt="Enter an integer to signify the order in which this image will appear on the webpage."/>&nbsp;<input type="text" size="2"  name="photos[][1]" value=""/>                  </div>
                </td>
              </tr>...

Now, lets assume that the user ticked the box next to 'Courtyard 2' and entered an integer '1' in the input box to signify that this image should be displayed 1st on the chosen webpage.  These 2 values go into the multidimensional array (photoid, ranking) and are submitted in the form to php in the photos[][] array.

But here is where I have the problem.  I am trying to extract the values from the array and then do an insert to a table in mysql.  My syntax must be wrong somewhere so I am asking anyone to please offer any advice:

  if (isset($_REQUEST['submitted'])){   
       $photos = $_REQUEST['photos'];
...

    if(!empty($photos)){
       foreach($photos as $photoID){
         $sql = "INSERT IGNORE INTO menuItemPhotos
                SET photoid='$photoID[0]', menuItemid='$id', ranking='$photoID[1]'";
        $ok = @mysql_query($sql); // execute the query
      } // End of foreach($photos as $photoID){
    } // End of if(!empty($photos)){

Thanks
Conor

[attachment deleted by admin]

I need to set up a threaded comments system in a PHP project and I got this script shown below from http://www.jongales....#comment-436261

class Threaded_comments
{
    
    public $parents  = array();
    public $children = array();

    /**
     * @param array $comments 
     */
    function __construct($comments)
    {
        foreach ($comments as $comment)
        {
            if ($comment['parent_id'] === NULL)
            {
                $this->parents[$comment['id']][] = $comment;
            }
            else
            {
                $this->children[$comment['parent_id']][] = $comment;
            }
        }        
    }
   
    /**
     * @param array $comment
     * @param int $depth 
     */
    private function format_comment($comment, $depth)
    {   
        for ($depth; $depth > 0; $depth--)
        {
            echo "\t";
        }
        
        echo $comment['text'];
        echo "\n";
    }
    
    /**
     * @param array $comment
     * @param int $depth 
     */ 
    private function print_parent($comment, $depth = 0)
    {   
        foreach ($comment as $c)
        {
            $this->format_comment($c, $depth);

            if (isset($this->children[$c['id']]))
            {
                $this->print_parent($this->children[$c['id']], $depth + 1);
            }
        }
    }

    public function print_comments()
    {
        foreach ($this->parents as $c)
        {
            $this->print_parent($c);
        }
    }
  
}

Here’s the example usage with the data provided as an array:

$comments = array(  array('id'=>1, 'parent_id'=>NULL,   'text'=>'Parent'),
                    array('id'=>2, 'parent_id'=>1,      'text'=>'Child'),
                    array('id'=>3, 'parent_id'=>2,      'text'=>'Child Third level'),
                    array('id'=>4, 'parent_id'=>NULL,   'text'=>'Second Parent'),
                    array('id'=>5, 'parent_id'=>4,   'text'=>'Second Child')
                );

$threaded_comments = new Threaded_comments($comments);

$threaded_comments->print_comments();

I have a sample select query that pulls data from a database and stores the result in the $comments array as shown below. The $comments array is then passed as an argument to the $threaded_comments object:

$sql = 'SELECT * FROM test_comments';
// submit the query and capture the result
$result = $conn->query($sql);
$comments = array();
while ($row = $result->fetch_assoc()) {
    $comments[] = $row;
}

The challenge is that nothing is printed to the screen when I run the script. Inspection of the comments array with the var_dump function is shown below:

array (size=4)
  0 => 
    array (size=3)
      'id' => string '1' (length=1)
      'parent_id' => string '0' (length=1)
      'text' => string 'comment' (length=7)
  1 => 
    array (size=3)
      'id' => string '2' (length=1)
      'parent_id' => string '0' (length=1)
      'text' => string 'comment' (length=7)
  2 => 
    array (size=3)
      'id' => string '3' (length=1)
      'parent_id' => string '1' (length=1)
      'text' => string 'comment ' (length=8)
  3 => 
    array (size=3)
      'id' => string '4' (length=1)
      'parent_id' => string '3' (length=1)
      'text' => string 'comment ' (length=8)

I was wondering if the array format from my select query is the issue? Could anyone provide a clue as to how to fix this?   Thanks.
Edited by terungwa, 11 January 2015 - 05:07 PM.