Завершено

PHP ARRAY CLASS

I need to construct a PHP script that will take the results of a query to a MYSQL database (fields may vary) and then construct an array that is indexed on the State field or the Country field. THe script needs to tacke whether there are results for any given state/country, and if there are print out the results for that state/country. There needs to be a row check for the number of results by state/country, so that presentation options can be looped through. As an example, the MySQL database will have records including Patient Name, Address, City, State, Country and Phone, Plan 1, Plan 2, Plan 3. I The query will select all Patient Name, City, State and Plan 1,2,3 fields from the database. Inside the Plan 1,2,3 fields records contain a Y to indicate if they are a member of that plan. The output will need to be a list of patients that are alphabetical by State and then By City, then by patient name, and an indication of what Plan they are on. If there are no records for a state, then nothing for that state will be listed. All the state fields are 2 letters, and will need to be convereted to ALL CAPS full names (AL or Al becomes ALABAMA) The output would look like this ALASKA Fairbanks John Doe Plan 1, Plan 3 Wheeler jane Doe COLORADO Boulder Jim Doe Plan 3 Frank McDonald Plan 1, Plan 2, Plan 3

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables):

a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

PHP 4.x, Mysql 3.23 unix bases. Global Variables are off.

Квалификация: Техника, MySQL, PHP, Архитектура ПО, Тестирование ПО

Показать больше work in colorado, work in alaska, site plan presentation, print presentation, global source buyer list, country state and city database mysql, c al coder, a. y. mcdonald, alaska list, looped, Jane, check if phone number exist, alaska, work database letters, city state country php, class full address, array form, patient database mysql, form array, city country state database php

О работодателе:
( 23 отзыв(-а, -ов) ) United States

ID проекта: #3294934

Поручен:

martok

See private message.

$25.5 USD за 1 день
(21 отзывов(-а))
4.0

20 фрилансеров(-а) в среднем готовы выполнить эту работу за $36

progwriter

See private message.

$67.15 USD за 1 день
(620 отзывов(-а))
7.7
CodingExpertz

See private message.

$85 USD за 1 день
(105 отзывов(-а))
6.3
adidami

See private message.

$8.5 USD за 1 день
(143 отзывов(-а))
6.1
liviussl

See private message.

$34 USD за 1 день
(225 отзывов(-а))
6.0
coderprovw

See private message.

$51 USD за 1 день
(38 отзывов(-а))
5.6
codenamewww

See private message.

$8.5 USD за 1 день
(32 отзывов(-а))
5.6
priyankjainvw

See private message.

$17 USD за 1 день
(41 отзывов(-а))
5.4
khurramshahvw

See private message.

$68 USD за 1 день
(23 отзывов(-а))
5.2
i4interactive

See private message.

$25.5 USD за 1 день
(38 отзывов(-а))
5.1
vw902514vw

See private message.

$8.49 USD за 1 день
(20 отзывов(-а))
4.9
cercelarua

See private message.

$34 USD за 1 день
(8 отзывов(-а))
2.9
mcirsta

See private message.

$8.5 USD за 1 день
(3 отзывов(-а))
1.5
jtricarico

See private message.

$5.1 USD за 1 день
(1 отзыв)
0.0
ivarivw

See private message.

$33.15 USD за 1 день
(0 отзывов(-а))
0.0
vw01000101

See private message.

$42.5 USD за 1 день
(0 отзывов(-а))
1.9
khimenkoandrey

See private message.

$42.5 USD за 1 день
(0 отзывов(-а))
0.0
jemts

See private message.

$12.75 USD за 1 день
(0 отзывов(-а))
0.0
webportals

See private message.

$72.25 USD за 1 день
(0 отзывов(-а))
0.0
nathansullivan

See private message.

$68 USD за 1 день
(1 отзыв)
0.0