Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 email 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Logic In Databases International Workshop Lid 96 San Miniato Italy July 1 2 1996 Proceedings Lncs 1154

Authors: Dino Pedreschi ,Carlo Zaniolo

1st Edition

3540618147, 978-3540618140

More Books

Students also viewed these Databases questions