Inserting data and/or Updating database using CSV

Question

So I've been working on this for some time, but i cant seem to figure out how to get it to work.

I want to update the prices of a product in the database if the product id is there, if it's not there i want it to insert the new id and it's prices.

Using the code below it updates the database, however it does not insert anything if the id is not there.

Any clues on what's gone wrong?

With thanks
Jim

EDIT

This works for me:

$count = mysql_num_rows(mysql_query("SELECT id FROM products WHERE id = '$id'"));



            if ($count == 1){

            mysql_query("UPDATE products SET price='$price',ordprice='$ordprice' WHERE id='$id'");

            }elseif($count == 0){

            mysql_query("INSERT INTO products (id,price,ordprice) VALUES ('$id','$price','$ordprice')");
            }

/EDIT

if(isset($_POST['submit']))
    {
        $file = $_FILES['file']['tmp_name'];

        $handle = fopen($file,"r");
        while(($fileop = fgetcsv($handle,10000,";")) !== false)
        {
            $id = $fileop[0];
            $price = $fileop[1];
            $ordprice = $fileop[2];


            $count = mysql_num_rows(mysql_query("SELECT id FROM products WHERE id = '$id'"));



            if ($count = $id){

            mysql_query("UPDATE products SET price='$price',ordprice='$ordprice' WHERE id='$id'");

            }elseif($id != $count){

            mysql_query("INSERT INTO products (id,price,ordprice) VALUES ('$id','$price','$ordprice')");
            }

Hugh Downer · Accepted Answer · 2013-06-20 11:12:45Z

4

At first glance, this line:

 if ($count = $id){

will always equate to true, so try:

 if ($count == $id){

However, I think count will always return 1 (or zero if no record found) and wont ever match the id from the csv.

Instead pull the record from the database with mysql_fetch_assoc and compare the id field from the database with from your csv

answered Jun 20, 2013 at 11:12

Hugh Downer

1066 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jim Sundqvist Over a year ago

"However, I think count will always return 1 (or zero if no record found)" This line made it possible for me. I will update the original question with the solution i made

BudwiseЯ · Accepted Answer · 2013-06-20 11:29:19Z

1

Besides what Hugh Downer said, you're facing another problem.

You're assigning to $count the value returned by mysql_num_rows which seems not to be the value you want.

You're comparing $count to $id to find out if they match. If I assume correctly that your id in the database is unique, $count will never be other than 0 or 1.

So try this:

if ($result = mysql_query("SELECT id FROM products WHERE id = $id")) {
    $row = mysql_fetch_array($result);
    $id2 = $row['id'];
}
else {
    $id2 = NULL;
}

if ($id == $id2) {
    // match found, do the insert magic
}
else {
    // update here
}

edited Jun 20, 2013 at 11:29

answered Jun 20, 2013 at 11:24

BudwiseЯ

1,8262 gold badges16 silver badges28 bronze badges

2 Comments

Jim Sundqvist Over a year ago

"You're comparing $count to $id to find out if they match. If I assume correctly that your id in the database is unique, $count will never be other than 0 or 1." This line made it possible for me. I will update the original question with the solution i made

Jim Sundqvist Over a year ago

I don't think i have the reputation to do that, or i do not know how to do it :)

Collectives™ on Stack Overflow

Inserting data and/or Updating database using CSV

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related