Understanding PHP and Its Ecosystem

What is the purpose of a function in PHP?

• To handle user input validation

• The purpose of a function in PHP is to encapsulate code for reuse and organization.

• To store data in a database

• To create HTML elements dynamically

How do you connect PHP to a MySQL database?

• Connect using a file-based approach with PHP.

• Use mysql_query() to connect to the database.

• Use mysqli_connect() or PDO to establish a connection to the MySQL database.

• Utilize the exec() function to run SQL commands directly.

Name a popular PHP framework and its primary use.

• CakePHP

• Laravel

• CodeIgniter

• Symfony

What is AJAX and how does it relate to PHP?

• AJAX is a database management system that works with PHP.

• PHP is a client-side scripting language that replaces AJAX.

• AJAX is a technique for asynchronous web requests, and it relates to PHP as PHP can be used to handle server-side processing for AJAX calls.

• AJAX is a programming language used for web development.

How can you send cookies in PHP?

• Use the cookie() function in PHP.

• Send cookies using the header() function only.

• Store cookies in a database instead of sending them.

• Use the setcookie() function in PHP.

What is the difference between sessions and cookies in PHP?

• Sessions are stored in the browser; cookies are stored on the server.

• Sessions are server-side; cookies are client-side.

• Cookies can hold larger amounts of data than sessions.

• Sessions expire after a set time; cookies last indefinitely.

How do you use jQuery with PHP?

• Include jQuery in your HTML, use AJAX to communicate with PHP.

• Use jQuery without any HTML or AJAX.

• Use PHP to directly manipulate the DOM.

• Include jQuery in your PHP files only.

What is the purpose of the mail() function in PHP?

• To store emails in a database using PHP.

• To delete emails from a PHP script.

• To send emails from a PHP script.

• To receive emails from a PHP script.

How can you retrieve data from a MySQL database using PHP?

• Connect using FTP to retrieve data.

• Execute a DELETE query to fetch results.

• Use mysqli or PDO to connect, execute a SELECT query, and fetch results.

• Use only SQL commands without PHP.

What are some common security practices when using PHP with MySQL?

• Using only GET requests for all data transactions

• Common security practices include using prepared statements, validating inputs, proper error handling, using HTTPS, and keeping software updated.

• Storing passwords in plain text

• Disabling error reporting completely