phpCRUD/activitytrack.php at master · mukeshg1/phpCRUD · 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
<?php

    /*
    File Name    : activity.php
    File Path    : C:\xampp\htdocs\phpCRUD
    Description  : PHP page which stores all the user activity in 'activity' table inside database 'crudphp'
    Created date : 04/02/2019
    Author       : Mukesh
    */
    session_start();
    $SERVER = '127.0.0.1';
    $USER = 'root';
    $PASSWORD = '';
    $DB = 'crudphp';

    $dbc = mysqli_connect($SERVER, $USER, $PASSWORD, $DB);
    $id = mysqli_real_escape_string($dbc, $_POST['id']);
    $email = mysqli_real_escape_string($dbc, $_POST['email']);
    $activity = mysqli_real_escape_string($dbc, $_POST['activity']);

    if (ISSET($_SESSION['user']))
    {
        $iuser = $_SESSION['user'];
        $activitymsg = "".$activity." for user ".$id." by ".$iuser."";
        try
        {
            $sql = "INSERT INTO activity (email, activity) VALUES ('$email', '$activitymsg')";

            if ($dbc->query($sql) === TRUE)
            {
            echo "Activity added.";
            }
            else
            {
                echo "Failed to add activity";
            }
        }

        catch (mysqli_sql_exception $e)
        {
            echo "<p style='color:red;'>Error: Failed.</p>";
        }
    }
    else
    {
        echo "<p style='color:white;'>Error: Invalid Session</p>";
        exit();
    }


?>