mysql boyicha savol !'

Question

Salom manashu tablitsadegi `sardor` so'zini php sahifada chiqarish kere. Shunda yordam berila

+------+------+-----+

|   ID   | ismi  | text |

+------+------+-----+

|    1   |Sardor| abc |

+-----+-------+-----+

Shuni to'lliq yozib berila qanaqb php sahiada shu Sardor so'zi chiqishi.

Answer 1

<?php

$mysqli = new mysqli("localhost", "LOGIN", "PAROL", "BAZA_NOMI");

// Bog'lanishni tekshiramiz
if (mysqli_connect_errno()) {
    printf("Baza bilan bog'lanib bo'lmadi, xatolik: %s\n", mysqli_connect_error());
    exit();
}

// Jadvaldan ma'lumotlarni qabul qilamiz
$query = "SELECT ismi FROM JADVAL_NOMI";
if ($result = $mysqli->query($query)) {
  while ($row = $result->fetch_assoc()) {
    var_dump($row['ismi']);
  }
  // To'plamni tozalaymiz (zarur emas)
  $result->close();
}

// Bog'lanishni yopamiz (zarur emas)
$mysqli->close();

?>

Comments

Yuqoridagini to'liqroq shakli:

$query = "SELECT ismi FROM JADVAL_NOMI WHERE 'ID' = 1; 

---

men yozganimda nechta qator bo'lsa hammasidagi ism degan ustunni chiqarib beradi

Answer 2

$query = mysql_query("select * from `jadval` where `ismi` = "Sardor");

$fetch = mysql_fetch_array($query);

echo $fetch['ismi'];