NamePop





Add to Table


Search Table



setAttribute(PDO::ATTR_EMULATE_PREPARES,false); # makes error handling work
		$stmt = $dbh->prepare("SELECT name, cost, lethality FROM weapon where cost > ?");
		if (!$stmt) {
			print_r($dbh->errorInfo());
			die("Bad day");
		}
                if ($stmt->execute(array($searchPrice))) {
                        while ($row = $stmt->fetch()) {
                                print $row['name']." ".$row['cost']." ".$row['lethality'] ."
";
                        }
		}
		
	        $dbh = null;
	}
	 catch (Exception $e) {
	    print "Error!: " . $e->getMessage() . "
";
	    die();
	}
}

function addAThing($name,$cost,$lethality){

        try {
                $dbh = new PDO('mysql:host=localhost;dbname=murder', 'cmacdona', '');
		$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES,false); # makes error handling work
                $stmt = $dbh->prepare("INSERT INTO weapon values(?,?,?)");
		if (!$stmt) {
			print_r($dbh->errorInfo());
			die("Bad day");
		}
		$stmt->execute(array($name,$cost,$lethality));
 	}
	 catch (Exception $e) {
            print "Error!: " . $e->getMessage() . "
";
            die();
        }

}

if( isset( $_REQUEST['myButt'])){
	$name = $_REQUEST["name"];
	$cost = $_REQUEST["cost"];
	$lethality = $_REQUEST["lethality"];
	addAThing($name,$cost,$lethality);
}

if( isset( $_REQUEST['myButt2'])){
	$searchPrice = $_REQUEST["searchPrice"];
	searchAThing($searchPrice);
}
?>