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.
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
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
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