<?php

//DB-varaibles
$dsn = "mysql:dbname=dbirkemalm_com;host=dbirkemalm.com.mysql;";
$username = "dbirkemalm_com";
$password ="8ejxQ4Pn";
$db_name = "dbirkemalm_com";
$vote_table = 'votes';

//Variables
$ip = $_SERVER['REMOTE_ADDR'];
$vote = $_GET['id'];

//Connect to DB
try {
    $dbh = new PDO($dsn, $username, $password);
    }   catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

//IP-query
$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );

/*$ipsql = "SELECT COUNT(*) FROM $ip_table WHERE ip = :ip";
$ipq = $dbh->prepare($ipsql);
$ipq->bindParam(':ip', $ip, PDO::PARAM_STR);
$ipq->execute();
$ipq->setFetchMode(PDO::FETCH_NUM);*/


    //Insert vote and IP
    $ipinsql = "INSERT INTO $vote_table (ip, vote) VALUES(:ip, :vote)";
    $ipinsq = $dbh->prepare($ipinsql);
    $ipinsq->bindParams(':ip', $ip, PDO::PARAM_STR);
    $ipinsq->bindParams(':vote', $vote, PDO::PARAM_STR);
    $ipinsq->execute();


//print_r($array);
?>