PHP program - Small vocabulary testing program (Part 1/3) -- 2

I need to complete a freelancer project that was not completed, and you will help complete the first part of the PHP program that is [85% completed]. Must have good MySQL, php skills. Must speak English. Must work with lead programmer. If you can handle this simple job, you can continue working with us.

PREVIOUS POST: You will be helping build a small program in a bigger system, with us, check our projects before. Know that you will be working with an experienced programmer, who has experience with Freelancer! We are looking for [small budget] workers, we can help you build your reputation (we have held many already). To reduce complexity, we have broken this project into 3 smaller projects.

This project would take about [20 HOURS] if you have the required basic coding experience. But you probably don't know about a certain part (mysqli, JSON, etc), which you'd have to look up, or I'd have to explain to you (show examples), or even help you write code. But if you have some coding experience, this shouldn't take over 30 hours.




1. Create 10 tables for a simple dictionary (and a second language, cloned features)

2. Create features to add words, definitions and examples (cloned Features for 2nd language)

Note: you must use MySQLi to prevent SQL injection amongst other good points.


Looking for:


1. PHP/MySQL Developer

2. Have WAMP/LAMP system and can develop using PHP/MySQL (and some maybe JS? depends on your ability)

3. Should know about HTML5/CSS3/JS/JSON

4. Good communication and listen to requirements and able to do fixes for problems

5. if you don't have a webserver, you must know how to pass all files to me(SQL, php files)


Requirements (Tentative):


All php pages and Mysql tables are utf-8! Your features will be inserted into a bigger page. We will give you the work in parts, as to prevent you creating a gigantic fully system that we don't want. Save your time and my time.

As project continues, we will give more details to ensure that what you create is of use, and has great usability.


Create a MySQL Tables:


1. EngWord {id, name, creatorID, lastUpdated}

2. EngDefinition {id(primary, auto-incr), wordID, typeID, string[definition], string[usage], creatorID, orderIndex}

3. EngDefinitionExample{id(primary, auto-incr), definitionID, string[example], creatorID, orderIndex}

4. EngSynonyms {id(primary, auto-incr), wordID(index),string[JSON string of wordIDs],orderIndex}

5. EngWordForm{baseWordID, baseTypeID, wordID, typeID}

Note 1 - typeID : 1-noun, 2-verb, 3-adj, 4-adv, 5-conj, 6-prep, 7-inter

Note 2 – EngWordForm, a base word has other forms, such as: [happy<-base, happily, happiness] or [economy<-base, economist, economical, economically]

6. ChineseWord {id, name}

7. ChineseDefinition{id(primary, auto-incr),wordID,string[definition],orderIndex}

8. ChineseSynonyms {id(primary, auto-incr), wordID(index),string[JSON string of wordIDs],orderIndex}

9. EnglishChinese{engWordID, string[JSON string of chineseWordIDs], orderIndex}

10. ChineseEnglish{chnWordID, string[JSON string of englishWordIDs], orderIndex}


Create pages with word functions page:


a. add English Word – a single input line, to enter a word

b. for an English word, add a definition (multiple definitions for a word) – can choose typeID (1-7), add definition

c. for a definition, add an example (multiple definitions for a word)

3. [Have exact same features for ChineseWord ] - of course, your testing, you can just use English,because you don't know chinese

4. Create page for add translation info (EnglishChinese) – English word is typed, and then a Chinese word is typed, program checks if both words exist, if so add a EnglishWordID to EnglishChinese, and add the ChineseWordID to the string of chineseWordIDs

5. Add features to add, delete translations from EnglishChinese

6. [Have exact features for ChineseEnglish, but opposite]

Skills: Apache, CSS, Javascript, MySQL, PHP

See more: working as a freelancer sql developer, work how freelancer php, work as freelancer programmer, who to create id on freelancer, what skills must a php developer have, what is time complexity in c, what is time complexity, what freelancer c programmer do, what experience should a freelancer have, what are the functions of a freelancer, what a php programmer should know, wamp with php 5.6, us auto parts, usability freelancer, t sql freelancer, translation job from english to chinese, translation job english to chinese, translation job chinese to english, translation english to chinese freelancer, time complexity of code

About the Employer:
( 45 reviews ) Kaohsiung City, Taiwan

Project ID: #6485758

Awarded to:


Hello. I`d like to work on your project. I have experience working with MySQLi, PHP and JS (JQuery). I believe that I have good enough skills to handle your task. Don`t know what is "low budget" for you so we can t More

$120 USD in 3 days
(4 Reviews)

8 freelancers are bidding on average $168 for this job


Hi sir, My name is Leonardo Medina, and I´m from Brazil. I have lots of experience in PHP. Please drop me a line, so we can discuss this project in details and I can make a proper bid. I'm an experienced Web D More

$260 USD in 5 days
(113 Reviews)

hi we could do it perfectly with accuracy, please let us know if you want any clarification. if you want us to share our skill and previous work please initiate the chat by replying..

$164 USD in 9 days
(81 Reviews)

A proposal has not yet been provided

$263 USD in 15 days
(24 Reviews)

Hello, After reviewing your criteria, we are very eager to work on this project as we have strong knowledge on this [login to view URL] we have some queries/inputs on this [login to view URL] this We need to discuss with you. Clari More

$166 USD in 3 days
(16 Reviews)

Hi, I got a fair comprehension about your project. I have few questions, so please come on chat for further discussion. Benefits you get: 1. 2 Months Free Technical Support and Warranty 2. W3C Compliant Code, So More

$147 USD in 3 days
(13 Reviews)

Hi, I am very interested working on your project:"PHP program - Small vocabulary testing program " I've read your specifications and I can help you finish your requests with no problem My 8+ years background i More

$111 USD in 3 days
(7 Reviews)

Hi, I am a very experienced software and we developer. I have over 10 years developing experience using Java, PHP and Python. Over the years I worked on various projects that vary from simple static HTML based web s More

$116 USD in 5 days
(2 Reviews)