<?php
if(isset($_POST['action'])) {
    $idea;

    switch($_POST['action']) {
        case "show":

            $curl = curl_init();
            curl_setopt($curl, CURLOPT_URL, 'http://www.edycja.pl/');
            curl_setopt($curl, CURLOPT_REFERER, "http://www.google.pl/");
            curl_setopt($curl, CURLOPT_FOLLOWLOCATION, 1);
            curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
            curl_setopt($curl, CURLOPT_USERAGENT, 'Googlebot/2.1 (+http://www.googlebot.com/bot.html)');
            curl_setopt($curl, CURLOPT_TIMEOUT, 30);
            curl_setopt($curl, CURLOPT_HEADER, 0);

            $site = curl_exec($curl);
            curl_close($curl);


            preg_match('#DNIA</h5><p>\&\#8222;(.+)\&\#8221;<span class="author">(.+)</span></p>#siU',$site,$score);
            echo json_encode($score);
            $idea=$score;
        break;
        case "favourite":
            $servername = "localhost";
            $username = "root";
            $password = "";

            $conn = new mysqli($servername, $username, $password);

            if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
            }

            $sql = "CREATE DATABASE IF NOT EXISTS ideas CHARACTER SET utf8 COLLATE utf8_general_ci";
            $conn->query($sql);

            mysqli_set_charset($conn,"utf8");
            mysqli_select_db ( $conn , "ideas" );
            mysqli_query($conn, "SET NAMES 'utf8'");

            $sql = "CREATE TABLE IF NOT EXISTS myideas (
                id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
                ideaText TEXT(300)  NOT NULL
                )";

            mysqli_query($conn, $sql);

            $sql = " INSERT IGNORE INTO myideas (ideaText)
            VALUES ('{$_POST['todayIdea']}')";

            //$sql = "INSERT INTO myideas (ideaText) VALUES ('{$_POST['todayIdea']}') WHERE NOT EXISTS (SELECT ideaText FROM myideas where ideaText='{$_POST['todayIdea']}')";

            $conn->query($sql);

            $conn->close();
            break;
///////////////////////////////////////////
case "showFavourite":
            $servername = "localhost";
            $username = "root";
            $password = "";

            $conn = new mysqli($servername, $username, $password);

            if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
            }
            mysqli_set_charset($conn,"utf8");
            mysqli_select_db ( $conn , "ideas" );
            mysqli_query($conn ,"SET NAMES 'utf8'");

            $result = mysqli_query($conn,"SELECT * FROM myideas");

            while($row = mysqli_fetch_array($result))
            {
            echo $row['ideaText'];
            }
            $conn->close();
        break;
    }
}
?>