Laravel - Need a short consultation
Orçamento €8-30 EUR
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
Concedido a:
29 freelancers estão ofertando em média €22 nesse trabalho
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
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
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
HI There i can try to help you with your SQL problem what results do you see after this commands on your wbesite?
+=+=+=+=+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
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
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
HI Darina, --- Kindly share the source code with me then I will resolve the problem smoothly. -- Regards, Ismail F.
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
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
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
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
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
Hi I have checked your problem and I can fix in short minutes. I want to discuss about this problem via chat. Thank you.
