Database Programmering

Forberedelse til Mandag

Hav XAMPP klar på jeres computer. XAMPP kan downloades her https://www.apachefriends.org/index.html

Opgave

Bruger Database (navn og password)
En side til oprettelse af brugere
En side til at verificere et login
Et backup system i json
Lav en profil side, der viser data om den nuværende bruger

Eksempler

JSON (Mere info: json_encode og json_decode)

<?php
class MyClass {
	public $name = "Mads";
	public $age = 27;
	public $awesome = TRUE;
}

$mads = new MyClass();
$json = json_encode($mads);
//{"name":"Mads","age":27,"awesome":true}

$newMads = json_decode($json);
echo $newMads->$name;
?>

Saving a File (simple, Mere Info: file_get_contents og file_put_contents)

<?php
file_put_contents("myFile.txt", "PHP is used for Server-Side Applications");
echo file_get_contents("myFile.txt");
?>

Saving a File (full, Mere Info: fopen, fwrite og fread)

<?php
$filename = "myFile.txt";
$handle = fopen($filename, 'w');
fwrite($handle, "Now we have far more control!");
fclose($handle);
$handle = fopen($filename, 'r');
echo "File Says:\n";
echo fread($handle, filesize($filename));
fclose($handle);
?>

Password Hashing (Mere Info: password_hash og password_verify)

<?php
	$st = "madsbock";
	echo $st . "<br>";
	$hash = password_hash($st, PASSWORD_DEFAULT);
	echo $hash . "<br>";
	if(password_verify($st, $hash)) {
		echo "Access Granted";
	} else {
		echo "Access Denied";
	}
?>

Session Variables (Mere Info: Sessions)

<!--Script1.php, Setting a session variable -->
<?php
	session_start(); //Must be in every script that uses session variables

	$_SESSION["abc"] = "dfg";
?>

<!--Script2.php, Using a session variable -->
<?php
	session_start();

	echo $_SESSION["abc"]; //outputs "dfg"
?>

<!--Script3.php, Stopping a session -->
<?php
	session_start();

	session_unset();
	session_destroy();

	echo $_SESSION["abc"]; //This line will now give error
?>