পিএইচপি

<?php

$hostname = "localhost";
$username = "root";
$password = "";
$database = "test";

$connect = mysqli_connect($hostname, $username, $password, $database);

if(!$connect->connect_error) {
    echo "connect is successful";
}

$connect->close();

?>

<?php

$connect = mysqli_connect("localhost", "root", "");

$sql = "CREATE DATABASE testing";

if (mysqli_query($connect, $sql)) {
  echo "database created successfully";
} else {
  echo "error creating database";
}

?>

<?php

$connect = mysqli_connect("localhost", "root", "", "testing");

$sql = "CREATE TABLE users (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(30) NOT NULL,
  land VARCHAR(30) NOT NULL
)";

if (mysqli_query($connect, $sql)) {
  echo "table created successfully";
} else {
  echo "error creating table";
}

?>

<?php

$connect = mysqli_connect("localhost", "root", "", "testing");

$sql = "INSERT INTO users (name, land) VALUES ('afridi', 'pakistan')";

if (mysqli_query($connect, $sql)) {
  echo "insert successfully";
} else {
  echo "error insert";
}

?>

<?php

$connect = mysqli_connect("localhost", "root", "", "testing");

$sql  = "SELECT id, name, land FROM users WHERE id=1";
$data = mysqli_query($connect, $sql);

while($cell = mysqli_fetch_assoc($data)) {
  echo $cell["name"] . " " . $cell["land"];
}

?>

<?php

$connect = mysqli_connect("localhost", "root", "", "testing");

$sql  = "SELECT id, name, land FROM users WHERE id=1";
$data = mysqli_query($connect, $sql);

while($cell = mysqli_fetch_assoc($data)) {
  echo $cell["name"] . " " . $cell["land"];
}

?>

<?php

$connect = mysqli_connect("localhost", "root", "", "testing");

$sql  = "SELECT * FROM users LIMIT 5";
$data = mysqli_query($connect, $sql);

echo "<table border='1'>";
echo "<tr>";
echo "<th>Id</th>";
echo "<th>Name</th>";
echo "<th>Land</th>";
echo "</tr>";

while ($cell = mysqli_fetch_assoc($data)) {

  echo "<tr>";
  echo "<td>" . $cell["id"] . "</td>";
  echo "<td>" . $cell["name"] . "</td>";
  echo "<td>" . $cell["land"] . "</td>";
  echo "</tr>";

}

echo "</table>";

?>

<?php

$connect = mysqli_connect("localhost", "root", "", "testing");

$sql  = "SELECT * FROM users ORDER BY name";
$data = mysqli_query($connect, $sql);

echo "<table border='1'>";
echo "<tr>";
echo "<th>Id</th>";
echo "<th>Name</th>";
echo "<th>Land</th>";
echo "</tr>";

while ($cell = mysqli_fetch_assoc($data)) {

  echo "<tr>";
  echo "<td>" . $cell["id"] . "</td>";
  echo "<td>" . $cell["name"] . "</td>";
  echo "<td>" . $cell["land"] . "</td>";
  echo "</tr>";

}

echo "</table>";

?>

<?php

$connect = mysqli_connect("localhost", "root", "", "testing");
$select  = "SELECT * FROM users";
$update  = "UPDATE users SET name='hafig' WHERE id=5";

mysqli_query($connect, $update);

$data = mysqli_query($connect, $select);

echo "<table border='1'>";

echo "<tr>";
echo "<th>Id</th>";
echo "<th>Name</th>";
echo "<th>Land</th>";
echo "</tr>";

while ($cell = mysqli_fetch_assoc($data)) {

  echo "<tr>";
  echo "<td>" . $cell["id"] . "</td>";
  echo "<td>" . $cell["name"] . "</td>";
  echo "<td>" . $cell["land"] . "</td>";
  echo "</tr>";

}

echo "</table>";

?>

<?php

$connect = mysqli_connect("localhost", "root", "", "testing");
$select  = "SELECT * FROM users";
$delete  = "DELETE FROM users WHERE id=5";

mysqli_query($connect, $delete);

$data = mysqli_query($connect, $select);

echo "<table border='1'>";

echo "<tr>";
echo "<th>Id</th>";
echo "<th>Name</th>";
echo "<th>Land</th>";
echo "</tr>";

while ($cell = mysqli_fetch_assoc($data)) {

  echo "<tr>";
  echo "<td>" . $cell["id"] . "</td>";
  echo "<td>" . $cell["name"] . "</td>";
  echo "<td>" . $cell["land"] . "</td>";
  echo "</tr>";

}

echo "</table>";

?>