Jump to content

Archived

This topic is now archived and is closed to further replies.

jmif96

fwrite error

Recommended Posts

I've created a small php script that writes info for a podcast to a database, then, when a differen't is pressed, it creates an XML file for that. I do this by opening an SML file with the w attribute. However, I always the error statement in my if/else test when I run it. I cant seem to figure out why. I've give the file 777 permissions also.

Heres the part that writes the XML:

[code]
function compilePodcastXML() {
mysqlConnect();

// open file
$xmlfile = fopen ('podcasts/podcast.xml', "w");

// select SQL records
$sql = "SELECT * FROM podcasts";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
$podcast = mysql_fetch_array($result);

// Write first, static part of XML File
$date = date("D, M d Y H:i:s O");
$xml = "<?xml version="1.0\" encoding=\"UTF-8\"?>
<rss xmlns:itunes=\"http://www.itunes.com/dtds/podcast-1.0.dtd\" version=\"2.0\">
  
  <channel>

    <title>xxx</title>
    <description>xxxdescription>
    <link>xxx</link>
    <language>en-us</language>
    <copyright>xxx</copyright>
    <lastBuildDate>$date</lastBuildDate>
    <pubDate>$date</pubDate>
    <docs>xxx</docs>
    <webMaster>xxx</webMaster>

    <itunes:author>xxx</itunes:author>
    <itunes:subtitle>xxxitunes:subtitle>
    <itunes:summary>xxx</itunes:summary>

    <itunes:owner>
           <itunes:name>xxx</itunes:name>
           <itunes:email>xxx</itunes:email>
    </itunes:owner>

    
    <itunes:category text=\"Transportation\">
         <itunes:category text=\"Podcasting\" />
    </itunes:category> "; // END STATIC XML
    
// write item statements
for ($i = 0; $i < $num; $i++) {

$xml .= "
    <item>
        <title>".$podcast['title'][$i]."</title>
        <link>".$podcast['infolink'][$i]."</link>
        <guid>".$podcast['mp3url'][$i]."</guid>
        <description>".$podcast['description'][$i]."</description>
        <enclosure url=\"".$podcast['mp3url'][$i]."\" length=\"".$podcasts['filesize'][$i]."\" type=\"audio/mp3\" />
        <category>Podcasts</category>
        <pubDate>".date("D, M d Y H:i:s O", $podcast['pubdate'][$i])."</pubDate>
        
        <itunes:author>DVA CRJ Team</itunes:author>
        
        <itunes:subtitle>".$podcast['Isubtitle'][$i]."</itunes:subtitle>
        <itunes:summary>".$podcast['Isummary'][$i]."</itunes:summary>
        <itunes:duration>".$podcast['Iduration'][$i]."</itunes:duration>
        <itunes:keywords>".$podcast['Ikeywords'][$i]."</itunes:keywords>
        
    </item>
    ";
}

// finish up xml file
$xml .= "  </channel>

</rss>";

if (fwrite ($xmlfile, $sml)) {
print ("Podcast XML file created successfully.");
$doneBy = $_SESSION['f_name'].' '.$_SESSION['l_name'];
$date = time();
$query = "INSERT INTO adminLog VALUES ('','Podcast','Publish','$doneBy','$title','$date')";
mysql_query($query);
} else {
print ("Error creating XML file.");
}

?>
[/code]


Any ideas?

Thanks!

Share this post


Link to post
Share on other sites
Well, I don't know what happens when you try to use an undefined variable as 2nd argument for fwrite, but that may be your problem:
[code]if (fwrite ($xmlfile, $sml)) { [/code]
Shouldn't it be:
[code]if (fwrite ($xmlfile, $xml)) { [/code]

?

Share this post


Link to post
Share on other sites
Yup that's correct, I hate it when I miss little things like that. However, now I have a differen't problem, when it prints the <item> tags to the xml file it dosen't print the whole string from the database. It prints this:

[code]
<item>
        <title>t</title>
        <link>h</link>
        <guid>h</guid>
        <description>t</description>
        <enclosure url="h" length="" type="audio/mp3" />
        <category>Podcasts</category>
        <pubDate>Wed, Dec 31 1969 17:00:01 -0700</pubDate>
        
        <itunes:author>DVA CRJ Team</itunes:author>
        
        <itunes:subtitle>t</itunes:subtitle>
        <itunes:summary>t</itunes:summary>
        <itunes:duration>t</itunes:duration>
        <itunes:keywords>k</itunes:keywords>
        
    </item>
[/code]

I cannot seem to find why it's only printing that. I've checked the databases and there is no problem there. Any ideas?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.