PHPproject/createPost.php at main · Mitfort/PHPproject · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-T3c6CoIi6uLrA9TneNEoa7RxnatzjcDSCmG1MXxSR1GAsXEV/Dwwykc2MPK8M2HN" crossorigin="anonymous">
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.2/dist/js/bootstrap.bundle.min.js"></script>
    <link rel="stylesheet" href="style.css">
    <script src="https://cdn.tiny.cloud/1/no-api-key/tinymce/6/tinymce.min.js" referrerpolicy="origin"></script>
    <script>
        tinymce.init({
        selector: "textarea",
        plugins: [
        "insertdatetime"
        ],
        width: 700,
        height: 400,})
        </script>
</head>
<body>

        <?php

        session_start();

        if(!isset($_SESSION['currentUser'])){
            header("Location:register.php");
        }

        ?>

        <?php
          include("header.php");

        ?>

        <?php

        if(isset($_POST['title']) && isset($_POST['content'])){

            $title = strip_tags($_POST['title']);
            $content = strip_tags($_POST['content']);

            $connection = mysqli_connect("localhost","root","","phpprojekcik");

            if(!$connection){
                echo "DALEJ NIE MA BAZY";
                exit();
            }

            $query2 = "SELECT userID FROM users WHERE login='{$_SESSION['currentUser']['login']}'";

            $res2 = mysqli_query($connection,$query2);

            $userID = mysqli_fetch_assoc($res2);

            $date = date('Y-m-d H:i:s');

            $query = "INSERT INTO articles (creatorID,title,content,createdAt) VALUES ({$userID['userID']},'{$title}','{$content}','{$date}')";

            $res = mysqli_query($connection,$query);

            echo "<script>alert('Dodano Post')</script>";

        }

        ?>


        <div class="create-post-menu">

            <form action="" method="post">

                <div class="form-row">
                    <label for="title">TITLE</label>
                    <input type="text" name="title" id="title" >
                </div>

                <div class="form-row">
                    <label for="content">CONTENT</label>
                    <textarea name="content" id="mytextarea"></textarea>
                </div>

                <button type="submit">Create Post</button>

            </form>

        </div>

    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/popper.js@1.14.7/dist/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@4.3.1/dist/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
</body>
</html>