PHP formatSqlStringValue Exemples

Exemple #1

Fichier : sql_help.php Projet : coyotetracks/PiutePonds

function formatSqlSetStringValue($columnName, $stringValue, $addComa)
{
    $formattedValue = $columnName;
    $formattedValue .= "=";
    $formattedValue .= formatSqlStringValue($stringValue, $addComa);
    return $formattedValue;
}

Exemple #2

Fichier : bagCheckNoteHelp.php Projet : coyotetracks/PiutePonds

function generateInsertNoteSql($noteContent)
{
    $insertSql = "";
    $insertSql .= "INSERT INTO bc_note (bc_note, bc_created, bc_modified) VALUES(";
    $insertSql .= formatSqlStringValue($noteContent, true);
    $insertSql .= formatSqlStringValue(getNow(), true);
    $insertSql .= formatSqlStringValue(getNow(), false);
    $insertSql .= ")";
    return $insertSql;
}

Exemple #3

Fichier : EventLogManager.php Projet : coyotetracks/PiutePonds

function generateEventInsertSql($event)
{
    $sql = "INSERT ";
    $sql .= "INTO event_log ";
    $sql .= "(create_date, type, message) ";
    $sql .= "VALUES (";
    $sql .= formatSqlDateValue($event->getCreateDate(), true);
    $sql .= formatSqlStringValue($event->getType(), true);
    $sql .= formatSqlStringValue($event->getMessage(), false);
    $sql .= ")";
    return $sql;
}

Exemple #4

Fichier : hunt_count_report_help.php Projet : coyotetracks/PiutePonds

function generateHuntCountReportInsertSql($huntReportId, $huntCount)
{
    $sql = "INSERT ";
    $sql .= "INTO hunt_count_report ";
    $sql .= "(hunt_id, species_id, species_count, created) ";
    $sql .= "VALUES (";
    $sql .= formatSqlNumericValue($huntReportId, true);
    $sql .= formatSqlStringValue($huntCount->getSpeciesId(), true);
    $sql .= formatSqlNumericValue($huntCount->getCount(), true);
    $sql .= formatSqlDateValue($huntCount->getCreated(), false);
    $sql .= ")";
    return $sql;
}

Exemple #5

Fichier : hunt_details_help.php Projet : coyotetracks/PiutePonds

function generateHuntDetailsInsertSql($huntDetails)
{
    $sql = "INSERT ";
    $sql .= "INTO hunt_details_ver ";
    $sql .= "(hunt_id, status, hunter_id, hunter_count, hunt_date, hunt_hours, car_count, blind_id, area_id, is_multi_blind, is_jump_shoot, is_bag_checked, created) ";
    $sql .= "VALUES (";
    $sql .= formatSqlNumericValue($huntDetails->getHuntId(), true);
    $sql .= formatSqlStringValue($huntDetails->getStatus(), true);
    $sql .= formatSqlNumericValue($huntDetails->getHunterId(), true);
    $sql .= formatSqlNumericValue($huntDetails->getHunterCount(), true);
    $sql .= formatSqlDateValue($huntDetails->getHuntDate(), true);
    $sql .= formatSqlNumericValue($huntDetails->getHuntHours(), true);
    $sql .= formatSqlNumericValue($huntDetails->getCarCount(), true);
    $sql .= formatSqlNumericValue($huntDetails->getBlindId(), true);
    $sql .= formatSqlNumericValue($huntDetails->getAreaId(), true);
    $sql .= formatSqlBooleanValue($huntDetails->isMultiBlind(), true);
    $sql .= formatSqlBooleanValue($huntDetails->isJumpShoot(), true);
    $sql .= formatSqlBooleanValue($huntDetails->isBagChecked(), true);
    $sql .= formatSqlDateValue($huntDetails->getCreated(), false);
    $sql .= ")";
    return $sql;
}

Exemple #6

Fichier : blind_help.php Projet : coyotetracks/PiutePonds

function generateUpdateStringValue($tableName, $year, $blindNumber, $priority, $columnName, $newValue)
{
    $sql = "UPDATE ";
    $sql .= $tableName;
    $sql .= " ";
    $sql .= "SET ";
    $sql .= $columnName;
    $sql .= "=";
    $sql .= formatSqlStringValue($newValue, false);
    $sql .= " ";
    $sql .= "WHERE year=";
    $sql .= $year;
    $sql .= " ";
    $sql .= "AND blind_number=";
    $sql .= $blindNumber;
    $sql .= " ";
    $sql .= "AND priority=";
    $sql .= $priority;
    return $sql;
}

Exemple #7

Fichier : hunt_report_help.php Projet : coyotetracks/PiutePonds

function generateHuntReportIdSql($huntReport)
{
    $sql = "SELECT id ";
    $sql .= "FROM hunt_report ";
    $sql .= " WHERE status = ";
    $sql .= formatSqlStringValue($huntReport->getStatus(), false);
    $sql .= " AND hunter_id = ";
    $sql .= formatSqlNumericValue($huntReport->getHunterId(), false);
    $sql .= " AND hunter_count = ";
    $sql .= formatSqlNumericValue($huntReport->getHunterCount(), false);
    $sql .= " AND hunt_date = ";
    $sql .= formatSqlDateValue($huntReport->getHuntDate(), false);
    $sql .= " AND hunt_hours = ";
    $sql .= formatSqlNumericValue($huntReport->getHuntHours(), false);
    $sql .= " AND car_count = ";
    $sql .= formatSqlNumericValue($huntReport->getCarCount(), false);
    $sql .= " AND blind_id = ";
    $sql .= formatSqlNumericValue($huntReport->getBlindId(), false);
    $sql .= " AND area_id = ";
    $sql .= formatSqlNumericValue($huntReport->getAreaId(), false);
    $sql .= " AND is_multi_blind = ";
    $sql .= formatSqlBooleanValue($huntReport->isMultiBlind(), false);
    $sql .= " AND is_jump_shoot = ";
    $sql .= formatSqlBooleanValue($huntReport->isJumpShoot(), false);
    $sql .= " AND is_bag_checked = ";
    $sql .= formatSqlBooleanValue($huntReport->isBagChecked(), false);
    $sql .= " AND created = ";
    $sql .= formatSqlDateValue($huntReport->getCreated(), false);
    return $sql;
}

Exemple #8

Fichier : bagCheckHelp.php Projet : coyotetracks/PiutePonds

function generateBCSpeciesInsertSql($oneSpecies, $birdGroupId, $speciesSeq)
{
    $insertSql = "";
    $insertSql .= "INSERT INTO bc_species (bird_group_id, bc_species_id, bc_harvest_count, bc_species_seq, bc_created, bc_modified) VALUES(";
    $insertSql .= formatSqlNumericValue($birdGroupId, true);
    $insertSql .= formatSqlStringValue($oneSpecies->getSpeciesId(), true);
    $insertSql .= formatSqlStringValue($oneSpecies->getHarvestCount(), true);
    $insertSql .= formatSqlNumericValue($speciesSeq, true);
    $insertSql .= formatSqlStringValue(getNow(), true);
    $insertSql .= formatSqlStringValue(getNow(), false);
    $insertSql .= ")";
    return $insertSql;
}