Home BCA/BTech JEE RAS RSCIT Blogs
Switch Language हिन्दी
BCA / B.Tech 22 min read

Use of MySQL in PHP

Use Of My SQL in PHP in Hindi | Use of MySQL in PHP in Hindi :


PHP and MySQL are used to create websites and web applications. PHP is a server-side scripting language and MySQL is a database management system. PHP is used to process data and MySQL is used to store, manage, and access data.

Use Of MYSQL in PHP in Hindi | Use of MySQL in PHP in Hindi


MySQL and PHP relationship:

Through PHP, we can connect to a MySQL database, store data, update it, and fetch data. It is used for CRUD operations:

  • Create: to add new data.
  • Read: to read or view data.
  • Update: to update existing data.
  • Delete: to remove data.
  • Steps to use MySQL in PHP
Connecting to database in PHP in Hindi |  Connecting to the database:

PHP's mysqli_connect() or PDO (PHP Data Objects) can be used to connect to a MySQL database.

<?php
$servername = "localhost";
$username = "root";
$password = "";
$database = "my_database";

// Create a connection
$conn = mysqli_connect($servername, $username, $password, $database);

// Check the connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connection successful!";
?>

Inserting data to database in Hindi | Adding data to the database:

An SQL query is used to insert data into the database.

<?php
$sql = "INSERT INTO users (name, email) VALUES ('Rahul', '[email protected]')";
if (mysqli_query($conn, $sql)) {
    echo "Data added successfully!";
} else {
    echo "Error: " . mysqli_error($conn);
}
?>

Reading in Hindi | Reading data:

A SELECT query is used to read data.

<?php
$sql = "SELECT id, name, email FROM users";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        echo "ID: " . $row["id"] . " - Name: " . $row["name"] . " - Email: " . $row["email"] . "
";
    }
} else {
    echo "No data found.";
}
?>
Update in Hindi | Updating data: 

An UPDATE query is used to update data.


<?php
$sql = "UPDATE users SET email='[email protected]' WHERE name='Rahul'";
if (mysqli_query($conn, $sql)) {
    echo "Data updated successfully!";
} else {
    echo "Error: " . mysqli_error($conn);
}
?>

Delete in Hindi | Deleting data:

A DELETE query is used to delete data.

<?php
$sql = "DELETE FROM users WHERE name='Rahul'";
if (mysqli_query($conn, $sql)) {
    echo "Data deleted successfully!";
} else {
    echo "Error: " . mysqli_error($conn);
}
?>

Closing Database connection in Hindi | Closing the database connection:

It is important to close the connection when the work is done.

<?php
mysqli_close($conn);
?>

Importance of PHP and MySQL in Hindi | Importance of PHP and MySQL:

  • Helps in creating dynamic web pages.
  • Can easily store and manage large amounts of data.
  • It is easy to implement CRUD operations.
  • It is fast, secure, and open-source.
  • Using PHP and MySQL together makes a website intelligent and interactive.
  • You can easily create a login system, e-commerce website, blogging platform, etc. with it.


General Installation Consideration in MYSQL in PHP in Hindi 


  • General considerations for installing MySQL with PHP
  • Installation and setup for PHP and MySQL are easy, but it is important to pay attention to the correct configuration and settings at every step.
  •  Once set up, you can create secure and fast web applications using MySQL.
  • Before using PHP and MySQL, some necessary installation and setup are required.

Below are the important steps and considerations for this:

Need of Server in Hindi | Server requirement:

PHP and MySQL are used through a web server. For this, you can use any of the following options:

  • XAMPP: This is a combination of Apache, MySQL, and PHP.
  • WAMP: A combination of Apache, MySQL, and PHP for Windows.
  • MAMP: For Mac.
  • LAMP: For Linux.
  • Custom Server Setup: If you want to configure your server individually.

XAMPP installation process:

  • Download XAMPP from the Apache Friends website.
  • Run the installer and install Apache and MySQL.
  • After installation, open the XAMPP control panel.
  • Start the Apache and MySQL services.

PHP and MySQL version compatibility in Hindi | PHP and MySQL version compatibility:

Ensure that the versions of PHP and MySQL are compatible with each other.
Example:

Use MySQL 5.x or a newer version with PHP 7.x.
Using the latest version is better as it comes with new features and security updates.

PHP MySQL extension support in Hindi |  PHP MySQL extension support

The MySQLi or PDO (PHP Data Objects) extension is used for communication between PHP and MySQL:

MySQLi (MySQL Improved): Only for MySQL.
PDO (PHP Data Objects): Supports various types of databases.
Ensure that these extensions are enabled during installation.

  • To enable:
Go to the php.ini file.

  • Find this line:
extension=mysqli
or
extension=pdo_mysql
If it is commented (starts with # or ;), then uncomment it.

Take care of default ports in Hindi | Pay attention to default ports:

Apache: Port 80 or 8080.
MySQL: Port 3306. If these ports are in use by any other service, you will have to change it in your server's configuration.

MySQL user account and password setup in Hindi | MySQL user account and password setup:

After installation, set up a secure user account:

  • Default user: root
  • Default password: (is empty, but should be changed).
  • To set a password:
  • Open the MySQL command line: mysql -u root
  • Change the password: ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';

Installing phpMyAdmin in Hindi |  Installing phpMyAdmin:

  • phpMyAdmin is a GUI tool that helps in managing MySQL databases.
  • It is usually pre-installed with XAMPP and WAMP.
  • phpMyAdmin can be accessed at the http://localhost/phpmyadmin URL.
Firewall & Network Settings in Hindi | Firewall and network settings:

If you want to use MySQL from outside the local server (remote access):

  • Allow the MySQL port (3306) in the firewall.
  • Set the bind-address in the MySQL config file (my.cnf or my.ini) to 0.0.0.0 or your server's IP address.

Testing PHP and MySQL in Hindi | Testing PHP and MySQL:

After installation, check the connection between PHP and MySQL:

PHP test code:

<?php
$servername = "localhost";
$username = "root";
$password = ""; // Put your password here

// Check the connection
$conn = mysqli_connect($servername, $username, $password);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connection between PHP and MySQL is successful!";
?>

Important points for safety in Hindi | Important points for security:

  • Change the default password.
  • Make phpMyAdmin secure (set a custom URL or access control).
  • Hide error messages on the production server.
  • Take regular backups.
List of required equipment in Hindi | List of required equipment:

  • PHP: For server-side coding.
  • MySQL: For data storage.
  • Web server: Apache or Nginx.
  • phpMyAdmin: GUI tool for database management.
  • Text editor/IDE: For coding (e.g., VS Code, Sublime Text).

In this Chapter

Use of MySQL in PHP
Introduction to PHP
Flow Control Statements in PHP
Embedding PHP in Webpages
How to Configure Our Framework
Difference between PHP and HTML
Advance Features of PHP
Expression in PHP
Juggling Expression in PHP
Comments in PHP
Whitespace in PHP
Error Handling in PHP | What is Error Handling in PHP?
Sending Email By PHP