File: db_functions.php

package info (click to toggle)
stacks 1.44-2
  • links: PTS, VCS
  • area: main
  • in suites: stretch
  • size: 5,272 kB
  • ctags: 6,756
  • sloc: cpp: 33,308; ansic: 31,921; perl: 4,169; php: 4,059; sh: 1,709; makefile: 468; sql: 386; python: 289
file content (48 lines) | stat: -rw-r--r-- 1,475 bytes parent folder | download | duplicates (3)
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
<?php
//
// Copyright 2010-2016, Julian Catchen <jcatchen@illinois.edu>
//
// This file is part of Stacks.
//
// Stacks is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Stacks is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Stacks.  If not, see <http://www.gnu.org/licenses/>.
//

function db_connect($database) {
    global $db_user, $db_pass, $db_host;

    $dbh = new mysqli($db_host, $db_user, $db_pass, $database);

    if ($dbh->connect_errno) {
        die("File: " . __FILE__ . " (line " . __LINE__ . ") Failed to connect to MySQL: (" . $dbh->connect_errno . ") " . $dbh->connect_error);
    }

    //
    // The $db array will hold the database handle and 
    // common, prepared SQL statements.
    //
    $db = array();
    $db['dbh']  = $dbh;
    $db['name'] = $database;

    return $db;
}

function write_db_error($sth, $file, $line) {
    $error_str = 
        "File: $file (line $line)<br />\n " .
        $sth->errno . ": <strong>" . $sth->error . "</strong><br />\n";
    die($error_str);
}

?>