Broken RSS feed echoed from php

[torsaur]

This is my php code.

PHP Code:

<?php 
echo '<?xml version="1.0"?>';
echo '<rss version="2.0">';
echo "<channel>";
echo "<title> J10 Presents: The Sleeper </title>";
echo "<link>www.j10thesleeper.net84.net/j10sleeperhomepage.html</link>";
echo "<description> This is a description for you to decide on, Justin.</description>";
$x=0;
$connect = mysqli_connect('host','user','password','database');
$rssaudiopath = mysqli_query($connect,"select * from the_sleeper");
$numRows=mysql_num_rows($rssaudiopath);
Do
{$rssaudio=mysqli_query($connect,"select * from the_sleeper where id=$x") or die(mysqli_error());
$rssrow=mysqli_fetch_array($rssaudio);
echo "<item>";
echo "<title>". $rssrow['title'] . "</title> <link>" . $rssrow['audiopath'] . "</link> <description>" . $rssrow['description'] ."</description>";
echo "</item>";
$x++;}
while ($x<=$numRows);
echo "</channel>";
echo "</rss>";
mysqli_close($connect);
?>

This is the output I get.
http://www.j10thesleeper.net84.net/RSSfeed.php

I am trying to access the table the_sleeper in my mysql database so that it will post each of the items in the mysql database as a seperate item in the RSS feed. None of the items show up. What is wrong with my code?

Thank you for your time!

[abduraooft]

Check the HTML source of that page for

Warning</b>: mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/home/a2379928/public_html/RSSfeed.php</b> on line <b>11</b><br />

Change

$rssaudiopath = mysqli_query($connect,"select * from the_sleeper");

to

PHP Code:

$rssaudiopath = mysqli_query($connect,"select * from the_sleeper") or die(mysqli_error()); 


and see what happens

[torsaur]

I changed the code and no error appeared. The output stayed the same.

[Arcticwarrio]

try

PHP Code:


 <?php 
echo '<?xml version="1.0"?>';
echo '<rss version="2.0">';
echo "<channel>";
echo "<title> J10 Presents: The Sleeper </title>";
echo "<link>www.j10thesleeper.net84.net/j10sleeperhomepage.html</link>";
echo "<description> This is a description for you to decide on, Justin.</description>";

$connect = mysqli_connect('host','user','password','database');
$rssaudio=mysqli_query($connect,"select * from the_sleeper") or die(mysqli_error());
mysqli_close($connect);
while ($rssrow=mysqli_fetch_array($rssaudio)){
echo "<item>";
echo "<title>";
echo "<title>". $rssrow['title'] . "</title> <link>" . $rssrow['audiopath'] . "</link> <description>" . $rssrow['description'] ."</description>";
echo "</title>";
echo "</item>";
}

echo "</channel>";
echo "</rss>";

 
?>

[torsaur]

I changed the code to that and it didn't work. It got some of the content from the table, but the rss feed completely dissapeared.

[Arcticwarrio]

What did it get and what disappeared?

[Arcticwarrio]

just realised you have 2 titles in this:

Originally Posted by Arcticwarrio

try

PHP Code:


 <?php 
echo '<?xml version="1.0"?>';
echo '<rss version="2.0">';
echo "<channel>";
echo "<title> J10 Presents: The Sleeper </title>";
echo "<link>www.j10thesleeper.net84.net/j10sleeperhomepage.html</link>";
echo "<description> This is a description for you to decide on, Justin.</description>";

$connect = mysqli_connect('host','user','password','database');
$rssaudio=mysqli_query($connect,"select * from the_sleeper") or die(mysqli_error());
mysqli_close($connect);
while ($rssrow=mysqli_fetch_array($rssaudio)){
echo "<item>";
echo "<title>";
echo "<title>". $rssrow['title'] . "</title> <link>" . $rssrow['audiopath'] . "</link> <description>" . $rssrow['description'] ."</description>";
echo "</title>";
echo "</item>";
}

echo "</channel>";
echo "</rss>";

 
?>

please try:

[PHP]

PHP Code:


 <?php 
echo '<?xml version="1.0"?>';
echo '<rss version="2.0">';
echo "<channel>";
echo "<title> J10 Presents: The Sleeper </title>";
echo "<link>www.j10thesleeper.net84.net/j10sleeperhomepage.html</link>";
echo "<description> This is a description for you to decide on, Justin.</description>";

$connect = mysqli_connect('host','user','password','database');
$rssaudio=mysqli_query($connect,"select * from the_sleeper") or die(mysqli_error());
mysqli_close($connect);
while ($rssrow=mysqli_fetch_array($rssaudio)){
echo "<item>";
echo "<title>". $rssrow['title'] . "</title> <link>" . $rssrow['audiopath'] . "</link> <description>" . $rssrow['description'] ."</description>";
echo "</item>";
}

echo "</channel>";
echo "</rss>";

 
?>

[torsaur]

I realized that and a few other small errors and edited them out a bit ago. It didn't solve the issue though. It seems like a real mystery... I just can't comprehend why it's not working in the way it should. The issue seems to be the error abdura pointed out earlier.

[tracknut]

Are you sure your connect (mysqli_connect) is even working?

Dave

[torsaur]

Yes, I use the same connection statement of the homepage.

[torsaur]

I finally found out the error.
I was using the mysql_num_rows function, which is not compatible with mysqli result resources. I simply changed it to mysqli_num_rows, and the problem was solved. Thank you all for your help!

[Arcticwarrio]

post your new code, i'd like to see if theres anything else we can do to it

[torsaur]

PHP Code:

<?php 
echo '<?xml version="1.0"?>';
echo '<rss version="2.0">';
echo "<channel>";
echo "<title> J10 Presents: The Sleeper </title>";
echo "<link>www.j10thesleeper.net84.net/j10sleeperhomepage.html</link>";
echo "<description> This is a description for you to decide on, Justin.</description>";
$x=-1;
$connect = mysqli_connect('mysql3.***************','a2379928_Torsaur','hihihi111','a2379928_Sleeper');
$rssaudiopath = mysqli_query($connect,"select * from the_sleeper");
mysqli_fetch_array($rssaudiopath);
$numRows=mysqli_num_rows($rssaudiopath);
while ($x<=$numRows)
{$rssaudio=mysqli_query($connect,"select * from the_sleeper where id='$x'");
$rssrow=mysqli_fetch_array($rssaudio);
echo "<item>";
echo "<title>". $rssrow['title'] . "</title> <link>" . $rssrow['audiopath'] . "</link> <description>" . $rssrow['description'] ."</description>";
echo "</item>";
$x++;
}
echo "</channel>";
echo "</rss>";
mysqli_close($connect);
?>

[Arcticwarrio]

PHP Code:

$x=-1;
$connect = mysqli_connect('mysql3.***************','a2379928_Torsaur','hihihi111','a2379928_Sleeper');
$rssaudiopath = mysqli_query($connect,"select * from the_sleeper");
mysqli_fetch_array($rssaudiopath);
$numRows=mysqli_num_rows($rssaudiopath);
while ($x<=$numRows)
{$rssaudio=mysqli_query($connect,"select * from the_sleeper where id='$x'");
$rssrow=mysqli_fetch_array($rssaudio); 


is the same as

PHP Code:

$connect = mysqli_connect('mysql3.***************','a2379928_Torsaur','hihihi111','a2379928_Sleeper');
$rssaudiopath = mysqli_query($connect,"select * from the_sleeper");
mysqli_fetch_array($rssaudiopath);
mysqli_close($connect); 
while ($rssrow=mysqli_fetch_array($rssaudiopath){ 


[torsaur]

I don't understand how. Wouldn't that create an infinite loop since $rssrow will always equal itself? Also, how would that loop through the specific rows to post each? Thank you!