Creating webservice(XML) with php for java

Question

Am trying to write a php script that exports a database and prints out the contents as XMl. So for i have this

<?php
require('connect.php');

$query = mysql_query("SELECT * FROM blog_comments");
$database="MyWebsite";
$table = "blog_comments";
echo mysql_error();


echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?>";

echo "<$database>";
$i=0;
while($row=mysql_fetch_assoc($query))
{
    echo "<$table>";
            while ($i < mysql_num_fields($query))
            {
                $meta = mysql_fetch_field($query);
                echo "<".$meta->name.">".$row['$meta->name']."</".$meta->name."><br/>";
                $i++;
            }
            $i=0;
    echo "</$table>";
}

echo "</$database>";


?>

And my output is

<?xml version="1.0" encoding="utf-8" ?>
<MyWebsite>
<blog_comments>
    <></>
    <></>
    <></>
    <></>
    <></>
    <></>
    <></>
    <></>
</blog_comments>
<blog_comments>
    <></><></><></><></><></><></><></><></>
</blog_comments>
<blog_comments> 
    <></><></><></><></><></><></><></><></>
</blog_comments>
<blog_comments>
    <></><></><></><></><></><></><></><></>
</blog_comments>
<blog_comments>
    <></><></><></><></><></><></><></><></>
</blog_comments>
<blog_comments>
    <></><></><></><></><></><></><></><></>
</blog_comments>
<blog_comments>
    <></><></><></><></><></><></><></><></>
</blog_comments>
<MyWebsite>

The number of everything is correct but for some reason i am not getting the values printed. Am doing this because my websites host doesn't allow remote database connections and I need to connect to a database from my java application. So i want to call a php page from my java app and it would respond with xml containing my data and i then parse this XML and use the relevant data

I need help on how to make this work so i can achieve the above goal.. thanks Thanks a lot.

The number of everything is correct but for some reason i am not getting the values printed. I need to make it work so that i can use the database from my java applicaion. — DaMainBoss
– DaMainBoss, Commented Jul 9, 2011 at 18:56
Next time please include your code and output in your question. This way, potential answerers don't need to navigate to a different site to understand your question. I've taken the liberty of including the code and output here. — Mark Elliot
– Mark Elliot, Commented Jul 9, 2011 at 19:02
I tried to but it wasn't fitting properly, how did you do it? — DaMainBoss
– DaMainBoss, Commented Jul 9, 2011 at 19:05
I pasted your code into the box and made sure before every line of code there were 4 spaces and that before the entire block there was an empty line and that after the entire block there was an empty line. This amounted to indenting the first line by 4 spaces. You can always just hit the {} button. See the Editing Help for details. — Mark Elliot
– Mark Elliot, Commented Jul 9, 2011 at 19:09
Why don't you connect directly to mysql server via JDBC (java database connectivity)? — f4lco
– f4lco, Commented Jul 9, 2011 at 19:09

Mark Elliot · Accepted Answer · 2011-07-09 19:07:45Z

1

I'm not positive, but I think mysql_fetch_assoc is basically "burning" your query result, and that for the same query, you can't call it first. However, you don't need to grab all this field information if all you want is the name, just use:

echo "<{$table}>";
foreach($row as $key => $val){
    echo "<{$key}>{$val}</{$key}>";
}
echo "</{$table}>";

answered Jul 9, 2011 at 19:07

Mark Elliot

77.4k23 gold badges147 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

DaMainBoss Over a year ago

Thanks a lot man. I really do appreciate...Was really helpful

Mark Elliot Over a year ago

@DaMainBoss: On StackOverflow it's encouraged you accept the best answer for your question by clicking the checkmark next to that answer. If this solves your problem and you receive no better responses, please consider accepting it.

Collectives™ on Stack Overflow

Creating webservice(XML) with php for java

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related