![' . $row['name'] . '](../images/dep/' . $row['image'] . ')
edit
delete
';
}
} else {
echo '
لا يوجد بيانات يمكن عرضها...
';
}
// show data with foreach
include "conn.php";
$sql = "select * from department";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
foreach ($result as $key => $row) {
echo '
' . ++$key . '
' . $row['name'] . '
edit
delete
';
}
} else {
echo '
لا يوجد بيانات يمكن عرضها...
';
}
//show data from two table
include "conn.php";
$sql = "select students.id,students.name,students.email,students.age,
students.address,students.phone,department.id as dId,department.name as dName
from students join department on students.depnum=department.id ";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
$key = 0;
while ($row = mysqli_fetch_assoc($result)) {
echo '
' . ++$key . '
' . $row['name'] . '
' . $row['email'] . '
' . $row['age'] . '
' . $row['address'] . '
' . $row['phone'] . '
' . $row['dName'] . '
edit
delete
';
}
} else {
echo '
لا يوجد بيانات يمكن عرضها...
';
}
//search from data in database
include "conn.php";
if (isset($_POST['submit'])) {
$name = $_POST['name'];
$sql = "select students.id,students.name,students.email,students.age,
students.address,students.phone,department.id as dId,department.name as dName
from students join department on students.depnum=department.id
where students.name like '%$name%' ";
} else {
$sql = "select students.id,students.name,students.email,students.age,
students.address,students.phone,department.id as dId,department.name as dName
from students join department on students.depnum=department.id ";
}
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
$key = 0;
while ($row = mysqli_fetch_assoc($result)) {
echo '
' . ++$key . '
' . $row['name'] . '
' . $row['email'] . '
' . $row['age'] . '
' . $row['address'] . '
' . $row['phone'] . '
' . $row['dName'] . '
edit
delete
';
}
} else {
echo '
لا يوجد بيانات يمكن عرضها...
';
}
//show data in select
//SLIDER BY FOREACH
--------------------------------------------------------fullSlider-----------------------------------
Some quick example text to build on the card title and make up the bulk of the card's content.
Some quick example text to build on the card title and make up the bulk of the card's content.
Some quick example text to build on the card title and make up the bulk of the card's content.
Some quick example text to build on the card title and make up the bulk of the card's content.