Solved

php usort

Posted on 2011-09-06
5
394 Views
Last Modified: 2012-05-12
I have this xml file from my YouTube account:
<?xml version="1.0"?>
<YouTubeVideos>
      <title>Video Title
            <video img="//i2.ytimg.com/vi/AhXBvK0x9fg/default.jpg" id="AhXBvK0x9fg" part="17"/>
            <video img="//i1.ytimg.com/vi/PzEdUMOBMRg/default.jpg" id="PzEdUMOBMRg" part="16"/>
            <video img="//i2.ytimg.com/vi/Q4-j5zQLr2A/default.jpg" id="Q4-j5zQLr2A" part="15"/>
                 ...
                 <video img="//i2.ytimg.com/vi/Q4-j5zQLr2A/default.jpg" id="Q4-j5zQLr2A" part="1"/>
       </title>
</YouTubeVideos>

Now I want to use usort() function to sort by part:

function sortByPart( $a, $b ){
    if ( $a[part] == $b[part] )
        return 0;
    if ( $a[part] < $b[part] )
         return -1;
    return 1;
}
            
$file = '../YouTubeVideos.xml';
$xml = simplexml_load_file($file);
if (!empty($xml->title)) {
   echo "<div id=\"div-wrap-around-a\">";
   foreach ($xml->title as $title) {
       $count = count($title);
       usort($title->video, 'sortByPart');
       foreach ( $title->video as $video ) {
             echo "<a href='#' id='{$video['id']}' title='$title Ph¿n {$video['part']}'><img src={$video['img']} width=50 align=\"absmiddle\" style=\"padding:5px\" /></a>" . " &nbsp; " .
                      "<a href='#' id='{$video['id']}' title='$title Ph¿n {$video['part']}'>".trim($title)." Ph¿n {$video['part']}</a>&nbsp;"."&nbsp;<img src=\"{$CCT_site['img_path']}videoicon.gif\" />" . "<br />";
          }
    }
    echo "</div>";
}

It's still displaying part 17 down to 1.

Thanks in advance
0
Comment
Question by:aline0508
5 Comments
 
LVL 34

Expert Comment

by:Beverley Portlock
Comment Utility
1
 
LVL 15

Accepted Solution

by:
babuno5 earned 500 total points
Comment Utility
try this

if (!empty($xml->title)) {
   echo "<div id=\"div-wrap-around-a\">";
   foreach ($xml->title as $title) {
       $count = count($title);
         $newvideo = array();
         foreach($title->video as $tmp_new)
         {
                  $newvideo[] =array('id'=>(string)$tmp_new['id'],'part'=>(int)$tmp_new['part'],'img'=>(string)$tmp_new['img']);
         }
       usort($newvideo, 'sortByPart');
       foreach ( $newvideo as $video ) {
             echo "<a href='#' id='{$video['id']}' title='$title Ph¿n {$video['part']}'><img src={$video['img']} width=50 align=\"absmiddle\" style=\"padding:5px\" /></a>" . " &nbsp; " .
                      "<a href='#' id='{$video['id']}' title='$title Ph¿n {$video['part']}'>".trim($title)." Ph¿n {$video['part']}</a>&nbsp;"."&nbsp;<img src=\"{$CCT_site['img_path']}videoicon.gif\" />" . "<br />";
          }
    }
    echo "</div>";
}
0
 
LVL 108

Expert Comment

by:Ray Paseur
Comment Utility
I am having trouble making sense of the XML string.  Install this and run it to see why.
<?php // RAY_temp_aline0508.php
error_reporting(E_ALL);
echo "<pre>";


// TEST DATA FROM THE POST AT EE
$xml = <<<XML
<?xml version="1.0"?>
<YouTubeVideos>
      <title>Video Title
            <video img="//i2.ytimg.com/vi/AhXBvK0x9fg/default.jpg" id="AhXBvK0x9fg" part="17"/>
            <video img="//i1.ytimg.com/vi/PzEdUMOBMRg/default.jpg" id="PzEdUMOBMRg" part="16"/>
            <video img="//i2.ytimg.com/vi/Q4-j5zQLr2A/default.jpg" id="Q4-j5zQLr2A" part="15"/>
            <video img="//i2.ytimg.com/vi/Q4-j5zQLr2A/default.jpg" id="Q4-j5zQLr2A" part="1"/>
       </title>
</YouTubeVideos>
XML;


// MAKE AN OBJECT
$obj = SimpleXML_Load_String($xml);

// VISUALIZE THE OBJECT
var_dump($obj);

Open in new window

0
 

Author Closing Comment

by:aline0508
Comment Utility
Thanks.
0
 
LVL 108

Expert Comment

by:Ray Paseur
Comment Utility
If you make a small modification to the XML string, you can use something like this.
http://www.laprbass.com/RAY_temp_aline0508.php
Outputs:
<video img="//i2.ytimg.com/vi/Q4-j5zQLr2A/default.jpg" id="Q4-j5zQLr2A" part="1"/>
<video img="//i2.ytimg.com/vi/Q4-j5zQLr2A/default.jpg" id="Q4-j5zQLr2A" part="15"/>
<video img="//i1.ytimg.com/vi/PzEdUMOBMRg/default.jpg" id="PzEdUMOBMRg" part="16"/>
<video img="//i2.ytimg.com/vi/AhXBvK0x9fg/default.jpg" id="AhXBvK0x9fg" part="17"/>

No usort() complexity anywhere in sight!  HTH, ~Ray
<?php // RAY_temp_aline0508.php
error_reporting(E_ALL);
echo "<pre>";


// A DERIVATIVE OF THE TEST DATA FROM THE POST AT EE
$xml = <<<XML
<?xml version="1.0"?>
<YouTubeVideos>
   <YouTubeVideo>
      <title>Video Title</title>
      <video img="//i2.ytimg.com/vi/AhXBvK0x9fg/default.jpg" id="AhXBvK0x9fg" part="17"/>
      <video img="//i1.ytimg.com/vi/PzEdUMOBMRg/default.jpg" id="PzEdUMOBMRg" part="16"/>
      <video img="//i2.ytimg.com/vi/Q4-j5zQLr2A/default.jpg" id="Q4-j5zQLr2A" part="15"/>
      <video img="//i2.ytimg.com/vi/Q4-j5zQLr2A/default.jpg" id="Q4-j5zQLr2A" part="1"/>
   </YouTubeVideo>
</YouTubeVideos>
XML;


// MAKE AN OBJECT
$obj = SimpleXML_Load_String($xml);

// ACTIVATE THIS TO VISUALIZE THE OBJECT
// var_dump($obj);

// COPY THE VIDEO IMG TAGS INTO A KEYED ARRAY
foreach ($obj->YouTubeVideo->video as $v)
{
    // CREATE A TAG AND AN ARRAY INDEX FROM THE OBJECT
    $tag = $v->AsXML();
    $ndx = (string)$v["part"];

    // USE THE PART NUMBER AS THE ARRAY INDEX KEY
    $arr[$ndx] = $tag;
}

// SORT BY THE KEYS
ksort($arr);

// SHOW THE WORK PRODUCT
foreach ($arr as $video_tag)
{
    echo PHP_EOL . htmlentities($video_tag);
}

Open in new window

0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now