Question 1

CodeIgniter automatically creates database tables the first time a Model is used.

Accepted Answer

False

Question 2

Why is CodeIgniter's Query Builder generally considered safer than concatenating raw SQL strings with user input?

Accepted Answer

Query Builder automatically escapes values, reducing the risk of SQL injection

Question 3

A table has columns id, title, status, created_at. Which line correctly inserts a new row with only a title?

Accepted Answer

$model->insert(['title' => 'Buy groceries']);

Question 4

Which CodeIgniter file typically stores database connection settings such as hostname, username, and database name?

Accepted Answer

.env

Question 5

Comparing SELECT * FROM tasks WHERE status = '$status' (built by directly inserting a variable into a SQL string) against $builder->where('status', $status)->get();, which is safer and why?

Accepted Answer

The Query Builder version, because it automatically escapes the value and reduces SQL injection risk.

Question 6

Chaining where() and orderBy() lets you filter and sort a query in a single statement.

Accepted Answer

True

Question 7

Which method would you chain to where('status', 'pending') to sort results by creation date, newest first?

Accepted Answer

orderBy('created_at', 'DESC')

Question 8

The .env file is used to store view templates.

Accepted Answer

False

Question 9

A developer hardcodes a task list directly inside a controller using a PHP array, even though a database table for tasks already exists. What is the main drawback?

Accepted Answer

Any change to the task list requires editing code, and the two sources of data can fall out of sync.

Question 10

A page correctly lists all tasks, but clicking into one specific task shows "Undefined variable $task." The controller has: $data['tasks'] = $model->find($id); return view('tasks/show', $data);. What is the bug?

Accepted Answer

The single record is stored under the plural key 'tasks' but the view expects $task (singular).

Question 11

Which Query Builder method retrieves a single record by its primary key?

Accepted Answer

find($id)

Question 12

What term describes the special class that represents and manages a specific database table?

Accepted Answer

Model

Question 13

After correctly configuring .env and creating a Model, a page still throws a database connection error. Which of these is LEAST likely to be the cause?

Accepted Answer

The view has no <title> tag.

Question 14

Which line correctly retrieves all tasks with status 'done' using a TaskModel instance $model?

Accepted Answer

$model->where('status', 'done')->findAll();

Question 15

The public folder should contain the application's business logic, including Models.

Accepted Answer

False

Question 16

A team stores database passwords directly inside a Model's PHP file instead of .env. What is the main problem with this?

Accepted Answer

Credentials embedded in code are more likely to be exposed and harder to change per environment than values in .env.

Question 17

where()

Accepted Answer

Filters query results based on a condition

Question 18

What is the primary purpose of a CodeIgniter Model?

Accepted Answer

To manage data and communicate with the database

Question 19

What is the name of the CodeIgniter file where database connection settings are typically stored?

Accepted Answer

.env

Question 20

In the typical CodeIgniter data flow, which component calls the Model to retrieve data before passing it to a View?

Accepted Answer

The Controller

Question 21

findAll()

Accepted Answer

Retrieves every record from a Model's table

Question 22

$allowedFields

Accepted Answer

Restricts which fields may be mass-assigned during insert or update

Question 23

What Query Builder method sorts retrieved records by a specific column, ascending or descending?

Accepted Answer

orderBy()

Question 24

Which Query Builder method retrieves every record from a Model's table?

Accepted Answer

findAll()

Question 25

What term describes an unauthorized attempt to manipulate a database through injected SQL, which Query Builder helps prevent?

Accepted Answer

SQL injection

"Know" box contains:
Time elapsed:
Retries:

Stack #4716043