Movie-Database/functions.php at main · aref-osman/Movie-Database · 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
<?php

// function to 'clean' data
function test_input($data) {
	$data = trim($data);
	$data = htmlspecialchars($data); //  needed for correct special character rendering
	return $data;
}


// entity is subject, country, occupation etc
function autocomplete_list($dbconnect, $item_sql, $entity)
{
// Get entity / topic list from database
$all_items_query = mysqli_query($dbconnect, $item_sql);
$all_items_rs = mysqli_fetch_assoc($all_items_query);

// Make item arrays for autocomplete functionality...
while($row=mysqli_fetch_array($all_items_query))
{
  $item=$row[$entity];
  $items[] = $item;
}

$all_items=json_encode($items);
return $all_items;

}


// function to get subject, country & career ID's
function get_ID($dbconnect, $table_name, $column_ID, $column_name, $entity)
{

    if($entity=="")
    {
        return 0;
    }


    // get entity ID if it exists
    $findid_sql = "SELECT * FROM $table_name WHERE $column_name LIKE '$entity'";
    $findid_query = mysqli_query($dbconnect, $findid_sql);
    $findid_rs = mysqli_fetch_assoc($findid_query);
    $findid_count=mysqli_num_rows($findid_query);

    // If subject ID does exists, return it...
    if($findid_count > 0) {
        $find_ID = $findid_rs[$column_ID];
        return $find_ID;
    }   // end if (entity existed, ID returned)


    else {
        $add_entity_sql = "INSERT INTO $table_name ($column_ID, $column_name) VALUES (NULL, '$entity');";
        $add_entity_query = mysqli_query($dbconnect, $add_entity_sql);

    $new_id_sql = "SELECT * FROM $table_name WHERE $column_name LIKE '$entity'";
    $new_id_query = mysqli_query($dbconnect, $new_id_sql);
    $new_id_rs = mysqli_fetch_assoc($new_id_query);

    $new_id = $new_id_rs[$column_ID];

    return $new_id;

    }   // end else (entity added to table and ID returned)

} // end get ID function


function get_rs($dbconnect, $sql)
{
    $find_sql = $sql;
    $find_query = mysqli_query($dbconnect, $find_sql);
    $find_rs = mysqli_fetch_assoc($find_query);

    return $find_rs;
}


function country_job($dbconnect, $entity_1, $entity_2, $label_sg, $label_pl, $table, $entity_ID, $entity_name)
{

    $all_entities = array($entity_1, $entity_2);
    // loop through items and look up their values...

    // Counts # of countries that without ID zero...
    $num_entities = count(array_filter($all_entities));


    if ($num_entities == 1)
    {
    echo "<strong>".$label_sg."</strong>: ";
    }

    else { echo "<strong>".$label_pl."</strong>: ";}

    foreach ($all_entities as $entity) {

    $entity_sql = "SELECT * FROM $table WHERE $entity_ID = $entity";
    $entity_query = mysqli_query($dbconnect, $entity_sql);
    $entity_rs = mysqli_fetch_assoc($entity_query);

    if ($entity != 0) {

    ?>


    <span class="author_entity tag"><?php echo $entity_rs[$entity_name]; ?> </span> &nbsp;

    <?php

    } // end entity if

    // break reference with the last element as per the manual
    unset($entity);

    }

}

?>