Find Jobs
Hire Freelancers

Write PHP Functions for creating, accessing and modifying a PostgreSQL database -- 2

€30-250 EUR

Lezárt
Kiadva ekkor: több mint 7 évvel ezelőtt

€30-250 EUR

Teljesítéskor fizetve
We have a PHP written Database, with around 280 products, each one is stored as an array of many attributes. Write the following functions in PHP: 1). Function which creates a PostgreSQL database "dsc-electronics-de" with all products from this PHP Database (dpd1 to last, dfc1 to last, dps1 to last, dph1 to last) in a "products" table. The function has to auto detect how many products are available in the PHP database, as we will extend it later. The PostgreSQL table should have the following system: Column | Type | Modifiers ---------------+---------+----------- id | integer | not null auto increment model | text | primary key properties | jsonb | The ID should be incremented from 1 to infinite for each new product. The MODEL should get the value of the model attribute of the product (for example DP10H-10D) they are always unique. The PROPERTIES jsonb cell should store all the other data from the product array except of the model for example for the product dpd1: ({"series" => "DP-D", "voltage" => "10", "current" => "400", "power" => "4.000", "price" => "1390", "frame" => "6", "weight" => "27", "priceRC" => "690", "frameRC" => "10", "CWeight" => "55", "priceRP" => "1400", "frameRP" => "10", "PWeight" => "55", "priceCP" => "900", "lead" => "", "priceCWeight" => "", "pricePWeight" => ""}) 2). Create a function to search for the product in the PostgreSQL database table and store the data in the same way as it was in the PHP Database before. For example: $model = DP10H-10D $dpd1 = functionSeachDatabaseModel($model); Now the variable $dpd1 should have the values as an array from the Database for the product DP10H-10D. 3). Create a file [login to view URL] which will use the above function Nr.1 to create the new PostgreSQL database with the name "dsc-electronics-de" and a table with the name "products" from the PHP Database . If database or table already available remove old database and table and rewrite new. It Should display errors or success messages step by step while performing operations. Files: [login to view URL] - This is the database file with 4 types of products dpd, dfc, dps, dph - We will send it on project accept [login to view URL] - This should the file that will be run to create the database - PLEASE CREATE [login to view URL] - Export all database functions to this file so they will be available from everywhere later - PLEASE CREATE The work on this project has to be started immediately, as this is urgent.
Projektazonosító: 12755297

A projektről

15 ajánlat
Távolról teljesíthető projekt
Aktiválva: 7 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
15 szabadúszó adott átlagosan €195 EUR összegű árajánlatot erre a munkára
Felhasználó avatár
Professiona lPostgreSQL expert. I understand what you are looking for. I’ve read your project and understood. Because I’ve completed the done work before so I am sure it will not be a problem for me. I am highly professional and skilled web designer and developer (responsive) with more than 5 year experience of development. I am fully skilled and up to date with all web technologies/languages including (HTML5, AJAX, CSS3, ASP.Net, Wordpress, Drupal, Magento, PHP, Java, Python, Ruby, JavaScript, jQuery, Bootstrap, MySQL, Oracle etc.). I’ve read your project and understood. I assure you 100 % professional and user friendly work environment. Feel free to ask any question. Thanks
€242 EUR 3 napon belül
5,0 (106 értékelés)
8,1
8,1
Felhasználó avatár
A proposal has not yet been provided
€263 EUR 3 napon belül
4,9 (91 értékelés)
7,4
7,4
Felhasználó avatár
A proposal has not yet been provided
€155 EUR 5 napon belül
4,9 (21 értékelés)
5,7
5,7
Felhasználó avatár
Hi, I'm Ing of systems With over 10 years of experience developing large-scale applications and providing web technology solutions for freelancers , small, medium and large businesses. experience working with the private sector and public my skills 1) HTML5 + CSS3 2) PHP POO laravel, Zend 3) Javascript Boostrap, Jquery, Angular 4) Database Mysql, Oracle, Postgresql 5) GIT, SVN I'm Available for this job. Thanks good day
€155 EUR 3 napon belül
4,7 (39 értékelés)
5,5
5,5
Felhasználó avatár
Hi I am expert in PHP and responsive designs. I will fix your website issues in 1 or 2 days max. I will give you the best price as well. thanks Nav
€166 EUR 2 napon belül
5,0 (3 értékelés)
3,9
3,9
Felhasználó avatár
Hi, We have reviewed your job description and we are interested to write the PHP functions for creating, accessing and modifying the PostgreSQL DB. We have reviewed the details of the three functions you want and we pretty much understood it but we have a couple of queries before we start the work. You can message us over chat so that we can discuss the details and proceed forward ASAP. Thanks
€160 EUR 3 napon belül
5,0 (9 értékelés)
3,6
3,6
Felhasználó avatár
I'm making another bid as this is a repost but this one is higher. Why the sudden need to repost the job?
€200 EUR 3 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

GERMANY zászlója
Bonn, Germany
5,0
33
Fizetési mód hitelesítve
Tagság kezdete: nov. 30, 2015

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.