Комментарии:
thanks boy
Ответить
how to fetch data from table id to another table head like personal info ??
Ответить
$db=mysqli_select_db($conn,"student");
this statement helped a lot thanks you geek....
how to fetch jsonArray from android to php plz help this problem
Ответить
Bro how can we fetch particular data with unique id from same database
Ответить
You should seperate the logic and the view! Not making an output within the while loop.
Ответить
thanks bro
Ответить
PHP changes shit too much.. all the MySQL commands don't work on latest version
Ответить
thx bro helped me much :)
Ответить
Great video man
Ответить
thanks for the tut
Ответить
How to fetch multiple row using chechbox
Ответить
How to fetch my SQL data using div tag ?
Ответить
hye i have done my coding, but i want to display from a same username to see their own multiple data, but for now i can only display one data from same username. would you mind to check my coding.
<?php
session_start();
?>
<?php
$servername = "localhost";
$username = "root";
$password = "mysql";
$dbname = "Online";
//Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
//Check connection
if (mysqli_connect_error())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($conn, "SELECT * FROM Booking WHERE Username = '{$_SESSION['Username']}'" );
while($row = mysqli_fetch_array($result))
{
$BookingID= $row['BookingID'];
$UserID= $row['UserID'];
$Username= $row['Username'];
$Department= $row['Department'];
$Room= $row['Room'];
$StartDate= $row['StartDate'];
$EndDate= $row['EndDate'];
$StartTime= $row['StartTime'];
$EndTime= $row['EndTime'];
$Reason= $row['Reason'];
}
mysqli_close($conn);
?>
<body>
Booking ID:<? echo $BookingID;?><br>
User ID:<? echo $UserID;?><br>
Username:<? echo $Username;?> </b></span><br>
Department:<? echo $Department;?><br>
Room:<? echo $Room;?><br>
Start Date:<? echo $StartDate;?><br>
End Date:<? echo $EndDate;?><br>
Start Time:<? echo $StartTime;?><br>
End Time:<? echo $EndTime;?>
<br><br>
Booking ID:<? echo $BookingID;?><br>
User ID:<? echo $UserID;?><br>
Username:<? echo $Username;?> </b></span><br>
Department:<? echo $Department;?><br>
Room:<? echo $Room;?><br>
Start Date:<? echo $StartDate;?><br>
End Date:<? echo $EndDate;?><br>
Start Time:<? echo $StartTime;?><br>
End Time:<? echo $EndTime;?>
</body>
Very clean tutorial keep it up mate and big tha ks :)
Ответить
voice and language is very clear and good keep it up
Ответитьgood work dear i raelly need this.....tahnku so much
Ответить
Greetings. I can not seem to get this to work.
I can confirm that my SQL-database got DATA in it's table by using mysqli_num_rows,
but the while-loop simply won't perform the action inside the loop body.
while ($row = mysqli_fetch_array($entries)) {
echo 'Hello' . $row[2] . 'Bye';
}
what if we want to display data from multiple tables?
Ответить
what if i just want to display the 2nd value? whats the code?
Ответить
