LESSON5-XAMPP

Question 1

is a popular cross-platform web server solution stack package developed by Apache Friends, consisting mainly of Apache HTTP Server, MariaDB database (previously MySQL), and interpreters for scripts written in the PHP and Perl programming languages.

Answer 1

XAMPP

Question 2

is a free and open-source administration tool for MySQL and MariaDB databases.

Answer 2

PHPMyAdmin

Question 3

simplifies setting up a local web server environment for PHP development. It bundles all the necessary components, including the Apache web server, MySQL database, PHP, and Perl, making it easy to install and configure on various operating systems such as Windows, macOS, and Linux.

Answer 3

XAMPP

Question 4

is a web-based interface for managing MySQL databases. It provides a userfriendly graphical interface for tasks such as creating, deleting, and modifying databases, tables, and records.
_________ also allows users to execute SQL queries, import and export data, and manage database
users and privileges.

Answer 4

PHPMyAdmin

Question 5

is a feature used to execute the same (or similar) SQL statements repeatedly with high efficiency.

Answer 5

Prepared Statements

Question 6

involves adding new data entries to the database.

Answer 6

Create(Insert)
$sql = “INSERT INTO users (name, email) VALUES (‘$name’, ‘$email’)”;

Question 7

involves fetching data from the database and displaying it to users.

Answer 7

Read(Retrieve)
$sql = “SELECT * FROM users”;
$result = mysqli_query($conn, $sql);

Question 8

allows users to modify existing data entries in the database.

Answer 8

Update
$sql = “UPDATE users SET name=’$name’, email=’$email’ WHERE id=$id”;

Question 9

involves removing data entries from the database.

Answer 9

Delete
$sql = “DELETE FROM users WHERE id=$id”;

Question 10

Database Connection

Answer 10

<?php

$servername='localhost';
$username='root';
$password='';
$dbname = "db_name";
$dbconnect=mysqli_connect($servername,$username,$password,"$dbname");
  if(!$dbconnect){
      die('Could not Connect MySql Server:' . mysqli_connect_error());
    }

?>