Hi,
I’m having a problem with some PHP code for a guestbook. Here’s the code:
[php]<?php
// CONNECT TO THE SERVER AND SELECT DATABASE
$server = ’ <?php
$link = mysqli_connect( <?php
$link = mysqli_connect(‘jimmybryantnet.ipagemysqli.com’, ‘xxxxx’, ‘xxxx’);
if (!$link) {
die('Could not connect: ’ . mysqli_error());
}
echo ‘Connected successfully’;
mysqli_select_db(guestbook);
?> );
if (!$link) { die('Could not connect: ’ . mysqli_error());
echo ‘Connected successfully’;
mysqli_select_db(guestbook);
?> ';
$user = ‘jimmyb29’;
$password = ‘********’;
$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 .= “\n”;
if(isset($_POST['name'])){
$result = 0;
$name=mysqli_escape_string(trim($_POST['name']));
$email=mysqli_escape_string(trim($_POST['email']));
$message=mysqil_escape_string(trim($_POST['message']));
// ADD DATA TO THE TABLE guestbook WHEN THE USER PRESS THE send_btn in FLASH
$sql="INSERT INTO guestbook(name,email,message,dateAdded)values('$name','$email','$message',now())";
$query = mysqil_query($sql,$conx);
if ($query){
$result= 1;
$sql2 = "SELECT * FROM guestbook ORDER BY id DESC";
$query2 = mysql_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($sql,$conx);
while($data = mysqli_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());
}
?>[/php]
I keep getting a T_STRING error on line 5. Anyone see the problem? Thanks VERY much!
Jimmyb