Database Programmering

Forberedelse til Første Kursusdag

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

Link til Classroom

https://classroom.github.com/a/87PUc6pC

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
Lav et status system (One to Many)
Lav upload af profil billede (Avanceret)
Lav enten et event system, eller et friend system (Avanceret)

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
?>