[RESOLVED] assigning variable within pathinfo??

robertjm

Hi all,

I have a section of code where I'm trying to parse out a part of the path of a remote file. This is working now if I assign a fixed file/path within the pathinfo.

Below is the working code. I am trying to pull the Luke out of the directory structure. If I run the code below it works, but as you can see I'm hard coding then pathinfo() value into $path1, as opposed to passing a variable that's assigned by $path['dirname'];

Ultimately I would like to be assign a variable within the pathinfo() of $path too, because I'm working with an xml file of a podcast RSS feed, which I'm trying to pull info out into a MySQL database. One of the columns I want to use will have its value assigned by that directory name.

Can this be done, or do I have to go about it in a different way?

Thanks!!

Robert

<?php
$path = pathinfo('http://www.recastweb.com/media/Luke/Luke14_01-14.mp3');

echo $path['dirname'], "\n <br />";
echo $path['basename'], "\n <br />";
echo $path['extension'], "\n <br />";
echo $path['filename'], "\n <br />";


$string=$path['dirname'];
strlen($string);
echo strlen($string), "\n <br />";
echo $string, "\n <br />";

$path1 = pathinfo('http://www.recastweb.com/media/Luke');
echo $path1['basename'], "\n <br />";
?>

bradgrafelman

EDIT: Welcome to PHPBuilder!

When posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

I'm confused with what it is you're asking about... You've already got 'http://www.recastweb.com/media/Luke' in $path['dirname'] from the first [man]pathinfo/man.

robertjm wrote:
but as you can see I'm hard coding then pathinfo() value into $path1, as opposed to passing a variable that's assigned by $path['dirname'];

Yes, I do see that; why are you doing the former if you actually want the latter?

robertjm

Thanks for the quick reply, and sorry about the posting error. Will remember that for the furture.

What I am trying to ultimately get is just the "Luke" folder name out of the "http://www.recastweb.com/media/Luke"

I couldn't find a way to cut to the chase, and that's why I did the double level. First getting the dirname, and then parsing the Luke part out of the first dirname.

I cannot do something with strlen because I have multiple folder names to get. Not just Luke.

Thanks again!

Robert

bradgrafelman

So in other words, you're just interested in the name of the parent "directory" (and I say "directory" since URL paths have nothing to do with the file system or any directories on it)?

If so, then it sounds like you simply want the [man]basename/man of the [man]dirname/man of the path (URL) to the file.

robertjm

The basename of the dirname would be correct..

As for the other statement, to me, the parent directory would be the URL itself, which is / on my server (root level). Then there's a sudbirectory of media, which contains subdirectories of the different podcast mp3 files. In this case Luke.

Robert

bradgrafelman;10996077 wrote:
So in other words, you're just interested in the name of the parent "directory" (and I say "directory" since URL paths have nothing to do with the file system or any directories on it)?

If so, then it sounds like you simply want the [man]basename/man of the [man]dirname/man of the path (URL) to the file.

robertjm

OK, so I was able to get the result that I was looking for. However, when I went to implement it on the final page, I'm having a problem. Instead of returning the folder name, it is returning the word "array."

The working code below returns:

http://www.recastgweb.com/media/Luke
Luke


<?php

$entry = 'http://www.recastgweb.com/media/Luke/Luke14_01-14.mp3';
$path = pathinfo($entry);

echo $path['dirname'], "\n <br />";
echo $path['basename'], "\n <br />";
echo $path['extension'], "\n <br />";
echo $path['filename'], "\n <br />";


$string=$path['dirname'];
echo $string, "\n <br />";

$path1 = pathinfo($string);
 echo $path1['basename'], "\n <br />";
?>

When I apply that to my final code I get this returned:

=============== ITEM DATA ==============
Title: Luke: Amongst the Highways and Hedges (01/29/12)
Description: Pastor Albert Lee teaches from Luke 14:15-24
Link: http://www.recastweb.com/media/Luke/Luke14_15-24.mp3
GUID: 67BEFCBA-A0F2-4B1F-997A-92824DF3E6AF
Folder: Array
Enclosure URL: http://www.recastweb.com/media/Luke/Luke14_15-24.mp3
Enclosure Size: 22512965
Enclsoure Type: audio/mpeg
PubDate: Tue, 31 Jan 2012 17:26:53
pubZoneOffset: -0800

=============== ITUNES DATA ==============
author: Albert Lee @ Regeneration
keywords: regeneration, Albert Lee, Holy Bible, New Testiment, Jesus, Gospel, Luke
duration: 53:02
subtitle: Luke: Amongst the Highways and Hedges (01/29/12)
summary: Pastor Albert Lee teaches from Luke 14:15-24
isClosedCaptioned: no

blockEpisode: no

Episodes were added.

Here is the implementation:



<html>
<head>
<title>Tag Parser</title>

<!-- <form name="configform" action="parser.php?action=saveconfig" method="POST">
<fieldset style="width: 650px;">
<legend>Results</legend>
-->
<?php

$myFile = '
      <item>
      <title>Luke: Amongst the Highways and Hedges (01/29/12)</title>
      <link>http://www.recastweb.com/media/Luke/Luke14_15-24.mp3</link>
      <description>Pastor Albert Lee teaches from Luke 14:15-24</description>
      <pubDate>Tue, 31 Jan 2012 17:26:53 -0800</pubDate>
      <guid isPermaLink="false">67BEFCBA-A0F2-4B1F-997A-92824DF3E6AF</guid>
      <enclosure url="http://www.recastweb.com/media/Luke/Luke14_15-24.mp3" length="22512965" type="audio/mpeg" />
      <itunes:author>Albert Lee @ Regeneration</itunes:author>
      <itunes:image href="http://www.recastweb.com/images/GospelOfLuke300.png" />
      <itunes:keywords>regeneration, Albert Lee, Holy Bible, New Testiment, Jesus, Gospel, Luke</itunes:keywords>
      <itunes:duration>53:02</itunes:duration>
      <itunes:subtitle>Luke: Amongst the Highways and Hedges (01/29/12)</itunes:subtitle>
      <itunes:summary>Pastor Albert Lee teaches from Luke 14:15-24</itunes:summary>
    </item>';


$fh = fopen($myFile, 'r');
$theData = fread($fh, filesize($myFile));
fclose($fh);

$strCode = $myFile;

if (preg_match_all('%<item>.*?</item>%si',$strCode,$regs)) {
        $aryItems = $regs[0];
        foreach($aryItems as $strItem) {
		$strTitle = '';                

		$strDescription = '';
		$entry = '';
        	$strLink = '';
		$strGUID = '';
		$strEnclosureURL = '';
		$intEnclosureLength = '';
		$strEnclosureType = '';
        	$strPubDate = '';
		$strpubZoneOffset = '';
		$strblockEpisode = 'no';
		$strisClosedCaptioned ='no';
			$aryItuneData = array();

            if (preg_match('%<title>(.*?)</title>%si',$strItem,$regs)) {
                    $strTitle = $regs[1];
            }
            if (preg_match('%<description>(.*?)</description>%si',$strItem,$regs)) {
                    $strDescription = $regs[1];
            }

	if (preg_match('%<link>(.*?)</link>%si',$strItem,$regs)) {
                    $entry = $regs[1];
		$path = pathinfo($entry);
		$string=$path['dirname'];
		$folder = pathinfo($string);
//			$folder = pathinfo($folderB);
                }

            if (preg_match('%<link>(.*?)</link>%si',$strItem,$regs)) {
                    $strLink = $regs[1];
            }
            if (preg_match('%<guid isPermaLink=\"false\">(.*?)</guid>%si',$strItem,$regs)) {
                    $strGUID = $regs[1];
            }
            if (preg_match('%<pubDate>(.*?)</pubDate>%si',$strItem,$regs)) {
                    $strPubDate = date('D, d M Y H:i:s',strtotime($regs[1]));
            }
            if (preg_match('%<pubDate>(.*?)</pubDate>%si',$strItem,$regs)) {
                    $strpubZoneOffset = date('O',strtotime($regs[1]));
            }





//				if (preg_match('%<enclosure url="([^"]*?)" length="([^"]*?)" type="([^"]*?)".*?</enclosure>.%si',$strItem,$regs)) //use for </enclosure>
//				{
				if (preg_match('%<enclosure url="([^"]*?)" length="([^"]*?)" type="([^"]*?)".*?/>.%si',$strItem,$regs)) //use for />
				{

		 		$strEnclosureURL = $regs[1];
				$intEnclosureLength = (int)$regs[2];
				$strEnclosureType = $regs[3];
			}

            if (preg_match_all('%<itunes:([^>]+)>(.*?)</itunes:\1>%si',$strItem,$regs)) {
                    foreach($regs[2] as $index=>$val) {
                            $aryItuneData[$regs[1][$index]] = $val;
                    }}



            echo "\n=============== ITEM DATA ==============\n <br />";
            echo "Title: $strTitle\n <br />";
	echo "Description: $strDescription\n <br />";
            echo "Link: $strLink\n <br />";
	echo "GUID: $strGUID\n <br />";
	echo "Folder: $folder\n <br />";
	echo "Enclosure URL: $strEnclosureURL\n <br />";
	echo "Enclosure Size: $intEnclosureLength\n <br />";
	echo "Enclsoure Type: $strEnclosureType\n <br />"; 
            echo "PubDate: $strPubDate\n <br />";
	echo "pubZoneOffset: $strpubZoneOffset\n <br />";
	echo "<br />";
            echo "\n=============== ITUNES DATA ==============\n <br />";

            foreach($aryItuneData as $key=>$val) 
                    echo "\t$key: $val\n <br />";{
		echo "isClosedCaptioned: $strisClosedCaptioned\n <br />";
		echo "blockEpisode: $strblockEpisode\n <br />";}
		echo "------------------------------------------------------\n <br />";


$emptyExplicit = 'no';
$con = mysql_connect("localhost","user","password");

mysql_select_db("podadmin", $con);

// insertion into episodes table

$query = "INSERT INTO import (guid, title, subtitle, keywords, explicit, isClosedCaptioned, author, description, pubdate, pubZoneOffset, blockEpisode, size, duration, folder, filename)";
$query .= "VALUES (";
$query .= "'" . mysql_real_escape_string(basename($strGUID)) . "', " .
      "'" . mysql_real_escape_string($strTitle) . "', " .
          "'" . mysql_real_escape_string($aryItuneData['subtitle'])  . "', " .
      "'" . mysql_real_escape_string($aryItuneData['keywords'])  . "', " .
      "'" . mysql_real_escape_string($emptyExplicit)  . "', " .
      "'" . mysql_real_escape_string($strisClosedCaptioned)  . "', " .
          "'" . mysql_real_escape_string($aryItuneData['author'])  . "', " .
      "'" . mysql_real_escape_string($strDescription)  . "', " .
          "FROM_UNIXTIME('" . strtotime(mysql_real_escape_string($strPubDate))  . "'), " .
          "'" . mysql_real_escape_string($strpubZoneOffset)  . "', " .
          "'" . mysql_real_escape_string($strblockEpisode)  . "', " .
          "'" . mysql_real_escape_string($intEnclosureLength)  . "', " .
          "'" . mysql_real_escape_string($aryItuneData['duration'])  . "', " .
          "'" . mysql_real_escape_string(basename($folder))  . "', " .
          "'" . mysql_real_escape_string(basename($strLink)) . "')";


if ( ! mysql_query($query) ) {
  exit("Query failed! - $query<Br>" . mysql_error());
}




// CHECKING FOR DUPLICATE GUID ENTRIES IN XML FILE

$emptyExplicit = 'no';
$con = mysql_connect("localhost","user","password");

mysql_select_db("podadmin", $con);

// insertion into guid table

$query = "INSERT INTO guid (guid, filename) ";
$query .= "VALUES (";
$query .= "'" . mysql_real_escape_string(basename($strGUID)) . "', " .
          "'" . mysql_real_escape_string(basename($strLink)) . "')";

if ( ! mysql_query($query) ) {
  exit("Query failed! - $query<Br>" . mysql_error());


 }
}

}

print "<p style='color: green'>Episodes were added.</p>\n";



mysql_close($con);

?>

</html>

To my eyes I'm not seeing a difference regarding getting the Folder to return Luke, rather than array. If I simply assign $folder = $path['dirname']; then it prints out
http://www.recastweb.com/media/Luke

Thanks for looking,

Robert

Weedpacket

As well as the functions bradgrafelman mentions, you might also look at [man]parse_url[/man].

Also, since you're reading XML, you might find it more straightforward to use the [man]DOM[/man] XML functions.

robertjm

Awesome! I ended up using parse_url in combination with
pathinfo to create a custom function which returns the value I wanted.

return_value.php


<?php

function getDirName() {
$entry = 'http://www.recastweb.com/media/Luke/Luke14_01-14.mp3';
$path = pathinfo($entry);


$url=$path['dirname'];

$folder = parse_url($url, PHP_URL_PATH);
$entry1 = $folder;
$path1 = pathinfo($entry1);

echo $path1['basename'], "\n <br />";
}
$xyz = getDirName();
print_r($xyz);
?>

This returns:

Luke

However, I'm still having problems passing that returned value into my other script.

Here's the swatch of my bigger script that I'm using to assign the value of "Luke" to $abc, which is then used to fill an entry into a MySQL database.

parsingtext.php (part of)

	if (preg_match('%<link>(.*?)</link>%si',$strItem,$regs))
           {
		include("return_value.php");
		$abc = $xyz;
			 }

Nothing stuffed into the database value (the "folder" entry in the data returned):

Luke
Luke
=============== ITEM DATA ==============
Title: Luke: Amongst the Highways and Hedges (01/29/12)
Description: Pastor Albert Lee teaches from Luke 14:15-24
Link: http://www.recastweb.com/media/Luke/Luke14_15-24.mp3
GUID: 67BEFCBA-A0F2-4B1F-997A-92824DF3E6AF
Folder:
Enclosure URL: http://www.recastweb.com/media/Luke/Luke14_15-24.mp3
Enclosure Size: 22512965
Enclsoure Type: audio/mpeg
PubDate: Tue, 31 Jan 2012 17:26:53
pubZoneOffset: -0800

=============== ITUNES DATA ==============
author: Albert Lee @ Regeneration
keywords: regeneration, Albert Lee, Holy Bible, New Testiment, Jesus, Gospel, Luke
duration: 53:02
subtitle: Luke: Amongst the Highways and Hedges (01/29/12)
summary: Pastor Albert Lee teaches from Luke 14:15-24
isClosedCaptioned: no

blockEpisode: no

Episodes were added.

I know the two Luke at the top are coming from the print_r and echo statements within the function. I added those to make sure my function is working.

I'm sure it's something simple, but I'm not seeing it.

Thanks again!

Robert

Weedpacket;10996185 wrote:
As well as the functions bradgrafelman mentions, you might also look at [man]parse_url[/man]....

Derokorian

you never return the value within the function.

function foo() {
   return 'bar';
}
function bar() {
   echo 'foo';
}

$a = foo(); // no output on this line
echo $a; // outputs 'bar'

$b = bar(); // outputs foo on this line
echo $b;  // does nothing, because $b is not set to anything because bar does not have a returned value

Actually depending on your error settings that last line might give you a notice..

HTH

robertjm

Thanks everyone for your help. I finally got the value to post into my database properly.

Here's a copy of the final return_value.php for anyone that might look at this in the future:


<?php

function getDirName() {
$entry = 'http://www.recastweb.com/media/Luke/Luke14_01-14.mp3';
$path = pathinfo($entry);

$url=$path['dirname'];

$folder = parse_url($url, PHP_URL_PATH);


$entry1 = $folder;
$path1 = pathinfo($entry1);

return $path1['basename'];
}
$xyz = getDirName();
?>

And here's where I'm using the data:

				if (preg_match('%<link>(.*?)</link>%si',$strItem,$regs)) {
						$bcd = $regs[1];
						include("return_value.php");
						$abc = $xyz;
			 }

Now I've got to figure out why using this broke my bigger script that loops through the 195 podcast sermons I'm trying to extract from an XML file and insert into MySQL. But that's a different problem so I'll mark this one as resolved.