In Progress

Retrieving info from MySQL database and place it in PHP-form

Dear experts,

The global idea is to retrieve information from an existing MySQL database, which is included under Cpanel webhosting, and display this information (text, memo, yes/no and photo fields) by using a small number of PHP-scripts with included (HTML)table layout.

Login data to MySQL should be hide well in the script or encoded so that it is impossible to gather this information from outside (with browser etc.).

This PHP-script block should be universal.

What means that in the top of the script(s) a number of values must be able to change in order to get different information from different product groups (different product types).

It must be possible to put these PHP-scripts/block on more places on the website.

On each specific page there will be a header, a buttonbox, THE PHP SCRIPT and a footer.

The choice of the product group (product type) must be declared in the top of the script or triggered by a value which can be send from the particular page to the script.

Global information about what is in the database:

For each product there is text, memo and yes/no fields. Approx. 20 fields per product. There are 7 photo fields (small in memory size) for each product. Photos are all in .jpeg format, but types like (.bmp or .tif) should be able to support too (prepared).

The product information should be displayed two ways:

- First: Global product overview:

With 1 main resized photo (approx. 200x133 pixels),

5 resized photos (approx. 100x66 pixels) around the main photo and some text, memo and yes/no fields. The maximum number of products per page must be declared in the top of the script. The products page(s) must come with page linking (previous page, page1, page2, next page if applicable). If more products are in the database. If there are no products at all in the database, there must be a text like ‘no objects available’. If a number of products are in the database more displaying like descript above must be executed in the same page until the max number products per page are retrieved (declared in the top of the PHP-script). After that page linking should be active.

-Second: Specific product overview:

Once pressed on one of the product photos (large or small) a specific product page (in the same kind layout should be opened. In this page the photos will be larger (main photo:

200 x300 pixels, smaller photos: 100x150 pixels).

A possible 7th photo (.jpg format (optional: .bmp/.tif), but wider) must be included in this form (on the bottom of the table layout) next to more information (more text, memo and yes/no fields).

In this more detailed product overview (1 product per page) page linking must be active.

Extra button must be included which makes it possible to go back to the main page with the global product overview (see ‘First: Global products overview’). When going back to this page the page overview should displayed the related page with a maximum 5 products (declared). For an example if customer went to Specific products page 17 and wants to return to the Global product overview, he should return to the fourth block of 5 products (adjustable setting) with a bookmark to the second product on that page. Linking should be correct again.

The ideas/outlook of the table fields will come after agreement / approval.

Remember: the PHP-script(s) only gather information from MySQL and displays it two way in two types of tables.

Bid is open!

Many thanks in advance!

Skills: Data Processing, PHP

See more: what is in, top group, table customer, php per, outlook experts, mysql customer database, maximum top, maximum max, info website only, html 5 login form, displays to go, cpanel mysql database, bookmark layout, retrieving information mysql database, change layout info retrieved mysql database php, what is open text, what is memo, get php, database scripts with php and mysql, tif, the php group, table top, processing customer info, php mysql database, php login

About the Employer:
( 3 reviews ) Zoetermeer, Netherlands

Project ID: #32619

Awarded to:

emBee

Greetings Sir, This can be easily done. Waiting for your response. Vikash

$100 USD in 2 days
(1 Review)
2.3

10 freelancers are bidding on average $69 for this job

DevExpert

I got familiar with your task and will offer you quality service with 5 days free support after completion.

$80 USD in 4 days
(131 Reviews)
7.4
ccpplinux

Hi, Please see PMB for more details and demo. Best Regards ... ccpplinux

$50 USD in 5 days
(137 Reviews)
6.9
EzzatHelal

I am ready to implement this script for you.

$40 USD in 2 days
(10 Reviews)
4.4
neon

we can do this

$60 USD in 6 days
(5 Reviews)
3.5
vietsoft

Hi, Please preview a vietnamese version at http://www.maytinhxachtay.com.

$100 USD in 7 days
(0 Reviews)
0.0
opensourcefreak

Can provide you with what you need. Please choose me.

$75 USD in 1 day
(0 Reviews)
0.0
szpilman

hi we have often finished such application. Please see PMB.

$50 USD in 2 days
(0 Reviews)
0.0
osCoder

Dear Sir, I'm experienced full time freelancer. I can do this job exactly as you want. If you need to ask me something please use PMB. Thanks.

$70 USD in 3 days
(0 Reviews)
0.0
LANMARK

We are INDIA based company, well experianced in web projects, will give you a best product at short time.

$60 USD in 2 days
(0 Reviews)
0.0