php - Foreach in foreach check data?

Solution:

Considering you'll have unique value pertax_number in your table. You should make thistax_number column as unique.

ALTER TABLE `current`
    ADD UNIQUE INDEX `tax_number` (`tax_number`);
Copy code

Once done you can use mysql INSERT ... ON DUPLICATE KEY UPDATE feature to insert a record or update existing record in single query for a given tax_number.

Considering you havecol1,col2 andtax_number as columns in your table and you want to updatecol1 if this record already exists. So mysql query would be

INSERT INTO `current` (col1, col2, tax_number) 
VALUES ('a', 'b', 12345)
ON DUPLICATE KEY UPDATE col1 = 'a';
Copy code

Note: Your code is vulnerable tosql injection, make sure you update your code by PDO with parameter binding.

So corresponding code in php would be like this.

$current = simplexml_load_file('http://example.com/simple.xml');

foreach($current->simple as $item){

    $query = $db->prepare('INSERT INTO current (currentDocumentNumber, currentTaxNumber, currentIdentity,currentOperationType,currentAmountOfDebt,currentAmountDue,currentAccountDate)
                VALUES (:doc_number, :tax_number, :identity, :operation_type, :debt_amount, :due_amount, :date)
                ON DUPLICATE KEY UPDATE currentAmountOfDebt = :debt_amount, currentAmountDue = :due_amount');
   
    $query->bindParam(':doc_number', $item->EVRAK_NO, PDO::PARAM_STR);
    $query->bindParam(':tax_number', $item->VERGI_NO, PDO::PARAM_INT);
    $query->bindParam(':identity', $item->TC_KIMLIK_NO, PDO::PARAM_STR);
    $query->bindParam(':operation_type', $item->ISLEM_TURU, PDO::PARAM_INT);
    $query->bindParam(':debt_amount', $item->KPB_BTUT, PDO::PARAM_STR);
    $query->bindParam(':due_amount', $item->KPB_ATUT, PDO::PARAM_STR);
    $query->bindParam(':date', $item->TARIHI, PDO::PARAM_STR);
    $query->execute();
}
Copy code

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.