Simple PHP MYSQL Task for Someone with Basic Skills

I could have done this but got other important tasks to perform. Simple PHP MYSQL project.

Expenditure tracking:

Check if databases exist and if not then create Three MySql Tables with following attributes.

Material Procurement:

• Serial number (primary auto increment)

• Date

• Particular

• Quantity

• Rate

• Amount (must be the product of quantity and rate )

• Vender ID (auto suggestion ajax from a separate table with vendor lists and then store the Vendor ID)

Yes! Create a separate table named vendors with following fields

• ID (primary auto increment)

• Name (unique)

• GSTIN no

• Pan No

• Contact number 1

• Contact number 2

• Email address 1

• Email address 2

• Whatsapp number

Commission Table:

Then create a table with following fields:

• Serial number

• Name

• Amount

Labour Payment:

Then create a table with following fields:

• Serial number

• Labor name

• Amount

• Payment mode (Cash, cheque, or bank transfer)

• Date

• Timestamp

Associate the Labour name with the labor id of labor profile table:

• ID (primary auto increment)

• Name

• Bank account number

• Contact number 1

• Contact number 2

• Email address 1

• Email address 2

• Whatsapp number

Note: Your task is to develop Insert update and delete forms for all table entries. And ability to sort expenditures on a single click.


On the [login to view URL]

1. One initial run Ask for a prefix. Then the user will provide input and press submit button.

2. Then on post check, if tables exist. If exists then just alert (do not overwrite, it’s important), Else, Create all three tables and their related tables programmatically with the mentioned prefix in all tables.

3. Once this happens the user should not be prompted again to enter a prefix.

I need separate forms to insert update and delete the items as per requirement.

Material Procurement Form needs to insert the following information.

• Serial number (INT 10 primary key autoincrement)

• Date (date selector)

• Particular (text varchar 256)

• Quantity (float)

• Rate (float)

• Amount (must be the product of quantity and rate )

• Vender ID (auto suggestion ajax from a separate table with vendor lists and then store the Vendor ID)

I need the ability to sort and search different expenditures. Search by vendor and find out the sum of expenditures associated to it.

The similar ability for Labour payment based on labour ID.

Finally, Mobile friendliness of HTML is a must to get paid.

More details In PM.

Ujuzi: AJAX, Javascript, MySQL, PHP

Angalia zaidi: simple php mysql database, simple php mysql gallery, simple php mysql video upload script, crm in php tutorial, web developer skills list, udemy php free, web developer skills and qualifications, crm php source code, web developer skills 2017, skills required for web developer, essential skills web development, php, mysql, css, html, codeigniter, cakephp, free simple php mysql rating, simple php mysql script users, simple php mysql rating

Kuhusu Muajiri:
( Maoni 3 ) lucknow, India

Kitambulisho cha Mradi: #17659211

Imetuzwa kwa:


Hello, I am well versed and having experience of 4+ years as “Codeigniter and Php developer/designer”. I believe i will be suitable for this job and serving you with all my hard work and skills. Skills Includes: Zaidi

₹6000 INR kwa siku 3
(Maoni 12)

25 freelancers are bidding on average ₹12479 for this job


Dear Client, I am well experienced follow the programming languages. PHP, MYSQL, JQUERY, HTML, MYSQL, MONGODB, NODE.JS, ANGULAR, REACT, VUE.JS. Overall 8 years experienced. Check my projects ht Zaidi

₹18888 INR kwa siku 6
(Maoni 163)

Hi, I checked your project details and I have more than 5-6 years experience on PHP,MYSQL. I understand your requirement and I am ready to start working. Please come online so we can discuss in details. Pleas Zaidi

₹22777 INR kwa siku 14
(Maoni 69)

I have 9+ years experience in web / ios fields,and 3+ years of experience in private company having 500+ employee as a Technical Team leader . My expertise are : php , drupal , wordpress , joomla , magento , Zaidi

₹9998 INR kwa siku 5
(Maoni 40)

Hello Sir, I have read your job description regarding Simple PHP MYSQL Task for Someone with Basic Skills. I have 6+ year of experience in AJAX, Javascript, MySQL, PHP. I have strong expertise to accomplish this Zaidi

₹6172 INR kwa siku 3
(Maoni 96)

I have done lot of cms and admin backends like this so can start and complete quickly in few days.

₹10000 INR kwa siku 10
(Maoni 55)

Hi, We have read that you are looking for web developer We are a team of well-experienced freelancers that values quality over anything else. Here are the skills we have for your reference: • Web design and Zaidi

₹5555 INR kwa siku 3
(Maoni 21)

Hello Sir, I can complete your project on time and within your budget. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. We are a dedicated team o Zaidi

₹12500 INR kwa siku 5
(Maoni 22)

Hello, Hope you are doing good, I am Dilshad I have imminence experience in web development using PHP, mysql. I have read your description I understand and ready to do it. with 100% accuracy Looking forward. Zaidi

₹10000 INR kwa siku 3
(Maoni 18)

Hi! I am a Web expert and have 7 years of experience with PHP, MYSQL, CSS5. I read your requirements carefully and checked doc file already. I know how to complete your project, and can get this developed for you q Zaidi

₹5555 INR kwa siku 3
(Maoni 15)

I can do this job. I have more than 5 year of experience in web development. Please give me a chance to solve your problem.

₹7777 INR kwa siku 3
(Maoni 17)

Hi, I have gone through your Requirement and I am sure I can help you in this project. I have much EXPERIENCE in Web Designing, Web Development, E-Commerce Web Development using technology: PHP Codeigniter Lara Zaidi

₹10000 INR kwa siku 15
(Maoni 11)

hi sir, I have red your project description and I am ready to start working on it; please send me any more details and I could start working right now.

₹2500 INR kwa siku 1
(Maoni 17)

Dear Hiring Manage, I am have 5+ year of experience in web development. I read your requirements. I can do it. Can we discuss about project. thanks

₹7777 INR kwa siku 3
(Maoni 10)

I am expert developer with 5+ years experience. I can easily do PHP MYSQL task as mentioned in the description.

₹6666 INR kwa siku 1
(Maoni 8)
₹10000 INR kwa siku 3
(Maoni 3)
₹5000 INR kwa siku 4
(Maoni 3)

Hello. my name is Loukas Kontotaios and I'm a programmer from Greece. I will be happy to help you with your work. It's easy project for me.

₹13692 INR kwa siku 10
(Maoni 0)
₹7777 INR kwa siku 3
(Maoni 0)

Hi sir, I am good at different programming and scripting languages and i have done some real projects on [login to view URL] i am a fresher for the freelancer so can u give me a chance to prove myself

₹13333 INR kwa siku 5
(Maoni 0)

We are having 10+ years of experience in Logo & Graphic design, Web design / development, Mobile Apps (IOS & Android) development, Game Development & providing Affordable, Quality solutions / services to all kinds of b Zaidi

₹9000 INR kwa siku 3
(Maoni 1)