Skip to content

Instantly share code, notes, and snippets.

@maio

maio/AddController.php

Created January 30, 2011 21:48
Show Gist options
  • Save maio/803286 to your computer and use it in GitHub Desktop.
Save maio/803286 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
AddController.php
<?php
final class AddController {
public function __construct() {
require 'model/WriteModel.php';
}
public function newPost($name,$text) {
$addModel = new WriteModel($name, $text);
return $addModel;
}
}
Raw
DbModel.php
<?php
abstract class DbModel {
public $id_spojeni;
function __construct() {
$server = "127.0.0.1"; // jm�no serveru
$login = "root"; // p�ihla�ovac� jm�no
$heslo_dat = ""; // heslo
$databaze = "visitbook"; // n�zev datab�ze
$this->id_spojeni = MySQL_Connect($server, $login, $heslo_dat) or die("Nepodařilo se připojit k databázi"); // p�ipojen� k datab�zi
MySQL_Select_DB($databaze) or die("Nepodařilo se otevřít databázi"); // v�b�r datab�ze
mysql_query("SET NAMES 'utf8'");
}
}
Raw
index.php
<?php
session_start();
error_reporting(E_ALL);
require 'controller/PostsController.php';
require 'model/DbModel.php';
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="style.css" type="text/css" media="screen, projection">
<title>Návštěvní kniha - OOP
</title>
</head>
<body>
<h1>Návštěvní kniha</h1>
<?php
$controller = new PostsController;
$posts = $controller->posts();
if(isset($_POST["name"])) {
require 'controller/AddController.php';
$newPost = new AddController();
$addPost = $newPost->newPost($_POST["name"], $_POST["text"]);
if($addPost == true)
echo "<h3>Příspěvek byl úspěšně přidán!</h3><br>Pokud svůj příspěvek nevidíte obnovte nejdříve stránku!";
else
echo "Příspěvek se nepodařilo přidat. Někde je chyba!";
}
?>
<div id="prispevky" style="width: 80%; margin-left: 10%">
<form name="post" action="index.php" method="post" onSubmit="return check()">
<table>
<tr><td style="text-align: right;"><label for="name">Jméno:</label></td><td><input type="text" name="name"></td></tr>
<tr><td style="text-align: right;"><label for="text">Text:</label></td><td><textarea name="text" rows="7" cols="50"></textarea></td></tr>
<tr><td></td><td style="text-align: right;"><input type="submit" name="submit"></td></tr>
</table>
</form>
<?php
foreach($posts as $arr => $id) {
echo "<b>". $id[0] ."</b> <div style=\"float: right;\">". $id[1] ."</div><br>". $id[2] ."<br><hr>";
}
?>
</div>
<script type="text/javascript">
var cesta;
function check() {
cesta = document.post;
if(cesta.name.value=="" || cesta.text.value=="") {
alert('Musíte vyplnit všechny povinné údaje');
return false;
}
else
return true;
}
</script>
</body>
</html>
Raw
PostsController.php
<?php
final class PostsController {
public $model;
function posts() {
require "model/ReadModel.php";
$this->model = new ReadModel;
$prispevky = $this->model->ReadPosts();
return $prispevky;
}
}
Raw
private.properties
copy.src.files=false
copy.src.target=
index.file=index.php
run.as=LOCAL
url=http://127.0.0.1:8888/oop/navstevni%20kniha%20v%20oop/
Raw
project.properties
include.path=${php.global.include.path}
php.version=PHP_53
source.encoding=UTF-8
src.dir=.
tags.asp=false
tags.short=true
web.root=.
Raw
project.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://www.netbeans.org/ns/project/1">
<type>org.netbeans.modules.php.project</type>
<configuration>
<data xmlns="http://www.netbeans.org/ns/php-project/1">
<name>navstevni kniha v oop</name>
</data>
</configuration>
</project>
Raw
ReadModel.php
<?php
final class ReadModel extends DbModel {
function ReadPosts() {
$select = mysql_query("SELECT * FROM prispevky ORDER BY Datum DESC",$this->id_spojeni);
$posts = array();
while($radek = mysql_fetch_array($select)) {
$posts[] = $radek;
}
return $posts;
}
}
Raw
style.css
/* CSS Document */
body {
background: lightblue;
width: 800px;
margin: 0 auto;
padding: 0;
}
h1 {
text-align: center;
}
Raw
visitbook.sql
-- phpMyAdmin SQL Dump
-- version 3.3.8
-- http://www.phpmyadmin.net
--
-- Počítač: 127.0.0.1
-- Vygenerováno: Neděle 30. ledna 2011, 21:49
-- Verze MySQL: 5.1.52
-- Verze PHP: 5.3.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Databáze: `visitbook`
--
-- --------------------------------------------------------
--
-- Struktura tabulky `prispevky`
--
CREATE TABLE IF NOT EXISTS `prispevky` (
`Jmeno` varchar(30) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
`Datum` datetime NOT NULL,
`Text` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
`ID` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
--
-- Vypisuji data pro tabulku `prispevky`
--
INSERT INTO `prispevky` (`Jmeno`, `Datum`, `Text`, `ID`) VALUES
('Kryštof', '2011-01-18 09:15:30', 'Ahoj, tohle je zkouška', 1),
('Darkry', '2011-01-04 09:15:50', 'čau, tohle je taky zkouška!', 2),
('Darkry', '2011-01-30 21:45:41', 'Další pokus. Tentokrát už přidávám příspěvek!', 10);
Raw
WriteModel.php
<?php
final class WriteModel extends DbModel {
public function __construct($name,$text) {
$addPost = mysql_query("INSERT INTO prispevky(Jmeno,Datum,Text) VALUES ('$name', NOW(), '$text' )");
if($addPost)
return true;
else
return false;
}
}
@Darkry
Copy link

Darkry commented Jan 31, 2011

Diky, ze jsi to sem dal.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment