mysql to xml

mskocabay

my xml format must be below

<?xml version="1.0" encoding="iso-8859-1"?>
<content>


<pageText><![CDATA[
<b> NEWS 1 </b>
<br><font color="#D52D00"><b><a href="asfunction:_root.more_click_func,0">° read more</a></b></font><br><br>

<b> NEWS 2 </b>
<br><font color="#D52D00"><b><a href="asfunction:_root.more_click_func,1">° read more</a></b></font><br><br>
]]>
</pageText>

<link linkType="readMoreLink">
<item name="title"><![CDATA[
news header 
]]></item>
<item name="linkText"><![CDATA[
NEWS 1
NEWS 1
NEWS 1
NEWS 1
NEWS 1
NEWS 1
NEWS 1
NEWS 1
NEWS 1


]]></item>
</link>


<link linkType="readMoreLink">
<item name="title"><![CDATA[
news header
]]></item>
<item name="linkText"><![CDATA[
NEWS 2
NEWS 2
NEWS 2
NEWS 2
NEWS 2
NEWS 2
NEWS 2
]]>
</item>
</link>
</content>

but in my mysqltoxml.php i cant do this. 🙁

my php is


<?php

$baglan=mysql_connect("localhost","deneme","123456");
$dbsec=mysql_select_db("deneme_tbb");



$sqlx="select * from news ";
$sorgux=mysql_query($sqlx);
$row=mysql_fetch_array($sorgux);
$num=mysql_num_rows($sorgux);


if ($num != 0) 
{


$file= fopen("16461_main.xml", "w");
$_xml ="<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n";
$_xml .="<content>\r\n";


for($i=0; $i<$num; $i++)
{ 

$_xml .= '<pageText><![CDATA[<font color="#8b0918"><b><font size="12">' . $row['header'] . '</font></b></font> <br><font color="#d52d00"><b><a href="asfunction:_root.more_click_func,' . ($i) . '">devami</a></b></font><br><br>]]></pageText>' . "\r\n"; 




		  $_xml .="<link linkType='readMoreLink'> \r\n";
		  $_xml .=" <item name='title'>";
		  $_xml .='<![CDATA['.$row[header].']]>';
		  $_xml .="</item>\r\n";
		  $_xml .=" <item name='linkText'>";
		  $_xml .='<![CDATA['.$row[news].']]>';
		  $_xml .="</item>\r\n";
		  $_xml .="</link> \r\n";


			  }


$_xml .="</content> \r\n";
 fwrite($file, $_xml);
 fclose($file);

}
?>

condoug

Your loop is in the wrong place. You will need to do a loop for each element (node) in your XML file.

So for your <pageText> node, have a loop which displays the contents x number of times, then break out of the loop. Then start a new loop for the <link linkType="readMoreLink"> element and so on.

bpat1434

Okay, so you have 1 <pageText> node in your example XML document. Then multiple <linkType> nodes with multiple "item" child-nodes.

Now logically think about your loops. So you need to just print out the <pageText> node since there's only one. Then you need one loop to loop through your <linkType> nodes. So you need to move this block:

$_xml .= '<pageText><![CDATA[<font color="#8b0918"><b><font size="12">' . $row['header'] . '</font></b></font> <br><font color="#d52d00"><b><a href="asfunction:_root.more_click_func,' . ($i) . '">devami</a></b></font><br><br>]]></pageText>' . "\r\n";

from inside your for() loop to just above it.

That should be about all you have to do to get this to work.

mskocabay

bpat1434 wrote:
Okay, so you have 1 <pageText> node in your example XML document. Then multiple <linkType> nodes with multiple "item" child-nodes.

Now logically think about your loops. So you need to just print out the <pageText> node since there's only one. Then you need one loop to loop through your <linkType> nodes. So you need to move this block:
$_xml .= '<pageText><![CDATA[' . $row['header'] . ' <a href="asfunction:_root.more_click_func,' . ($i) . '">devami</a> ]]></pageText>' . "\r\n";
from inside your for() loop to just above it.

That should be about all you have to do to get this to work.

if i remove this code how can i take $row['header'] ?
i need to header one is for news subject (short) other is for long news in flash

bpat1434

you're not removing it, just moving it above the loop... but below the $row = mysql_fetch_assoc() call....

<?php

$baglan=mysql_connect("localhost","deneme","123456");
$dbsec=mysql_select_db("deneme_tbb");

$sqlx="select * from news ";
$sorgux=mysql_query($sqlx);
$row=mysql_fetch_array($sorgux);
$num=mysql_num_rows($sorgux);

if ($num != 0)
{
	$file= fopen("16461_main.xml", "w");
	$_xml ='<?xml version="1.0" encoding="UTF-8" ?>
<content>
	<pageText><![CDATA[<font color="#8b0918"><b><font size="12">' . $row['header'] . '</font></b></font> <br><font color="#d52d00"><b><a href="asfunction:_root.more_click_func,' . ($i) . '">devami</a></b></font><br><br>]]></pageText>';

for($i=0; $i<$num; $i++)
{
	$_xml ='
<link linkType="readMoreLink">
	<item name="title"><![CDATA['.$row[header].']]></item>
	<item name="linkText"><![CDATA['.$row[news].']]></item>
</link>'; 
}

$_xml .='
</content>';

fwrite($file, $_xml);
fclose($file);
}

?>

mskocabay

but my xml format is below


<pageText><![CDATA[
<b> NEWS 1 ( [COLOR="Red"]$header form mysql[/COLOR] )</b>
<br><font color="#D52D00"><b><a href="asfunction:_root.more_click_func,0">° read more</a></b></font><br><br>

<b> NEWS 2 ([COLOR="red"]$header form mysql [/COLOR])</b>
<br><font color="#D52D00"><b><a href="asfunction:_root.more_click_func,1">° read more</a></b></font><br><br>
]]>
</pageText>

<link linkType="readMoreLink">
<item name="title"><![CDATA[
NEWS 1 ( [COLOR="Red"]$header form mysql[/COLOR] )
]]></item>
<item name="linkText"><![CDATA[
NEWS 1
NEWS 1
NEWS 1
NEWS 1
NEWS 1
NEWS 1
NEWS 1
NEWS 1
NEWS 1


]]></item>
</link>


<link linkType="readMoreLink">
<item name="title"><![CDATA[
NEWS 2 ( [COLOR="Red"]$header form mysql[/COLOR] ]]></item>
<item name="linkText"><![CDATA[
NEWS 2
NEWS 2
NEWS 2
NEWS 2
NEWS 2
NEWS 2
NEWS 2
]]>
</item>
</link>

if i will remove from loop i will take just first header
my flash page is

news

header

read more link -> cilick then in other page

header1

news 1

bpat1434

Okay, then you need to redo your entire looping structure... right now, you'll only ever have 1 row shown because you're not looping through the mySQL result set.

Here's some basic code to help you out:

<?php

$baglan=mysql_connect("localhost","deneme","123456");
$dbsec=mysql_select_db("deneme_tbb");

$query = "SELECT * FROM `news`";
$result = mysql_query($query) or die('MySQL Error: ' . mysql_error());
$i=0;
$k=1;
$links = $pageText = '';

$xml = '<?xml version="1.0" encoding="utf-8"?>
<content>
    <pageText><![CDATA[';

while($row = mysql_fetch_assoc($result))
{
    $pageText .= '
        <b> NEWS ' . $k . ' (' . $row['header'] . ')</b>
        <br><font color="#d52d00"><b><a href="asfunction:_root.more_click_func,' . $i . '">° read more</a></b></font><br><br>';

$links .= '<link linkType="readMoreLink">
<item name="title"><![CDATA[NEWS ' . $k . ' (' . $row['header'] . ')]]></item>
<item name="linkText"><![CDATA[NEWS ' . $k . ']]></item>
</link>';

$k++;
$i++;
}

$xml .= $pageText . ']]></pageText>' . $links . '
</content>';

fwrite($file, $_xml);
fclose($file);

?>