PHP establish_mysql_connection Examples

Example #1

File: get_imaging.php Project: andyboscor/Examples

function update_report()
{
    //This function prints all the reports in different divs connected to a specific category
    //The latest gets the biggest ID
    $id = $_GET['category'];
    $db = establish_mysql_connection();
    $mysql_query = $db->prepare("SELECT * FROM `boxes_selectable_content` WHERE id='{$id}'");
    $mysql_query->execute();
    $mysql_array = $mysql_query->fetchAll();
    $table_name = $mysql_array[0]['table_link'];
    //$
    $name = $mysql_array[0]['name'];
    $pid = $_SESSION['pid'];
    $mysql_query = $db->prepare("SELECT * FROM `{$table_name}` WHERE MRN='{$pid}' ORDER BY 3 ASC");
    $mysql_query->execute();
    $mysql_array = $mysql_query->fetchAll();
    print '<div class="dashboard_box_entry_title" class="dashboard_box_entry_long_text_title">';
    print $name;
    print '</div>';
    for ($i = 0; $i < sizeof($mysql_array); $i++) {
        print "<div id='dashboard_box_imaging_report" . $i . "'";
        print $i + 1 == sizeof($mysql_array) ? "" : " style='display:none;' ";
        print "date='" . $mysql_array[$i][2] . "'>";
        print $mysql_array[$i][3];
        print "</div>";
    }
}

Example #2

File: get_letter.php Project: andyboscor/Examples

function get_selectables()
{
    $box = $_GET['box'];
    $db = establish_mysql_connection();
    $mysql_query = $db->prepare("SELECT * FROM `boxes_selectable` WHERE box_id={$box}");
    $mysql_query->execute();
    $mysql_array = $mysql_query->fetchAll();
    foreach ($mysql_array as $line) {
        print '<option value="' . $line[0] . '">';
        print $line[2];
        print '</option>';
    }
}

Example #3

File: download_letter.php Project: andyboscor/Examples

function return_content($id, &$section)
{
    $pid = $_SESSION['pid'];
    $db = establish_mysql_connection();
    $mysql_query = $db->prepare("SELECT * FROM `boxes_selectable_content` WHERE selectable_id={$id}");
    $mysql_query->execute();
    $mysql_array = $mysql_query->fetchAll();
    foreach ($mysql_array as $array) {
        $section->addTextBreak();
        $table_link = $array['table_link'];
        $section->addText(htmlspecialchars($array['name']), array("bold" => true));
        $mysql_queryc = $db->prepare("SELECT * FROM {$table_link} WHERE MRN={$pid} ORDER BY 3 DESC");
        $mysql_queryc->execute();
        $mysql_arrayc = $mysql_queryc->fetchAll();
        $section->addText(htmlspecialchars($mysql_arrayc[0][2]), array("italic" => true));
        $section->addText(htmlspecialchars($mysql_arrayc[0][3]), array("spaceBefore" => 5));
    }
}

Example #4

File: update_problem_list.php Project: andyboscor/Examples

<?php

function establish_mysql_connection()
{
    try {
        $db = new PDO("mysql:host=localhost;dbname=NHS;charset=utf8", "portal_user", "");
    } catch (PDOException $ex) {
        die("Failed to connect to the database: " . $ex->getMessage());
    }
    return $db;
}
if (isset($_GET['content'])) {
    session_start();
    $pid = $_SESSION['pid'];
    $db = establish_mysql_connection();
    $content = $_GET['content'];
    $mysql_queryc = $db->prepare("SELECT * FROM `problem_list` WHERE patient_id={$pid}");
    $mysql_queryc->execute();
    $mysql_arrayc = $mysql_queryc->fetchAll();
    if (sizeof($mysql_arrayc) == 0) {
        $mysql_query = $db->prepare("INSERT INTO problem_list (patient_id, content) VALUES (?, ?)");
        $mysql_query->execute(array($pid, $content));
    } else {
        $mysql_query = $db->prepare("UPDATE problem_list SET content=? WHERE patient_id=?");
        $mysql_query->execute(array($content, $pid));
    }
}

Example #5

File: dashboard_builder.php Project: andyboscor/Examples

function print_problem_list()
{
    $pid = $_SESSION['pid'];
    print '<td>';
    print '<div class="dashboard_box" id="dashboard_box0">';
    print '<div class="dashboard_box_title">Problem list</div>';
    print '<div class="dashboard_box_content">';
    print '<textarea id="dashboard_problem_list_textarea">';
    $db = establish_mysql_connection();
    $mysql_query = $db->prepare("SELECT * FROM `problem_list` WHERE patient_id={$pid}");
    $mysql_query->execute();
    $mysql_array = $mysql_query->fetchAll();
    print isset($mysql_array[0]['content']) ? $mysql_array[0]['content'] : "";
    print '</textarea>';
    print '<input type="button" value="Save" onclick="saveProblemList()" id="dashboard_problem_list_save" />';
    print '<span id="dashboard_problem_list_status"></span>';
    print '</div>';
    print '</div>';
    print '</div>';
}