compare two array and return id if array match

Question

I am working in codeigniter. I have two table job_post and snapshot.I have written query to fetch data from above table like :

Query1 :

select skill from snapshot where user_id = 1

and it gives and array like :

Array
(
[0] => stdClass Object
    (
        [skill] => 1,2
    )
)

Query2 :

select emp_id,skill from job_post

and this query return array like this :

Array
(
[0] => stdClass Object
    (
        [emp_id] => 10
        [skill] => 1,2,3
    )

[1] => stdClass Object
    (
        [emp_id] => 10
        [skill] => 3,12,13
    )
)

Now, I want to match these to array. If query1 skill match with the query2 skill then its return emp_id. So how can I get that emp_id?

Note : Partical match with query1 and query2

Full match or partial match?

Sougata Bose
– Sougata Bose

2016-04-05 12:11:22 +00:00
Commented Apr 5, 2016 at 12:11 — Sougata Bose
– Sougata Bose, Commented Apr 5, 2016 at 12:11
@Sougata partial match

Nisarg Bhavsar
– Nisarg Bhavsar

2016-04-05 12:12:20 +00:00
Commented Apr 5, 2016 at 12:12 — Nisarg Bhavsar
– Nisarg Bhavsar, Commented Apr 5, 2016 at 12:12
Please show us what you have tried in order to achieve this

Epodax
– Epodax

2016-04-05 12:13:00 +00:00
Commented Apr 5, 2016 at 12:13 — Epodax
– Epodax, Commented Apr 5, 2016 at 12:13
Ok. SO have you tried anything?

Sougata Bose
– Sougata Bose

2016-04-05 12:16:41 +00:00
Commented Apr 5, 2016 at 12:16 — Sougata Bose
– Sougata Bose, Commented Apr 5, 2016 at 12:16
No, because i dont have any idea about it.

Nisarg Bhavsar
– Nisarg Bhavsar

2016-04-05 12:18:43 +00:00
Commented Apr 5, 2016 at 12:18 — Nisarg Bhavsar
– Nisarg Bhavsar, Commented Apr 5, 2016 at 12:18

Dipanwita Kundu · Accepted Answer · 2016-04-06 07:28:41Z

1

Store below query's response in a variable lets say in $mySkill.

select skill from snapshot where user_id = 1;

"select emp_id,skill from job_post where concat(',',skill,',') like '%,".$mySkill.",%'"

Alternative: you need to explode $myskill & then need to create or condition dynamically.like:

$arrmyskill = explode(",",$mySkill); 
foreach($arrmyskill as $skill )
{ 
   $str .=" or concat(',',skill,',') like '%,".$skill.",%' ";
} 
$finalqry = "select emp_id,skill from job_post where concat(',',skill,',') like '%".$mySkill."%'" .$str;

edited Apr 6, 2016 at 7:28

answered Apr 5, 2016 at 12:41

Dipanwita Kundu

1,6451 gold badge10 silver badges14 bronze badges

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

3 Comments

Nisarg Bhavsar Over a year ago

Here I have a problem. it find skill as 1 and 2 in job_post table.If both skill are match then it will return.

Nisarg Bhavsar Over a year ago

Here I have skill as 1 den it match with 11 so its gives wrong result and i remove % then it does not give any output that match with exact 1. so what can i do?

Dipanwita Kundu Over a year ago

I am very sorry, missed the comma...Please check my edited post

Manjeet Barnala · Accepted Answer · 2016-04-05 12:21:57Z

0

Try this code, it will solve your problem

<?php 
$arr1 = array('skill'=> '1,2,3');
$arr2 = array(array('emp_id'=>1,'skill'=> '1,2,3'),array('emp_id'=>1,'skill'=> '1,2,4'));
foreach($arr2 as $key => $val)
{
    if($val['skill']== $arr1['skill'])
    {
        echo 'Matched Id :'.$val['emp_id'];
    }
}
?>

this will output :

Matched Id :1

answered Apr 5, 2016 at 12:21

Manjeet Barnala

2,9951 gold badge13 silver badges21 bronze badges

Comments

mitkosoft · Accepted Answer · 2016-04-05 12:26:53Z

0

Why not use single SQL query to JOIN both tables? If any skill(s) matches, the query will give you needed emp_id with matched skills in addition.

SELECT
    j.emp_id,
    GROUP_CONCAT(j.skill) AS skills
FROM
    job_post j
    INNER JOIN `snapshot` s ON s.skill = j.skill
WHERE
    s.user_id = 1
GROUP BY
    j.emp_id

answered Apr 5, 2016 at 12:26

mitkosoft

5,3361 gold badge15 silver badges32 bronze badges

Collectives™ on Stack Overflow

compare two array and return id if array match

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related