Esempi in PHP per initialize_db_info

Esempio n. 1

File: duck_blinds.php Progetto: coyotetracks/PiutePonds

function display_duck_blinds()
{
    $dbinfo = initialize_db_info();
    #report_database_settings($dbinfo);
    try {
        $db_link = db_connect($dbinfo);
        db_select($db_link, $dbinfo);
    } catch (Exception $e) {
        echo report_exception("Database Connection", $e);
        echo report_database_settings($dbinfo);
    }
    $sql = generate_blind_list_sql();
    $result_rows = mysql_query($sql, $db_link);
    if (!$result_rows) {
        echo $sql;
        $message = 'Invalid query: ' . mysql_error() . "\n";
        echo $message;
        throw new Exception('No Results.');
    }
    echo '<table>';
    while ($row = mysql_fetch_array($result_rows, MYSQL_ASSOC)) {
        //echo generate_blind_row($row);
    }
    echo '</table>';
}

Esempio n. 2

File: register_new.php Progetto: coyotetracks/PiutePonds

function registerX($email, $password, $first_name, $last_name)
{
    // Register new person with db
    // Return true or error message
    // Connect to db
    $dbinfo = initialize_db_info();
    //report_database_settings($dbinfo);
    try {
        $db_link = db_connect($dbinfo);
        db_select($db_link, $dbinfo);
    } catch (Exception $e) {
        echo report_exception("Database Connection", $e);
        echo report_database_settings($dbinfo);
    }
    // Check if username is unique
    $uniqueSql = "select * from login where email='" . $email . "'";
    echo report_name_value("uniqueSql", $uniqueSql);
    $result_rows = mysql_query($uniqueSql, $db_link);
    if (!$result_rows) {
        throw new Exception('Could not execute query');
    }
    $numberOfRows = mysql_num_rows($result_rows);
    if ($numberOfRows > 0) {
        throw new Exception('That email is taken - go back and choose another one.');
    }
    $insert_sql = generateUserInsertSql($email, $password, $first_name, $last_name);
    $result_rows = mysql_query($insert_sql, $db_link);
    if (!$result_rows) {
        throw new Exception('Could not register you in database - please try again later. (' . $insert_sql . ')');
    }
    return true;
}

Esempio n. 3

File: hunt_count_report_help.php Progetto: coyotetracks/PiutePonds

function saveNewHuntCountReport($huntReportId, $huntCount)
{
    // Connect to the database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $insertHuntCountReportSql = generateHuntCountReportInsertSql($huntReportId, $huntCount);
    // Insert the hunt details information in the database.
    $result = mysql_query($insertHuntCountReportSql, $dbLink);
    if (!$result) {
        echo $insertHuntCountReportSql;
        throw new Exception('Failed to insert hunt count report');
    }
}

Esempio n. 4

File: species_help.php Progetto: coyotetracks/PiutePonds

function getSpeciesNameById($speciesId)
{
    // Connect to database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $getSpeciesSql = "SELECT common_name FROM species WHERE id=" . $speciesId;
    $result = mysql_query($getSpeciesSql, $dbLink);
    if (!$result) {
        throw new Exception('no results: ' . $getSpeciesSql);
    }
    $row = mysql_fetch_assoc($result);
    $speciesName = $row['common_name'];
    return $speciesName;
}

Esempio n. 5

File: bagCheckNoteHelp.php Progetto: coyotetracks/PiutePonds

function insertNote($noteContent)
{
    // Make connection to the database.
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $insertNoteSql = generateInsertNoteSql($noteContent);
    $result = mysql_query($insertNoteSql, $dbLink);
    if (!$result) {
        echo $insertNoteSql;
        throw new Exception('Insert Note Failed: ' . $insertNoteSql);
    }
    $noteId = getInsertId();
    return $noteId;
}

Esempio n. 6

File: harvest_count_help.php Progetto: coyotetracks/PiutePonds

function getHarvetsListByHuntDetailsId($huntDetailsId)
{
    // Connect to the database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $harvestCountList = array();
    $sql = generateHarvestListByHuntDetailsId($huntDetailsId);
    $result = mysql_query($sql, $dbLink);
    $row = mysql_fetch_assoc($result);
    while ($row) {
        $oneHarvestCount = createHarvestCountFromRow($row);
        $harvestCountList[$oneHarvestCount->getSpeciesId()] = $oneHarvestCount;
        $row = mysql_fetch_assoc($result);
    }
    return $harvestCountList;
}

Esempio n. 7

File: hunt_dates_help.php Progetto: coyotetracks/PiutePonds

function getHuntDatesList($season)
{
    // Connect to database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $huntDatesList = array();
    $findHuntDatesByYearSql = generateFindHuntDatesByYearSql($season);
    $result = mysql_query($findHuntDatesByYearSql, $dbLink);
    $row = mysql_fetch_assoc($result);
    while ($row) {
        $oneHuntDate = $row['hunt_date'];
        $huntDatesList[] = $oneHuntDate;
        $row = mysql_fetch_assoc($result);
    }
    return $huntDatesList;
}

Esempio n. 8

File: report_hunt_help.php Progetto: coyotetracks/PiutePonds

function getHarvestCounts($huntId)
{
    // Connect to the database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $reportHarvestList = array();
    $reportHarvestSql = generateReportHarvestSql($huntId);
    //var_dump($reportHarvestSql);
    $result = mysql_query($reportHarvestSql, $dbLink);
    $row = mysql_fetch_assoc($result);
    while ($row) {
        $oneReportHarvest = createReportHarvestFromRow($row);
        $reportHarvestList[] = $oneReportHarvest;
        $row = mysql_fetch_assoc($result);
    }
    return $reportHarvestList;
}

Esempio n. 9

File: report_help.php Progetto: coyotetracks/PiutePonds

function getAnonymousHarvestCountsForASeason($season)
{
    // Connect to the database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $reportCountList = array();
    $reportSql = generateAnonymousHarvestCountsForASeasonSql($season);
    var_dump($reportSql);
    $result = mysql_query($reportSql, $dbLink);
    $row = mysql_fetch_assoc($result);
    while ($row) {
        $oneSpeciesCount = createSpeciesCountFromRow($row);
        $reportCountList[] = $oneSpeciesCount;
        $row = mysql_fetch_assoc($result);
    }
    return $reportCountList;
}

Esempio n. 10

File: report_hunt_season_help.php Progetto: coyotetracks/PiutePonds

function getHarvestCountBySpeciesForSeason($speciesId, $season)
{
    // Connect to database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $getHarvestCountBySpeciesForSeasonSql = generateHarvestCountBySpeciesForSeasonSql($speciesId, $season);
    $result = mysql_query($getHarvestCountBySpeciesForSeasonSql, $dbLink);
    if (!$result) {
        throw new Exception('no results');
    }
    $row = mysql_fetch_assoc($result);
    $count = $row['count'];
    if (!isset($count)) {
        $count = 0;
    }
    return $count;
}

Esempio n. 11

File: display_help.php Progetto: coyotetracks/PiutePonds

function getDisplay($label)
{
    $displayList = array();
    // Connect to database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $sql = generateDisplayListSql($label);
    $result = mysql_query($sql, $dbLink);
    if ($result) {
        if (mysql_num_rows($result) > 0) {
            while ($row = mysql_fetch_assoc($result)) {
                $currentDisplay = createDisplayFromRow($row);
                $displayList[] = $currentDisplay;
            }
        }
    }
    return $displayList;
}

Esempio n. 12

File: common_name_help.php Progetto: coyotetracks/PiutePonds

function getAllCommonNames()
{
    // connect to db
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $getCommonNameSql = "SELECT * FROM common_names ORDER BY common_name";
    $result = mysql_query($getCommonNameSql, $dbLink);
    if (!$result) {
        echo $getCommonNameSql;
        throw new Exception('no results');
    }
    $row = mysql_fetch_assoc($result);
    while ($row) {
        $oneCommonName = createCommonNameFromRow($row);
        $commonNameList[] = $oneCommonName;
        $row = mysql_fetch_assoc($result);
    }
    return $commonNameList;
}

Esempio n. 13

File: EventLogManager.php Progetto: coyotetracks/PiutePonds

function getAllEvents($numberOfEvents)
{
    // Connect to Database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $getAllEventsSql = "SELECT * FROM event_log ORDER BY create_date DESC LIMIT " . $numberOfEvents;
    $result = mysql_query($getAllEventsSql, $dbLink);
    if (!$result) {
        echo $getAllEventsSql;
        throw new Exception('no results');
    }
    $row = mysql_fetch_assoc($result);
    while ($row) {
        $oneEvent = createEventFromRow($row);
        $eventList[] = $oneEvent;
        $row = mysql_fetch_assoc($result);
    }
    return $eventList;
}

Esempio n. 14

File: season_help.php Progetto: coyotetracks/PiutePonds

function getSeasonId($season)
{
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $huntIdSql = generateHuntIdSql($hunt);
    $result = mysql_query($huntIdSql, $dbLink);
    if (!$result) {
        echo $huntIdSql;
        throw new Exception('Failed to retrieve hunt id');
    }
    $row = mysql_fetch_assoc($result);
    $currentHuntId = $row['id'];
    return $currentHuntId;
}

Esempio n. 15

File: hunter_help.php Progetto: coyotetracks/PiutePonds

function saveNewHunter($newHunter)
{
    // Connect to database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $insertNewHunterSql = "INSERT INTO hunter SET first_name='" . $newHunter->getFirstName() . "', ";
    $insertNewHunterSql .= "last_name='" . $newHunter->getLastName() . "' ";
    $result = mysql_query($insertNewHunterSql, $dbLink);
    if (!$result) {
        echo $insertNewHunterSql;
        throw new Exception('Failed to insert hunter');
    }
}

Esempio n. 16

File: user_help.php Progetto: coyotetracks/PiutePonds

function removeUserHunterId($userId)
{
    $updateRemoveUserHunterIdSql = generateRemoveUserHunterIdUpdateSql($userId);
    // Connect to the database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    //var_dump($updateRemoveUserHunterIdSql);
    // Update the users information in the database.
    $result = mysql_query($updateRemoveUserHunterIdSql, $dbLink);
    if (!$result) {
        echo $updateRemoveUserHunterIdSql;
        throw new Exception('Failed to update user');
    }
}

Esempio n. 17

File: insertTest.php Progetto: coyotetracks/PiutePonds

<?php

session_start();
require_once dirname(__FILE__) . '/bagCheckIncludes.php';
$dbInfo = initialize_db_info();
$dbLink = db_connect($dbInfo);
db_select($dbLink, $dbInfo);
$insertSql = "INSERT INTO bc_day (bc_date, bc_area) VALUES('2013-07-16', 'Area Jeff')";
$result = mysql_query($insertSql, $dbLink);
if (!$result) {
    echo $insertSql;
    throw new Exception('Insert Test Failed');
}
$insertId = mysql_insert_id();
echo $insertId;

Esempio n. 18

File: user_auth.php Progetto: coyotetracks/PiutePonds

function savePassword($email, $newPassword)
{
    $updatePasswordSql = generateChangePasswordSql($email, $newPassword);
    // Connect to the database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    // Update the users password in the database.
    $result = mysql_query($updatePasswordSql, $dbLink);
    if (!$result) {
        echo $updatePasswordSql;
        throw new Exception('Password could not be changed.');
    }
}

Esempio n. 19

File: blind_help.php Progetto: coyotetracks/PiutePonds

function updateStringValue($year, $blindNumber, $priority, $columnName, $newValue)
{
    // Connect to database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $updateStringValueSql = generateUpdateStringValue("blinds", $year, $blindNumber, $priority, $columnName, $newValue);
    //var_dump($updateStringValueSql);
    $result = mysql_query($updateStringValueSql, $dbLink);
    if (!$result) {
        echo $updateStringValueSql;
        throw new Exception('Failed to update blind');
    }
}

Esempio n. 20

File: role_help.php Progetto: coyotetracks/PiutePonds

function getRoleIdFromName($roleName)
{
    // connect to db
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $sql = "SELECT id FROM role WHERE name = '" . $roleName . "'";
    $result = mysql_query($sql, $dbLink);
    if ($result) {
        if (mysql_num_rows($result) == 1) {
            $row = mysql_fetch_assoc($result);
            $roleId = $row['id'];
        }
    }
    return $roleId;
}

Esempio n. 21

File: hunt_help.php Progetto: coyotetracks/PiutePonds

function getSeasonHunts($season)
{
    // Connect to database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $huntList = array();
    $findHuntsForSeasonSql = generateFindHuntsForSeasonSql($season);
    //var_dump($findHuntsForSeasonSql);
    $result = mysql_query($findHuntsForSeasonSql, $dbLink);
    $row = mysql_fetch_assoc($result);
    while ($row) {
        $oneHuntId = $row['d_id'];
        //echo("oneHuntId"); var_dump($oneHuntId); echo("<BR>");
        $oneHunt = getHuntById($oneHuntId);
        //echo("oneHunt"); var_dump($oneHunt); echo("<BR>");
        $huntList[] = $oneHunt;
        $row = mysql_fetch_assoc($result);
    }
    return $huntList;
}

Esempio n. 22

File: hunt_details_help.php Progetto: coyotetracks/PiutePonds

function getHuntsDetailsForASeason($season)
{
    // Connect to the Database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $huntDetailsList = array();
    $findAllHuntDetailsIdsSql = generateFindAllHuntDetailsForASeasonSql($season);
    var_dump($findAllHuntDetailsIdsSql);
    $result = mysql_query($findAllHuntDetailsIdsSql, $dbLink);
    $row = mysql_fetch_assoc($result);
    while ($row) {
        $oneHuntDetailId = createHuntDetailsFromRow($row);
        $row = mysql_fetch_assoc($result);
    }
    return $huntDetailsList;
}

Esempio n. 23

File: baseline_help.php Progetto: coyotetracks/PiutePonds

function removeAllBaselineHunts($season)
{
    // Connect to database
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $removeBaselineHuntsSql = generateRemoveBaselineHuntsSql($season);
    $resultSuccess = mysql_query($removeBaselineHuntsSql, $dbLink);
    if ($resultSuccess) {
        $affectedRowCount = mysql_affected_rows();
        echo "<br/><br/>" . $affectedRowCount . " Hunts Removed!</p>";
    } else {
        echo "<br/><br/>Error deleteing: " . mysql_error() . "</p>";
    }
}

Esempio n. 24

File: bagCheckHelp.php Progetto: coyotetracks/PiutePonds

function loadBagCheckSpecies($birdGroup, $blindIndex, $listIndex)
{
    // Make connection to the database.
    $dbInfo = initialize_db_info();
    $dbLink = db_connect($dbInfo);
    db_select($dbLink, $dbInfo);
    $speciesIndex = 0;
    $loadSpeciesSql = generateLoadSpeciesSql($birdGroup->getId());
    //jeff_dump_string("loadSpeciesSql", $loadSpeciesSql);
    $result = mysql_query($loadSpeciesSql, $dbLink);
    $row = mysql_fetch_assoc($result);
    while ($row) {
        $newSpecies = setSpeciesInfoWithRow($row);
        $newSpecies->setFieldIds($blindIndex, $listIndex, $speciesIndex);
        $birdGroup->appendSpecies($newSpecies);
        $row = mysql_fetch_assoc($result);
        $speciesIndex++;
    }
}