Php with Mysql 1

Ma’lumotlar bazasi va jadval yaratilgandan so‘ng, ularga ma‘lumotlar qo‘shish
connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "INSERT INTO talaba (familiyasi, ismi, email) VALUES ('John', 'Doe', '[e-mail]')"; if ($conn->query($sql) === TRUE) { echo "New record created successfully"; } else { echo "Error: " . $sql . "
" . $conn->error; } $conn->close(); ?>
MySQL ma’lumotlar bazasidan ma’lumotlarni o‘qish
SELECT buyrug‘i bir yoki bir nechta jadvallardan ma’lumotlarni tanlash uchun ishlatiladi:
SELECT column_name(s) FROM table_name
yoki jadvaldan barcha ustunlarni tanlash uchun * belgisidan foydalanishimiz mumkin:
SELECT * FROM table_name
connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT id, familiyasi, ismi FROM talaba"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo "id: " . $row["id"]. " – Familiyasi va ismi: " . $row[“familiyasi"]. " " . $row[“ismi"]. "
"; } } else { echo "0 results"; } $conn->close(); ?>
MySQL ma’lumotlar bazasi.
1-ish. Qdpi nomli ma’lumotlar bazasini yaratish uchun create_db.php fayliga quyidagi kodlarni kiritamiz.
$servername = "localhost";
$username = "root";
$password = "";
//bog'lanishni yaratish
$conn = new mysqli($servername, $username, $password);
//bog'lanishni tekshirish
if ($conn->connect_error)
{
die("Bog`lanishda xatolik: " . $conn->connect_error);
}
//ma'lumotlar bazasini yaratish
$sql = "CREATE DATABASE qdpi";
if ($conn->query($sql) === TRUE) {
echo "qdpi ma`lumotlar bazasi yaratildi";
} else {
echo "qdpi ma`lumotlar bazasi yaratishda xatolik: " . $conn->error;
}$conn->close();
?>