In Progress

Add MySql queries in PHP pages

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.

Skills: Javascript, MySQL, PHP

See more: today javascript, tables data structure, software developer home, php independent developer, php developer home, login php code mysql, in php, data software research company, database one word two, queries, php software structure mysql, php pages, independent php developer, database queries, mysql code search, placed call, mysql add fields, list checkbox popup, change checkbox, mysql structure, mysql delete, mysql add record, popup php, word add date, javascript history change

About the Employer:
( 5 reviews ) Milano, Italy

Project ID: #2505058

Awarded to:

WikiSolutions

Please check PMB for details, Thanks.

€50 EUR in 1 day
(40 Reviews)
6.2

22 freelancers are bidding on average €85 for this job

toinnisfree

pls chk pmb

€135 EUR in 2 days
(628 Reviews)
8.1
tomydeveloper

Hello,We are php / mysql expert.Ready to create MySql queries in PHP pages.Please check pmb for portfolio.Thanks

€100 EUR in 4 days
(260 Reviews)
7.7
dinotech

understood your requirement and ready to start...................

€250 EUR in 3 days
(109 Reviews)
7.1
aliarshad9691

Dear, I can develop exactly what you are looking for, please check PMB...

€120 EUR in 2 days
(38 Reviews)
6.5
annsys

Hi I am ready start the work.

€30 EUR in 1 day
(209 Reviews)
6.4
frkSuna

I can do it right now.

€99 EUR in 1 day
(120 Reviews)
6.1
AdamsK

Ready for service sir, thanks.

€30 EUR in 1 day
(95 Reviews)
5.7
MakeYouBelieve

Hello, I'm expert pure PHP. Thanks.

€50 EUR in 2 days
(44 Reviews)
4.7
serpentscode

Hello, I fully understanded the project, and I'm ready to start! Andy.

€50 EUR in 1 day
(32 Reviews)
4.5
jewelhuq

Ready to start the job. I did lots of similar project. http://sample.bdchatsites.com you will find all the details there.

€100 EUR in 2 days
(17 Reviews)
4.5
hamm

I can start immediately.

€40 EUR in 1 day
(25 Reviews)
4.5
rjsultan

Ready to start this JOB right now...

€30 EUR in 2 days
(22 Reviews)
4.3
eSwass

Ready to start work. queries in MySql are our specialty

€100 EUR in 3 days
(0 Reviews)
0.0
xpertdev65

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!

€39 EUR in 1 day
(0 Reviews)
0.0
jhkav

Expert Software engineer, with strong background in object oriented programming and Datebases and web devolopment.

€100 EUR in 3 days
(0 Reviews)
0.0
pksoftware

hi i would like to do this project

€30 EUR in 1 day
(0 Reviews)
0.0
charlse

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.

€30 EUR in 1 day
(0 Reviews)
0.0
poletaew

It's easy. Contact me.

€60 EUR in 1 day
(0 Reviews)
0.0
orsala

My name is Oriol Sala, I'm a web developer passionate about web design & development especially PHP, MySQL, jQuery, AJAX Oriol

€100 EUR in 3 days
(0 Reviews)
0.0
chamiya1977

I am ready for work. Please check my PM.

€50 EUR in 2 days
(0 Reviews)
1.4