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:
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;
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.
- Help me to query for add each keywords in the database. One job may have multiple keywords.
16 freelancers are bidding on average $26 for this job
*****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.
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