Add MySql queries in PHP pages
€30-250 EUR
Pagado a la entrega
I need a developer to add mysql queries into a php software.
The software is very simple:
a database of companies and calls that are made to these companies
This is the structure:
- Login page
- Home page: here there are 3 independent fields of research:
search by company search by person name, search by zip.
Each search sent to a page with the results placed in the list, a result for each page.
Important: case sensitive: upper or lower have to be the same. And could be more then one single word (i.e. name surname")
Under the fields of research there are the actions "to do today" (check server date and "date_to_call" field into calls table).
This is a list with the data taken from the database, paged in 10 results per page.
- Search Result Page: paginated with a single record per page, same structure as "to do today".
Edit/Delete Companies Page: a page with records from companies tables in table, button "edit" and checkbox and buttons "delete selected records" with confirm request.
The database has two tables:
companies: contains preload data, should not be modified.
Calls: These data should be entered and modified, not eliminated. This table has a idcompany to be connected to the id in the table companies.
Each company will have more calls to be included in the table calls.
The list is as follows:
each record begins with company data (static) and under will have the last call (by date created), then inside an accordion called "call history", there are other calls related to that company.
In the record, there will be these buttons:
"add new call" that opens a popup with the data to be inserted into the table calls.
"edit" change the data previously entered.
"next" and "previous" to go to next and previous record.
The software currently take only the data from the table companies show that, so all pages are already built in php with paging, you only need to enter queries.
I will give all pages, db with samples data and detailed instructions about commented code.
Nº del proyecto: #2505058
Sobre el proyecto
Adjudicado a:
21 freelancers están ofertando un promedio de €86 por este trabajo
My name is Oriol Sala, I'm a web developer passionate about web design & development especially PHP, MySQL, jQuery, AJAX Oriol
Expert Software engineer, with strong background in object oriented programming and Datebases and web devolopment.
I am an expert in mysql database and have much experience in php programming. I am ready to take this project and begin work immediately.
Hi, We web expert in web development. It would be our pleasure, to have the chance to work with you. Your satisfaction is 100% Guaranteed! Many thanks!
I am a web developer by profession and work on PHP and MySQL. I can complete the work in said timeframe.