Anyone See An Error?

[jimmyb29]

Hi,

I'm an old guy trying to create a guestbook. The xml code keeps throwing an error in the following:

<?xml version="1.0" encoding="utf-8" ?> 
<configuration>
    <img_back>img/back.jpg</img_back>
    <phpURL>/home/users/web/b2713/jpg.jimmybryantnet</phpURL>
    <alert_color>#FF0000</alert_color>
    <name_color>#8d2405</name_color>
    <message_color>#532b2b</message_color>
    <datePosted_color>#307a03</datePosted_color>
    <insert_ok><![CDATA[<font color='#0f5711'>Thanks for the message.</font>]]></insert_ok>
    <insert_error><![CDATA[<font color='#ff0000'>Error adding Message</font>]]></insert_error>
</configuration>

It throws the error: "Error Adding Message", which I assume means that it got that far.

Any help appreciated!

Jimmy

[!NoItAll]

The xml is fine. The error is being thrown by something other than the XML parser so we would need to see the rest of your code to determine what might be happening.

[jimmyb29]

I attached all the files - there isn't a lot, but I'm sure you can see the problem. Thank you so much for replying!

Jimmy

[!NoItAll]

I don't see any attachment...

[jimmyb29]

I think the error is in the Guestbook.php module:

<?php
// CONNECT TO THE SERVER AND SELECT DATABASE
$server = "<?php 
$link = mysqli_connect('jimmybryantnet.ipagemysqli.com', 'jimmyb29', 'alfiep69'); 
if (!$link) { 
    die('Could not connect: ' . mysqli_error()); 
 
echo 'Connected successfully'; 
mysqli_select_db(guestbook); 
?> ";
$user = "jimmyb29";
$password = "alfiep69";
$dataBase = "guestbook";
 
$conx = mysqli_connect($server,$user,$password);
$db_selected = mysqli_select_db($dataBase,$conx);
 
if($conx && $db_selected){
    // IF CONNECTION IS ESTABLISHED
    $xml = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n";
    $xml .= "<data>\n";
 
    if(isset($_POST['name'])){
        $result = 0;
        $name=mysql_escape_string(trim($_POST['name']));
        $email=mysql_escape_string(trim($_POST['email']));
        $message=mysql_escape_string(trim($_POST['message']));
 
        // ADD DATA TO THE TABLE guestbook WHEN THE USER PRESS THE send_btn in FLASH
        $sqli="INSERT INTO guestbook(name,email,message,dateAdded)values('$name','$email','$message',now())";
        $query = mysqli_query($sql,$conx);
        if ($query){
            $result= 1;
            $sqli2 = "SELECT * FROM guestbook ORDER BY id DESC";
            $query2 = mysqli_query($sql2,$conx);
            //WHEN query == true , GET LIST OF MESSAGES  AND PUT THEM AS XML FILE
            while($data = mysqli_fetch_array($query2)){
                $xml .= "<guest>\n";
                $xml .= "<name>".$data['name']."</name>\n";
                $xml .= "<msg><![CDATA[".$data['message']."]]></msg>\n";
                $xml .= "<sdate>".$data['dateAdded']."</sdate>\n";
                $xml .= "</guest>\n";
                }
            }
        else{
            $result=0;
            }
        $xml .= "<inserted>".$result."</inserted>\n";
 
    }    
    if(isset($_POST['getMessage'])){
            // GET LIST OF MESSAGES AND PUT THEM AS XML FILE
            $sql = "SELECT * FROM guestbook ORDER BY id DESC";
            $query = mysqli_query($sqli,$conx);
            while($data = mysql_fetch_array($query))
                $xml .= "<guest>\n";
                $xml .= "<name>".$data['name']."</name>\n";
                $xml .= "<msg><![CDATA[".$data['message']."]]></msg>\n";
                $xml .= "<sdate>".$data['dateAdded']."</sdate>\n";
                $xml .= "</guest>\n";
            }
        }
    $xml .= "</data>\n";
    echo $xml;
}
else{
    // IF CONNECTION == false OR DATABASE DOESN'T EXISTE
    die (mysqli_error());
}
?>
 

Thanks again for your expertise,

jimmyb

[jimmyb29]

OOPS! I used the wrong terminology - I didn't "attach" the files, I "included" the files in my reply. SORRY!

Jimmyb

[jimmyb29]

Sorry about the

, 

error - I'm NOT a coder, as you can probably imagine.