PHP somo la 67: Project ya CUDE operaton wa utuma OOP na PDO
Katika somo hii utakwenda kujifunza jinsi ya kufanya CRUDE operation kwa kutumia PDO. crude operation inahusu create, read, update. Delete.
Database ambayo tunakwend akuitumia ni ileile ya wanafunzi. Ila ongeza table nyingine iite majibu. Table hiyo iwe na column 3 ambazo ni id, jina, alama. Hakikisha column id ni autoincrement..
Project yetu tauwa na mfali 6 ambayo ni
- Add.php
- Delete.php
- Edit.php
- index.php
- Style.css
- Wanafnzi_class.php.
Kama nilivyo eleza kwene somo lilotanguliwa kuwa tutatumia mfumo wa OOP yaani object oriented programming. Hivyo kama utarejea project yetu ya CRUDE operation kwa kutumia OOP unaweza kuelewa zaidi.
index.php
Tengeneza faili liite index.php kisha pest code hizo hapo chini:-
<?php
require_once 'wanafunzi_class.php';
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="style.css">
<title>Majibu Data</title>
</head>
<body>
<?php
echo '<table border="1" class="center">';
echo '<a href="add.php"><h1>Add data</h1></a>';
echo '<tr><th>ID</th>
<th>Name</th>
<th>Alama</th>
<th>Edit</th>
<th>Delete</th>
</tr>';
$majina = $db->majina_ya_wanafunzi();
foreach ($majina as $jina) {
$options = $db->majina_ya_wanafunzi();
//echo $jina[0] . ' ' . $jina[1] . '<br>';
echo '<tr>';
echo '<td>' .$jina['id'] . '</td>';
echo '<td>' . $jina['jina'] . '</td>';
echo '<td>' . $jina['alama'] . '</td>';
echo '<td><a href="edit.php?id='.$jina['id'].'">âœ</a> </td>';
echo '<td><a href="delete.php?id='.$jina['id'].'">âŒ</a> </td>';
echo '</tr>';
}
echo '</table>';
?>
</body>
</html>
add.php
Tengeneza faili liite add.php kisha pest code hizo hapo chini:-
<?php
require_once 'wanafunzi_class.php';
if (isset($_POST['submit'])){
// Insert data
$jina = $_POST['jina'];
$matokeo = $_POST['alama'];
$insertResult = $db->insertData($jina, $matokeo);
if ($insertResult) {
echo "<h1>Data inserted successfully!</h1>";
echo '<script>function quiz (){window.location.replace("index.php")}var myTimeout = setTimeout(quiz, 500)</script>';
} else {
echo "Error inserting data.";
}
}
?>
<br><br><br>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link href="style.css" rel="stylesheet">
<title>Styled Form</title>
</head>
<body>
<form action="" method="post">
<label for="jina">Jina</label><br>
<input type="text" name="jina"><br><br>
<label for="alama">Alama</label><br>
<input type="number" name="alama"><br><br>
<input type="submit" name="submit" value="Save">
</form>
</body>
</html>
edit.php
Tengeneza faili liite edit.php kisha pest code hizo hapo chini:-
<?php
require_once 'wanafunzi_class.php';
// Check if the form for editing is submitted
if (isset($_POST['edit_submit'])) {
$id_to_edit = $_POST['edit_id'];
$edited_jina = $_POST['edited_jina'];
$edited_matokeo = $_POST['edited_alama'];
// Edit data
$editResult = $db->editData($id_to_edit, $edited_jina, $edited_matokeo);
if ($editResult) {
echo "<h1>Data edited successfully!</h1>";
echo '<script>function quiz (){window.location.replace("index.php")}var myTimeout = setTimeout(quiz, 500)</script>';
} else {
echo "Error editing data.";
}
}
$majina = $db->to_be_edited($_GET['id']);
foreach ($majina as $jina) {
$options = $db->majina_ya_wanafunzi();
?>
<br><br><br>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Styled Form</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<form action="" method="post">
<!-- Fields for editing -->
<input type="hidden" name="edit_id" id="edit_id" value="<?php echo $jina['id']?>">
<label for="edited_jina">Edited Jina</label><br>
<input type="text" name="edited_jina" id="edited_jina" value="<?php echo $jina['jina']?>"><br><br>
<label for="edited_alama">Edited Alama</label><br>
<input type="number" name=&qu...
Umeionaje Makala hii.. ?
Share On:
👉1 Tafasiri ya Riyadh Swalihina 👉2 Simulizi za Hadithi Audio 👉3 Kitau cha Fiqh 👉4 Bongolite - Game zone - Play free game 👉5 web hosting 👉6 Sira ya Mtume Muhammad (s.a.w)
Post zinazofanana:
Jinsi ya kupata location ya mtu lwa kutumia IP address
Katika post hii utajifunza jinsi ya kupata taarifa muhimu za mtumiaji kw akutumia Ip address yake.
Soma Zaidi...PHP BLOG - somo la 7: Jinsi ya kutengeneza ukurasa wa kusoma post kwenye blog
HApa utakwenda kujifunza sasa namna ya kuzisoma post kutoka kwenye blog
Soma Zaidi...PHP BLOG - somo la 5: Jinsi ya kuandika code za PHP kwa ajili ya kuweka post kwenye blog
Katika ukurasa huu utakwenda kujifunz jinsi ya kuandika code za php kwa ajili ya kutuma post yetu kwenye blog.
Soma Zaidi...PHP somo la 61: jinsi ya kufanya loop kwenye class kw akutumia foreach loop
Katika somo hili utakwenda kujifunza concept ya iteration kwenye PHP OOP hapa tutakwenda kuiona jinsi inavyofanya kazi pamoja na foreach loop
Soma Zaidi...PHP somo la 102: Cron job
atika somo hli tutakwenda kujifunza kuhusu kitu kinachitwa cron job. ni moja ya teknolojia zinazotumika kufanya kazi zinazofanyika automatic
Soma Zaidi...PHP somo la 57: class traits kwenye PHP
Katika somo hili utakwenda kujifunza concept ya traits kwenye OOP. hii itakusaidia ku solve baadhi ya changamoto zinazotokana na inheritance
Soma Zaidi...