create mysql table, display data on php page

Σε Εξέλιξη Αναρτήθηκε Oct 2, 2013 Πληρώθηκε κατά την παράδοση
Σε Εξέλιξη

Currently we have a database with many tables. One of the tables has a list of companies. We want to create another table which lists products. Each company sells one or many products.

We need a secure user interface to link the companies with the associated products. Please propose a rough sketch of how you would design this page and how it would work.

We also want to develop a secure username/password table which we can use to access the secure user interface discussed above. And will use this same table to access other secure areas of our website for which currently each user uses various usernames and passwords.

Deliverables:

1. New mysql product table.

2. A secure and hidden web page to link the companies in the company table with the associated products they sell in the product table. 1 company to 1 or many products.

3. New username/password table that will be used to access the company product linking page.

Ideas to keep in mind:

1. The username/password table will in the future be used to access other secure areas of our site. Not all users will have access to all secure pages.

2. The product table is the first along these lines. If this is implemented well, we will be expanding to do a very similar linking of Brands with the companies.

3. The web page for linking companies and products should be expandable to incorporate linking brands as well in the future.

Must have knowledge of git and/or git flow. Or, be willing to add it to their repertoire on their own time.

CakePHP English (US) Translator MySQL PHP

Ταυτότητα Εργασίας: #4988111

Σχετικά με την εργασία

37 προτάσεις Απομακρυσμένη εργασία Ενεργό Oct 8, 2013

37 freelancers κάνουν προσφορά κατά μέσο όρο $12/ώρα για αυτή τη δουλειά

kchg

Hello, sir I'm interested with your project. I'll do it for you. I can do it well more than you can think. :) Regards.

$20 USD / ώρα
(429 Αξιολογήσεις)
9.6
rajeshsonisl

Hello, With 99% completion rate, 600 successfully completed projects, and a 5.00 reputation... you can never go wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni

$30 USD / ώρα
(1004 Αξιολογήσεις)
8.8
xtreemsolution

Hello Client Please discuss with me i have 4 years of experience in PHP frame work so please discuss We are the team of web professionals and we are very confident in Web based field to do anything we know to i Περισσότερα

$14 USD / ώρα
(134 Αξιολογήσεις)
8.6
searcheverything

Hi, Thanks for sharing the requirement, please have a look to my understanding below and let us know if we are on the same page, so that we can start the work ASAP. Our Understanding: As per our understanding we Περισσότερα

$10 USD / ώρα
(209 Αξιολογήσεις)
7.6
phpXpertbd

I can offer my high quality php programming services to you. phpXpertbd ready to start immediately. More details in PM. Thanks

$15 USD / ώρα
(69 Αξιολογήσεις)
7.2
webedeveloper

Experienced team specializing in Flash, PSD, LOGO, Banner, Corporate Identity, Flyer PSD to HTML, SLICING, HTML4, CSS2, HTML5, CSS3 Responsive Theme and open sources like Wordpress, Drupal, Joomla, Open Cart, PHP Frame Περισσότερα

$11 USD / ώρα
(108 Αξιολογήσεις)
7.0
luminous15

Hello There I think i can do this for you and help you achieve the task.. We will be using a session based approach and will link the tables via foreign key.. Also i can provide a way to create a secure area where o Περισσότερα

$8 USD / ώρα
(55 Αξιολογήσεις)
6.1
Churaliya

Hello Sir, I have good experiences in these kind of work. I can do this job for you ASAP. Please check my feedback and award me the project. If you want to see a sample work of mine please ask me. Thanks.

$10 USD / ώρα
(43 Αξιολογήσεις)
6.2
elboukharimu

Hi, I'm very interested helping you creating your mysql table and php page, I have years of experience in php websites, SQL and database administration, modeling, and manipulating, please do not hesitate to check my po Περισσότερα

$16 USD / ώρα
(27 Αξιολογήσεις)
5.1
kausik1985

Hi, I am kausik das and I am writing to you since I am interested in the job posting Senior Web Developer. Working with PHP, HTML/CSS and MYSQL, I have completed a number of projects that are relevant to the ski Περισσότερα

$8 USD / ώρα
(22 Αξιολογήσεις)
3.8
jibs1990

Interested to start the work for you. We are experienced in Web and Mobile development working over different technologies including open source PHP and also ASP.NET.

$8 USD / ώρα
(5 Αξιολογήσεις)
2.8
sohelmahfuz

Dear Sir, I have read all of your requirements. In product table you need company-id as foreign key from companies table so that every product is recognizable by company. Let's start it and finish. Quality work is ensu Περισσότερα

$8 USD / ώρα
(4 Αξιολογήσεις)
2.8
cwestbr2

This is a relatively simple project based on the specs. The product table would consist of a primary unique key, company code, product id, product description. The users table would have a unique key, user name, emai Περισσότερα

$12 USD / ώρα
(3 Αξιολογήσεις)
3.0
jmclement

Hello, I'm experienced PHP/MySQL developer and I can help you with your application. You need 2 interface, 1 for "public" and 1 for "administrator", public will allow ppl to see the products based on compagnies selecti Περισσότερα

$27 USD / ώρα
(4 Αξιολογήσεις)
3.2
skynine

hi , i am ready to work with you on least amount while giving you better quality then any other one !! the reason is just to create a long term realtions with you and your organization !! i am having more then 5years e Περισσότερα

$9 USD / ώρα
(4 Αξιολογήσεις)
3.9
brij420

Hi, I have gone through your requirement.I can develop in PHP/Python/Java. Please let me know when to start. My Working style:- -Requirement Analysys -System Design and Database Design -Development by Περισσότερα

$12 USD / ώρα
(1 Κριτική)
0.0
rubengarcia0510

Hi I think you can install joomla with some plugin to manage the back and frontend I have experience with virtuemart, but i think, you can use any other, like sobipro

$12 USD / ώρα
(0 Αξιολογήσεις)
0.0
aakashidesai

Hi, I have delivered a similar project using cakePHP which is also pertaining to an organisation and required to manage various modules of the organisation using role based authentication. I can quickly deliver the Περισσότερα

$11 USD / ώρα
(0 Αξιολογήσεις)
0.0
vasyliikhal

I can do it. But I need more information to specify the time and cost of the project. I hope that the cooperation will be beneficial

$11 USD / ώρα
(0 Αξιολογήσεις)
0.0
parijat1982

I had worked on these kind of requirements several times in CakePHP. Though I am a new in freelancer.com, I am an expert in the CakePHP. I would work on your project daily and will be able to finish it in few hours Περισσότερα

$9 USD / ώρα
(0 Αξιολογήσεις)
0.0