Crude mockup system for input of variables and a way to view the data

已关闭 已发布的 6 年前 货到付款
已关闭 货到付款

I have a few MySQL tables that is used to input messages and tags.

The database structure consists of the following tables:

tbl_messages

message_ID | message | dateAdded

tbl_messages_x_tbl_tags

message_ID | tageName

tbl_tags

tagName | dateAdded

tbl_used

used_ID | message_ID | usedWith | timeOfUse

The relations between these tables are that the tbl_messages are filled with different messages.

Ex. "Hi! I need to find a handyman in Stockholm. Perferably with his own toolbox as I don't own any tools other than a few screwdrivers and a hammer! Please contact me!"

The table tbl_tags stores tags that can be found in the message, ex.

handyman, stockholm, own toolbox

The table tbl_messages_x_tbl_tags are used to link the message with the different tags related to the message.

The table tbl_used are used to store which message has been used, who used it and at what time.

What I need now, is a simple and crude webinterface where I can do the following:

1. View, edit, remove and insert new tags and messages

This part of the page, should show one box with all available tags.

If a tag is selected, it should be possible to edit or remove the tag.

I also want to be able to add new tags.

Another box should be available where I can insert a message.

A new message must have at least one tag selected in order to be saved, but it should also be

possible add multiple tags to a message.

2. Find a message based on tags.

This part of the page should list all available messages.

When a message is selected, the message should also have the posibility to be edited.

The page should first load ALL available messages and when I select one or more tags, they

should be used to filter the messages.

3. List all messages that has been used.

This part of the page should list all the messages that has been marked as used.

It should show the message, the name of who used it ([login to view URL]) and the date it was

used.

4. Add/remove users who have access to this page.

The freelancer who are awarded this project are free to create a completely new database with a different structure they way they see fit. As long as the end result is somewhere close to the described features.

The interface does NOT need to be fancy.

This is as a demo for a customer who will most likely want more features added to this system, and then it can be designed better.

The awarded freelancer will have priority to continue with the project if the customer decides to go further.

数据库编程 HTML MySQL PHP 网站设计

项目ID: #16072937

关于项目

5个方案 远程项目 活跃的6 年前

有5名威客正在参与此工作的竞标,均价$146/小时

abrahambrons

Hello, i can make the CRUD for you, its simple to me make the database in 3rd Normal form, and i will provide you fast job and results, if you like it, please contact me. We can discuss the price ;)

$70 USD 在3天内
(62条评论)
5.7
gopiande

I am an experienced web developer. Can do your task quickly as per your requirements.

$30 USD 在5天内
(14条评论)
3.0
jcannicott

Hi, I'd like the opportunity to work on this project with you. I propose some simple bootstrap web forms which we can build on and improve as the project progresses. Please message me to discuss further. Regards Ja 更多

$30 USD 在7天内
(0条评论)
0.0