Lupin Interview Questions and Answers

The $requested variable in PHP is used to store user input or data passed through a form or URL.

• Used to access user input or data submitted through forms or URLs

• Helps in processing and manipulating user input within PHP scripts

• Prevents direct access to sensitive data by storing it in a variable

Database connectivity in PHP involves establishing a connection to a database server and executing queries to retrieve or manipulate data.

• Use PHP's built-in functions like mysqli_connect() or PDO to establish a connection to the database

• Execute SQL queries using functions like mysqli_query() or PDO::query() to interact with the database

• Remember to handle errors and close the connection after use to ensure security and efficiency

GET and POST are HTTP methods used to send data to a server in web development.

• GET method sends data in the URL, visible to users

• POST method sends data in the body of the request, not visible to users

• GET requests are cached by the browser

• POST requests are not cached and are more secure for sensitive data

• GET requests have length restrictions, while POST requests do not

Creating a form in HTML involves using the

Attributes in PHP are used to add metadata to classes, methods, or properties.

• Attributes are declared using the #[Attribute] syntax.

• They can be used to provide additional information about the code.

• Attributes can be retrieved using reflection.

• Example: #[Route('/home')] class HomeController {}

SQL query for submitting form data to database

• Use INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...)

• Make sure to sanitize user input to prevent SQL injection

• Consider using prepared statements for security