Quiz 3 - ITEDEV - Final

What PHP library is used to read Excel files?

• PhpSpreadsheet
• PHPExcel
• ExcelJS
• PDO

Answer explanation

PHPExcel and PhpSpreadsheet are both popular, but PhpSpreadsheet is the modern library.

Which PHP function is used to move uploaded files?

• upload_file()
• store_file()
• move_uploaded_file()
• save_as()

Answer explanation

move_uploaded_file() is the correct function.

What HTML attribute is required to upload Excel files?

• type='csv'
• name='upload'
• enctype='multipart/form-data'
• action='upload.php'

Answer explanation

Forms must include enctype='multipart/form-data' to handle file uploads.

What is the purpose of exporting data from a database?

• To delete old data
• To backup the server
• To generate reports in Excel
• To create new tables

Answer explanation

Exporting enables creating downloadable reports for users.

Which SQL statement is commonly used before exporting?

• INSERT
• SELECT
• UPDATE
• ALTER

Answer explanation

SELECT is used to gather data for export.

What is typically used to compute total price with checkboxes?

• radio buttons
• text fields
• checkboxes
• drop-downs

Answer explanation

Checkboxes allow users to select multiple options for total calculation.

What JavaScript function helps calculate real-time total?

• calculateSum()
• onchange()
• updateTotal()
• parseFloat()

Answer explanation

parseFloat() converts string to number in calculations.

Which PHP function formats numbers for display?

• format_number()
• number_format()
• convert_to_float()
• round()

Answer explanation

number_format() is used to show currency values properly.

Which Stripe key is safe to use in client-side code?

• secret_key
• database_key
• publishable_key
• server_token

Answer explanation

Only publishable_key should be exposed on the client side.

Which method processes Stripe transactions securely?

• Stripe::pay()
• Stripe::charge()
• Stripe API with keys
• form-submit()

Answer explanation

Stripe uses an API and token-based system for secure payments.