12th Standard Syllabus & Materials

12th Standard

TN 12th Standard Biology Zoology - Reproduction in Organisms Creative Questions Study Material - QB365 Set D

NEW

12th Standard

TN 12th Standard Biology Zoology - Reproduction in Organisms Creative Questions Study Material - QB365 Set C

NEW

12th Standard

TN 12th Standard Biology Zoology - Reproduction in Organisms Creative Questions Study Material - QB365 Set B

NEW

12th Standard

TN 12th Standard Biology Zoology - Reproduction in Organisms Creative Questions Study Material - QB365 Set A

NEW

12th Standard

TN 12th Standard Physics Electronics and Communication Creative Questions Study Material - QB365 Set D

NEW

12th Standard

TN 12th Standard Physics Electronics and Communication Creative Questions Study Material - QB365 Set C

12th Standard English Medium Computer Applications Subject Connecting PHP and MYSQL Book Back 3 Mark Questions with Solution updated Book back Questions

Published on: 13/05/2022

QB365 provides detailed and simple solution for every book back questions in class 12 Computer Applications subject.It will helps to get more idea about question pattern in every book back questions with solution.

latest Book back Questions

Download Tamil Nadu 12th Standard Computer Applications question papers, model tests, one-mark questions, important questions, and public exam papers in PDF format. Free study materials and answer keys for TN State Board students.

Questions + Answers key

Take MCQ Computer Applications Test

QB365 Student Learing Managemnet System

Std: 12th Standard - Computer Applications

chapter: - Book back Questions

Visit QB365-SLMS - https://www.qb365.in/slms/ Complete Questions and Answers

Questions:

Generic 3

5 x 3 = 15

Write a note PHP MySQL database connection.

Write MySQL Connection Syntax with example.

Differentiate mysqli_affected_rows( ) Function and mysqli_fetch_assoc( ) Function.

Write is the purpose of MySQLi function available.

Write the Syntax for MySQLi Queries.

Visit QB365-SLMS - https://www.qb365.in/slms/

Answers Key:

Generic 3

5 x 3 = 15

Database Connections: Accessing MySQL Database, connect to Database Server machine via PHP scripting language using Mysqli_connect() Function.
Syntax:
mysqli_connect("Server Name","User Name","Password","DB Name");
This function requires four parameters to connect to database server. Database Server name, Database username, password and Database Name.

Syntax:
mysqli_connect("Server Name","User Name","password","DB Name");
Example:

mysqli_affected rows( )	mysqli_fetch_assoc( )
It returns the number of affected rows in the prearvious SELECT, INSERT UPDATE, REPLACE, or DELETE query.	It fetches a result rowas an associative aray
Return value: An integer >0 indicates the number of rows affected (0 indicates that no records were affected. '-1' indicates that the query returned an error).	Returns an associative array of strings representing the fetched row. NULL if there are no more rows in result set.
Syntax: mysqli_affected_rows (connection);	Syntax: mysqli fetch_as-soc(result);

In PHP Scripting language many functions are available for MySQL Database connectivity and executing SQL queries. MySQLi is extension in PHP Scripting language which gives access to the MySQL database. MySQLi extension was introduced version 5.0.0.

The MySQLi extension contains the following important functions which are related to MySQL database connectivity and management.
i) Mysqli_connect() Function
ii) Mysqli_close() Function
iii) Mysqli_query() Function