if($data->edit_flag == 'ADDED')
        {

            $rowdata[0] =   $data->location_name;
            $rowdata[1] =   0;
            $rowdata[2] =   $data->store_id;

            $query = "INSERT IGNORE INTO store_locations (location_name,total_items, store_id) VALUES (?,?,?)";

            $statement = $conn->prepare($query);
            $statement->execute($rowdata);
            $id = mysqli_stmt_insert_id($statement);
            echo "inserted id: " . $id;
        }

$id = $conn->lastInsertId();
echo "insert id: " . $id;

$statement = $conn->prepare($query);
$statement->execute($rowdata);