szit

Ez az oldal csak olvasható. Megtekintheted a forrását, de nem változtathatod meg. Ha úgy gondolod, hogy ez helytelen, kérdezd az Adminisztrátorokat!
[[oktatas:programozás:php:php adatbázis|< PHP adatbázis]]

====== MySQLi Objektum Orientáltan ======

  * **Szerző:** Sallai András
  * Copyright (c) Sallai András, 2020
  * Licenc: GNU Free Documentation License 1.3
  * Web: https://szit.hu

===== Adatbázis =====

<code mysql feherbt.sql>
create database feherbt
character set utf8
collate utf8_hungarian_ci;

grant all privileges
on feherbt.*
to feherbt@localhost
identified by 'titok';


use feherbt;
create table employees (
    id int not null primary key auto_increment,
    name varchar(30),
    city varchar(30),
    salary double
);
</code>


===== Példa =====

==== Struktúra ====

<code>
projekt01/
  |-src/
  |  |-includes/
  |  |   |-employee.php
  |  |   |-getdata.php
  |  |   |-insertdata.php
  |  |   `-mariadb.php
  |  |-templates/
  |  |   |-footer.tpl
  |  |   |-header.tpl
  |  |   |-index.tpl
  |  |   `-li.tpl
  |  `-index.php
  `-test/
     `-insertEmployeeTest.php
</code>


==== employee.php ====

<code php employee.php>
<?php

class Employee {
    public $id;
    public $name;
    public $city;
    public $salary;
}
</code>

==== mariadb.php ====

<code php mariadb.php>
<?php

class Mariadb {
    public static function connectDb() {        
        $conn = new mysqli('localhost', 'feherbt', 'titok', 'feherbt');
        if($conn->connect_error) {
            error_log('Hiba! A kapcsolódás sikertelen!');
            die;
        }
        $conn->set_charset("utf-8");
        return $conn;
    }
}
</code>

==== getdata.php ====

<code php getdata.php>
<?php 

include 'mariadb.php';

class Getdata {
    public static function getEmployees() {
        $employees = array();        
        $conn = Mariadb::connectDb();
        $sql = "select name, city, salary from employees";
        if ($res = $conn->query($sql)) {
            while(($record = $res->fetch_assoc()) !== null) {
                $employee = new Employee();
                $employee->name = $record['name'];
                $employee->city = $record['city'];
                $employee->salary = $record['salary'];
                array_push($employees, $employee);
            }
        }else {
            error_log('Hiba! A lekérdezés sikertelen!');
        }
        $conn->close();
        return $employees;
    }
}
</code>

==== index.php ====

<code php index.php>
<?php

include 'includes/getdata.php';
include 'includes/employee.php';

$employees = Getdata::getEmployees();

echo file_get_contents('templates/header.tpl');

$page = file_get_contents('templates/index.tpl');

$li = file_get_contents('templates/li.tpl');
$employeeList = '';
foreach($employees as $employee) {    
    $employeeList .= str_replace('{{ employee }}', $employee->name, $li);
}

$page = str_replace('{{ employeeList }}', $employeeList, $page);
echo $page;

echo file_get_contents('templates/footer.tpl');
</code>

==== header.tpl ====

<code html header.tpl>
<!DOCTYPE html>
<html lang="hu">
<head>
<meta charset="utf-8">
<title>Minta</title>
</head>
<body>

    <div class="container">


    <h1>Minta</h1>
</code>

==== footer.tpl ====

<code html footer.tpl>


    </div>
</body>
</html>
</code>

==== index.tpl ====

<code html index.tpl>
<ul>
    {{ employeeList }}
</ul>
</code>

==== li.tpl ====

<code html li.tpl>
<li>{{ employee }}</li>
</code>

===== Beszúrás =====

<code php insertEmployee.php>
include_once 'includes/employee.php';
include_once 'includes/mariadb.php';

class Insertdata {
    public static function insertEmployee($employee) {
        $conn = Mariadb::connectDb();
        $sql = "insert into employees " .
               "(name, city, salary) values " .
               "(?, ?, ?)";
        
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("ssd", 
            $employee->name,
            $employee->city,
            $employee->salary
            );
        $insertOk = false;
        if($stmt->execute()) {
            $insertOk = true;
            error_log('Beszúrt, azonosító: ' . $conn->insert_id . "\n");
        }else {
            error_log("Hiba! A beszúrás sikertelen!\n");
        }        
        $stmt->close();        
        $conn->close();
        return $insertOk;
    }
}
</code>

==== Teszt ====

<code php insertEmployeeTest.php>
<?php 

include '../src/includes/insertdata.php';
include_once '../src/includes/employee.php';

$employee = new Employee();
$employee->name = 'Parány Mihály';
$employee->city = 'Szeged';
$employee->salary = 2850000;
if(Insertdata::insertEmployee($employee)) {
    echo 'Ok    Sikeres beszúrás';
}else{
    echo 'Hiba! Sikertelen beszúrás!';
}
</code>