cds vol2

delete.php

<?php
	require_once('db.php');
	require_once('const.php');

	#---------------------------------------------------------------------------
	header('Location: http://localhost:1234	/siles');
	$response = Array('id' => null);

	if (isset($_POST['id'])) {
		$id = $_POST['id'];
		$result = deleteFromTable($link, $TABLE, $id);
		$response['id'] = $result ? $id : null;
	}

	$link->close();

	$json = json_encode($response);
	echo $json;


	#---------------------------------------------------------------------------

	function deleteFromTable($link, $table, $id) {
		$query = "DELETE FROM $table WHERE id = $id;";
		$result = $link->query($query);
		return $result;
	}

	#---------------------------------------------------------------------------

read.php

<?php
header('Content-Type: text/plain; charset=ISO-8859-1');
echo "<table style='border: solid 1px black;'>";
echo "<tr><th>id</th><th>Ime</th><th>Prezime</th>
<th>Adresa</th><th>Broj telefona</th><th>Datum rodenja</th></tr>";

class TableRows extends RecursiveIteratorIterator {
    function __construct($it) {
        parent::__construct($it, self::LEAVES_ONLY);
    }

    function current() {
        return "<td style='width:150px;border:1px solid black;'>" . parent::current(). "</td>";
    }

    function beginChildren() {
        echo "<tr>";
    }

    function endChildren() {
        echo "</tr>" . "\n";
    }
}

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "telefonski_imenik";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $conn->prepare("SELECT id, ime, prezime,adresa,broj_telefona,datum_rodenja FROM imenik");
    $stmt->execute();

    $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
    foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) {
        echo utf8_encode ($v);
    }
}
catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}
$conn = null;
echo "</table>";
?>

update.php

<?php

	require_once('db.php');
	require_once('const.php');
	#---------------------------------------------------------------------------

	$data = Array();
	if (!empty($_POST)) {
		$result = updateInTable($link, $TABLE, $_POST);
		if ($result) {
			$json = json_encode($_POST);
			echo $json;
		}
	}

	$link->close();

	#---------------------------------------------------------------------------

	function updateInTable($link, $table, $data) {
   		$id = $data['id'];
   		$ime = $data['ime'];
   		$prezime = $data['prezime'];
   		$adresa = $data['adresa'];
   		$broj_telefona = $data['broj_telefona'];
   		$datum_rodenja = $data['datum_rodenja'];
   		$sql  = "UPDATE $table SET ime = '$ime', prezime = '$prezime', adresa = '$adresa' , broj_telefona = '$broj_telefona' , datum_rodenja = '$datum_rodenja' WHERE id = $id;";
   		rtrim($sql, ",");
   		$result = $link->query($sql);
		return $result;
	}