Blog

SQL Command

CREATE DATABASE mydb;

SQL Command

CREATE TABLE users (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(50) NOT NULL,
  email VARCHAR(50),
  reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "mydb";

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

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

<form action="insert.php" method="post">
  <label>নাম:</label><br>
  <input type="text" name="name"><br><br>
  <label>ইমেইল:</label><br>
  <input type="email" name="email"><br><br>
  <input type="submit" value="জমা দিন">
</form>

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "mydb";

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

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

$name = $_POST['name'];
$email = $_POST['email'];

$sql = "INSERT INTO users (name, email) VALUES ('$name', '$email')";

if ($conn->query($sql) === TRUE) {
  echo "নতুন রেকর্ড সফলভাবে যুক্ত হয়েছে";
} else {
  echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

<?php
$conn = new mysqli("localhost", "root", "", "mydb");

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

$sql = "SELECT id, name, email FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  echo "<table border='1'><tr><th>ID</th><th>নাম</th><th>ইমেইল</th></tr>";
  while($row = $result->fetch_assoc()) {
    echo "<tr><td>" . $row["id"]. "</td><td>" . $row["name"]. "</td><td>" . $row["email"]. "</td></tr>";
  }
  echo "</table>";
} else {
  echo "কোনো রেকর্ড পাওয়া যায়নি";
}
$conn->close();
?>

<?php
$conn = new mysqli("localhost", "root", "", "mydb");

$id = $_GET['id'];

$sql = "SELECT * FROM users WHERE id=$id";
$result = $conn->query($sql);

if ($result->num_rows == 1) {
  $row = $result->fetch_assoc();
?>

<form action="update.php" method="post">
  <input type="hidden" name="id" value="<?php echo $row['id']; ?>">
  <input type="text" name="name" value="<?php echo $row['name']; ?>"><br>
  <input type="email" name="email" value="<?php echo $row['email']; ?>"><br>
  <input type="submit" value="আপডেট করুন">
</form>

<?php } ?>

<?php
$conn = new mysqli("localhost", "root", "", "mydb");

$id = $_POST['id'];
$name = $_POST['name'];
$email = $_POST['email'];

$sql = "UPDATE users SET name='$name', email='$email' WHERE id=$id";

if ($conn->query($sql) === TRUE) {
  echo "তথ্য সফলভাবে আপডেট হয়েছে";
} else {
  echo "Error updating record: " . $conn->error;
}

$conn->close();
?>

<?php
$conn = new mysqli("localhost", "root", "", "mydb");

$id = $_GET['id'];

$sql = "DELETE FROM users WHERE id=$id";

if ($conn->query($sql) === TRUE) {
  echo "ইউজার সফলভাবে ডিলিট হয়েছে।";
} else {
  echo "ডিলিট করতে সমস্যা হয়েছে: " . $conn->error;
}

$conn->close();
?>