Completed

Very basic backend job listing website

Hello,

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:

CREATE TABLE `jobs` (

`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`)

) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;

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`)

) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

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:
( 9 reviews ) Miami, United States

Project ID: #21190072

Awarded to:

vadden

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
(17 Reviews)
3.8

16 freelancers are bidding on average $26 for this job

bjrupani

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
(134 Reviews)
6.6
csajit

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)
6.8
saritamahar

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
(90 Reviews)
6.2
amitbanerjee2812

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)
5.4
ShrineWeb

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
(44 Reviews)
5.6
himeshsharma92

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
(16 Reviews)
4.6
kdwebsolution9

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
(21 Reviews)
4.6
poojaexpertz

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
(21 Reviews)
4.4
monikadevm

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
(9 Reviews)
3.5
bharat1977

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
(8 Reviews)
3.5
MarsCharmer

Hello. ******************* I am ready to start if you hire me**************** I will provide result in few hrs.

$20 USD in 1 day
(7 Reviews)
3.2
kostya1207

*****Hello, dear!!!***** I have read your description carefully. I can handle it with full confidence and have already done this type of projects. Please give me an opportunity to work with you.

$20 USD in 7 days
(7 Reviews)
2.9
netforthoffpage

Hi there, As an experienced PHP developer, I analyze your issuse after reviewed the given code. Interact with me, I will assist you now. Thanks!

$20 USD in 1 day
(0 Reviews)
0.0
projectsTF

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
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0