By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,051 Members | 1,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,051 IT Pros & Developers. It's quick & easy.

create rss xml

P: n/a
I'm currently working on creating the xml feed since I had data ready
in my database after web data extraction. However, it has errors for
this line:

<xml version="1.0" encoding="ISO-8859-1">

I was unable to solve this.

<html>
<head>
<title>MMU RSS FEED</title>
</head>
<body>

header("Content-type: application/xml");
<xml version="1.0" encoding="ISO-8859-1">

<rss version ="2.0">
<channel>
<title>MMU RSS FEED Today: <?php echo date("D, d-M-Y H:i:s")?></
title>
<link>http://bulletin.mmu.edu.my/</link>
<description>MMU RSS FEED</description>
<ttl>60<ttl>

<?php

//connect to database
$db = mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("bulletin", $db) or die(mysql_error());

$day = date("Y-n-j");

//select queries
$sql = "SELECT * FROM `bul_data` WHERE `DATE` LIKE '{$day}%' ORDER by
`DEPARTMENT`";
echo "sql=".$sql;

$res = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($res)>0)
{

while($row=mysql_fetch_assoc($res))
{
$date = $row['DATE'];
$title = $row['TITLE'];
$department = $row['DEPARTMENT'];
$link = $row['LINK'];

//output to browser

echo "<item>";
echo "<title>$title</title>";
echo "<category>$department</category>";
echo "<link><a href=\"$link\">$link</a></link>";
echo "</item>";
}

echo "</table>";

}

?>

</channel>
</rss>
</body>
</html>

Feb 4 '07 #1
Share this Question
Share on Google+
11 Replies


P: n/a
Rik
caine <th*********@gmail.comwrote:
I'm currently working on creating the xml feed since I had data ready
in my database after web data extraction. However, it has errors for
this line:

<xml version="1.0" encoding="ISO-8859-1">
<?xml .... ?>
--
Rik Wasmus
Feb 4 '07 #2

P: n/a
On Sun, 04 Feb 2007 06:41:16 -0800, Rik <lu************@hotmail.comwrote:
caine <th*********@gmail.comwrote:
>I'm currently working on creating the xml feed since I had data ready
in my database after web data extraction. However, it has errors for
this line:

<xml version="1.0" encoding="ISO-8859-1">

<?xml .... ?>
Since it's within a PHP document, you'd have to echo it, in case short
tags start trying to process the contents of the declaration:

echo '<?xml ... ?>';

--
Curtis, http://dyersweb.com
Feb 5 '07 #3

P: n/a
<?xml .... ?>
echo '<?xml ... ?>';
Both these don't work as well. I tried with <?xml version="1.0"
standalone="yes"?also failed.

I'm saving this as .php file. Or could it be problem with setting or
anything else?
Caine

Feb 5 '07 #4

P: n/a
Rik
caine <th*********@gmail.comwrote:
<?xml .... ?>
>echo '<?xml ... ?>';

Both these don't work as well. I tried with <?xml version="1.0"
standalone="yes"?also failed.

I'm saving this as .php file. Or could it be problem with setting or
anything else?
Disable short_open_tags.

--
Rik Wasmus
Feb 5 '07 #5

P: n/a
On Sun, 04 Feb 2007 23:53:57 -0800, caine <th*********@gmail.comwrote:
<?xml .... ?>
>echo '<?xml ... ?>';

Both these don't work as well. I tried with <?xml version="1.0"
standalone="yes"?also failed.

I'm saving this as .php file. Or could it be problem with setting or
anything else?
Caine
In what way is it not working? PHP error? XML parse error? If so, post the
exact error you're getting.

Also, maybe releated, on the line with "<title>", you have an echo
statement in your document that isn't terminated by a semi-colon.

--
Curtis, http://dyersweb.com
Feb 5 '07 #6

P: n/a
Caine,

Some interspaced comments. Probably not all of the errors, but it
should give you a start.

caine wrote:
I'm currently working on creating the xml feed since I had data ready
in my database after web data extraction. However, it has errors for
this line:

<xml version="1.0" encoding="ISO-8859-1">

I was unable to solve this.

<html>
<head>
<title>MMU RSS FEED</title>
</head>
<body>

header("Content-type: application/xml");
Is this supposed to be a PHP statement? If so, it won't work here.

It must be within <?php ... ?tags, and must appear before any output
(including the <htmltag, any whitespace, etc.).
>
<xml version="1.0" encoding="ISO-8859-1">
Should be <?xml ...?>.
<rss version ="2.0">
<channel>
<title>MMU RSS FEED Today: <?php echo date("D, d-M-Y H:i:s")?></
title>
Needs semicolon at the end of the PHP statement.
<link>http://bulletin.mmu.edu.my/</link>
<description>MMU RSS FEED</description>
<ttl>60<ttl>
Should be <ttl>60</ttl>
<?php

//connect to database
$db = mysql_connect("localhost", "root", "") or die(mysql_error());
VERY BAD idea to connect with "root", especially with no password.
Major security vulnerability.
mysql_select_db("bulletin", $db) or die(mysql_error());

$day = date("Y-n-j");

//select queries
$sql = "SELECT * FROM `bul_data` WHERE `DATE` LIKE '{$day}%' ORDER by
`DEPARTMENT`";
echo "sql=".$sql;

$res = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($res)>0)
{

while($row=mysql_fetch_assoc($res))
{
$date = $row['DATE'];
$title = $row['TITLE'];
$department = $row['DEPARTMENT'];
$link = $row['LINK'];

//output to browser

echo "<item>";
echo "<title>$title</title>";
echo "<category>$department</category>";
echo "<link><a href=\"$link\">$link</a></link>";
echo "</item>";
}

echo "</table>";

}

?>

</channel>
</rss>
</body>
</html>

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Feb 5 '07 #7

P: n/a
The error statement i got is :

Parse error: parse error, expecting `','' or `';'' in C:\Program Files
\xampp\htdocs\phprss.php on line 12

for this line : echo "<?xml version="1.0" standalone="yes"?>";
doesn't work.

I had updated these lines:

<?php

header ("Content-Type: text/xml; charset=iso-8859-1");
echo "<?xml version="1.0" standalone="yes"?>";

echo "<rss version ="2.0">";
echo "<channel>";
echo "<title>MMU RSS FEED Today: date("D, d-M-Y H:i:s")</title>";
echo "<link>http://bulletin.mmu.edu.my/</link>";
echo "<description>MMU RSS FEED</description>";

Feb 8 '07 #8

P: n/a
caine wrote:
The error statement i got is :

Parse error: parse error, expecting `','' or `';'' in C:\Program Files
\xampp\htdocs\phprss.php on line 12

for this line : echo "<?xml version="1.0" standalone="yes"?>";
doesn't work.
echo "<?xml version=\"1.0\" standalone=\"yes\"?>";

Or

echo '<?xml version="1.0" standalone="yes"?>'
;
I had updated these lines:

<?php

header ("Content-Type: text/xml; charset=iso-8859-1");
echo "<?xml version="1.0" standalone="yes"?>";

echo "<rss version ="2.0">";
echo "<channel>";
echo "<title>MMU RSS FEED Today: date("D, d-M-Y H:i:s")</title>";
echo "<link>http://bulletin.mmu.edu.my/</link>";
echo "<description>MMU RSS FEED</description>";

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Feb 8 '07 #9

P: n/a
echo "<?xmlversion=\"1.0\" standalone=\"yes\"?>";
>
Or

echo '<?xmlversion="1.0" standalone="yes"?>'
Not working again. Got the error statement like this:

XML Parsing Error: xml declaration not at start of external entity
Location: http://localhost/phprss.php
Line Number 7, Column 1: <?xml version="1.0" standalone="yes"?>
^

Feb 9 '07 #10

P: n/a
caine wrote:
>echo "<?xmlversion=\"1.0\" standalone=\"yes\"?>";

Or

echo '<?xmlversion="1.0" standalone="yes"?>'

Not working again. Got the error statement like this:

XML Parsing Error: xml declaration not at start of external entity
Location: http://localhost/phprss.php
Line Number 7, Column 1: <?xml version="1.0" standalone="yes"?>
^
Did you look at the error message? It says this isn't at the start. It
even tells you it's on line 7.

Check your XML spec. This must be the first thing in it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Feb 9 '07 #11

P: n/a
On Feb 9, 8:56 am, "caine" <thensiuj...@gmail.comwrote:
echo "<?xmlversion=\"1.0\" standalone=\"yes\"?>";
Or
echo '<?xmlversion="1.0" standalone="yes"?>'

Not working again. Got the error statement like this:

XML Parsing Error: xml declaration not at start of external entity
Location:http://localhost/phprss.php
Line Number 7, Column 1: <?xml version="1.0" standalone="yes"?>
^
-------------------
I will suggest these changes in your script:

First of all you will change <xml ... to <?xml ... >.
Second may be short tag will create problem.
So for above line do something like this: echo '<?xml ....>';
and you are using header() below lot of html. Use header at top or use
ob_start(); at top.
I think you do not need <html>, <head>, <title>, <body>, etc. all
above header() line. So remove all these from bottom of the file.

Feb 10 '07 #12

This discussion thread is closed

Replies have been disabled for this discussion.