Survey_Form_in_PHP/index.php at main · Devender00999/Survey_Form_in_PHP · 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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
<?php
    session_start();
    if(isset($_SESSION["isFilled"]))
    {
        // echo "<script>alert('You Have Already Filled the form');</script>";
        echo "<h1 style='text-align:center  '>You've already filled this form</h1>";
        exit();
    }
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="stylesheet" href="style.css">
    <!-- CSS only -->
    <title>Document</title>
</head>
<body>
    <div id="main">
       <div id="survey-form-container">
            <h1 id="title">PAI Programmers Survey Form</h1>
            <p id="description">Thanks for filling the form. It will help us to improve our services</p>
            <form action="./" id="survey-form" method="POST">
                <div class="dataContainer">
                    <label class="inputLabel" id="name-label" for="name">Name</label>
                    <input class="inputBox" name="name" type="text" id="name" placeholder="Enter Your Name" required>
                    <span></span>
                </div>
                <div class="dataContainer">
                    <label class="inputLabel" id="email-label" for="email">Email</label>
                    <input class="inputBox" name="email" type="email" placeholder="Enter Your Emaild ID" id="email" required>
                    <span></span>
                </div>

                <div class="dataContainer">
                    <label class="inputLabel" id="number-label" for="number">Age</label>
                    <input class="inputBox" name="age" type="number" placeholder="Enter Your Age" id="number" required min=10 max = 100>
                    <span></span>
                </div>
                <div class="dataContainer">
                    <label class="inputLabel" id="number-label" for="mnumber">Number(Optional)</label>
                    <input class="inputBox" name="number" type="number" placeholder="Enter Your Mobile No." id="mnumber" minlength=10 maxlength = 100>
                    <span></span>
                </div >
                <div class="dataContainer">
                    <label class="inputLabel" id="" for="dropdown">What do you do?</label>
                    <select class="inputBox"  name="role" id="dropdown">
                        <option value="Select An Option">Select an option</option>
                        <option value="Sturdent">Student</option>
                        <option value="Full Time Job">Job</option>
                        <option value="Full Time Learner">Freelancing</option>
                        <option value="Prefer not to say">Prefer not to say</option>
                        <option value="Others">Others</option>
                    </select>
                    <span></span>
                </div>
                <label class="inputLabel" id="number-label" for="refer">Would you recommend PAI Programmers to a friend?</label>

                <div class="dataContainer">
                    <input type="radio" value="Definitely" name = "refer" id="definite" required><label class="radioLable" for="definite">Definitely</label><br>
                    <input type="radio" value="May Be" name = "refer" id="maybe" required><label class="radioLable" for="maybe">May Be</label><br>
                    <input type="radio" value="Not Sure " name = "refer" id="notesure" required><label class="radioLable" for="notesure">Not Sure</label><br>
                </div>
                <div class="dataContainer">
                    <label class="inputLabel" for="feature">What is your favorite feature of PAI Programmers?</label>
                    <select class="inputBox" name="feature" id="feature">
                        <option value="Select An Option">Select an option</option>
                        <option value="Challanges">Challanges</option>
                        <option value="Projects">Projects</option>
                        <option value="Community">Community</option>
                        <option value="Open Source">Open Source</option>
                    </select>
                    <span></span>
                </div>
                <div class="dataContainer">
                    <label class="inputLabel" for="intrested">What is your intrested field of study?</label>
                    <input class="checkLable" type="checkbox" name="interest[]" id="fweb" value="Frontend Web Development"><label for="fweb">Frontend Web Development</label><br>
                    <input class="checkLable" type="checkbox" name="interest[]" id="bweb" value="Backend Web Development"><label for="bweb">Backend Web Development</label><br>
                    <input class="checkLable" type="checkbox" name="interest[]" id="software" value="Software Development"><label for="software">Software Development</label><br>
                    <input class="checkLable" type="checkbox" name="interest[]" id="cwriting" value="Content Writing"><label for="cwriting">Content Writing</label><br>
                    <input class="checkLable" type="checkbox" name="interest[]" id="gdesign" value="Graphics Design"><label for="gdesign">Graphics Design</label><br>

                    <span></span> <br>
                </div>
                <div class="dataContainer">
                    <label class="inputLabel" id="suggestion-label" for="suggestion">Any Other Suggestions?</label>
                    <textarea class="inputBox" name="suggestion" rows="4" cols="50" placeholder="Write your suggestions here..." id="suggestion" required></textarea>


                    <span></span>
                </div >
                <input type="submit" id="submit" value="Submit">
            </form>
        </div>

    </div>

</body>

</html>
<?php
    if($_SERVER['REQUEST_METHOD']=="POST"){
        $servername = "localhost";
        $username = "";
        $password="";
        $db = "";
        $conn = new mysqli($servername,$username,$password,$db);
        $interest =join(" | ",$_POST["interest"]);
        $query = "insert into Survery_Details(name,email,age,mob_no,role,refer,feature,interest,suggestion) values ('$_POST[name]','$_POST[email]',$_POST[age],'$_POST[number]','$_POST[role]','$_POST[refer]','$_POST[feature]','$interest','$_POST[suggestion]');";
        // Insert Data in table

        if($conn->query($query))
        {
            echo "<script>alert('Thank You for Filling the form');</script>";
            $_SESSION["isFilled"] = TRUE;
            $conn->close();
            echo "<meta http-equiv='refresh' content='0'></meta>";
            exit();
        }
        else{
            // echo "<script>alert('Insertion Failed: $conn->error');</script>";
            echo "Data Not";
        }
        $conn->close();

    }


?>