codeadam-php-cms/evaluations_edit.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
<?php

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

secure();

include( 'includes/header.php' );

if( !isset( $_GET['id'] ) )
{

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

}

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

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

    $query = 'UPDATE evaluations SET
      text = "'.mysqli_real_escape_string( $connect, $_POST['text'] ).'"
      WHERE id = '.$_GET['id'].'
      LIMIT 1';
    mysqli_query( $connect, $query );

    set_message( 'Evaluation has been updated' );

  }

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

}


if( isset( $_GET['id'] ) )
{

  $query = 'SELECT *
    FROM evaluations
    WHERE id = '.$_GET['id'].'
    LIMIT 1';
  $result = mysqli_query( $connect, $query );

  if( !mysqli_num_rows( $result ) )
  {

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

  }

  $record = mysqli_fetch_assoc( $result );

}

?>

<h2>Edit Evaluation</h2>

<form method="post">

  <label for="text">Text:</label>
  <textarea name="text" id="text" rows="5"><?php echo htmlentities( $record['text'] ); ?></textarea>

  <br>

  <input type="submit" value="Edit Evaluation">

</form>

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


<?php

include( 'includes/footer.php' );

?>