I'm working on an android app ......i'm trying to insert into an online server but Im getting an error saying "Parse error:syntax error, unexpected '{' on line 44(at if(isempty)) I just want to check what fields are empty....... here is the code
<?php
$con=mysqli_connect("mysql4.000webhost.com","a9023721_Recomd","123password","a9023721_Logs") or die(mysql_error());
$db=mysqli_select_db($con,"a9023721_Logs");
$response=array();
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
if(isset($_POST['User'])&&isset($_POST['SongId'])&&isset($_POST['SongTitle'])&&isset($_POST['AlbumId'])&&isset($_POST['Album'])&&isset($_POST['TimeStamp']))
{
$User = $_POST['User'];
$SongId = $_POST['SongId'];
$SongTitle=$_POST['SongTitle'];
$AlbumId=$_POST['AlbumId'];
$Album=$_POST['Album'];
$TimeStamp=$_POST['TimeStamp'];
$result = mysqli_query($con,"INSERT INTO LogTable (User,SongId,SongTitle,AlbumId,Album,TimeStamp) VALUES ('$User', '$SongId', '$SongTitle', '$AlbumId', '$Album', '$TimeStamp')");
$row = mysqli_fetch_array($result);
$data = $row[0];
if($data){
echo $data;
}
if (mysql_affected_rows() > 0) {
// successfully updated
$response["success"] = 1;
$response["message"] = "Product successfully deleted";
// echoing JSON response
echo json_encode($response);
} else {
// no product found
$response["success"] = 0;
$response["message"] = "No product found";
// echo no users JSON
echo json_encode($response);
}
}
else {
// required field is missing
$response["success"] = 0;
if (empty($_POST['User']) {
$response["message"] = "Required field(s) User is missing";
} elseif (empty($_POST['SongId']) {
$response["message"] = "Required field(s) ID is missing";
} elseif (empty($_POST['SongTitle']) {
$response["message"] = "Required field(s) SongTitle is missing";
}
// echoing JSON response
echo json_encode($response);
}
mysqli_close($con);
?>