Very basic backend job listing website

$10-30 USD

Teljesítve

Kiadva ekkor:

több mint 4 évvel ezelőtt

$10-30 USD

Teljesítéskor fizetve

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.

PHP

MySQL

Projektazonosító: 21190072

A projektről

13 ajánlat

Távolról teljesíthető projekt

Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

Neki odaítélve:

@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 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 1 napon belül

5,0

(30 értékelés)

4,7

13 szabadúszó adott átlagosan $28 USD összegű árajánlatot erre a munkára

@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 all things i can start this right now so please give me chance to serve you thanks in advance :)

$25 USD 1 napon belül

5,0

(181 értékelés)

7,0

@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 1 napon belül

4,9

(278 értékelés)

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, 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 1 napon belül

4,9

(93 értékelés)

6,2

@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 7 napon belül

4,6

(60 értékelés)

5,8

@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 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 7 napon belül

4,6

(42 értékelés)

5,3

@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 7 napon belül

4,7

(24 értékelés)

4,6

@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 1 napon belül