12th Standard Syllabus & Materials
12th Standard
TN 12th Computer Applications மின்னணு தரவு பரிமாற்றம் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications மின் - வணிக பாதுகாப்பு அமைப்புகள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications மின்னணு செலுத்தல் முறைகள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications மின் - வணிகம் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications திறந்த மூல கருத்துருக்கள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications வலையமைப்பு வடமிடல் Sample Question Papers Study Material - QB365 Set A

Published on: 27/09/2019
Connecting PHP and MYSQL
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

1.
What is the main goal of MySQL and PHP connectivity?
2.
How many parameters to connect to database server, in Mysqli_connect( ) Function?
3.
What are the major operations of database?
4.
What is MySQLi?
5.
Expand RDBMS.
6.
Define mysqli_affected_rows() Function.
7.
Define mysqli_connect_error() Function
8.
What is mysqli_fetch_assoc() Function?
9.
What is web Database?
10.
What is Connection string?
11.
Give few examples of MySQLi Queries.
12.
Difference between Connection and Close function?
13.
What are the types MySQLi function available PHP?
14.
What is MySQLi function?
15.
What are the MySQLi function available PHP?
1.
To retrieve and manipulate the data from MySQL database server.
2.
This function requires four parameters to connect to database server.
3.
INSERT, SELECT,UPDATE and DELETE.
4.
MySQLi is extension in PHP scripting language which gives access to the MYSQL database.
5.
Relational Database Management System.
6.
1. The mysqli_affected_rows() function returns the number of affected rows in the previous SELECT, INSERT, UPDATE, REPLACE,or DELETE query.
2. Syntax
mysqli_affected_rows( connection);
7.
1.The mysqli_connect_error() function returns the error description from the last connection error, if any.
2.Syntax
mysqli_connect_error( );
8.
1. The mysqli_fetch_assoc() function fetches a result row as an associative array .
2. Syntax
mysqIi_fetch_assoc(result);
9.
1. A Web database is a database application designed to be managed and accessed through the Internet.
2. In other words, the light databases that support the web applications are also known as Web Databases
10.
(i) In computing, a connection string is a string that specifies information about a data source and the means of connected to it.
(ii) It is passed in code to underlying driver or provider in order to initiate the connection.
11.
EXAMPLES:
(i) SELECT * FROM Customers;
(ii) SELECT CustomerName, City FROM Customers;
(iii) SELECT * FROM Customers WHERE Country='Mexico';
(iv) SELECT * FROM Customers WHERE Country=Germany' AND City='Berlin;
(v) DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';
12.
| Connection function | Close function |
|---|---|
| 1) Before accessing MYSQL Database, connect to Database Server machine via PHP scripting language using Mysqli_connect() Function. | Mysqli_close() Function is used to close an existing opened database connection between PHP scripting and MySQL Database Server. |
| 2) This function requires 4 parameters | This function requires only one parameter. |
13.
Types of MYSQL Functions in PHP:
(i) Database Connectíons
(ii) Managing Database
(iii) Performing Queries
(iv) Closing Connection
14.
(i) The MySQLi functions allows you to access MYSQL database servers.
(ii) For the MYSQL functions to be available, you must compile PHP with support for the MYSQLi extension.
15.
(i) Mysqli_connect() Function
(ii) Mysqli_close() Function
(iii) Mysqli_query() Function
12th Standard Syllabus & Materials
12th Standard
TN 12th Computer Applications களப்பெயர் முறைமை (DNS) Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications வலையமைப்பு எடுத்துக்காட்டுகள் மற்றும் நெறிமுறைகள் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications கணினி வலையமைப்பு ஓர் அறிமுகம் Sample Question Papers Study Material - QB365 Set A
NEW12th Standard
TN 12th Computer Applications PHP-உடன் MySQL-ஐ இணைத்தல் Sample Question Papers Study Material - QB365 Set A
Tamilnadu Stateboard 12th Standard Subjects

Maths

Chemistry

Physics

Biology

Computer Science

Business Maths and Statistics

Economics

Commerce

Accountancy

History

Computer Applications

Biology

Computer Technology

Computer Applications

Computer Science

Business Maths and Statistics

Commerce

Economics

Maths

Chemistry

Physics

Computer Technology

History

Accountancy

Tamil

English

French
Tamilnadu Stateboard Standards