codeadam-php-cms/topics_add.php at main · codeadamca/codeadam-php-cms · 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
<?php

include( 'includes/database.php' );
include( 'includes/config.php' );
include( 'includes/functions.php' );

secure();

include( 'includes/header.php' );

if( isset( $_POST['name'] ) )
{

  if( $_POST['name'] and $_POST['name'] )
  {

    $query = 'INSERT INTO topics (
        name,
        url,
        tag,
        teaching,
        icon,
        background
      ) VALUES (
         "'.mysqli_real_escape_string( $connect, $_POST['name'] ).'",
         "'.mysqli_real_escape_string( $connect, $_POST['url'] ).'",
         "'.mysqli_real_escape_string( $connect, $_POST['tag'] ).'",
         "'.$_POST['teaching'].'",
         "'.mysqli_real_escape_string( $connect, $_POST['icon'] ).'",
         "'.mysqli_real_escape_string( $connect, $_POST['background'] ).'"
      )';
    mysqli_query( $connect, $query );

    set_message( 'Topic has been added' );

  }

  header( 'Location: topics.php' );
  die();

}

?>

<h2>Add Topic</h2>

<form method="post">

  <label for="name">Name:</label>
  <input type="text" name="name" id="name">

  <br>

  <label for="url">URL:</label>
  <input type="text" name="url" id="url">

  <br>

  <label for="icon">Icon:</label>
  <input type="text" name="icon" id="icon">

  <br>

  <label for="tag">Tag:</label>
  <input type="text" name="tag" id="tag">

  <br>

  <label for="teaching">Teaching:</label>
  <?php

  $values = array( 'Yes', 'No' );

  echo '<select name="teaching" id="teaching">';
  foreach( $values as $key => $value )
  {
    echo '<option value="'.$value.'"';
    echo '>'.$value.'</option>';
  }
  echo '</select>';

  ?>

  <br>

  <label for="background">Background:</label>
  <?php

  $values = array( 'Dark', 'Light' );

  echo '<select name="background" id="background">';
  foreach( $values as $key => $value )
  {
    echo '<option value="'.$value.'"';
    echo '>'.$value.'</option>';
  }
  echo '</select>';

  ?>

  <br>

  <input type="submit" value="Add Topic">

</form>

<p><a href="topics.php"><i class="fas fa-arrow-circle-left"></i> Return to Topics</a></p>


<?php

include( 'includes/footer.php' );

?>