Find Jobs
Hire Freelancers

Very basic backend job listing website

$10-30 USD

Completed
Posted over 4 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 21190072

About the project

13 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 and get it done as per your deadline. My Motion: "No Satisfaction, No Páyment" We have expertise in Web Design & Development. I would like to tell you that I have 7+ years of experience in web and eCommerce software creation and management. Please check our client reviews to determine the quality of our work. Some clients are repeat to me assign works. I We have expertise in Web Design & Development. I would like to tell you that I have 3+ Codeigniter, WordPress, PHP, OpenCart, Shopify, HTML, CSS, MySQL, JavaScript, Ajax Bootstrap, Graphic Design, Website design etc. I am very hard working and always deliver the work on time. My Motive is to make my employer happy without adding additional charges. 100% Jobs Completed 100% On Time Recent PHP Website Work: [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] and more.. Please visit our profile reviews to make confidence working with us https://www.freelancer.com/u/vadden?w=f#/reviews More work and client Reference can be provided on demand! Looking forward to your response. Thanks, with regards Vipul Jethva
$25 USD in 1 day
5.0 (30 reviews)
4.7
4.7
13 freelancers are bidding on average $28 USD for this job
User Avatar
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 all things i can start this right now so please give me chance to serve you thanks in advance :)
$25 USD in 1 day
5.0 (181 reviews)
7.0
7.0
User Avatar
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
4.9 (278 reviews)
6.8
6.8
User Avatar
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, CSS, Bootstrap, JavaScript, Jquery and PSD. Please enable chat for further details and discussion. Looking forward to your positive response. Best Regards: Sarita Mahar
$50 USD in 1 day
4.9 (93 reviews)
6.2
6.2
User Avatar
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
4.6 (60 reviews)
5.8
5.8
User Avatar
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 development & designing. Just give me a response and I assure you won't be disappointed. Looking forward to hear from you and hoping for a long term work relationship. I will satisfy you. Best regards,
$20 USD in 7 days
4.6 (42 reviews)
5.3
5.3
User Avatar
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
4.7 (24 reviews)
4.6
4.6
User Avatar
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.4 (1 review)
1.7
1.7

About the client

Flag of UNITED STATES
Miami, United States
4.4
13
Payment method verified
Member since Nov 6, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.