Em Andamento

Laravel - Need a short consultation

Job Description:

I have problem to making a search

I have 3 tables:

candidates:

id

name

teches: (technologies)

id

name

and pivot table

candidate_tech:

tech_id

candidate_id

Code:

public function index(Request $request)

{

$teches = Tech::latest()->get();

if ( null !== $request->input('search') ){

$technologies = $request->get('teches');

$email = $request->input('email');

$country = $request->input('country');

$fullName = $request->input('name');

$candidates= Candidate::where('email', 'LIKE', "%{$email}%")

->where('country', 'LIKE', "%{$country}%")

->where('first_name', 'LIKE', "%{$fullName}%")

->orWhere('last_name', 'LIKE', "%{$fullName}%")

->with('teches')->whereIn('id', $technologies)->get();

// ->whereHas('teches', function ($query) use($technologies) {

// $query->whereIn('id', $technologies);

// })->get();

return view('[login to view URL]')->with('candidates', $candidates)

->with('email', $email)

->with('country', $country)

->with('name', $fullName)

->with('teches', $teches);

} else {

$user_id = Auth::id();

$candidates = Candidate::latest()->paginate(10);

return view('[login to view URL]')->with('candidates', $candidates)->with('teches', $teches);

}

}

I need all the candidates with the searched technologies to be presented.

I need help

Habilidades: PHP, Laravel, MySQL

Sobre o Cliente:
( 1 comentário ) Sofia, Bulgaria

ID do Projeto: #35113397

Concedido a:

(8 Comentários)
4.1

29 freelancers estão ofertando em média €22 nesse trabalho

ShrineWeb

I have some questions in relation to the specifications that you have provided. Could we please have a chat? My Skills: PHP, MySQL and Laravel

€8 EUR in 7 dias
(122 Comentários)
6.6
kamransiyal9

HI! I am an expert web programmer. I am familiar with Laravel and I have a lot of work experience in Laravel, Codeigniter, PHP, Wordpress, JavaScript, HTML, Vuejs, Reactjs, React Native, and MySQL. I can start right aw Mais

€30 EUR em 1 dia
(109 Comentários)
6.5
edwarddzi8f

Hi there, This is a relationship issue I can help you as Laravel PHP expert. Being a senior Laravel Web developer and PHP professional, I will surely help your with your Laravel task as per your requirements with 100 Mais

€19 EUR in 7 dias
(32 Comentários)
5.7
MoShoeb

HI There i can try to help you with your SQL problem what results do you see after this commands on your wbesite?

€15 EUR em 1 dia
(19 Comentários)
4.4
scottwardell

+=+=+=+=+T r u s t & C r e d i t +=+=+=+=+=+ I am a senior Full stack developer with over 7 years of professional experience working with Python, PHP, JS. I am very familiar with Laravel frame work. I have experience c Mais

€19 EUR in 7 dias
(15 Comentários)
5.1
pavansharma2008

Hello there I have read your job description and perfect fit for this job because i have 9+ years experience in software development field and expertise in Laravel. Right now i am free for new project so let's discuss Mais

€30 EUR em 1 dia
(13 Comentários)
4.4
giang60

PHP Laravel EXPERT!!!!!!! Hi. I'm very interested in your project, I'll do it as fast as I can. I've read your requirements carefully and I'm ready. I' m now free, so I have no problem with investing all my availab Mais

€19 EUR in 7 dias
(5 Comentários)
3.3
ankitkaran99

Hello sir, I am a full stack developer working since 2016. I have experienced in Laravel, Codeigniter, React.js, Javascript, Node.js, Vue.js, React Native, SQL, MongoDB, Linux, Websocket, Wordpress, Scraping, Responsiv Mais

€20 EUR in 7 dias
(8 Comentários)
3.1
franciscoisaque4

*** I can finish in 1 hour max *** Start immediately !!! Best Regards,

€30 EUR em 1 dia
(4 Comentários)
2.7
ismailrehman0331

HI Darina, --- Kindly share the source code with me then I will resolve the problem smoothly. -- Regards, Ismail F.

€20 EUR in 7 dias
(10 Comentários)
3.7
ItsTahmina21

Hi, I read your project description. I am an expert laravel developer with 5 years of experience. I can write you the exact query you need within a very short time. I am expert in MySQL and laravel eloquent as well. P Mais

€20 EUR em 1 dia
(7 Comentários)
3.0
BixBytech

Greetings! As an experienced developer I have seen so many clients frustrated who have faced issues in their websites like you have, but don’t worry I have solved their issues and want to help you as well. I have been Mais

€15 EUR in 3 dias
(3 Comentários)
2.1
davidrstevens

hi, I have checked your code very carefully, so I have some methods to solve problems. I can handle your project on time. please contact me and discuss more. Best regards

€20 EUR in 7 dias
(1 Comentário)
2.0
saadimam6

Hello, I saw you are looking for a Laravel Dev here . I have been associated with Full Stack Development for the past 6 years+ and I have had experience of working with multiple global clients so far. Moreover, I have Mais

€19 EUR in 7 dias
(5 Comentários)
1.4
TsehelnykAlona

Hello, Warm Greetings!! I have been working as a website Developer for 5 years now. I would like to let you know that I have rich experience in Frontend/Backend, WordPress and Web scraping development. My skills are in Mais

€50 EUR em 1 dia
(1 Comentário)
1.4
sajithhameed112

Dear client, I just saw your job description and I am very interested in your project. I have a lot of experience over 5 years in Laravel. If you need to discuss any suggestions or information with me, please contact Mais

€20 EUR in 7 dias
(1 Comentário)
0.8
ykledel

Hello, i can help you in your project,, i have great experience with Laravel FRAMWOK. Please contact me to start working on your project. Best regards

€15 EUR in 2 dias
(1 Comentário)
0.6
bengrehl

Hi I have checked your problem and I can fix in short minutes. I want to discuss about this problem via chat. Thank you.

€30 EUR em 1 dia
(0 Comentários)
0.0