Database Systems CIT381 - using PHP with MySQL by example

Sample Query

select * from customer limit 5;

Formatted Results

	101 - Jane Block 
	102 - Cherry Hamilton 
	103 - Katherine Harrison 
	104 - Carroll Breaux 
	106 - Anita Morehouse 

Try your own query

show tables

Unformatted Results

customer

employee

hourlyemployee

movie

otherusers

paystatement

previousrental

purchaseorder

purchaseorderdetail

rental

reservation

salariedemployee

store

supplier

timecard

video

worksin

MySQL Configuration Settings

	server:   ix.cs.uoregon.edu:3035
	database: bighitvideo
	user:     guest
	password: guest

---

Code for this page

mysql.php as a txt file