2. PHPRunner General questions
  3. Creating a Simple PHP To Compare Uploaded CSV file
This topic is locked

Creating a Simple PHP To Compare Uploaded CSV file

 		1/2/2019 4:10:55 AM
PHPRunner General questions
J
 justinkongyt author

Hi everyone,
Happy new year to you.
Sorry to trouble you guys, I got a question to ask. Is there any way I can do a php in such a way:

  1. mysql consists of 2 tables containing only 1 field each. Each field is a series of 8 digit numbers
  2. I need a function that allows me to upload another csv list so that it will compare the entries in the CSV with both the tables for matching numbers.
  3. Any matching numbers in table 1 and table 2 will be removed from the csv and I will download the balance data minus the numbers contained in table 1 and table 2.
    Hope I don't sound confusing, can anyone point me in the right direction?
    Thanks!!

    Justin
lefty 1/2/2019

Where are you uploading/importing the csv file too? Another table 3? or both tables or which table 1 or 2?
J
 		justinkongyt author 1/2/2019



Where are you uploading/importing the csv file too? Another table 3? or both tables or which table 1 or 2?



Hi John,
I can upload it into a temporary table 3 for it to compare. After which I will download the unique numbers and the content in table

3 can be deleted.