PHP ParentPagerHousehold::CreateOrUpdateForMsSqlRow Exemples

Exemple #1

Fichier : get-data.cli.php Projet : alcf/chms

    $objRow = GetRowForTableColumnRow($strTableName, $strPkColumnName, $objRow);
    ParentPagerProgram::CreateOrUpdateForMsSqlRow($objRow);
}
////////////////////////////
// ParentPager Household
////////////////////////////
$strTableName = 'tblHousehold';
$strPkColumnName = 'lngHouseHoldID';
$intRowCount = GetRowCount($strTableName);
$intCurrentRow = 0;
$objResult = GetPkResultForTableColumn($strTableName, $strPkColumnName);
while ($objRow = mssql_fetch_assoc($objResult)) {
    printf('[%5s/%5s]', $intCurrentRow++, $intRowCount);
    $objRow = GetRowForTableColumnRow($strTableName, $strPkColumnName, $objRow);
    print '  -  ID #' . $objRow[$strPkColumnName] . '  -  ' . $objRow['strHouseHold'] . "\r\n";
    ParentPagerHousehold::CreateOrUpdateForMsSqlRow($objRow);
}
///////////////////////////
// ParentPager Individual
////////////////////////////
$strTableName = 'tblIndividual';
$strPkColumnName = 'lngIndividualID';
$intRowCount = GetRowCount($strTableName);
$intCurrentRow = 0;
$objResult = GetPkResultForTableColumn($strTableName, $strPkColumnName);
while ($objRow = mssql_fetch_assoc($objResult)) {
    printf('[%5s/%5s]', $intCurrentRow++, $intRowCount);
    $objRow = GetRowForTableColumnRow($strTableName, $strPkColumnName, $objRow);
    print '  -  ID #' . $objRow[$strPkColumnName] . '  -  ' . $objRow['strFirstName'] . ' ' . $objRow['strLastName'] . "\r\n";
    ParentPagerIndividual::CreateOrUpdateForMsSqlRow($objRow);
}