catalog/populate_table.php at master · sagitta1618/catalog · 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
<?php
include("dbb/connect_db.php");

    include("dbb/join_query.php"); # return sql_main_joint
    // echo $sql_main_joint;

    // new without joint
    $select = $conn->prepare($sql_main_joint);
    $select->execute();

    if (!$select) {
        echo 'An SQL error occured.\n';
        exit;
    }

$ArrayValue = array();
$row = $select->fetch(PDO::FETCH_ASSOC);
array_push($ArrayValue, json_encode($row));

// echo var_dump($row);
$ArrayValue = array();
        # Loop through rows to build feature arrays
        while ($row = $select->fetch(PDO::FETCH_ASSOC)) {
            $ArrayValue_tmp['organisation'] = $row['organisation'];
            $ArrayValue_tmp['name'] = $row['name'].' '.$row['surname'] ;
            $ArrayValue_tmp['contrib_authors'] = $row['contrib_authors'];
            $ArrayValue_tmp['method'] = $row['method'];


            $ArrayValue_tmp['software_name'] =  $row['software_name'];
            $ArrayValue_tmp['licence_type'] =  $row['licence_type'];
            $ArrayValue_tmp['notebook_filename'] =  $row['notebook_filename'];


            $ArrayValue_tmp['dimension'] = $row['dimension'];
            $ArrayValue_tmp['spatial_scale'] = $row['spatial_scale'];
            $ArrayValue_tmp['bound_cond'] = $row['bound_cond'];
            $ArrayValue_tmp['temporal_scale'] = $row['temporal_scale'];
            $ArrayValue_tmp['instrument'] = $row['instrument'];
            $ArrayValue_tmp['permanent_setup'] = $row['permanent_setup'];

            $ArrayValue_tmp['species'] = $row['species'];
            $ArrayValue_tmp['organ'] = $row['organ'];

            $ArrayValue_tmp['contrib_date'] = $row['contrib_date'];
            $ArrayValue_tmp['contrib_type'] =  $row['contrib_type'];
            $ArrayValue_tmp['contrib_title'] =  $row['contrib_title'];
            $ArrayValue_tmp['DOI'] =  '<a href="https://dx.doi.org/'.$row['DOI'].'"  target="_blank">DOI</a>';
            $ArrayValue_tmp['more'] = '<a href="contribution_detailed.php?idnb='.$row['id'].'">more</a>';


            array_push($ArrayValue, $ArrayValue_tmp);
        }
    echo json_encode($ArrayValue);

?>