Jawaharlal Nehru Technological University Hyderabad B.Tech IV Year PHP PROGRAMMING Previous Question Paper (September - 2022 - R16)

To configure PHP to work with MySQL, follow these installation and configuration steps:

1. Install a web server (e.g., Apache), PHP, and MySQL. Using an integrated stack like XAMPP or WAMP is the most efficient method for development.
2. Locate the php.ini configuration file, typically found in the PHP installation directory.
3. Open php.ini in a text editor and search for the extension section. Uncomment the line
   extension=php_mysqli.dll
   by removing the semicolon at the start.
4. Ensure the extension_dir directive points to the correct folder containing the extension files.
5. Restart the web server to apply the changes.
6. Verify the installation by creating a PHP file containing the phpinfo() function. Access this file via a browser and search for the 'mysqli' section to confirm it is enabled.
7. Test the connection using a script:

   $conn = new mysqli('localhost', 'username', 'password', 'database'); if ($conn->connect_error) { die('Connection failed'); }

To set up users and manage privileges in MySQL, use the following SQL commands:

1. Create a new user:
   CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
2. Grant specific privileges to the user for a database:
   GRANT SELECT, INSERT, UPDATE ON database_name.* TO 'username'@'localhost';
3. Apply the changes immediately by running the flush command:
   FLUSH PRIVILEGES;
4. To grant all privileges, use the ALL PRIVILEGES keyword, and to restrict access to a specific host, replace 'localhost' with the appropriate IP address or '%' for remote access.