Web Design - ***Enseignant Fiable***

profileoquinones
Assignment6.zip

Assignment 6/~$sg6_hints1.docx

Assignment 6/cargame1.php

$table\n"); print (" \n"); $mydb = new mysqli('localhost', $user, $pword, $dbase); if ($mydb->connect_error) { die( "Failed to connect to MySQL: " . $mydb->connect_error); } $query = "SELECT name, url FROM $table ORDER BY rand() LIMIT 4;"; $result = $mydb->query($query); $mydb->close(); $row = $result->fetch_assoc(); print (" \n"); $correct_name = $row["name"]; print (" \n"); print (" \n"); print (" \n"); while ($row = $result->fetch_assoc()) { $options[]=$row['name']; } $x=rand(1,4); //choose random answer box for ceorrect answer $pos=0; for ($i=1; $i\n"); } else { print (" \n"); $pos++; } } print ("\n"); if (isset($_GET["correct"]) && isset($_GET["answered"])){ $score=$score+$_GET["correct"]; $outOf=$outOf+$_GET["answered"]; } ?> /

Assignment 6/dbtest1.php

<?php $servername = "localhost"; $username = "flashuser"; $password = "MyDogHasFleas"; // Create connection $conn = new mysqli($servername, $username, $password); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully"; ?>

Assignment 6/flashcards/cars.frm

Assignment 6/flashcards/cars.ibd

Assignment 6/flashcards/db.opt

default-character-set=utf16le default-collation=utf16le_general_ci

Assignment 6/images/acura.jpg

Assignment 6/images/background.png

Assignment 6/images/buick.jpg

Assignment 6/images/cadillac.jpg

Assignment 6/images/chevy.jpg

Assignment 6/images/chrysler.png

Assignment 6/images/honda.jpg

Assignment 6/images/hyndai.jpg

Assignment 6/images/infinity.jpg

Assignment 6/images/jaguar.jpg

Assignment 6/images/lexus.jpg

Assignment 6/images/lincoln.png

Assignment 6/images/mazda.jpg

Assignment 6/images/mercedes.jpg

Assignment 6/images/mitsubishi.png

Assignment 6/images/pontiac.jpg

Assignment 6/images/subaru.jpg

Assignment 6/images/toyota.jpg

Assignment 6/images/volkswagen.jpg

Assignment 6/showtable21.php

Data in the Cars table

$dbase"); $mydb = new mysqli('localhost', $user, $pword, $dbase); if ($mydb->connect_error) { die( "Failed to connect to MySQL: " . $mydb->connect_error); } print (" "); print ("
name url
"); $query = "SELECT name, url FROM Cars;"; if ($result = $mydb->query($query)) { while ($row = $result->fetch_assoc()) { // Output the results as an html table print ("
"); foreach ( $row as $key => $value ) { print ("
$key : $value
"); } print (""); } } $mydb->close(); ?>

Assignment 6/test1.php

<?php phpinfo(); ?>