ok jeg smider alt kode ind her. jeg skriver filnavnet over over koden så du kan følge med. kommer ikke liger med yderligere forklaringer. med mindre i beder mig om det.
db.class.php
<?php
class DB {
protected $dbhost = 'localhost';
protected $dbuser = 'test';
protected $dbpass = 'xxxx';
protected $dbname = 'test';
protected $conn = '';
public function __construct() {
$conn = mysqli_connect($this->dbhost, $this->dbuser, $this->dbpass, $this->dbname);
if(mysqli_connect_errno()) {
die('Connection failed : <i>' . mysqli_connect_error($this->conn) . '</i>');
exit;
}
$this->conn = $conn;
}
public function search($q) {
$search = $q;
$stmt = $this->conn->prepare("select firstname, middlename, lastname, phone, email from contacts where firstname = ?");
if($stmt) {
mysqli_stmt_bind_param($stmt, 's', $search);
mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt, $firstname, $middlename, $lastname, $phone, $email);
while(mysqli_stmt_fetch($stmt)) {
$fullname = $firstname.' '.$middlename.' '.$lastname;
echo '
<span>'.$fullname.'</span>
<span>'.$phone.'</span>
<span>'.$email.'</span>
';
}
mysqli_stmt_close($stmt);
}
}
public function adminHeader($uid) {
$stmt = $this->conn->prepare("select user_id, fullname, access_level from admin where user_id = ?");
if($stmt) {
mysqli_stmt_bind_param($stmt, "i", $uid);
mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt, $user_id, $fullname, $access_level);
while(mysqli_stmt_fetch($stmt)) {
echo '
<label>Navn : </label>
<span>'.$fullname.'</span>
<label>Adgang : </label>
<span>'.$access_level.'</span>
<label>ID Nummer : </label>
<span>'.$user_id.'</span>
';
}
mysqli_stmt_close($stmt);
}
}
public function insertContact($firstname, $middlename, $lastname, $birthday, $phone, $email, $relation) {
$sql = "insert into contacts(firstname, middlename, lastname, birthday, phone, email, relation) values('$firstname', '$middlename', '$lastname', '$birthday', '$phone', '$email', '$relation')";
mysqli_query($this->conn, $sql) or die(mysqli_error($this->conn));
}
public function showAll() {
$stmt = $this->conn->prepare("select firstname, middlename, lastname, phone, email, relation from contacts");
if($stmt) {
mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt, $firstname, $middlename, $lastname, $phone, $email, $relation);
while(mysqli_stmt_fetch($stmt)) {
$fullname = $firstname.' '.$middlename.' '.$lastname;
echo '
<span>'.$fullname.'</span>
<span>'.$phone.'</span>
<span>'.$email.'</span>
<span>'.$relation.'</span>
';
}
mysqli_stmt_close($stmt);
}
}
admin.php
<?php
class Admin extends DB {
public function __construct() {
parent::__construct();
}
public function adminUser($uid) {
echo '<div class="adminheader">';
$this->adminHeader($uid);
echo '</div>';
}
public function addContact($firstname, $middlename, $lastname, $birthday, $phone, $email, $relation) {
$this->insertContact($firstname, $middlename, $lastname, $birthday, $phone, $email, $relation);
}
}
add_contact.php
<div class="forms">
<form action="" method="post">
<label>Fornavn</label><input type="text" name="firstname" placeholder="Fornavn">
<label>Mellemnavn</label><input type="text" name="middlename" placeholder="Mellemnavn">
<label>Efternavn</label><input type="text" name="lastname" placeholder="Efternavn">
<label>Fødselsdag</label><input type="date" name="birthday" placeholder="YYYY-MM-DD">
<label>Telefon</label><input type="text" name="phone" placeholder="Telefon nummer">
<label>Email</label><input type="text" name="email" placeholder="Email">
<label>Relation</label><select name="relation">
<option>Vælg Relation</option>
<option value="family">Familie</option>
<option value="owner">Ejer</option>
<option value="friends">Venner</option>
<option value="worker">Kollega</option>
<option value="other">Andet</option>
</select>
<input type="submit" name="add" value="Opret Kontakt" id="btn">
<input type="reset" value="Ryd Felter" id="btn">
</form>
<?php
if(isset($_POST['add'])) {
$firstname = $_POST['firstname'];
$middlename = $_POST['middlename'];
$lastname = $_POST['lastname'];
$birthday = $_POST['birthday'];
$phone = $_POST['phone'];
$email = $_POST['email'];
$relation = $_POST['relation'];
require_once 'controllers/admin.php';
$con = new Admin();
$con->addContact($firstname, $middlename, $lastname, $birthday, $phone, $email, $relation);
}
?>
</div>
bootstrap.php
<?php
class Bootstrap {
public function bootstrap() {
$url = 'page';
if(!isset($_GET[$url])) {
if(isset($_SESSION['logged']) == true) {
$this->view('admin/index');
} else {
$this->view('home/index');
}
} else {
switch($_GET[$url]) {
case "search":
$this->view('home/search');
break;
case "admin":
$this->view('home/admin');
break;
case "add_contact":
$this->view('admin/add_contact');
break;
case "contacts":
$this->view('admin/contacts');
break;
case "show_all_contacts":
$this->view('home/contacts');
break;
}
}
}
public function view($name) {
$file = 'views/'.$name.'.php';
if(file_exists($file)) {
require 'views/header.php';
require $file;
require 'views/footer.php';
} else {
$this->error();
}
}
public function error() {
require 'views/header.php';
require 'views/error/404.php';
require 'views/footer.php';
return false;
}
}
og her til sidst min index.php
<?php
session_start();
require 'config/paths.php';
require 'config/db.class.php';
require 'libs/bootstrap.php';
$app = new Bootstrap();
if(isset($_SESSION['sesid']) && $_SESSION['sesid'] == true) {
$app->bootstrap();
} else {
$app->bootstrap();
}
det er alt koden på de filer som bliver brugt.
håber du kan få noget brugbart ud af det...
