EVN078ii

1<?php
2if(isset($_POST['action'])) {
3    $idea;
4    
5    switch($_POST['action']) {
6        case "show":
7        
8            $curl = curl_init();
9            curl_setopt($curl, CURLOPT_URL, 'http://www.edycja.pl/');
10            curl_setopt($curl, CURLOPT_REFERER, "http://www.google.pl/");
11            curl_setopt($curl, CURLOPT_FOLLOWLOCATION, 1);
12            curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
13            curl_setopt($curl, CURLOPT_USERAGENT, 'Googlebot/2.1 (+http://www.googlebot.com/bot.html)');
14            curl_setopt($curl, CURLOPT_TIMEOUT, 30);
15            curl_setopt($curl, CURLOPT_HEADER, 0);
16            
17            $site = curl_exec($curl);
18            curl_close($curl);
19            
20            
21            preg_match('#DNIA</h5><p>\&\#8222;(.+)\&\#8221;<span class="author">(.+)</span></p>#siU',$site,$score);
22            echo json_encode($score);
23            $idea=$score;
24        break;
25        case "favourite":
26            $servername = "localhost";
27            $username = "root";
28            $password = "";
29            
30            $conn = new mysqli($servername, $username, $password);
31
32            if ($conn->connect_error) {
33                die("Connection failed: " . $conn->connect_error);
34            } 
35            
36            $sql = "CREATE DATABASE IF NOT EXISTS ideas CHARACTER SET utf8 COLLATE utf8_general_ci";
37            $conn->query($sql);
38
39            mysqli_set_charset($conn,"utf8");
40            mysqli_select_db ( $conn , "ideas" );
41            mysqli_query($conn, "SET NAMES 'utf8'");
42
43            $sql = "CREATE TABLE IF NOT EXISTS myideas (
44                id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 
45                ideaText TEXT(300)  NOT NULL
46                )";
47
48            mysqli_query($conn, $sql);
49           
50            $sql = " INSERT IGNORE INTO myideas (ideaText)
51            VALUES ('{$_POST['todayIdea']}')";
52
53            //$sql = "INSERT INTO myideas (ideaText) VALUES ('{$_POST['todayIdea']}') WHERE NOT EXISTS (SELECT ideaText FROM myideas where ideaText='{$_POST['todayIdea']}')";
54            
55            $conn->query($sql);
56        
57            $conn->close();
58            break;
59///////////////////////////////////////////
60case "showFavourite":
61            $servername = "localhost";
62            $username = "root";
63            $password = "";
64
65            $conn = new mysqli($servername, $username, $password);
66
67            if ($conn->connect_error) {
68                die("Connection failed: " . $conn->connect_error);
69            } 
70            mysqli_set_charset($conn,"utf8");
71            mysqli_select_db ( $conn , "ideas" );
72            mysqli_query($conn ,"SET NAMES 'utf8'");
73
74            $result = mysqli_query($conn,"SELECT * FROM myideas");
75            
76            while($row = mysqli_fetch_array($result))
77            {
78            echo $row['ideaText'];
79            }
80            $conn->close();
81        break;
82    }
83}
84?>