Terminé

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.

Compétences : AJAX, Javascript, MySQL, PHP

en voir plus : 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

Concernant l'employeur :
( 1 commentaire ) lucknow, India

Nº du projet : #17659211

Décerné à:

vipinjain1213

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: Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% INR en 3 jours
(1 Évaluation)
3.7

26 freelance font une offre moyenne de ₹12298 pour ce travail

html5css3php5

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 6 jours
(159 Commentaires)
7.1
webXpart

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 14 jours
(61 Commentaires)
6.8
enriquethumar

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 , Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 5 jours
(37 Commentaires)
5.8
navjootkaur

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(86 Commentaires)
5.7
ssspl

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 10 jours
(54 Commentaires)
5.8
wuricheng1985

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(12 Commentaires)
4.5
WEBsultion

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(16 Commentaires)
4.0
debkumarlab

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(16 Commentaires)
4.3
dilshadbukhari

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(17 Commentaires)
3.9
daisoftware123

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 15 jours
(5 Commentaires)
3.4
atulamol

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 5 jours
(15 Commentaires)
3.2
MuhammadRohailP

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(8 Commentaires)
2.7
ahmedqahmed46420

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(12 Commentaires)
2.9
kajalgupta0098

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(6 Commentaires)
2.4
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(3 Commentaires)
1.4
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 4 jours
(3 Commentaires)
0.6
lkontotasios

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 10 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(0 Commentaires)
0.0
tirumal100k

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 5 jours
(0 Commentaires)
0.0
vinodvarma42

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 3 jours
(0 Commentaires)
0.0