-3

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);
?>
Blackbelt
  • 156,034
  • 29
  • 297
  • 305

2 Answers2

2

The error is showing, because you don't end your empty() functions:

if (empty($_POST['User']))
                         ^---- missing bracket here!

Here is edited part of your code:

// 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";
}
pes502
  • 1,597
  • 3
  • 17
  • 32
2

Change your else block code with following.

you have missed to close empty on every if condition

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";
}
Amy
  • 4,034
  • 1
  • 20
  • 34