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

In Progress

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. If you can do a decent job, we'll give you the remaining 2 parts, to finish this project.

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.

----------------

JOB (PHP/MySQL)

----------------

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, who to create id on freelancer, what is time complexity in c, what is time complexity, what freelancer c programmer do, 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, time complexity examples, the economist, testing project in freelancer, string problems, sql injection freelancer, sql developer freelancer, programmer part time job, programmer dictionary

Project ID: #6270150

13 freelancers are bidding on average $142 for this job

JoomlaVogue

Hello Sir, First of all, we would like to tell you how we will initialize the project with you. We insist to follow these steps before you award the project to us: - we(technical team) will review the job and as More

$170 USD in 3 days
(72 Reviews)
6.9
techwelfare

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

$221 USD in 10 days
(81 Reviews)
6.4
hexamilesoft

WHOA! Hey there, My name is Faisal Malik and I’m the lead developer of Hexamilesoft Company. We are the web development and social media/SEO/SMO/SEM professionals and having more than 12 year experience along with r More

$222 USD in 3 days
(92 Reviews)
6.3
miltonyukiomatsu

A proposal has not yet been provided

$220 USD in 3 days
(42 Reviews)
5.3
jingguo811

Hi sir. Thank you for your post. I read your description carefully. I am very interesting in your project. I am an expert in Matlab, but i am a manager of website development team with 5 developers, and they have g More

$100 USD in 3 days
(2 Reviews)
2.6
tudormarze

Hello, I would like to discuss more details with you. I am available to work only in the next 24 hours, it sounds like a fairly easy project, i would only accept if you think we can complete it in this time (be onli More

$66 USD in 1 day
(3 Reviews)
1.4
prashantshukla14

Hello, I am expert in web programming and designing, have good knowledge of latest web technologies like : Wordpress, CodeIgnite, CakePHP, Drupal, HTML 5, CSS 3, JQuery, AJAX, MySql, Photoshop and many more, I More

$222 USD in 5 days
(0 Reviews)
0.0
praveenks10030

I have six years experience in working with PHP and LAMP server. I have been working on many projects related to PHP

$155 USD in 3 days
(0 Reviews)
0.0
devbrat01

Hi, I Have good experience in PHP, Mysql,Javascript,Jquery,Html and css.I know how to use JSON. Recently I was working on a project in which we have build server application for an android application.We have used More

$155 USD in 3 days
(0 Reviews)
0.0
solutionstation

Hi, Thanks for posting the job. I love coding and have lots of fun doing it. I understand that you need a dictionary application. The application needs to be developed using PHP and MySql. I think that someone ha More

$122 USD in 2 days
(0 Reviews)
0.0
dgamarra16

I'd like to work with you guys. I really want to get some experience here in Freelancer. I'll be wating for your answer!.

$120 USD in 5 days
(0 Reviews)
0.0
tarunsitlani

Hello, I am very much positive for your project and eager to discuss with you more in detail I had worked on web applications in PHP, .NET and JAVA . For my php work you can visit: www.getyourproject.com (no CMS More

$166 USD in 3 days
(0 Reviews)
0.0
sadiqahmad

I want to built reputation on freelancer. It will be a great opportunity for me to work on this project. I am good at mysql, apache, css, javascript and html. I have my own xamp server installed.

$100 USD in 7 days
(0 Reviews)
0.0
tedlaalemu

A proposal has not yet been provided

$31 USD in 2 days
(0 Reviews)
0.0