📚 Database Systems (2023)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/101

💬 Tags: #Database

USEFUL CHANNELS FOR YOU

📚 Database Performance at Scale (2023)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/936

💬 Tags: #Database

👉 BEST DATA SCIENCE CHANNELS ON TELEGRAM 👈

📚 Real-Time Database Systems (2024)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/1092

💬 Tags: #RealTime #DataBase

USEFUL CHANNELS FOR YOU

📚 Streaming Databases (2024)

1⃣ Join Channel Download:
https://t.iss.one/+MhmkscCzIYQ2MmM8

2⃣ Download Book: https://t.iss.one/c/1854405158/1800

💬 Tags: #database

USEFUL CHANNELS FOR YOU

Topic: PHP Basics – Part 10 of 10: Connecting PHP with MySQL Database (CRUD Operations)

---

1. Introduction

PHP works seamlessly with MySQL, one of the most popular open-source relational databases. In this lesson, we’ll learn how to:

• Connect to a MySQL database
• Perform basic CRUD operations (Create, Read, Update, Delete)

We’ll use the mysqli extension (object-oriented style) in this tutorial.

---

### 2. Setting Up the Database

Suppose we have a MySQL database named school with a table students:

CREATE DATABASE school;

USE school;

CREATE TABLE students (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(50),
  email VARCHAR(100),
  age INT
);

---

### 3. Connecting PHP to MySQL

<?php
$host = "localhost";
$user = "root";
$password = "";
$db = "school";

$conn = new mysqli($host, $user, $password, $db);

if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully!";
?>

---

### 4. Create (INSERT)

<?php
$sql = "INSERT INTO students (name, email, age) VALUES ('Ali', '[email protected]', 22)";
if ($conn->query($sql) === TRUE) {
  echo "New record created successfully.";
} else {
  echo "Error: " . $conn->error;
}
?>

---

### 5. Read (SELECT)

<?php
$sql = "SELECT * FROM students";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
    echo "ID: " . $row["id"]. " | Name: " . $row["name"]. " | Email: " . $row["email"]. "<br>";
  }
} else {
  echo "0 results";
}
?>

---

### 6. Update (UPDATE)

<?php
$sql = "UPDATE students SET age = 23 WHERE name = 'Ali'";
if ($conn->query($sql) === TRUE) {
  echo "Record updated successfully.";
} else {
  echo "Error updating record: " . $conn->error;
}
?>

---

### 7. Delete (DELETE)

<?php
$sql = "DELETE FROM students WHERE name = 'Ali'";
if ($conn->query($sql) === TRUE) {
  echo "Record deleted successfully.";
} else {
  echo "Error deleting record: " . $conn->error;
}
?>

---

### 8. Prepared Statements (Best Practice for Security)

Prevent SQL injection by using prepared statements:

<?php
$stmt = $conn->prepare("INSERT INTO students (name, email, age) VALUES (?, ?, ?)");
$stmt->bind_param("ssi", $name, $email, $age);

$name = "Sara";
$email = "[email protected]";
$age = 20;

$stmt->execute();
echo "Data inserted securely.";
$stmt->close();
?>

---

### 9. Closing the Connection

$conn->close();

---

### 10. Summary

• PHP connects easily with MySQL using mysqli.

• Perform CRUD operations for full database interaction.

• Always use prepared statements for secure data handling.

---

### Exercise

1. Create a PHP page to add a student using a form.
2. Display all students in a table.
3. Add edit and delete buttons next to each student.
4. Implement all CRUD operations using mysqli.

---

#PHP #MySQL #CRUD #PHPTutorial #WebDevelopment #Database

https://t.iss.one/Ebooks2023

# 📚 Connecting MySQL Database with Popular Programming Languages

#MySQL #Programming #Database #Python #Java #CSharp #PHP #Kotlin #MATLAB #Julia

MySQL is a powerful relational database management system. Here’s how to connect MySQL with various programming languages.

---

## 🔹 1. Connecting MySQL with Python
#Python #MySQL
Use the mysql-connector-python or pymysql library.

import mysql.connector

# Establish connection
conn = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

cursor = conn.cursor()
cursor.execute("SELECT * FROM your_table")
result = cursor.fetchall()

for row in result:
    print(row)

conn.close()

---

## 🔹 2. Connecting MySQL with Java
#Java #JDBC
Use JDBC (Java Database Connectivity).

import java.sql.*;

public class MySQLJava {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/your_database";
        String user = "your_username";
        String password = "your_password";

        try {
            Connection conn = DriverManager.getConnection(url, user, password);
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM your_table");

            while (rs.next()) {
                System.out.println(rs.getString("column_name"));
            }

            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

---

## 🔹 3. Connecting MySQL with C# (.NET)
#CSharp #DotNet #MySQL
Use MySql.Data NuGet package.

using MySql.Data.MySqlClient;

string connStr = "server=localhost;user=your_username;database=your_database;password=your_password";
MySqlConnection conn = new MySqlConnection(connStr);

try {
    conn.Open();
    string query = "SELECT * FROM your_table";
    MySqlCommand cmd = new MySqlCommand(query, conn);
    MySqlDataReader reader = cmd.ExecuteReader();

    while (reader.Read()) {
        Console.WriteLine(reader["column_name"]);
    }
} catch (Exception ex) {
    Console.WriteLine(ex.Message);
} finally {
    conn.Close();
}

---

## 🔹 4. Connecting MySQL with PHP
#PHP #MySQL
Use mysqli or PDO.

<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM your_table";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo $row["column_name"];
    }
} else {
    echo "0 results";
}

$conn->close();
?>

---

## 🔹 5. Connecting MySQL with Kotlin
#Kotlin #JDBC
Use JDBC (similar to Java).

import java.sql.DriverManager

fun main() {
    val url = "jdbc:mysql://localhost:3306/your_database"
    val user = "your_username"
    val password = "your_password"

    try {
        val conn = DriverManager.getConnection(url, user, password)
        val stmt = conn.createStatement()
        val rs = stmt.executeQuery("SELECT * FROM your_table")

        while (rs.next()) {
            println(rs.getString("column_name"))
        }

        conn.close()
    } catch (e: Exception) {
        e.printStackTrace()
    }
}

---

## 🔹 6. Connecting MySQL with MATLAB
#MATLAB #Database
Use Database Toolbox.

conn = database('your_database', 'your_username', 'your_password', 'com.mysql.jdbc.Driver', 'jdbc:mysql://localhost:3306/your_database');

data = fetch(conn, 'SELECT * FROM your_table');
disp(data);

close(conn);

---

## 🔹 7. Connecting MySQL with Julia
#Julia #MySQL
Use MySQL.jl package.

using MySQL

conn = MySQL.connect("localhost", "your_username", "your_password", db="your_database")

result = MySQL.execute(conn, "SELECT * FROM your_table")

for row in result
    println(row)
end

MySQL.disconnect(conn)

---