Find Jobs
Hire Freelancers

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

€30-250 EUR

Closed
Posted over 7 years ago

€30-250 EUR

Paid on delivery
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.
Project ID: 12755297

About the project

15 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
15 freelancers are bidding on average €195 EUR for this job
User Avatar
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 in 3 days
5.0 (106 reviews)
8.1
8.1
User Avatar
A proposal has not yet been provided
€263 EUR in 3 days
4.9 (91 reviews)
7.4
7.4
User Avatar
A proposal has not yet been provided
€155 EUR in 5 days
4.9 (21 reviews)
5.7
5.7
User Avatar
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 in 3 days
4.7 (39 reviews)
5.5
5.5
User Avatar
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 in 2 days
5.0 (3 reviews)
3.9
3.9
User Avatar
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 in 3 days
5.0 (9 reviews)
3.6
3.6
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Bonn, Germany
5.0
33
Payment method verified
Member since Nov 30, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.