Question: Q) Write the code to do what has been specified in the comments. Note: Table 01 shows the table user_account in the database: Table 01:
Q) Write the code to do what has been specified in the comments.
Note: Table 01 shows the table user_account in the database:
Table 01: user_account Table
| uid | username | password | |
| Int(PK, AI) | Varchar(20) | varchar(255), Unique | varchar(20) |
|
$db_host = "127.0.0.1"; $db_user = "pma"; $db_password = " "; $db_name = "Library"; $conn = mysqli_connect($db_host, $db_user, $db_password, $db_name); if(!$conn) { echo "Debugging errno: " . mysqli_connect_errno(); echo " "; echo "Debugging error: " . mysqli_connect_error(); exit; } $u_id = $_POST['uid']; //write the query here. $result = mysqli_query($con, $query); if($result){ //check if there is a result: // if there is a result, write a code to dp display the result in a table. // if there is no result, print: No result has been found. Using proper HTML. } else { //print the following an error has occurred. Using proper HTML. } else { //print the following an error has occurred. Using proper HTML. } mysqli_close($conn); ?> |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
