Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
web system tech FA2
| Question | Answer |
|---|---|
| What does the $primaryKey property in a Model define? | The column CodeIgniter treats as the unique identifier for each row |
| Which CodeIgniter file typically stores database connection settings such as hostname, username, and database name? | Database.php only |
| A new priority column is added directly in the database, but $allowedFields is never updated to include it. What happens when a controller tries to save a priority value through this Model? | It is silently dropped because $allowedFields still does not list it |
| What term describes an unauthorized attempt to manipulate a database through injected SQL, which Query Builder helps prevent? | SQL injection |
| What does a Model's $allowedFields property control? | Which fields may be mass-assigned during insert() or update() |
| The public folder should contain the application's business logic, including Models. | False |
| Matching type. Match the term with the correct description. $allowedFields | Restricts which fields may be mass-assigned during insert or update |
| Matching type. Match the term with the correct description. where() | Filters query results based on a condition |
| Which property in a Model tells CodeIgniter which database table the Model represents? | $table |
| What term describes the special class that represents and manages a specific database table? | Model |
| findAll() returns only the first matching record from a table. | False |
| 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? | Any change to the task list requires editing code, and the two sources of data can fall out of sync |
| Every CodeIgniter application must have at least one Model, even if it does not use a database. | False |
| A team stores database passwords directly inside a Model's PHP file instead of .env. What is the main problem with this? | Credentials embedded in code are more likely to be exposed and harder to change per environment than values in .env |
| What is the primary purpose of a CodeIgniter Model? | What is the primary purpose of a CodeIgniter Model? |
| 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? | The Query Builder version, because it automatically escapes the value and reduces SQL injection risk |
| A model defines protected $allowedFields = ['title', 'status']; but a controller tries to insert a record that also includes a description value. What happens? | The description value is silently ignored because it is not in $allowedFields |
| Matching type. Match the term with the correct description. $table | Tells a Model which database table it represents |
| Matching type. Match the term with the correct description. findAll() | Retrieves every record from a Model's table |
| What Query Builder method sorts retrieved records by a specific column, ascending or descending? | orderBy() |
| 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? | The view has no <title> tag |
| The .env file is used to store view templates. | False |
| Chaining where() and orderBy() lets you filter and sort a query in a single statement. | True |
| Why is CodeIgniter's Query Builder generally considered safer than concatenating raw SQL strings with user input? | Query Builder automatically escapes values, reducing the risk of SQL injection |
| Which Query Builder method retrieves a single record by its primary key? | find($id) |
| 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? | The single record is stored under the plural key 'tasks' but the view expects $task (singular) |
| What is the name of the CodeIgniter file where database connection settings are typically stored? | .env file |
| A view shows "Undefined variable $tasks" even though the Model successfully retrieves records in the controller. What is the most likely cause? | The controller did not include tasks in the data array passed to view() |
| What term describes the special class that represents and manages a specific database table? | Model |
| A new priority column is added directly in the database, but $allowedFields is never updated to include it. What happens when a controller tries to save a priority value through this Model? | It is silently dropped because $allowedFields still does not list it |
| A table has columns id, title, status, created_at. Which line correctly inserts a new row with only a title? | $model->insert(['title' => 'Buy groceries']); |
| CodeIgniter automatically creates database tables the first time a Model is used. | CodeIgniter automatically creates database tables the first time a Model is used. |
Created by:
jxxnixx