PHP somo la 65: Jinsi ya kusoma data kwenye database kwa kutumia PDO

Hapa tutakwenda kutumia database yetu tuliotengeneza somolililopita. Pia tutakwend akusima data ambazo tumeingiza kutoka katika somo lililopita.

Ili kuweza kusoma data kwenye data kwenye database tutatumia SELECT . Kwa mfano tutaandika

 $query = "SELECT * FROM matokeo";

    $stmt = $conn->prepare($query);

    $stmt->execute();

Kisha baada ya hapo tutatumia loop  ili kuweza kuprint matokeo ya hizo data ambazo tume select hapo juu loop ipo nyingi lakini hapa tutakwenda kutumia loop tatu ambazoni:-

1. for LOOP
2. While loop
3. Foreach loop

Kwa kutumia for loop:

Baada ya ku select tutatumia fetchAll() method ili kuweza kuchukuwa data kutoka kwenye database.

<?php

$dbHost = "localhost";

$dbName = "wanafunzi";

$dbUser = "root";

$dbPassword = "";

try {

   $conn = new PDO("mysql:host=$dbHost;dbname=$dbName", $dbUser, $dbPassword);

   // Code to read data from the database

   $query = "SELECT * FROM matokeo"; // Replace 'your_table_name' with the actual table name

   $stmt = $conn->prepare($query);

   $stmt->execute();

   // Fetch all data into an array

   $result = $stmt->fetchAll(PDO::FETCH_ASSOC);

   // Use a for loop to iterate through the array

   for ($i = 0; $i < count($result); $i++) {

       $row = $result[$i];

       // Access individual columns using $row['column_name']

       echo "ID: " . $row['id'] . ", Name: " . $row['jina'] . "<br>";

   }

} catch (Exception $e) {

   echo "Imefeli kuunganishwa";

   echo $e->getMessage();

} finally {

   // Close the connection

   $conn = null;

}

?>

Kwa kutumia while loop:

<?php

$dbHost = "localhost";

$dbName = "wanafunzi";

$dbUser = "root";

$dbPassword = "";

try {

   $conn = new PDO("mysql:host=$dbHost;dbname=$dbName", $dbUser, $dbPassword);

&...