PHP Problem
Posted: Mon Dec 22, 2014 3:22 pm
Hi, I'm back with a similar problem. This is the php code to query and add names to the guestbook. It ALMOST works, but-?
<img_back>imgback</img_back>
<img_back>imgback</img_back>
Code: Select all
<?php
$link = mysql_connect('jimmybryantnet.ipagemysql.com', '*****', '*****');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysqli_select_db(guestbook);
?>
}
echo 'Connected successfully';
(mysqli_select_db(guestbook);
?>";
$server = mysql_connect('jimmybryantnet.ipagemysql.com', '****', '****');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';$user = "*****";
$password = *****";
$dataBase = "guestbook";
$conx = mysqli_connect(<?php
$link = mysql_connect('jimmybryantnet.ipagemysql.com', '*****', '****');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_select_db(guestbook);
?>$server,$user,
$password);
$db_selected = mysqli_select_db($dataBase,$conx);
if($conx && $db_selected){
$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=mysqli_escape_string(trim($_POST['message']));
$sqli="INSERT INTO guestbook(name,email,message,dateAdded)values('$name','$email','$message',now())";
$query = mysqli_query($sql,$conx);
if ($query){
$result= 1;
$sql2 = "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 .= "</guest>\n";
}
}
else{
$result=0;
}
$xml .= "<inserted>".$result."</inserted>\n";
}
if(isset($_POST['getMessage'])){
$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{
die (mysqli_error());
}
?>