<?php

//DB-varaibles
$dsn = "mysql:dbname=dbirkemalm_com;host=dbirkemalm.com.mysql;";
$username = "dbirkemalm_com";
$password ="8ejxQ4Pn";
$db_name = "dbirkemalm_com";
$ip_table = 'ips';
$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->execute();
$ipq->setFetchMode(PDO::FETCH_NUM);



if($ipq->rowCount() == 1){
    echo "";
}

else{

    //Insert IP
    $ipinsql = "INSERT INTO $ip_table VALUES('$ip')";
    $ipinsq = $dbh->prepare($ipinsql);
    $ipinsq->execute();

    //Vote-query
    $votesql = "INSERT INTO $vote_table (vote, ID) VALUES('$vote', NULL)";
    $voteq = $dbh->prepare($votesql);
    $voteq->execute();
}

//print_r($array);
?>