private function fun_NWMLS_updateRecord($My_DB, $My_Table, $ID, $ID_Name, $arData)
{
unset($arData['ImportID']);
//print_r($arData);
$arUpdate[$ID_Name] = $ID;
foreach ($arData as $Field => $Value) {
$arUpdate[$Field] = $Value;
}
// $strData = implode(",", $arUpdate);
// $query = "UPDATE `$My_DB`.`$My_Table` SET $strData WHERE ($ID_Name='$ID')";
// fun_SQLQuery($query, $WantRC=0, $WantLID=0, $rtnRC="", $rtnLID="", $OtherDBConn="", $arVar="");
//
echo "\nfun_NWMLS_updateRecord:[[";
//print_r($arUpdate);
fun_Mysql_Update_Data($My_DB, $My_Table, $arUpdate, $ID_Name, $rtnError);
echo "]]:fun_NWMLS_updateRecord\n";
return $ID;
}
function endHandler($parser, $name)
{
global $Count, $arData, $Name, $CountNodes;
//debug
//echo "$Count.$name\n";
$Node = $this->CVSNode;
if (preg_match("/\\b{$Node}\\b/i", $name)) {
echo "\n({$CountNodes})Class_xml2mysql:(CurrentNode:({$Node}),MyNode:({$name})-> Inserting:[[";
//insert mysql data
$LastID = fun_MySQL_Insert_Data($this->DB, $this->New_Table, $arData);
$arData = "";
//reset this var for new node
//add custom field on insert of data, so to mark it for other uses
if ($this->AddCustomField) {
$AddCustomField = $this->AddCustomField;
$ID_Name = fun_Mysql_getPrimaryKeyColumn($this->DB, $this->New_Table, $OtherDBConn = "");
$arData[$ID_Name] = "{$LastID}";
$arData[$AddCustomField] = "1";
fun_Mysql_Update_Data($this->DB, $this->New_Table, $arData, $ID_Name = "", $rtnError = "");
$arData = "";
}
echo "]]\n";
$CountNodes++;
}
}
/**
* Import CSV2MySQL by File
* @param $DB string mysql database
* @param $Table string mysql table "import_sc_sales_2";
* @param $Table_ID_Name string mysql unique id column/field "ID";
* @param $csv_file string file to import or sync "/srv/hosting_files/tmp/allsales.csv";
* @param $EndRowCount integer stop earlier than end of file
* @param $sync bol update|Drop and Insert current data if id exists in table
*
*/
function fun_Mysql_Import_CSV($DB, $Table, $Table_ID_Name, $csv_file, $EndRowCount, $Delimiter = ",", $Enclosure = "\"", $NoFieldsInRow0 = "", $Sync = 0)
{
global $conn1;
$Enclosure = trim($Enclosure);
//had a problem of 'space"'
echo "\n\n<pre>\n";
echo "\n\n\nStarting CSV Importing *************************************************\n";
echo "\tProcessing: Delimiter:({$Delimiter}) Enclosure:({$Enclosure}) File:({$csv_file}), Sync:({$Sync})\n";
echo "\tTable({$Table}) Table_ID_Name({$Table_ID_Name})\n\n";
if (!is_file($csv_file)) {
echo "\n\nERROR: No CSV File\n\n";
return FALSE;
}
if (!$Table) {
$path_parts = pathinfo($csv_file);
$Table = $path_parts['basename'];
$Table = fun_Mysql_Check_TableorField_Name($Table);
//fix it if need be
$Table = "Import_{$Table}";
}
if (!$Table_ID_Name) {
$Table_ID_Name = "ImportID";
}
//Make Table - don't drop it if we want to sync
if ($Sync) {
$Drop = 0;
}
fun_Mysql_Create_Table($Table, $Table_ID_Name, $DB, $Drop);
//get fields from first line of csv
$row = 0;
$NewCount = 0;
$handle = fopen($csv_file, "r");
//open csv file
while (($arData = fgetcsv($handle, 0, $Delimiter, $Enclosure)) !== FALSE) {
//debug
echo "\ndump[arData:";
var_dump($arData);
//echo "\ntest2:";
//$test[] = "Abcd6";
//echo var_dump($test);
if (count($arData) > $NewCount) {
$NewCount = count($arData);
}
if (count($arData) < $NewCount) {
echo "Row Error Row:({$row}) RowFieldCount:({$NewCount})\n";
$theDiff = $NewCount - count($arData);
//get by with this fix maybe for now (when something is wrong with row count of fields/data)
for ($i = 0; $i < $theDiff; $i++) {
$arData[] = "";
}
}
//debug
echo "Row:({$row}) Extracted fields Start DataFieldsCount:({$NewCount}) NoFieldsInRow0:({$NoFieldsInRow0})\n";
print_r($arData);
echo "Row:({$row}) END\n";
//echo row for seeing debug and progress
echo "Row:({$row}) Processing[[";
if ($row == 0) {
$arColumns = fun_Mysql_Create_Columns($arData, $Table, $Table_ID_Name, $DB, $NoFieldsInRow0);
} else {
if ($Sync) {
$i = 0;
foreach ($arColumns as $Column) {
$arUpdate[$Column] = $arData[$i];
$i++;
}
fun_Mysql_Update_Data($DB, $Table, $arUpdate, $Table_ID_Name, $rtnError);
if ($rtnError) {
echo "\nERROR:{$rtnError}\n";
unset($rtnError);
}
} else {
fun_Mysql_Insert_Import_Data($arData, $Table, $DB);
}
//debug
//die("death early\n");
}
echo "]]Row:({$row}) END Processing\n";
$row++;
//debug
if ($EndRowCount != "" and $row == $EndRowCount) {
exit("\n\n Done Early \n\n");
}
}
fclose($handle);
echo "\nThe End -> fun_mysql_import_csv.php *************************************************\n";
echo "</pre>\n";
$Pass = 1;
//if we make it this far its good
return $Pass;
}