Sedang Disiapkan

Website with a graphical UI and MYSQL database (Apache, Raspberry project)


there are two major goals in this project. Before listing them, it should be noted, that this would be a part of a robotic device which is going to be used only for educational purposes and is working exclusively with limited amount of bottled liquid mixing components, such as: alcohol (vodka, whisky, rum, etc) and non-alcoholic beverages (coke, tonic, juice etc.), not with ice or with any other solid substance.


Web site - Objective is to implement a dynamic web site (for example using PHP) with a graphical user interface (arbitrary, your desgin/choice) via which could user search for a drink (=cocktail from a MYSQL database, read further) and choose it (if it is available). After the order was made, request is processed and sites provides data output for Raspberry.

Database - MYSQL, component of the website. Limited size (the main up to 60 items = drinks, the secondary up to 20). Each item should contain similar attributes as listed down below at "1)". Database should work together with the site - such as LAMP ( Linux, Apache, MYSQL, and PHP) stack. Other details at "2)".

OBJECTIVES: Databases and site with user interface

1) First objective is to design and develop two databases - the main one containing list of simple alcoholic cocktails (just the most popular - according to wiki/google, not all of them of course). For each drink the database should contain: name of the mix drink/cocktail, description of the drink, specifics for user in order to search for it on webserver, individual mixing parts of which it consists, preparation order (= which part should come first, second etc.). The database should be further managable/accessible (adding another drinks etc.). This should be the main one - with all necessary information.

The other should be build the way, that besides drink name, it mainly contains the mixing parts we currently have at our disposal - in other words, barbot is physically limited and could handle only up to 15-20 mixing parts at the same time but not more. So user would be able to see information about every drink (in the main db), but could order only the ones, which mixing parts are available (= in bottles and listed in the secondary db). Every mixing part should have a specific designation in order to differentiate them and also dose them in correct order - so when user makes the choice (see goal 2) his request is processed (checking if the mixing parts are available in sec. db) and if so, the correct designation order (in form of data) is passed over and the dispensing process is able to begin (further information would be provided).

2) Second part of the project is implementing a full website (running on Apache). The website should have an user interface, that would show the cocktails listed in the main database (e.g. pictures) and their info to the user, let him search for specific one, also let him know, if the desired drink is available or not and most importantly accept the order, process it (access the databases) and send the data for mixing (Additional info, not necessary for this project: Pi also controls relays and based on the sent data it would activate some of them one after another for a period of time. Activating relays would open a solenoid valve and therefore pushing air from airpump to the bottle and dispensing liquid).

Other requirement is that site should handle collisions = if there are multiple order requests at the same time, they should be processed continuously - right after the previous order is completed.

I am deeply sorry for such an 'exhaustive' and possibly unclear description. In case of interest I would be more than happy to share all the details there are with you. There will be an option to continue working on the later phases of the project (pumping and dosing).

Thank you very much for your time.

Kemahiran: PHP, Reka Bentuk Laman Web, MySQL, Raspberry Pi, Pengaturcaraan

Lihat lagi: project mysql database access using odbc, xml mysql database project sample, hack joomla website mysql database, implement mysql database online bookstore project, mysql database design project visual studio 2008, prepare project proposal mysql database client, free project php mysql database search, graphical look mysql database, create setup project mysql database, visual basic project mysql database, vbnet project adding images mysql database, website security php mysql application project, website graphical project, convert project access mysql database, use button website update mysql database, can rapidweaver website uses information mysql database, mysql database fill blank project, create website java display mysql database records, javafx ui mysql database

Tentang Majikan:
( 4 ulasan ) Brasy 1, Czech Republic

ID Projek: #29855456

Dianugerahkan kepada:


Greetings, I can surely help you for graphical UI and MYSQL database (Apache, Raspberry project) I fully understood your job offer and would be comfortable working on it as I am fully aware of building new websites a Lagi

€30 EUR dalam 2 hari
(3 Ulasan)

10 pekerja bebas membida secara purata €157 untuk pekerjaan ini


Hi there, Its a pleasure talking to you! I would like to work on this project as i got interested and think myseld much suitable to work on it as am a senior Laravel developer having expertise in Laravel and its mi Lagi

€155 EUR dalam 7 hari
(18 Ulasan)

Greetings, please share any referenced UI Design? Do you want a completely customized graphical UI Design website with MySQL Database integration? Can surely build you the one with every customization you require as we Lagi

€140 EUR dalam 6 hari
(16 Ulasan)

Yo! Very Thanks for your positing "Website with a graphical UI and MYSQL database (Apache, Raspberry project)" and I checked carefully As professional Full stack&Full time software engineer i have 7 years experience Lagi

€155 EUR dalam 7 hari
(15 Ulasan)

Hello there i'm a full stack developer expert in python programming (with 6 years experience). I've just read your project description and I'm ready to work. i can develop the website in raspberry pi using python (dja Lagi

€150 EUR dalam 7 hari
(25 Ulasan)

Hi! I just read your project and would like to work with you. Please send a message to discuss more regarding this project. Thanks Website with a graphical UI and MYSQL database (Apache, Raspberry project)

€150 EUR dalam sehari
(10 Ulasan)

I am Ring. I am about 19+ years experienced in GNU/Linux based system, server installation and customization, develop, deploy, security and support. I may help you in this regard.

€250 EUR dalam 5 hari
(8 Ulasan)

Hi Please! I confirm that i read and understand the project and I have good experience in Wordpress. Here you mentioned the details of the project and i understand the details... "Hello, there are two major goals in Lagi

€90 EUR dalam sehari
(0 Ulasan)

Hi Sir, I have made a similar work for an industry to control various stepper motors and relays using a LAMP server graphical interface and i have attached the demo link below. Kindly go through the link. https://dri Lagi

€200 EUR dalam 20 hari
(0 Ulasan)

Hi there, I've read your a bit long description briefly, and I think I can manage it. I have rich experience in Python web development and databases. You can check my skills on my profile page. I'd like to discuss more Lagi

€250 EUR dalam 4 hari
(0 Ulasan)