Home Library Explore SAT

Home Library Explore SAT

PHP and MySQL Integration Flashcards | StudBud

Explore/PHP and MySQL Integration

Why we use prepared statements in PHP?

How does PHP get data from MySQL?

PHP and MySQL Integration

10 terms·StudBud Administration·1 play

Imported from external platform

Flashcards10 cardsFPractice quizPHost liveL

Questions 10

Answers

1
How does PHP get data from MySQL?
A) Through HTTP
C) By sending JSON data
B) Using SQL statements
D) Using XML files
2
Why we use prepared statements in PHP?
A) To print data to the console
B) To display HTML content
D) To perform file operations
C) To prevent SQL injection
3
What does CRUD stand for?
B) Connect, Retrieve, Update, Delete
C) Create, Run, Upload, Download
A) Create, Read, Update, Delete
D) Compile, Read, Use, Deploy
4
Which extension uses a procedural style?
D) SOAP
A) PDO
B) MySQLi
C) SQLLite
5
What does MySQL send back after a query?
D) HTML document
A) JSON object
B) Result set
C) XML data
6
Why in modern applications we choose PDO over MySQLi?
C) It is faster than MySQLi
B) It requires fewer lines of code
A) It supports multiple database types
D) It only works with local databases
7
Which PHP extension is recommended for modern database connections?
A) MySQLi
D) XMLDB
C) SQLite
B) PDO
8
What is the main purpose of PHP in web development?
A) Client-side scripting
C) Database management
B) Server-side scripting
D) Networking
9
Which SQL command reads data from a database?
C) DELETE
A) INSERT
D) SELECT
B) UPDATE
10
Which CRUD operation updates existing data?
C) UPDATE
B) READ
D) DELETE
A) CREATE