Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Related questions
Question
thumb_up100%
So my assignment is to display a chart as a webpage using phpMyAdmin running code out of visual studio code. When I try to run the page, which should display my chart, I get a mysqli_connect(): (HY000/1045): Access denied error message. Which I believe has something to do with the permissions in phpMyAdmin, but I don't know how to access that. Thoughts?
Transcribed Image Text:ecpi UNIVERSITY
MYNETLAB > 202212CL-CIS224-NMW-MM-POD31 > Reservation 55295 > CIS224
Topology Content Status Windows 10
8
File Edit Selection View Go Run Terminal Help user_list.php - cis224_week3_gp1 - Visual Studio...
▷ Launch
user_list.php x {} launch.json
user_list.php > ...
<?php
VARIABLES
Run and Debug (Ctrl+Shift+D)
✓ WATCH
✓ CALL STACK
BREAKPOINTS
Caught Exceptions
Uncaught Except...
> BROWSER BREAKPOINTS
1
2
3
4
>
567000
8
9
10
11
12
13
14
15
16
17
18
19
20
21
PROBLEMS
$hostname
$username
$password
$dbname
$conn
?>
<style>
=
table {
=
=
$query
"SELECT * FROM userinfo";
$result = mysqli_query($conn, $query);
=
"localhost";
"ecpi_user";
"Password1";
"cis224_wk3gp";
mysqli_connect($hostname, $username, $password, $dbname)
=
}
th, td {
border-spacing: 5px;
}
table, th, td {
border: 1px solid black;
border-collapse: collapse;
Home Reservation
padding: 15px;
text-align: center;
DEBUG CONSOLE
80
Filter (e.g. text, !exclude)
-
micpor9577
Time Remaining
1 13
hrs. min.
Mar
Ex^X
![ecpi UNIVERSITY
MYNETLAB > 202212CL-CIS224-NMW-MM-POD31 > Reservation 55295 > CIS224
Windows 10
Topology Content
localhost/127.0.0.1/cis224_wk3 x +
Recent Favorites
New
cis224
← → C℗ localhost/phpmyadmin/sql.php?server=1&db=cis224_wk3gp&table=userinfo&pos=0
phpMyAdmin
Server: 127.0.0.1 » Database: cis224_wk3gp >> Table: userinfo
Browse Structure
Search
Insert
Hcis224_porter
cis224_wk3gp
New
- userinfo
HII Columns
New
EMail (varchar)
Indexes
+ information_schema
+- mysql
Expand/Collapse
phpmyadmin
test
mweek1
✔Status
Ⓒ
FavoriteNum (int)
FirstName (varchar
LastName (varchar
UserNo (PRI, int)
chema
SELECT * FROM `userinfo
U
+ Options
+T→
U
Showing rows 0 - 3 (4 total, Query took 0.0061 seconds.)
Show all Number of rows: 25
Edit - Copy
Edit - Copy
Edit Copy
Edit - Copy
localhost/phpmyadmin/sql.php?server=1&db=cis22...
Check all
Print
Console
Delete
Delete
Delete
Delete
Query results operations
SQL
Show all Number of rows:
With selected:
Copy to clipboard
Home
Profiling [Edit inline] [Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
UserNo
FirstName LastName EMail
1
Admin
2
YourFirst
3 Joe
4 Jane
25 ✓
Edit
Reservation
Export
a ☆
Filter rows: Search this table
Copy
Display chart
Export More
Administrator admin@admin.com
YourLast
Smith
Jones
you@you.com
jsmith@joe.com
jjones@jane.com
Delete
micpor9577
Filter rows: Search this table
Time Remaining
1 13
hrs. min.
Create view
Export
Sort by ke
Favorite Nui
Sort by ke](https://content.bartleby.com/qna-images/question/4d27a8a6-cc74-416c-a782-397e5cce3206/b478b522-54ef-4095-bd9a-366d0f85ba3f/rvcvj7e_processed.png)
Transcribed Image Text:ecpi UNIVERSITY
MYNETLAB > 202212CL-CIS224-NMW-MM-POD31 > Reservation 55295 > CIS224
Windows 10
Topology Content
localhost/127.0.0.1/cis224_wk3 x +
Recent Favorites
New
cis224
← → C℗ localhost/phpmyadmin/sql.php?server=1&db=cis224_wk3gp&table=userinfo&pos=0
phpMyAdmin
Server: 127.0.0.1 » Database: cis224_wk3gp >> Table: userinfo
Browse Structure
Search
Insert
Hcis224_porter
cis224_wk3gp
New
- userinfo
HII Columns
New
EMail (varchar)
Indexes
+ information_schema
+- mysql
Expand/Collapse
phpmyadmin
test
mweek1
✔Status
Ⓒ
FavoriteNum (int)
FirstName (varchar
LastName (varchar
UserNo (PRI, int)
chema
SELECT * FROM `userinfo
U
+ Options
+T→
U
Showing rows 0 - 3 (4 total, Query took 0.0061 seconds.)
Show all Number of rows: 25
Edit - Copy
Edit - Copy
Edit Copy
Edit - Copy
localhost/phpmyadmin/sql.php?server=1&db=cis22...
Check all
Print
Console
Delete
Delete
Delete
Delete
Query results operations
SQL
Show all Number of rows:
With selected:
Copy to clipboard
Home
Profiling [Edit inline] [Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
UserNo
FirstName LastName EMail
1
Admin
2
YourFirst
3 Joe
4 Jane
25 ✓
Edit
Reservation
Export
a ☆
Filter rows: Search this table
Copy
Display chart
Export More
Administrator admin@admin.com
YourLast
Smith
Jones
you@you.com
jsmith@joe.com
jjones@jane.com
Delete
micpor9577
Filter rows: Search this table
Time Remaining
1 13
hrs. min.
Create view
Export
Sort by ke
Favorite Nui
Sort by ke
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Can we obtain a more in-depth explanation of the HTML post and get methods somewhere? If that's the case, why not?arrow_forwardCreate an Android program with android studio, use Volley to read the list of Canadian universities and colleges and other related data from API http://universities.hipolabs.com/search?country=Canada, and then use Recycler View in Android to display Canadian universities and the name of the college, province and web page address, or n/a if there is no province. The end result looks like this image. please show me a code with steps .and its outputarrow_forwardSome parameters in Google searching the "lr" code, which does what?arrow_forward
- Write two JavaScript functions. The first function (makeAJAXQuery), should make an AJAX call to get the JSON file (warehouse.json). The second function (displayResponse) should parse the received JSON into a JavaScript object and display the JavaScript object on the web (using the div element with id 'display"). ut of stion warehouse.json "date": "20/es/2021", "warehouses": [ "warehouseID": 1256-255", "Address": "wollongong" , "Inventory": I Warehouse "CODE": "RACK-255", "NOItems": "5". "status": "OK" Date: 20/05/2021 "CODE": "LOAD-1026", "NOItems: "1", "Status": "Damaged" 1256-255 Wollongong ---RACK-255,5,0K ---LOAD-1026, 1,Damaged ---> "warehouseID": "2365-326", "Address": "Picton", "Inventory":E 2365-326 Picton ---LT-23655, 10,OK "CODE": "LT-23655", "NOItems": "10", "Status": "oK"arrow_forwardThe login.html image is shown below. The simple PHP module shows email and password fields for a user to enter. Analyze the code and identify one issue with the code regarding security. Explain the problem by identifying the line no. and provide the corrected line of code. login.html 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Login Form Login Email Address: Password: 15 16 17arrow_forwardWhich of the following actions occurs first within the browser upon the activation of a submit button? a. Asubmitevent is fired. b. A request is sent to the server handling the form data. c. The field values are checked for invalid data. d. The JavaScriptsubmit()method is executed.arrow_forward
- so which option is correct from this There should not be a >bracket at the end. The language attribute name in the <html> tag should not be lang. There should not be a <body> tag There should be quote marks around the content ID in the second <div> tag.arrow_forwardRead ALL of the instructions carefully before starting the exercise!Dear Colleague,Earlier today I built my third website using HTML5. Based on what we had learned in Exercises 1through 9, I wanted my website to try out four forms as shown in Figure 1 (below). However,after giving it my best effort, things once again didn’t turn out the way I wanted (see the codeprovided). I’ve been told that there are exactly 20 things wrong with the code. Can you help mespot all of the errors?Hint: You should not add ANY LINES to the code. There will never be more than one set of (ortype of errors) per line.To complete this assignment, update only the file named c2_broken.html contained in thec2_broken directory. Also, create a MS Word file describing what you did. Specifically, create abulleted list describing your improvements and be sure to include the line numbers. Save thissecond file as c2_notes_LastName.docx and add this file to the c2_broken directory. Whendone, rename c2_broken to…arrow_forwardUSING PHP : Make a website that shows the current world record holder for your game of choice.The user should be able to enter in the Name of the game, it's category (ANY%, 100%, NG+), and theworld record holder. Those input fields should have placeholder values up to you to decide what those defaultvalues are. Add a message underneath that simply tells the user the current world record holder for thatgame is. When reloading the page the message should have the values the user previously entered which weresaved as cookies. Also these cookies should have a 1 week expirary date. use a cookie and set its value read the cookie's value and print it outarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON 
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education