DynamicResume/addwork.php at master · slvamegestic/DynamicResume · 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
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
<?php include 'connection.php';?>
<?php include 'header.php';?>
<html>

<body class="w3-light-grey">

 <!-- Page Container -->
<div class="w3-content w3-margin-top" style="max-width:1400px;">

  <!-- The Grid -->
  <div class="w3-row-padding">

    <!-- Left Column -->
    <div class="w3-third">

      <div class="w3-white w3-text-grey w3-card-4">
        <div class="w3-display-container">
          <img src="https://images.unsplash.com/photo-1507679799987-c73779587ccf?ixlib=rb-1.2.1&ixid=eyJhcHBfaWQiOjEyMDd9&auto=format&fit=crop&w=1351&q=80" style="width:100%" alt="Avatar">
          <div class="w3-display-bottomleft w3-container w3-text-black">
          <h2 style="color:white;">Selvakkumar S</h2>
          </div>
        </div>
        <div class="w3-container">
        <p><i class="fa fa-briefcase fa-fw w3-margin-right w3-large w3-text-orange"></i>Designer</p>
          <p><i class="fa fa-home fa-fw w3-margin-right w3-large w3-text-orange"></i>india,coimbatore</p>
          <p><i class="fa fa-envelope fa-fw w3-margin-right w3-large w3-text-orange"></i>sselvakkumar12@mail.com</p>
          <p><i class="fa fa-phone fa-fw w3-margin-right w3-large w3-text-orange"></i>9159266344</p>
          <hr>
          <p class="w3-large"><b><i class="fa fa-asterisk fa-fw w3-margin-right w3-text-orange"></i>Skills</b><a href="add.php">
          <i class="fa fa-plus fa-fw w3-right w3-large w3-text-orange"></i></a></p>
         <?php
        $sql= "SELECT * FROM `skills`";

        $result = mysqli_query($conn, $sql);

        while($row = mysqli_fetch_assoc($result)) {
          ?>
            <p>
              <?php echo $row["skillname"];?>
                <a href="edit.php?edit=<?php echo $row["id"];?>">
                  <i class="fa fa-edit fa-fw w3-right w3-large w3-text-orange"></i>
                </a>
                <a href="index.php?del=<?php echo $row["id"];?>">
                  <i class="fa fa-remove fa-fw w3-right w3-large w3-text-orange"></i>
                </a>
            </p>
          <div class="w3-light-grey w3-round-xlarge w3-small">
             <div class="w3-container w3-center w3-round-xlarge w3-orange" style="width:<?php echo $row["skilllevel"]; ?>%"><?php echo $row["skilllevel"]; ?>%</div>
          </div>
     <?php }
        if(isset($_GET['del']))
        {
           $del_id= $_GET['del'];
           $sql="DELETE FROM `skills` WHERE id=$del_id";
           if(mysqli_query($conn, $sql)){
            echo "<script>window.location='index.php'; </script>";
        }
        }

     ?>

 <p class="w3-large w3-text-theme"><b><i class="fa fa-globe fa-fw w3-margin-right w3-text-orange"></i>Languages</b><a href="langadd.php">
          <i class="fa fa-plus fa-fw w3-right w3-large w3-text-orange"></i></a></p>
 <?php
        $sql= "SELECT * FROM `language`";

        $result = mysqli_query($conn, $sql);

        while($row = mysqli_fetch_assoc($result)) {
  ?>
          <p><?php echo $row["name"];?>
              <a href="langedit.php?edit=<?php echo $row["id"];?>">
                 <i class="fa fa-edit fa-fw w3-right w3-large w3-text-orange"></i>
              </a>
              <a href="index.php?del=<?php echo $row["id"];?>">
                  <i class="fa fa-remove fa-fw w3-right w3-large w3-text-orange"></i>
              </a>
          </p>
          <div class="w3-light-grey w3-round-xlarge">
            <div class="w3-round-xlarge w3-orange" style="height:24px;width:<?php echo $row["level"];?>%"></div>
          </div>
    <?php    }
         if(isset($_GET['del']))
         {
              $del_id= $_GET['del'];
              $sql="DELETE FROM `language` WHERE id=$del_id";
              if(mysqli_query($conn, $sql)){
                echo "<script>window.location='index.php'; </script>";
            }
         }
    ?>

        </div>
      </div><br>

    <!-- End Left Column -->
    </div>

    <!-- Right Column -->

    <div class="w3-twothird">

    <?php
      if(isset($_POST['addwork']))
      {
          $name =$_POST['p-name'];
          $duration=$_POST['du-tion'];
          $discription=$_POST['dis-tion'];

          if($name == "" || $duration == "" || $discription== ""){
            $nameErr = "* All Information is required";
          }
      else{
          $sql="INSERT INTO `experience` (`id`, `profile_name`, `duration`, `description`) VALUES (NULL, '$name', '$duration','$discription')";
          if(mysqli_query($conn, $sql)){
            echo"<script>window.location='index.php'; </script>";
             }
          }
       }
    ?>
      <div class="w3-container w3-card w3-white w3-margin-bottom">
        <h2 class="w3-text-grey w3-padding-16"><i class="fa fa-suitcase fa-fw w3-margin-right w3-xxlarge w3-text-orange"></i>Add Your Experience</h2>
            <form class="w3-container w3-card-4" action="" method='post'>


                <p>
                  <label class="w3-text-green"><b>Profilename</b></label>
                  <input class="w3-input w3-border" name="p-name" type="text">
                </p>
                <p>
                  <label class="w3-text-green"><b>Duration</b></label>
                  <input class="w3-input w3-border" name="du-tion" type="text">
                </p>
                <p>
                  <label class="w3-text-green"><b>Description</b></label>
                  <input class="w3-input w3-border" name="dis-tion" type="text">
                </p>
                <span class="error" style="color:red;"> <?php echo $nameErr;?></span>

                <p>
                  <button class="w3-btn w3-green" name="addwork">Add</button>
                </p>
            </form>
       </div>
       <div class="w3-container w3-card w3-white w3-margin-bottom">
              <h2 class="w3-text-grey w3-padding-16"><i class="fa fa-suitcase fa-fw w3-margin-right w3-xxlarge w3-text-orange"></i>Work Experience <a href="addwork.php">
          <i class="fa fa-plus fa-fw w3-right w3-large w3-text-orange"></i></a></h2>
              <?php
                    $sql= "SELECT * FROM `experience`";

                    $result = mysqli_query($conn, $sql);

                    while($row = mysqli_fetch_assoc($result)) {
              ?>
              <div class="w3-container">
                <h5 class="w3-opacity"><b><?php echo $row["profile_name"];?></b></h5>
                <h6 class="w3-text-orange"> <span class="w3-tag w3-orange w3-round"><?php echo $row["duration"];?></span>
                    <?php if($row['status'])
                    echo '- <span class="w3-tag w3-orange w3-round"> Current </span>';
                    ?>
                </h6>
                <h5 class="w3-opacity"><b><?php echo $row["description"];?></b></h5>
                <hr>
              </div>
         <?php }
          ?>
        </div>

    <!-- End Right Column -->
    </div>

  <!-- End Grid -->
  </div>

  <!-- End Page Container -->
</div>

</body>
<?php include 'footer.php';?>

</html>