Test

o

connect_error ){ die("Connection failed: ". $conn->connect_error ); }else{ echo "You are connected... "; } $sql = "SELECT s.state, s.2010_population, c.name, c.description FROM state AS s JOIN cultural_region_lookup AS l ON s.state_id= l.state_id JOIN cultural_region AS c ON l.cultural_region_id= c.cultural_id WHERE c.description LIKE '%boring%' ORDER BY 2010_population"; $sql2 = "SELECT state, …

connect_error ){ die("Connection failed: ". $conn->connect_error ); }else{ echo "You are connected... "; } $sql = "SELECT * FROM state"; $result = $conn->query($sql); if($result->num_rows > 0){ echo "StateCapitolElectorsHouse Seats "; while($row = $result ->fetch_array()){ echo " "; echo "". $row['state'] . ""; echo "" . $row['capitol'] . ""; echo "" …

Quiz Results <?php $Q1= $_POST['q1']; $Q2= $_POST['q2']; $Q3= $_POST['q3']; $Q41= $_POST['q41']; $Q42= $_POST['q42']; $Q43= $_POST['q43']; $Q5= $_POST['q5']; $Q6= $_POST['q6']; $Q7= $_POST['q7']; echo "Q1 is $Q1 Q2 is $Q2 Q3 is $Q3 Q41 is $Q41 Q42 is $Q42 Q43 is $Q43 Q5 is $Q5 Q6 is $Q6 Q47 is $Q7"; if …

Loops <?php $a = 0; for ($count = 1; $count < 10; $count++){ echo "$count"; echo "+"; $a = $a + $count; }; echo ""; echo "$a"; echo ""; echo ""; $animals=array("cat","dog","fish","rabbit"); foreach ($animals as $names) { echo "$names"; }; $x = 10; while ($x < 100000){ $x = (pow($x,2)); …

connect_error ) { die("Connection Failed: ".$conn->connect_error ); } echo "You are connected... "; ?>

connect_error){ die("Connection failed: ".$conn->connect_error); } $stateName = $conn->real_escape_string($_REQUEST['stateName']); $postalCode = $conn->real_escape_string($_REQUEST['pcode']); $capitol = $conn->real_escape_string($_REQUEST['capitol']); $lcity = $conn->real_escape_string($_REQUEST['lcity']); $statehood = $conn->real_escape_string($_REQUEST['statehood']); $landarea = $conn->real_escape_string($_REQUEST['landArea']); $noCounties = $conn->real_escape_string($_REQUEST['noCounties']); $region = $conn->real_escape_string($_REQUEST['region']); $pop2010 = $conn->real_escape_string($_REQUEST['2010pop']); $pop2000 = $conn->real_escape_string($_REQUEST['2000pop']); $electors = $conn->real_escape_string($_REQUEST['electors']); $houseSeats = $conn->real_escape_string($_REQUEST['houseSeats']); $color = $conn->real_escape_string($_REQUEST['color']); $snowfall = $conn->real_escape_string($_REQUEST['snowfall']); echo "State name …

connect_error){ echo"connection failed";} //sequal $sql = " SELECT States.state,States.id, States.2010Pop, CultRegionLookup.StateID, CultRegionLookup.CulturalRegionID,CulturalRegions.CulturalID,CulturalRegions.Name, CulturalRegions.Description FROM States JOIN CultRegionLookup On States.id=CultRegionLookup.StateID JOIN CulturalRegions ON CultRegionLookup.LookupID=CulturalRegions.CulturalID ORDER BY States.2010Pop DESC " ; $result = $conn->query($sql); if($result = $conn->query($sql)){ if($result->num_rows> 0){ echo " StateDescription2010pop "; while($row = $results ->fetch_array()) { echo ""; echo "" …

Arrays <!----> <?php $animals=array("cat","dog","fish","rabbit"); echo "My favorite animal is $animals[2]. I also like $animals[0]s and $animals[3]s. However, I don't like $animals[1]s. "; echo ""; array_push ($animals, "lion", "tiger", "leopard"); sort ($animals); $number = count ($animals); echo "This array has $number animals "; echo ""; rsort ($animals); print_r ($animals); echo ""; …

PHP and If statements

I did not finish all the homework but I completed enought to get a basic understanding of arrays.

query($sql); $otherresult=$conn->query($othersql); $thirdsql="SELECT bd.president_name, bd.state_id, bd.birth_date, s.state FROM birth_place bd JOIN state s ON bd.state_id=s.state_id WHERE birth_date BETWEEN '1800-01-01' AND '1850-01-01' GROUP BY s.state"; $thirdresult=$conn->query($thirdsql); if( $conn->connect_error ){ die("Connection failed: ". $conn->connect_error ); } echo "You are connected... "; if($result){ if($result->num_rows > 0){ echo "Here's where we will print out …