I'm having trouble on the last else [closed]

Question

I'm having trouble on the last else [closed]

Navigation

#1 by (3 votes)
#2 by (0 votes)
#3 by (-1 votes)

0

        if(is_numeric($id) && $id >=1){
            $stmt = $obj_mysqli->prepare("UPDATE 'clientes' SET 'nome'=$nome, 'email'=$email, 'cidade'=$cidade, 'uf'=$uf WHERE id= $id");
            $stmt->bind_param('ssssi', $nome, $email, $cidade, $uf, $id);

            if(!$stmt->execute()){
                $erro = $stmt->error;
            }
            else{
                header("Location:cadastro.php");
                exit;
            }
            /*retorna o erro<!--O PROBLEMA ESTÁ AQUI PRA BAIXO-->
            else{
                $erro = "Número Inválido";
            }*/

php

asked by anonymous 27.07.2018 / 22:33

3 answers

Pages .aspx in View folder in ASP.MVC project How to make input content appear in the alert?

score 3 · Answer 1

You can not use 2 elses without conditions in a row.

Or you put a condition (else if ()), or close the if "parent" with a "}" before the second else:

   if(is_numeric($id) && $id >=1){
        $stmt = $obj_mysqli->prepare("UPDATE 'clientes' SET 'nome'=$nome, 'email'=$email, 'cidade'=$cidade, 'uf'=$uf WHERE id= $id");
        $stmt->bind_param('ssssi', $nome, $email, $cidade, $uf, $id);

        if(!$stmt->execute()){
            $erro = $stmt->error;
        }
        else{
            header("Location:cadastro.php");
            exit;
        }
   }
   else {
       $erro = "Número Inválido";
   }

score 0 · Answer 2

You're making a syntax error, you're missing a key shortly before the second else , like this:

if(is_numeric($id) && $id >=1){
    $stmt = $obj_mysqli->prepare("UPDATE 'clientes' SET 'nome'=$nome, 'email'=$email, 'cidade'=$cidade, 'uf'=$uf WHERE id= $id");
    $stmt->bind_param('ssssi', $nome, $email, $cidade, $uf, $id);

    if(!$stmt->execute()){
        $erro = $stmt->error;
    }
    else{
        header("Location:cadastro.php");
        exit;
    }
}
else{
    $erro = "Número Inválido";
}

score -1 · Answer 3

I tested your code in PHPTester and had the errors:

FATAL ERROR syntax error, unexpected '**' (T_POW) on line number 12
FATAL ERROR syntax error, unexpected 'else' (T_ELSE) on line number 13

FATAL ERROR syntax error, unexpected '**' (T_POW), expecting end of file on line number 15 Fixed code:

if(is_numeric($id) && $id >=1){
    $stmt = $obj_mysqli->prepare("UPDATE 'clientes' SET 'nome'=$nome, 'email'=$email, 'cidade'=$cidade, 'uf'=$uf WHERE id= $id");
    $stmt->bind_param('ssssi', $nome, $email, $cidade, $uf, $id);

    if(!$stmt->execute()){
        $erro = $stmt->error;
    }
    else{
        header("Location:cadastro.php");
        exit;
    }}
    else{
        $erro = "Número Inválido";
    }