jimmyb29

This seems to be the culprit now; It's the Guestbook code: I get an error message that says there's an unexpected T_String error in line 5. <?php // CONNECT TO THE SERVER AND SELECT DATABASE $server = ' < $link = mysqli_connect( <?php $link = mysqli_connect('jimmybryantnet.ipagemysqli.com', 'jimmyb29', '*******'); 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 = '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=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; } Thanks!

Hi, mac_gyver, I finally found my way back with the info you requested about the T_STRING error. Here s the code from the affected area: <?php // CONNECT TO THE SERVER AND SELECT DATABASE $server = ' <?php $link = mysqli_connect( <?php $link = mysqli_connect(*****', '****', '****'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; It's on line 5. Thanks, Jimmyb

Hi, again, I'm still working on my Guestbook, and finally realized that the code is antiquated! I'm now trying it with PDO_Mysqli. I get an error: Unexpected T_String in/hermes/bosnaweb o4ay/62713/ipg.jimmybryant.net/Guestbook.php. I don't recognize anything; anyone see the problem? Thanks MUCH, Jimmy

Hi, I sent a post yesterday, but included the wrong code! Here's the problem: <?xml version="1.0" encoding="utf-8" ?> <configuration> <phpURL>/home/users/web/b2713/ipg.jimmybryantnet?> <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> The error message says: mismatch error line 11, Col 17. Please help. Jimmy

I'm getting an error with this code: <?php // CONNECT TO THE SERVER AND SELECT DATABASE $server = "/home/users/web/b2713/ipg.jimmybryantnet"; $user = "jimmyb29"; $password = "alfiep69"; $dataBase = "guestbook"; $conx = mysql_connect($server,$user,$password); $db_selected = mysql_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 $sql="INSERT INTO guestbook(name,email,message,dateAdded)values('$name','$email','$message',now())"; $query = mysql_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 = mysql_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 = mysql_query($sql,$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 (mysql_error()); } ?> The error message says, "error in line 10, character 17". I don't understand Thanks! Jimmy

Hi, Thanks for the reply! I'm using the MYsql - PHP Admin server on ipage to create the database,.I assumed that was why the ftp address was there (this was given in the code I bought.) I actually have a server on my computer - should I build the DB with that? I'm over my head with this - I assumed the code was correct when I bought the program - was I wrong? Jimmyb29

Hi! I'm an 85 year old newbie, trying to implement a "store bought" Guestbook. I seem to be having a problem with the module that connects the DB to the .flv (I think!) I've checked it with several online checkers and they don't report any errors/ Would someone be so kind as to look at the code and see id you can find the errors? THANKS! <?php // CONNECT TO THE SERVER AND SELECT DATABASE $server = "ftp.ipage.com"; $user = "jimmybryantnet"; $password = "********"; $dataBase = "guestbook"; $conx = mysql_connect($server,$user,$password); $db_selected = mysql_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 $sql="INSERT INTO guestbook(name,email,message,dateAdded)values('$name','$email','$message',now())"; $query = mysql_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 = mysql_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 = mysql_query($sql,$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 (mysql_error()); } ?>