#PHP 101 This guide will teach you methods like creating Webpages, interacting with SQL databases and more.

##Setup your environment

• You need some sort of Webserver, I like XAMPP.
• Download your IDE (Development environment). I use Atom, it is a hackable code editor
  • Alternativly you can use Submlime Text
• I also encourage you to use Google Chrome, it is one of the best, if not the best browser available
• Download MySQL Workbench

##Prepare XAMPP You may need to execute XAMPP as an Administrator

1. Start XAMPP

• Open the Windows Start menu or just press the windows key on your keyboard
• Search for "XAMPP Control Panel"
• Right click on it
• Select "More"
• Click on "Execute as Administrator"

2. Start all needed services

• Locate the freshly opened "XAMPP Control Panel"
• Start "Apache" and "MySQL"

3. Create the folder for the new Project

• Locate the XAMPP folder, usually under C:/xampp/htdocs
• Create a new directory in this folder (The folder name is the name you type in the URL bar, like http://localhost/proj1 for your first project)

##Prepare Atom This step only is needed if you are using Atom!

1. Simply start Atom
2. Open your project folder you created in step 3 of "Prepare XAMPP"

• Once Atom is opened locate the "Open a Project" button, click on it and follow the dialog

##Prepare MySQL Do you already have a Database you can work with? If not go and create one!

1. Create your Database using MySQL Workbench
2. Don't forget to save your progress, this tool tends to crash frequently
3. Insert some data if you like
4. Upload your Database to XAMPPs MySQL server by using forward engineer. Don't forget to check "Generate INSERT Statements for Table" after selecting "Forward Engineer", this will also insert all your data to the Database.

###Hurray, we are all set now!

---

###Take a look at www.idoodler.de/php101 for more infos and a detailed description

---

##Lets code Above you see different folders these folders are different projects you can take a look at! I tried my best to comment everything.

---

Don't make a one-to-one copy of the code, also modify the comments!

---

##Test your code Check test/testProtocol.xlsx

##Create a database connection As seen in movie/database.php

// Create a connection variable
$connection = new MySqli("localhost", "root", "", "DATABASE_NAME");

// Set the encoding of the Database
$connection->set_charset('utf8');

##Select data from the database As seen in movie/searchActorResult.php

// Include database.php to use the $connection variable 
include "database.php";

// Create the SQL query
// The ? after the like is a security feature, it prevents SQL injections
$sql = "SELECT p.bDate, s.Name
        FROM Person p, Sozialversicherung s
        WHERE p.SozId = s.id
        AND p.city LIKE ?";
        
// Preparing the sql select with the connection
$stm = $connection->prepare($sql);

// Prepare the variables you want to bind (replace the ? with)
// Replace SEARCH_TERM with the actual variable
$city = "%SEARCH_TERM%";

//Bind the variables
$stmt->bind_param("s", $city);

// Execute the sql statement
$stmt->execute();

// Get the result of the sql statement
$result = $stmt->get_result();

// Then fetch the result as an array, so index is a row
$actorRows = $result->fetch_all(MYSQLI_ASSOC);

// Dump the variable to better understand the data
var_dump($actorRows);

Happy coding!