Very basic backend job listing website


I am a CS frehsman working on a job listing website. I finished the front end and now I am working on the back end. I am building a page where the client will be able to add/remove a job from the website. Each job has different attributes: title, type, location, salary, description, keywords[] and requirements[]. I am using mySQL and PHP. I have three different tables:

jobs table:


`title` text NOT NULL,

`type` text NOT NULL,

`location` text NOT NULL,

`salary` int(11) NOT NULL,

`description` text NOT NULL,

`date` date NOT NULL,

`job_id` int(11) NOT NULL AUTO_INCREMENT,

PRIMARY KEY (`job_id`)


keywords table:

CREATE TABLE `keywords` (

`keyword_id` int(11) NOT NULL AUTO_INCREMENT,

`keyword` text NOT NULL,

`job_id` int(11) NOT NULL,

PRIMARY KEY (`keyword_id`),

KEY `job_id` (`job_id`),

CONSTRAINT `keywords_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `jobs` (`job_id`)


my issue here is I am able to add a job in the jobs table but the keywords table never increment.

Your task:

- Help me to query for add each keywords in the database. One job may have multiple keywords.

Skills: PHP, MySQL

See more: job posting website requirements net, job posting website creation, Job Board Website, job post website code, design job posting website, job board website developer, integrate mls listing website, basic job posting website, add job listing feeds website, basic job board website, basic backend website, job listing website clone, creating job listing website, integrate job listing website, job listing html website, agile website cms login mysql php, job listing website, very basic website design, Logo design for a job listing website

About the Employer:
( 13 reviews ) Miami, United States

Project ID: #21190072

Awarded to:


Hi There, I already done same kind of work before. I'm interested in your project. I have checked your project description well. Please send me a message so that we can discuss more. I will start your work right now More

$25 USD in 1 day
(30 Reviews)

13 freelancers are bidding on average $28 for this job


Hello hiring member i hope you are doing well i am bhavika i have 4+years experience in php , laravel ,ajax ,jqeury , javascript , html ,css , bootstrap , mysql and many another things i have done many job with this al More

$25 USD in 1 day
(181 Reviews)

I can get it fixed. Please check my reviews and then decide on me. I'm available now to get this done quickly. Thanks, Ajit

$30 USD in 1 day
(278 Reviews)

Dear Sir/Madam, Greetings! I have read the requirements carefully and interested to work on it. My Relevant Experience: I have 7+ years of experience in Core PHP, Laravel Framework, CodeIgniter Framework, HTML, CS More

$50 USD in 1 day
(93 Reviews)

John C. could you please inbox me more detail about this project ==== Ready for an Immediate start ==== Based on your mentioned set of requirements…. I I am an expert web designer/developer and have extensive experien More

$25 USD in 4 days
(47 Reviews)

Hi, I have done this before but I have a few questions, can we chat please? I have 10 years of experience in PHP.

$10 USD in 7 days
(60 Reviews)

We are an experienced Word Press Developer & webmaster and We can set up an entire WP site from hosting setup and installation to plug-in configurations and theme customization. We have managed to successfully develop More

$20 USD in 7 days
(10 Reviews)

Dear Hiring Manager, I read your job description and I am confident that I can exceed your expectations. I am a professional programmer on PHP+MySQL+WordPress. Please have a look at my recent work for WordPress : 1. More

$20 USD in 7 days
(28 Reviews)

Hello sir, After reviewing your post, I am very interested in that due to my experience. I'm expertise in php, core php, CMS, HTML5, bootstrap, wordPress and many other technologies. I have 8+ year of experience in de More

$20 USD in 7 days
(42 Reviews)

Hi, I have read your job description and I will definitely help you out on this. I have a good experience on PHP, CodeIgniter, JavaScript, WordPress, Python, Django, HTML, CSS and also have a knowledge of Google Analy More

$50 USD in 7 days
(18 Reviews)

Hello sir, Hope you are doing well. i have 6+ years of experience in WordPress php codeigniter html css mysql javascript bootstrap graphic design website design etc. these job suitable for me Kind Regards, purvi

$30 USD in 7 days
(24 Reviews)

Hi, Sure, I will create query for add each keywords in the database. I am expert in web development and designing . I am expert in mysql. I am waiting your good response Thanks Shikha

$30 USD in 1 day
(1 Review)
$25 USD in 1 day
(0 Reviews)