How do I use php to return a select from mysql table teams that outputs the following 1 All boss's text in blue in an unordered HTML list from a select statement My codes are below mysql table mysql select from teams Team ID Team Name Team Country Team Titles Team Boss 1 a England 10 Mr J 2 b Ireland 18 Mr K 3 c USA 12 Mr Z 4 d Italy 36 Mr A 5 e France 19 Mr P Teams php teams ftable font family Aerial, Helvetica, sans serif border collapse collapse table layout fixed width 80 f td, f th border 6px solid ddd padding 10px ftable tr nth child(even) background color f1f2f1 ftable tr hover background color fff ftable th padding top 10px padding bottom 10px text align left background color grey color white td width 25 Team ID Name Country Titles Boss Enter A New Team ID Name Country Team League Titles Boss Update teams php

The Answer is in the image, click to view ...

Question: How do I use php to return a select from mysql table teams that outputs the following 1. All boss's text in blue in an

How do I use php to return a select from mysql table "teams" that outputs the following

1. All boss's text in blue in an unordered HTML list from a select statement

My codes are below

mysql table

mysql> select * from teams; +---------+---------------+--------------+-------------+---------------------+ | Team_ID | Team_Name | Team_Country | Team_Titles | Team_Boss | +---------+---------------+--------------+-------------+---------------------+ | 1 | a | England | 10 | Mr J | | 2 | b | Ireland | 18 | Mr K | | 3 | c | USA | 12 | Mr Z | | 4 | d | Italy | 36 | Mr A | | 5 | e | France | 19 | Mr P | +---------+---------------+--------------+-------------+---------------------+

Teams.php

   teams        Team_ID  Name  Country  Titles  Boss  
        
  
  Enter A New Team 
  ID: Name: Country Team : League Titles: Boss:

Update_teams.php

Teams.php

   teams        Team_ID  Name  Country  Titles  Boss  
        
  
  Enter A New Team 
  ID: Name: Country Team : League Titles: Boss:

Update_teams.php

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Design awebsite of your choice .. Most of what has been studied must be applied to the site . HTML heading : Headings are defined with the to tags. defines the most important heading. defines the...

I posted this yesterday but did not get any response from chegg, can someone help pelease? Using php PDO pelase answer all parts (Do not not use SQLi). Please provide explanation what line of codes...

Using php PDO pelase answer all parts (Do not not use SQLi). Please provide explanation what line of codes does do, show outputs and you code source I am using XAMPP server and mysql on my mac Thank...

PHP and MySQL Programming... Part 1: A Guest Book Your tasks is to create a guest book that contains three small php-scripts as follows: connect.php , which will set up a connection to the database....

PHP and MySQL Programming Part 1: A Guest Book Your tasks is to create a guest book that contains three small php-scripts as follows: connect.php , which will set up a connection to the database....

You are requested to provide the following using MySQL, PHP, HTML and CSS with the techniques taught in class. 1. Create a database (csc385_project) with a username (csc385admin) and password...

create a banking program with html and javascript must have javascript and html in the code must have javascript and html in the code cannot use xml file Your supervisor has asked you to create a...

*SimpleReader/Writer are part of OSU CSE Components RSSReader.java: import components.simplereader.SimpleReader; import components.simplereader.SimpleReader1L; import...

create a banking program with html and javascript must have javascript and html in the code must have javascript and html in the code an xml is allowed Your supervisor has asked you to create a...

create a banking program with html and javascript must have javascript and html in the code must have javascript and html in the code cannot use xml file Your supervisor has asked you to create a...

(1) Calculate the total cost of SATHU and total cost of DHUA (if the expected number of units is produced) using the traditional costing system. (2)Calculate the total cost of SATHU and total cost of...

How are dummy variables used in regression forecasting models with seasonality?

Write these decimal numbers in order of size, starting with the smallest. a 4.67, 4.05, 4.76, 4.5 b 11.525, 11.91, 11.08, 11.6

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

10. What are the advantages and potential disadvantages of telecommuting for employees? For companies?

2. Go to www.workingmother.com, the Web site for Working Mother magazine. Review any five of the 2008 100 Best Companies for work-life policies. What common practices do they use to help employees...

1. Interview a relative or friend who is currently employed. The interview should a. Identify her current career development stage. b. Identify a special career management challenge she faces. c....