PHP Bilenler bakabilir mi r10+

Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in C:\xampp\htdocs\Yeni klasör\NXR\inc\functions\anasayfaupdate.php:99 Stack trace: #0 C:\xampp\htdocs\Yeni klasör\NXR\inc\functions\anasayfaupdate.php(99): PDOStatement->execute() #1 {main} thrown in [B]C:\xampp\htdocs\Yeni klasör\NXR\inc\functions\anasayfaupdate.php[/B] on line [B]99[/B]

<?php include "../config.php";  if(isset($_POST['anasayfaupdate'])){
      $id = $_POST['id'];
  $sliderbaslik=$_POST['sliderbaslik'];
 $sliderbaslikeng=$_POST['sliderbaslikeng'];
 $sliderlink=$_POST['sliderlink'];  
$slideraltbaslik=$_POST['slideraltbaslik'];
$slideraltbaslikeng=$_POST['slideraltbaslikeng'];
 $slideralticerik=$_POST['slideralticerik'];
 $slideralticerikeng=$_POST['slideralticerikeng'];
 $slideraltresim=$_POST['slideraltresim'];
 $sliderkutucukbasli=$_POST['sliderkutucukbasli'];
 $sliderkutucukbaslikeng1=$_POST['sliderkutucukbaslikeng1'];  
$sliderkutucukicerikeng=$_POST['sliderkutucukicerikeng'];  
$sliderkutucuklink=$_POST['sliderkutucuklink'];
 $sliderkutucukbaslik1=$_POST['sliderkutucukbaslik1'];  
$sliderkutucukbaslikeng1=$_POST['sliderkutucukbaslikeng1'];
 $sliderkutucukicerik1=$_POST['sliderkutucukicerik1'];  
$sliderkutucukicerikeng1=$_POST['sliderkutucukicerikeng1'];  
$sliderkutucuklink1=$_POST['sliderkutucuklink1'];  
$sliderkutucukbaslik2=$_POST['sliderkutucukbaslik2'];
 $sliderkutucukbaslikeng2=$_POST['sliderkutucukbaslikeng2'];  
$sliderkutucukicerik2=$_POST['sliderkutucukicerik2'];  
$sliderkutucukicerikeng2=$_POST['sliderkutucukicerikeng2'];
  $sliderkutucuklink2=$_POST['sliderkutucuklink2'];
  $sliderkutucukbaslik3=$_POST['sliderkutucukbaslik3'];
 $sliderkutucukbaslikeng3=$_POST['sliderkutucukbaslikeng3'];
 $sliderkutucukicerik3=$_POST['sliderkutucukicerik3'];
 $sliderkutucukicerikeng3=$_POST['sliderkutucukicerikeng3'];
 $sliderkutucuklink3=$_POST['sliderkutucuklink3'];  
$kutucukaltbaslik=$_POST['kutucukaltbaslik'];
 $kutucukaltbaslikeng=$_POST['kutucukaltbaslikeng'];  
$kutucukalticerik=$_POST['kutucukalticerik'];
 $kutucukalticerikeng=$_POST['kutucukalticerikeng'];  
$kutualtilink=$_POST['kutualtilink'];
 $footerustbaslik=$_POST['footerustbaslik'];  
$footerustbaslikeng=$_POST['footerustbaslikeng'];
 $footerusticerik=$_POST['footerusticerik'];
 $footerusticerikeng=$_POST['footerusticerikeng'];
 $footerustresim=$_POST['footerustresim'];
 $footerresim=$_POST['footerresim'];
 $footerbaslik=$_POST['footerbaslik'];
 $footerbaslikeng=$_POST['footerbaslikeng'];
 $footericerik=$_POST['footericerik'];
 $footericerikeng=$_POST['footericerikeng'];  
$footerlink=$_POST['footerlink'];
  $sql = "UPDATE homepage SET sliderbaslik=:sliderbaslik, sliderbaslikeng=:sliderbaslikeng, sliderlink=:sliderlink, slideraltbaslik=:slideraltbaslik, slideraltbaslikeng=:slideraltbaslikeng, slideralticerik=:slideralticerik, slideralticerikeng=:slideralticerikeng, slideraltresim=:slideraltresim, sliderkutucukbasli=:sliderkutucukbasli, sliderkutucukbaslikeng=:sliderkutucukbaslikeng, sliderkutucukicerik=:sliderkutucukicerik, sliderkutucukicerikeng=:sliderkutucukicerikeng, sliderkutucuklink=:sliderkutucuklink, sliderkutucukbaslik=:sliderkutucukbaslik, sliderkutucukbaslikeng1=:sliderkutucukbaslikeng1,sliderkutucukicerik1=:sliderkutucukicerik1, sliderkutucukicerikeng1=:sliderkutucukicerikeng1, sliderkutucuklink1=:sliderkutucuklink1, sliderkutucukbaslik2=:sliderkutucukbaslik2, sliderkutucukbaslikeng2=:sliderkutucukbaslikeng2, sliderkutucukicerik2=:sliderkutucukicerik2, sliderkutucukicerikeng2=:sliderkutucukicerikeng2, sliderkutucuklink2=:sliderkutucuklink2, sliderkutucukbaslik3=:sliderkutucukbaslik3, sliderkutucukbaslikeng3=:sliderkutucukbaslikeng3, sliderkutucukicerik3=:sliderkutucukicerik3, sliderkutucukicerikeng3=:sliderkutucukicerikeng3, sliderkutucuklink3=:sliderkutucuklink3, kutucukaltbaslik=:kutucukaltbaslik, kutucukaltbaslikeng=:kutucukaltbaslikeng, kutucukalticerik=:kutucukalticerik, kutucukalticerikeng=:kutucukalticerikeng, kutucukaltilink=:kutucukaltilink, footerustbaslik=:footerustbaslik, footerustbaslikeng=:footerustbaslikeng, footerusticerik=:footerusticerik, footerusticerikeng=:footerusticerikeng,footerustresim=:footerustresim, footerresim=:footerresim, footerbaslik=:footerbaslik, footerbaslikeng=:footerbaslikeng, footericerik=:footericerik, footericerikeng=:footericerikeng, footerlink=:footerlink WHERE id=:id";
   $query = $db->prepare($sql);            

  $query->bindparam(':id', $id);  
  $query->bindparam(':sliderbaslik', $sliderbaslik);
   $query->bindparam(':sliderbaslikeng', $sliderbaslikeng);  
  $query->bindparam(':sliderlink', $sliderlink);
   $query->bindparam(':slideraltbaslik', $slideraltbaslik);  
  $query->bindparam(':slideraltbaslikeng', $slideraltbaslikeng);
    $query->bindparam(':slideralticerik', $slideralticerik);
  $query->bindparam(':slideralticerikeng', $slideralticerikeng);  
  $query->bindparam(':slideraltresim', $slideraltresim);  
 $query->bindparam(':sliderkutucukbasli', $sliderkutucukbasli);
   $query->bindparam(':sliderkutucukbaslikeng', $sliderkutucukbaslikeng);
   $query->bindparam(':sliderkutucukicerik', $sliderkutucukicerik);
   $query->bindparam(':sliderkutucukicerikeng', $sliderkutucukicerikeng);  
  $query->bindparam(':sliderkutucuklink', $sliderkutucuklink);
   $query->bindparam(':sliderkutucukbaslik', $sliderkutucukbaslik);
   $query->bindparam(':sliderkutucukicerik1', $sliderkutucukicerik1);  
 $query->bindparam(':sliderkutucukicerikeng1', $sliderkutucukicerikeng1);
   $query->bindparam(':sliderkutucuklink1', $sliderkutucuklink1);
    $query->bindparam(':sliderkutucukbaslik2', $sliderkutucukbaslik2);
   $query->bindparam(':sliderkutucukbaslikeng2', $sliderkutucukbaslikeng2);  
  $query->bindparam(':sliderkutucukicerik2', $sliderkutucukicerik2);  
  $query->bindparam(':sliderkutucukicerikeng2', $sliderkutucukicerikeng2);  
  $query->bindparam(':sliderkutucuklink2', $sliderkutucuklink2);  
 $query->bindparam(':sliderkutucukbaslik3', $sliderkutucukbaslik3);  
  $query->bindparam(':sliderkutucukbaslikeng3', $sliderkutucukbaslikeng3);  
  $query->bindparam(':sliderkutucukicerik3', $sliderkutucukicerik3);  
 $query->bindparam(':sliderkutucukicerik3', $sliderkutucukicerik3);  
  $query->bindparam(':sliderkutucukicerikeng3', $sliderkutucukicerikeng3);
   $query->bindparam(':sliderkutucuklink3', $sliderkutucuklink3);  
  $query->bindparam(':kutucukaltbaslik', $kutucukaltbaslik);  
  $query->bindparam(':kutucukaltbaslikeng', $kutucukaltbaslikeng);
  $query->bindparam(':kutucukalticerik', $kutucukalticerik);  
 $query->bindparam(':kutucukalticerikeng', $kutucukalticerikeng);  
  $query->bindparam(':kutucukaltilink', $kutucukaltilink);  
 $query->bindparam(':footerustbaslik', $footerustbaslik);
   $query->bindparam(':footerustbaslikeng', $footerustbaslikeng);  
  $query->bindparam(':footerusticerik', $footerusticerik);  
  $query->bindparam(':footerusticerikeng', $footerusticerikeng);  
  $query->bindparam(':footerustresim', $footerustresim);
   $query->bindparam(':footerresim', $footerresim);  
 $query->bindparam(':footerbaslik', $footerbaslik);  
  $query->bindparam(':footerbaslikeng', $footerbaslikeng);
   $query->bindparam(':footericerik', $footericerik);  
  $query->bindparam(':footericerikeng', $footericerikeng);  
 $query->bindparam(':footerlink', $footerlink);      
 $query->execute();          
 header("Location: ../../anasayfa.php");
}        ?>

<?php
include "../config.php";
if(isset($_POST['anasayfaupdate'])){
    $sql = "UPDATE homepage SET ";
    foreach($_POST as $key=>$value)    {
        if($key == 'id')
            continue;
        $sql .= $key.'=:'.$key. ","
    } 
   $sql = rtrim($sql, ',');
   $sql = " WHERE id=:id";
   $query = $db->prepare($sql);
   foreach ($_POST as $key => $value) {
        $query->bindParam(':'.$key, $value);
   }
   $query->execute();
   header("Location: ../../anasayfa.php");
}