include("baglanti.php"); $y_id = $_POST['id']; $action = $_POST['type']; try { $conn = new PDO("mysql:host=$hostdb; dbname=$namedb", $userdb, $passdb); $conn->exec("SET CHARACTER SET utf8"); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $veri= $conn->query("SELECT * FROM yazi WHERE y_id = '{$y_id}'")->fetch(PDO::FETCH_ASSOC); $begenme1 = $veri['begenme']; $begenmeme1 = $veri['begenmeme']; if($action=='likes') { $begenme = $begenme1 +1; $query = $conn->query("SELECT * FROM yazi WHERE y_id = '{$y_id}'")->fetch(PDO::FETCH_ASSOC); $sql = "UPDATE yazi SET begenme='$begenme' WHERE y_id='{$y_id}'"; $stmt = $conn->prepare($sql); $stmt->execute(); if ( $sql ){ echo "basarılı"; }else{ echo "işlem başarısız"; } } elseif($action=='dislikes') { $begenmeme = $begenmeme1 +1; $query = $conn->query("SELECT * FROM yazi WHERE y_id = '{$y_id}'")->fetch(PDO::FETCH_ASSOC); $sql = "UPDATE yazi SET begenmeme='$begenmeme' WHERE y_id='{$y_id}'"; $stmt = $conn->prepare($sql); $stmt->execute(); if ( $sql ){ echo "basarılı"; }else{ echo "işlem başarısız"; } } } catch(PDOException $e) { echo $statement . "<br>" . $e->getMessage(); print_r($_POST); } $conn = null;