/*** connection credentials *******/
$servername = "www.watzekdi.net";
$username = "watzekdi_cs393";
$password = "KevinBac0n";
$database = "watzekdi_imdb";
$dbport = 3306;
/****** connect to database **************/
try {
$db = new PDO("mysql:host=$servername;dbname=$database;charset=utf8;port=$dbport", $username, $password);
}
catch(PDOException $e) {
echo $e->getMessage();
}
try {
$stmt = $db->prepare("select * from movies limit 10");
$stmt->execute();
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
/** see the resulting array **/
var_dump($rows);
/** loop through the rows: **/
foreach ($rows as $row){
$id=$row["id"];
$name=$row["name"];
$year=$row["year"];
echo "id: $id, name: $name, year: $year";
}
}
catch (Exception $e) {
echo $e;
}
id: 0, name: #28, year: 2002
id: 1, name: #7 Train: An Immigrant Journey, The, year: 2000
id: 2, name: $, year: 1971
id: 3, name: $1,000 Reward, year: 1913
id: 4, name: $1,000 Reward, year: 1915
id: 5, name: $1,000 Reward, year: 1923
id: 6, name: $1,000,000 Duck, year: 1971
id: 7, name: $1,000,000 Reward, The, year: 1920
id: 8, name: $10,000 Under a Pillow, year: 1921
id: 9, name: $100,000, year: 1915
function getActorByName($db, $firstName, $lastName){
try {
$stmt = $db->prepare("SELECT * FROM actors WHERE first_name=:firstName and last_name=:lastName");
$data=array(":firstName"=>$firstName, ":lastName"=>$lastName);
$stmt->execute($data);
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
return $rows;
} catch (Exception $e) {
return false;
}
}
if ($rows=getActorByName($db, "Kevin", "Bacon")){
var_dump($rows);
}
else{
echo "no results";
}