Salve ragazzi ho creato una pagina in php per modificare i dati caricati in un database mysql.
Non riesco tuttavia a modificarli.... dove sbaglio secondo voi?
l'id della mia Tabella è ID_Clienti, però inserindolo non va...

Ecco il codice php

Codice PHP:

<?php 

    
    
    require 'database.php';

    $id = null;
    if ( !empty($_GET['id'])) {
        $id = $_REQUEST['id'];
    }
    
    if ( null==$id ) {
        header("Location: index.php");
    }
    
    if ( !empty($_POST)) {
        // keep track validation errors
        $clienteError = null;
        $indirizzoError = null;
        $cittaError = null;
        $capError = null;
        $telefonoError = null;
        $emailError = null;
        
        // keep track post values
        $cliente = $_POST['cliente'];
        $email = $_POST['email'];
        $indirizzo = $_POST['indirizzo'];
        $citta = $_POST['citta'];
        $cap = $_POST['cap'];
        $telefono = $_POST['telefono'];
        
        // validate input
        $valid = true;
        if (empty($cliente)) {
            $clienteError = 'Inserire il Nome';
            $valid = false;
        }
        
                
        if (empty($indirizzo)) {
            $indirizzoError = 'Inserire Indirizzo';
            $valid = false;
        }
        
        if (empty($citta)) {
            $cittaError = 'Inserire la Città';
            $valid = false;
        }
        
        if (empty($cap)) {
            $capError = 'Inserire il Cap';
            $valid = false;
        }
        if (empty($telefono)) {
            $telefonoError = 'Inserire il Telefono';
            $valid = false;
        }
        
        if (empty($email)) {
            $emailError = 'Inserire Indirizzo Email';
            $valid = false;
        } else if ( !filter_var($email,FILTER_VALIDATE_EMAIL) ) {
            $emailError = 'Inserire Indirizzo Email';
            $valid = false;
        }

        // update data
        if ($valid) {
            $pdo = Database::connect();
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $sql = "UPDATE customers  set cliente = ?, indirizzo = ?, citta = ?, cap = ?, telefono = ?, email =? WHERE id_cliente = ?";
            $q = $pdo->prepare($sql);
            $q->execute(array($cliente,$indirizzo,$citta,$cap,$telefono,$email,$id_cliente));
            Database::disconnect();
            header("Location: index.php");
        }
    } else {
        $pdo = Database::connect();
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $sql = "SELECT * FROM customers where id_cliente = ?";
        $q = $pdo->prepare($sql);
        $q->execute(array($id));
        $data = $q->fetch(PDO::FETCH_ASSOC);
        $cliente = $data['cliente'];
        $indirizzo = $data['indirizzo'];
        $citta = $data['citta'];
        $cap = $data['cap'];
        $telefono = $data['telefono'];
        $email = $data['email'];
        Database::disconnect();
    }
?>


<!DOCTYPE html>
<html lang="it">
<head>
    <meta charset="utf-8">
    <link   href="css/bootstrap.min.css" rel="stylesheet">
    <script src="js/bootstrap.min.js"></script>
</head>

<body>
    <div class="container">
    
                <div class="span10 offset1">
                    <div class="row">
                        <h3>Aggiornamento</h3>
                    </div>
            
                    <form class="form-horizontal" action="update.php?id=<?php echo $id?>" method="post">
                      <div class="control-group <?php echo !empty($clienteError)?'error':'';?>">
                        <label class="control-label">Cliente</label>
                        <div class="controls">
                              <input name="cliente" type="text"  placeholder="Cliente" value="<?php echo !empty($cliente)?$cliente:'';?>">
                              <?php if (!empty($clienteError)): ?>
                                  <span class="help-inline"><?php echo $clienteError;?></span>
                              <?php endif; ?>
                        </div>
                      </div>
                      
                      
                      
                      <div class="control-group <?php echo !empty($indirizzoError)?'error':'';?>">
                        <label class="control-label">Indirizzo</label>
                        <div class="controls">
                              <input name="indirizzo" type="text"  placeholder="Indirizzo" value="<?php echo !empty($indirizzo)?$indirizzo:'';?>">
                              <?php if (!empty($indirizzoError)): ?>
                                  <span class="help-inline"><?php echo $indirizzoError;?></span>
                              <?php endif; ?>

                       </div>
                      </div>
                      
                      <div class="control-group <?php echo !empty($cittaError)?'error':'';?>">
                        <label class="control-label">Città</label>
                        <div class="controls">
                              <input name="citta" type="text"  placeholder="Citta" value="<?php echo !empty($citta)?$citta:'';?>">
                              <?php if (!empty($cittaError)): ?>
                                  <span class="help-inline"><?php echo $cittaError;?></span>
                              <?php endif; ?>

                       </div>
                      </div>
                      
                      <div class="control-group <?php echo !empty($capError)?'error':'';?>">
                        <label class="control-label">Cap</label>
                        <div class="controls">
                              <input name="cap" type="text"  placeholder="Cap" value="<?php echo !empty($cap)?$cap:'';?>">
                              <?php if (!empty($capError)): ?>
                                  <span class="help-inline"><?php echo $capError;?></span>
                              <?php endif; ?>

                       </div>
                      </div>
                      
                      <div class="control-group <?php echo !empty($telefonoError)?'error':'';?>">
                        <label class="control-label">Telefono</label>
                        <div class="controls">
                              <input name="telefono" type="text"  placeholder="Telefono" value="<?php echo !empty($telefono)?$telefono:'';?>">
                              <?php if (!empty($telefonoError)): ?>
                                  <span class="help-inline"><?php echo $telefonoError;?></span>
                              <?php endif; ?>

                      
                       </div>
                      </div>
                      <div class="control-group <?php echo !empty($emailError)?'error':'';?>">
                        <label class="control-label">Indirizzo Email</label>
                        <div class="controls">
                              <input name="email" type="text" placeholder="Indirizzo Email" value="<?php echo !empty($email)?$email:'';?>">
                              <?php if (!empty($emailError)): ?>
                                  <span class="help-inline"><?php echo $emailError;?></span>
                              <?php endif;?>
                        
                     
                        </div>
                      </div>
                      <div class="form-actions">
                          <button type="submit" class="btn btn-success">Modifica</button>
                          <a class="btn" href="index.php">Torna alla Home</a>
                        </div>
                    </form>
                </div>
                
    </div> <!-- /container -->
  </body>
</html>