Create view_admin.php for this table. There are 5 admin(s) in the database.ID LoginPassword Name1 tigerxyz123 Victor SmithJohn Lee2 panda xyz3335 Austin bbb6 monkey 1237 fish111DOBJoin date Gender Address1990-01-01 2018-01-01 MNULL 2015-01-01 F1998-01-01 1990-01-01 MNULL 2020-01-01 MFAustin testTester StaffTester2 Staff2||2021-01-10||2020-01-011000 Morris Ave., Union, NJ 07803133 Main St., Austin, TX71 Central Ave., Newark, NJ 07188100 Main st. Edison, NJ 07777100 Central st. Edison, NJ 07777 There are 5 admin (s) in the database.IDLoginPasswordNameDOBJoin dateGenderAddress1tigerxyz123Victor Smith1990-01-012018-01-01M1000 Morris Ave., Union, NJ 070832pandaxyz333John LeeNULL2015-01-01F133 Main St., Austin, TX5AustinbbbAustin test1998-01-011990-01-01M71 Central Ave., Newark, NJ 07188StaffNULL2020-01-01M100 Main st. Edison, NJ 07777Staff22021-01-102020-01-01F100 Central st. Edison, NJ 077776monkey123Tester7fish111Tester2

Program Approach: 1- As mentioned in the assignment create the table as admin and store the records as mentioned.2- Create the PHP page as view_admin.php3- Inside the PHP page write the database connectivity and SQL query. 4- Please change the database username, password, and database name as per system configuration.5- Make select SQL query for fetching the record from the database.6- For example:SELECT id, login, password, name, DOB,joindate, gender, address FROM admin7- Then make the table using HTML and inside the table print the data. 8- echo statement is used to print the records one by one and display them on the browser.9- mysqli() function is used to make the connectivity between the PHP code and database.10- Please check the following complete example and output screenshot. Code: <html lang="en"><head><title></title></head><body> <div class="page"> <div class="site-main"> <center><html><body><?php$servername = "localhost";$username = "root";$password = "";$dbname = "covid";// Create connection$conn = new mysqli($servername, $username, $password, $dbname);// Check connectionif ($conn->connect_error) { die("Connection failed: " . $conn->connect_error);}$sql = "SELECT id, login, password,name,DOB,joindate,gender,address FROM admin";$result = $conn->query($sql);?><table border="1 px"><tr><th>ID</th><th>Login</th><th>Password</th><th>Name</th><th>DOB</th><th>Join date</th><th>Gender</th><th>Address</th></tr><?phpif ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) {?><tr><td><?php echo $row["id"]?></td><td><?php echo $row["login"]?></td><td><?php echo $row["password"]?></td><td><?php echo $row["name"]?></td><td><?php echo $row["DOB"]?></td><td><?php echo $row["joindate"]?></td><td><?php echo $row["gender"]?></td><td><?php echo $row["address"]?></td></tr><?php }} else { echo "0 Count";}$conn->close();?></table></body></html> </center></div></html> Output: ----

Answered: te view_admin.php for this tab

Engineering

Computer Science

te view_admin.php for this tab

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

The 'customer' table contains ten columns but no row. The table is then updated with 10 new rows and 3 rows removed. What is the table 'customer's degree and cardinality?
CREATE TABLE DOCTOR(DOC_ID NUMBER(3),DOC_NAME VARCHAR2(9),DATEHIRED DATE,SALPERMON NUMBER(12),AREA VARCHAR2(20),SUPERVISOR_ID NUMBER(3),CHGPERAPPT NUMBER(3),ANNUAL_BONUS NUMBER(5),CONSTRAINT DOCTOR_DOC_ID_PK PRIMARY KEY (DOC_ID)); INSERT INTO DOCTOR VALUES(432, 'Harrison' , TO_DATE('05-DEC-94'), 12000,'Pediatrics', 100, 75, 4500); INSERT INTO DOCTOR VALUES(509, 'Vester' , TO_DATE('09-JAN-00'), 8100,'Pediatrics', 432, 40, null); INSERT INTO DOCTOR VALUES(389, 'Lewis' , TO_DATE('21-JAN-96'), 10000, 'Pediatrics', 432, 40, 2250); INSERT INTO DOCTOR VALUES(504, 'Cotner' , TO_DATE('16-JUN-98'), 11500,'Neurology', 289, 85, 7500); INSERT INTO DOCTOR VALUES(235, 'Smith' , TO_DATE('22-JUN-98'), 4550, 'Family Practice', 100, 25, 2250); INSERT INTO DOCTOR VALUES(356, 'James' , TO_DATE('01-AUG-98'), 7950,'Neurology', 289, 80, 6500); INSERT INTO DOCTOR VALUES(558, 'James' , TO_DATE('02-MAY-95'), 9800, 'Orthopedics', 876, 85, 7700); INSERT INTO DOCTOR VALUES(876, 'Robertson' , TO_DATE('02-MAR-95'),…
List State, Sales Year, Current Year Sales, Last Year Sales, and Change in Total Yearly Sales for Nike between years 2014 and 2015. As the focus is on Nike sales in each state for years 2014 and 2015, for the Last Year Sales and Change in Total Yearly Sales columns include ‘NA’ for sales year 2014. Display result set in ascending order of State. (Note – Please refer to the Department, SKU, Transact, and Store tables.) (Screenshot shown)
Please written by computer source Create a table with two columns. Name the table First Initial _ Last Name (e.g. John Dow will create table j_dow). You have to audit all DML statements on your table. To do this you write two triggers: 1. To log any DML statements that users might run on this table. The results must be stored in the First Initial _ Last Name _ Log table (e.g. John Dow will create table j_dow_log). The table should have unique event ID, values for both the Oracle and the system user who ran the query, the time it was executed and the type of DML query user ran. 2. To capture any data that was changed in the table. The results must be stored in the First Initial _ Last Name _ History table (e.g. John Dow will create table j_dow_history). The table should reference the event ID from the log table, and store both old and new values for both columns. What to submit: Name this file according to submission guidelines and include the following answers: Code to create all three…
Which results would show if the artist table LEFT JOINed the album table? Only rows from the artist table that do not have related albums in the album table Only artists from the artist table that have albums All artists, even those with no albums in the album table All rows from the album table, even those that have NULL artist_id's
Which of the following is the correct syntax to change the data type of a column in an existing table? O a. ALTER TABLE tableName MODIFY columnName DATATYPE(S) O b. ALTER TABLE tableName RENAME COLUMN columnName DATATYPE(S) O C. ALTER TABLE tableName ADD COLUMN DATATYPE(S) Od. ALTER TABLE tableName MODIFY COLUMN columnName DATATYPE(S)
The pg2.np_2017camping table contains public use statistics for camping in 2017 from the National Park Service. To enable statistics to be calculated for all camping locations, restructure the table as a narrow table.Show results also.
The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.
1.CREATE TABLE contacts ( last_name VARCHAR(30) NOT NULL, first_name VARCHAR(25) NOT NULL, birthday DATE, CONSTRAINT contacts_pk PRIMARY KEY (last_name, first_name) ); Use insert query and insert the values and display the table.
q18
Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns. Task 20: List every column in the ITEM table and its associated data type.
Mark as unused the Category column in the BOOK_PRICING table. Check that the column is no longer accessible.