php with my sql - techbharat · pdf filea two days workshop on php with my sql ... consulting...

TECHBHARAT CONSULTING PVT. LTD.TECHBHARAT CONSULTING PVT. LTD. Services is a leading Indian technology identity . TECHBHARAT CONSULTING PVT. LTD. offers computer forensics, robotics , social media, Web related solutions for enterprises and and students community. Our education domain "TECHBHARAT CONSULTING PVT. LTD. Education Services" have been in among top technology training provider brands in India. Our mentors had trained about 6,000 students and impacted around 50,000 students through our various outreach initiatives.

We deliver interactive training & workshops which equip its participants with better practical understanding and preparation for jobs in industry. The hands-on sessions and lectures are designed based on current industry trends and draw on the rich experience of instructors and organizers. We focus on Ethical Hacking, Embedded Systems, Robotics, Web Development, Digital Marketing and even more.

We are one of the fastest growing and globally recognized IT Securities firm for conducting Workshops and Corporate Training in India and world-wide.

for more details log on to www.techbharat.org

Robotics | Security | SocialMedia | Workshops

Robotics | Social Media | Forensics | Security Consulting |Educational Trainings www.techbharat.org

TECHBHARAT TRAINING PROGRAMME:We design, We develop, We deliver Cyber Security, Ethical Hacking & Penetration Testing, Networking, Web Development, Robotics, Programming Languages Training to the educational institutions, government agencies and private sectors. We have conceptualized Workshops, Seminars & various Developmental Programs catering to the needs of the before mentioned agencies. TechBharat has taken the responsibility on its shoulders to train the student community through Workshops/Seminars and Classroom Training Programs.

PHP is a general-purpose server-side scripting language originally designed for Web development to produce dynamic Web pages. It is one of the first developed server-side scripting languages to be embedded into an HTML source document rather than calling an external file to process data. MySQL is the world’s most used open source relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This is a two day workshop designed for the beginners to understand the PHP Programming & its use with MySQL.

What is PHP?

Our Clientale: TECHBHARAT CONSULTING PVT. LTD. Services has been catering to a vast number of elite colleges of Engineering by the means of workshops, training programmes and other events on technology related fronts.We have successfully impacted out an excess of 50,000 students through the workshops and technoholic events organized by our team. Below is the list of some of our esteemed clientele, whom we and our mentors served in the past up to their expectations

and list continues…

for more details log on to www.techbharat.org


Indian Institute of Technology, Delhi

Indian Institute of Technology, Bhubaneswar

National Institute of Technology, Bhopal

National Institute of Technology, Silchar

National Institute of Technology, Warrangal (Twice) National Institute of Technology, Calicut

National Institute of Technology, Allahabad

National Institute of Technology, Agartala

SRM University, Chennai, Tamilnadu (3 Times) K.L University, Vijayawada Birla Institute of Technology, Patna Northern India Engineering College, New Delhi

Marine Engineering and Research Institute, Kolkatta



MIT Manipal, Karnataka

Parul Institute Of Engineering And Technology, Vadodara, Gujarat

Beant College of Engineering & Technology, Gurdaspur, Punjab

Khalsa College of Engineering and Technology, Amritsar

Sai Vidya Institute of Technology, Bangalore

Dr. Mahalingam College of Engineering & Technology, Coimbatore, Tamilnadu

Government College of Engineering, Aurangabad, Maharashtra

SND College of Engineering & Research Centre, Yeola, Maharashtra

Government Engineering College, Barton Hills, Kerala

Chaitanya Bharathi Institute of Technology, Hyderabad

Chitkara University, Rajpura Campus, Punjab

AD Patel Institute of Technology, Anand, Gujarat

TITS. Technological Institute of Textile Sciences, Bhiwani, Haryana

Government Science College, Jammu

Meghnad Saha Institute of Technology, Kolkata

Vignan Institute of Technology & Sciences, Hyderabad

Guru Nanak Dev Engineering College, Bidar, Karnataka

Mallareddy Institute of Technology, Hyderabad

Sapthagiri College of Engineering, Bangalore

Gurgaon College of Engineering, Gurgaon

Swami Vivekanand Group of Institutions, Indore, Madhya Pradesh

Vidya Vikas Institute of Engineering & Technology, Mysore, Karnataka

Acharya Institute of Technology, Bangalore Karnataka

Sharda University, Noida

ITM University, Gwalior, Madhya Pradesh

Mahant Bachitttar Singh College of Engineering and Technology, Jammu

Jamia Milia Islamia University, New Delhi

Asia Pacific Institute of Information Technology (APIIT), Panipat, Haryana

Chhattisgarh Institute of Technology, Rajnandgaon, Chhattisgarh

Model Institute of Engineering & Technology, Jammu

New Modern Educational Society, Jammu

Baba Farid Institute of Technology (BFIT) Dehradun


Workshop Benefits and Highlights: We will provide following benefits to the college and Students :-

1. Conduction of two days workshop in your collegeDuration – 2 days (8 hours per day)

2. Deliverables to our students after the conduction of workshop 1. Software toolkit to each participant. 2. Training Material (eBooks) for each participant. 3. Authorised Certification from TECHBHARAT CONSULTING PVT. LTD. Services and AIESEC IIT-Delhi

3. Deliverables to the college & organizing team Certificate of Coordination after successful conduction of workshop. One Co-ordinator will get Campus Ambassdor Certificate who performs well.

4. Internship & Funded Research 1.We always look for bright technominds. May be they are sitting in your college, students with good background will be considered for internship under our experts. 2.We work in team. We work in collaboration. Interns can also expect a funded research project from TECHBHARAT CONSULTING PVT. LTD. Services.

5. Publicity & Branding Benefits Posters or Banners will be provided by TECHBHARAT CONSULTING Pvt. Ltd. for promotional purpose.

6. Sponsorship to the college We will provide sponsorship for conducting the workshop as a part of acknowledgement of using college infrastructural facilities.

7. Some of the Key Benefits to Students Learn and interact with one of the respected authorities in the field of Web Development. Practical demonstration for each and every module mentioned in course contents. Improve your job prospects and get an edge over your counterparts Receive an unparalleled education on the art of computer security with personal one-to-one attention. Covers all the basics for development of a server side website. Free tools & software’s used by professional animation designers. Hands on Demonstrations of Latest Animation Techniques & Tools.



Workshop Requirements: We want following things to be provided to us from college :-

Technical Infrastructure Facilities

1. A Seminar hall/ Auditorium having an enough capacity to accommodate 200 participants comfortably.

2. A Projector setup with stereo jack cord and audio public address system with sufficient number of screens in order to maintain good visibility in seminar hall.

3. An internet connectivity(WiFi Router) for the resource person(Without proxy if possible) 4. Two Wireless Microphones (Collar Mic. Preferred for speaker) 5. One laptop will be required per team from participants with little knowledge on programming

languages. (Optional)

Basic Requirements 1. Accomodation to our visiting team members in your college guest house or any other good

place. 2. Pick and drop facility from nearest railway station/ bus-stand/ or airport.

Publicity & Logistics Support

1. Specially designed workshop posters (will be provided by us) to be dispatched to engineering colleges across the state along with the festival posters and to be put up in the campus.

2. Four specially appointed coordinators (Student and Faculty) having the knowledge of the subject, to promote, publicize, handle local student queries etc. for our workshop to be conducted at the college.

3. Support to our team to interact with college students to provide them proper awareness regarding the workshop subject and to increase the participation.



Workshop Content:



1. Installation:1.1 Introduction PHP and Mysql1.2 PHP Installation1.3 MySQL Installation1.4 Apache Installation.1.5 XAMPP and WAMPP Installation

2. PHP Basics:2.1. Embedding PHP in HTML2.2. Embedding HTML in PHP2.3. Introduction Variable Using variables2.4. Understanding Data Types Using Operators2.5. Writing Statements and Comments Using Conditional Statements2.6. If(), else if() and else if condition Statement

3. Arrays and Custom Functions:3.1. Creating an Array3.2. Modifying Array Elements3.3. Processing Arrays with Loops3.4. Grouping Form Selections with Arrays Using Array Functions3.5. Creating User-Defined Functions3.6. Defining and Invoking Functions

4. Creating basic programs with PHP:4.1. Reading and Writing Files4.2. Reading Data from a File4.3. Writing Data to a File4.4. Testing File Attributes.4.5. Managing Sessions and Using Session Variables4.6. Creating a Session and Registering Session Variables4.7. Destroying a Session4.8. Storing Data in Cookies4.9. Setting Cookies4.10. Retrieving Cookie Data4.11. Dealing with Dates and Times4.12. Executing External Programs

5. Editing Records and Performing Queries:5.1. Inserting Records5.2. Editing and Deleting Records5.3. Performing Queries5.4. Retrieving Specific Columns5.5. Filtering Records with a WHERE Clause5.6. Using Operators5.7. Sorting Records and Eliminating Duplicates5.8. Limiting Results5.9. Using Built-In Functions5.10. Grouping Records5.11. Joining Tables5.12. Using Subqueries5.13. Using Table and Column Aliases

6. Using PHP with MySQL:6.1. Managing Database Connections6.2. Performing Queries6.3. Processing Result Sets6.4. Queries Which Return Data6.5. Queries That Alter Data6.6. Handling Errors6.7. Using Ancillary Functions

7. Creating Forms with HTML:7.1. HTML Basics7.2. Creating Forms with HTML

8. Working with Databases and Tables:8.1. Creating Databases8.2. Creating Tables8.3. Specifying Field Data Types8.4. Selecting the Most Appropriate Data Type8.5. Adding Field Modifiers and Keys8.6. Selecting a Table Type8.7. Altering Tables8.8. Altering Table and Field Names8.9. Altering Field Properties8.10. Adding and Removing Fields and Keys8.11. Altering Table Types


Workshop Payment:The amount shall be paid as under :-

Appropriate Amount to be handed over to TECHBHARAT CONSULTING PVT. LTD. team on the first day of the workshop

a. Mode of Payment can be Cheques/Demand Draft/Cash b. Proper Invoice will be provided for TECHBHARAT CONSULTING PVT. LTD. Services.

Appropriate Sponsorship Amount to be handed over to the College on the first day of the workshop

a. Mode of Payment can be Cheques/Demand Draft/Cash b. Proper Receipt will be provided by College

Contact Us: We ensure that you will find our training programs extremely beneficial for your students. If you have any queries kindly get back to us. We are looking forward to a quick and positive response from you and a long term association with your esteemed organization.

Thanks & Regards, If you have any queries, kindly contact us on

Sarika Sharma, Mob: +91-9911030818 Email: [email protected]


8.12. Backing Up and Restoring Databases and Tables8.13. BackingUp Databases and Tables8.14. Restoring Databases and Tables from Backup8.15. Dropping Databases and Tables8.16. Viewing Database, Table, and Field Information

Workshop Fees & Student takeaways: Rs. 1200 per participant (inclusive of all taxes)

1. One Software toolkit will be delivered for each participant free of cost. 2. Certificate from Techbharat consulting Pvt. Ltd. and AIESEC IIT-Delhi for every participant

php with my sql - techbharat · pdf filea two days workshop on php with my sql ... consulting...

Documents