Find Jobs
Hire Freelancers

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

€30-250 EUR

Cerrado
Publicado hace más de 7 años

€30-250 EUR

Pagado a la entrega
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.
ID del proyecto: 12755297

Información sobre el proyecto

15 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
15 freelancers están ofertando un promedio de €195 EUR por este trabajo
Avatar del usuario
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 en 3 días
5,0 (106 comentarios)
8,1
8,1
Avatar del usuario
A proposal has not yet been provided
€263 EUR en 3 días
4,9 (91 comentarios)
7,4
7,4
Avatar del usuario
A proposal has not yet been provided
€155 EUR en 5 días
4,9 (21 comentarios)
5,7
5,7
Avatar del usuario
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 en 3 días
4,7 (39 comentarios)
5,5
5,5
Avatar del usuario
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 en 2 días
5,0 (3 comentarios)
3,9
3,9
Avatar del usuario
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 en 3 días
5,0 (9 comentarios)
3,6
3,6
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de GERMANY
Bonn, Germany
5,0
33
Forma de pago verificada
Miembro desde nov 30, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.