<?php
require('head.php');
//$link = mysql_connect('localhost','root','');
//mysql_select_db('fotoblog',$link);
//mysql_query("SET NAMES 'UTF-8';");
require('mysql.php');
$posts = mysql_query("SELECT * FROM `posts` ORDER BY `id` DESC LIMIT 5;",$link);
while($post = mysql_fetch_object($posts)){
echo'
<div class="post">
<div class="postContent">
<img src="foto/'.$post->foto.'" alt="Foto">
</div>
<div class="postText">'.$post->text.'</div>
<div class="postFoot">
<a href="comments.php?id='.$post->id.'">? comments</a> / '.date('d/m/Y',$post->time).'
</div>
</div>
';
}
require('end.php');
?>
mysql.php ------------------------------------------------------------------
<?PHP
$link = mysql_connect('localhost','root','');
mysql_select_db('fotoblog',$link);
mysql_query("SET NAMES 'UTF-8';");
?>
head.php --------------------------------------------------------------------
<!DOCTYPE HTML>
<html lang="en">
<head>
<meta charset="utf-8">
<title>foto blogs</title>
<link rel="stylesheet" href="stils.css" type="text/css">
</head>
<body>
<div id="main">
<div id="left">
<h2>Foto blogs</h2>
<nav id="menu">
<a href="#">Link 1</a>
<a href="#">Link 2</a>
<a href="#">Link 3</a>
<a href="#">Link 4</a>
<a href="#">Link 5</a>
</nav>
<span>
©2011 foto blogs
</span>
</div>
<div id="center">
<div id="center_right">
<b>Search: </b>
<form action="#" method="post">
<input type="text" name="search" placeholder="Type and hit enter">
</form>
<b>Twitter</b>
<div class="tweet">
<p>Pirmais tweets</p>
<span>15 min </span>
</div>
<div class="tweet">
<p>Otrais tweets</p>
<span>21 min </span>
</div>
<div class="tweet">
<p>Trešais tweets</p>
<span>25 min </span>
</div>
</div>
<div id="center_left">
end.php ---------------------------------------------------------------------------------
</div>
</div>
</div>
</body>
</html>
comments.php -----------------------------------------------------------------------
<?PHP
require('head.php');
require('mysql.php');
$id = intval($_GET['id']);
$post = mysql_query("SELECT * FROM `posts` WHERE `id`='$id'",$link);
if(mysql_num_rows($post) == 0){
echo '<h2>404:</h2> Went to bar';
}else{
$row = mysql_fetch_row($post);
echo'
<div class="post">
<div class="postContent">
<img src="foto/'.$row[3].'" alt="Foto">
</div>
<div class="postText">'.$row[1].'</div>
<div class="postFoot">
'.date('d/m/Y',$row[2]).'
</div>
</div>
</div>
';
}
require('end.php');
?>
stils.css ----------------------------------------------------------------------------------
*{
margin:0;
padding:0;
}
body{
font-size:12px;
font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;
background-color:#F5F5F5;
}
#main{
width:1290px;
margin:auto;
overflow:hidden;
margin-top:40px;
/*border:1px solid #c0c0c0;
background-color:#fefefe;*/
}
#left{
position:fixed;
width:180px;
/*min-height:400px;*/
border:1px solid #F1F1F1;
background-color:white;
}
#left h2{
margin:20px;
font-family:Tahoma;
letter-spacing:0.12EM;
}
#left span{
display:block;
margin:20px;
margin-top:0px;
color:#B9BBBF;
}
#menu{
margin:20px;
border-top:1px solid #DDDFE2;
border-bottom:1px solid #DDDFE2;
}
#menu a{
display:block;
line-height:24px;
color:#545658;
text-decoration:none;
}
#menu a:hover{
color:#000;
text-decoration:underline;
}
#center{
overflow:hidden;
width:1080px;
margin-left:220px;
/*background-color:blue;*/
}
#center_right{
float:right;
width:265px;
min-height:300px;
/*background-color:orange;*/
}
#center_right input[type="text"]{
padding:5px;
height:20px;
line-height:20px;
width:200px;
margin-top:18px;
margin-bottom:60px;
color:#A1A3A6;
border:1px solid C9C9C9;
background-color:#FFF;
}
.tweet{
margin-top:20px;
text-align:justify;
}
.tweet span{
display:block;
margin-top:3px;
font-size:10px;
color:#A1A3A6;
}
#center_left{
float:left;
width:775px;
min-height:1000px;
/*background-color:violet;*/
}
.post{
min-height:200px;
line-height:20px;
margin-bottom:40px;
padding:30px;
border-top:1px solid #E1E1E1;
border-left:1px solid #E1E1E1;
box-shadow:1px 1px 2px #AAA;
background-color:white;
}
.postContent{
text-align:center;
}
.postContent img{
max-width:715px;
}
.postText{
margin-top:20px;
margin-bottom:20px;
text-align:justify;
color:#545658;
}
.postFood{
color:#A1A3A6;
}
.postFood a{
color:#A1A3A6;
text-decoration:none;
}
mysql -----------------------------------------------------------------
/* Connecting to 127.0.0.1 via TCP/IP, username root, using password: No ... */ /* Connected. Thread-ID: 24 */ /* Characterset: utf8 */ SHOW STATUS LIKE 'Uptime'; SHOW VARIABLES LIKE 'version_compile_os'; SHOW VARIABLES LIKE 'hostname'; SHOW DATABASES; USE `data1`; SHOW TABLE STATUS FROM `data1`; SHOW FUNCTION STATUS WHERE `Db`='data1'; SHOW PROCEDURE STATUS WHERE `Db`='data1'; SHOW TRIGGERS FROM `data1`; SHOW EVENTS FROM `data1`; SHOW CREATE TABLE `data1`.`preces`; SHOW COLLATION; SHOW ENGINES; SHOW CREATE TABLE `data1`.`testtable`; SHOW CREATE TABLE `data1`.`usera`; SHOW CREATE TABLE `data1`.`userb`; SHOW CREATE TABLE `data1`.`users`; SHOW CHARSET; SHOW TABLES FROM `information_schema`; SELECT * FROM `information_schema`.`SCHEMATA`; SHOW VARIABLES LIKE 'character_set_server'; CREATE DATABASE `fotoblog` /*!40100 CHARACTER SET utf8 COLLATE utf8_general_ci */; SHOW TABLE STATUS FROM `data1`; SHOW FUNCTION STATUS WHERE `Db`='data1'; SHOW PROCEDURE STATUS WHERE `Db`='data1'; SHOW TRIGGERS FROM `data1`; SHOW EVENTS FROM `data1`; SHOW DATABASES; SELECT * FROM `information_schema`.`SCHEMATA`; USE `fotoblog`; SHOW TABLE STATUS FROM `fotoblog`; SHOW FUNCTION STATUS WHERE `Db`='fotoblog'; SHOW PROCEDURE STATUS WHERE `Db`='fotoblog'; SHOW TRIGGERS FROM `fotoblog`; SHOW EVENTS FROM `fotoblog`; SHOW VARIABLES LIKE 'collation_database'; CREATE TABLE `posts` ( `id` INT(8) NOT NULL, `text` TEXT NOT NULL, `time` INT NOT NULL ) COLLATE='utf8_general_ci' ENGINE=MyISAM ROW_FORMAT=DEFAULT; SHOW TABLE STATUS FROM `fotoblog`; SHOW FUNCTION STATUS WHERE `Db`='fotoblog'; SHOW PROCEDURE STATUS WHERE `Db`='fotoblog'; SHOW TRIGGERS FROM `fotoblog`; SHOW EVENTS FROM `fotoblog`; SHOW CREATE TABLE `fotoblog`.`posts`; ALTER TABLE `posts` ADD PRIMARY KEY (`id`); SHOW TABLE STATUS FROM `fotoblog`; SHOW FUNCTION STATUS WHERE `Db`='fotoblog'; SHOW PROCEDURE STATUS WHERE `Db`='fotoblog'; SHOW TRIGGERS FROM `fotoblog`; SHOW EVENTS FROM `fotoblog`; SHOW CREATE TABLE `fotoblog`.`posts`; SELECT `id`, LEFT(`text`, 256), `time` FROM `fotoblog`.`posts` LIMIT 0, 1000; SHOW CREATE TABLE `posts`; INSERT INTO `posts` (`id`) VALUES (1); UPDATE `posts` SET `text`='sveiki1', `time`=1 WHERE `id`=1 LIMIT 1; INSERT INTO `posts` (`id`, `text`, `time`) VALUES (2, 'sveiki2', 2); INSERT INTO `posts` (`id`, `text`, `time`) VALUES (3, 'sveiki3', 3); INSERT INTO `posts` (`id`, `text`, `time`) VALUES (4, 'sveiki4', 4); INSERT INTO `posts` (`id`, `text`, `time`) VALUES (5, 'sveiki5', 5); SELECT `id`, LEFT(`text`, 256), `time` FROM `fotoblog`.`posts` LIMIT 0, 1000; SHOW CREATE TABLE `posts`; SELECT `id`, LEFT(`text`, 256), `time` FROM `fotoblog`.`posts` LIMIT 0, 1000; SHOW CREATE TABLE `posts`; UPDATE `posts` SET `time`=5000000 WHERE `id`=5 LIMIT 1; UPDATE `posts` SET `time`=50000 WHERE `id`=5 LIMIT 1; UPDATE `posts` SET `time`=1324388032 WHERE `id`=5 LIMIT 1; ALTER TABLE `posts` ADD COLUMN `foto` TEXT NOT NULL AFTER `id`; SHOW TABLE STATUS FROM `fotoblog`; SHOW FUNCTION STATUS WHERE `Db`='fotoblog'; SHOW PROCEDURE STATUS WHERE `Db`='fotoblog'; SHOW TRIGGERS FROM `fotoblog`; SHOW EVENTS FROM `fotoblog`; SHOW CREATE TABLE `fotoblog`.`posts`; ALTER TABLE `posts` CHANGE COLUMN `foto` `foto` TEXT NOT NULL AFTER `time`; SHOW TABLE STATUS FROM `fotoblog`; SHOW FUNCTION STATUS WHERE `Db`='fotoblog'; SHOW PROCEDURE STATUS WHERE `Db`='fotoblog'; SHOW TRIGGERS FROM `fotoblog`; SHOW EVENTS FROM `fotoblog`; SHOW CREATE TABLE `fotoblog`.`posts`; SELECT `id`, LEFT(`text`, 256), `time`, LEFT(`foto`, 256) FROM `fotoblog`.`posts` LIMIT 0, 1000; SHOW CREATE TABLE `posts`; UPDATE `posts` SET `foto`='1.jpg' WHERE `id`=1 LIMIT 1; UPDATE `posts` SET `foto`='2.jpg' WHERE `id`=2 LIMIT 1; UPDATE `posts` SET `foto`='3.jpg' WHERE `id`=3 LIMIT 1; UPDATE `posts` SET `foto`='4.jpg' WHERE `id`=4 LIMIT 1; UPDATE `posts` SET `foto`='5.jpg' WHERE `id`=5 LIMIT 1; SHOW VARIABLES LIKE 'collation_database'; CREATE TABLE `comments` ( `id` INT(10) NOT NULL, `postid` INT(10) NOT NULL, `author` TEXT NOT NULL, `email` TEXT NOT NULL, `ip` INT NOT NULL, `date` INT NOT NULL, PRIMARY KEY (`id`), INDEX `postid` (`postid`) ) COLLATE='utf8_general_ci' ENGINE=MyISAM ROW_FORMAT=DEFAULT; SHOW TABLE STATUS FROM `fotoblog`; SHOW FUNCTION STATUS WHERE `Db`='fotoblog'; SHOW PROCEDURE STATUS WHERE `Db`='fotoblog'; SHOW TRIGGERS FROM `fotoblog`; SHOW EVENTS FROM `fotoblog`; SHOW CREATE TABLE `fotoblog`.`comments`; SELECT `id`, `postid`, LEFT(`author`, 256), LEFT(`email`, 256), `ip`, `date` FROM `fotoblog`.`comments` LIMIT 0, 1000; SHOW CREATE TABLE `comments`; INSERT INTO `comments` (`postid`) VALUES (1); INSERT INTO `comments` (`postid`) VALUES (2); /* SQL Error (1062): Duplicate entry '0' for key 'PRIMARY' */ INSERT INTO `comments` (`postid`) VALUES (2); /* SQL Error (1062): Duplicate entry '0' for key 'PRIMARY' */ SELECT `id`, `postid`, LEFT(`author`, 256), LEFT(`email`, 256), `ip`, `date` FROM `fotoblog`.`comments` ORDER BY `id` ASC LIMIT 0, 1000; SHOW CREATE TABLE `comments`; SELECT `id`, `postid`, LEFT(`author`, 256), LEFT(`email`, 256), `ip`, `date` FROM `fotoblog`.`comments` ORDER BY `id` DESC LIMIT 0, 1000; SHOW CREATE TABLE `comments`; UPDATE `comments` SET `id`=1 WHERE `id`=0 LIMIT 1; INSERT INTO `comments` (`postid`) VALUES (1); UPDATE `comments` SET `postid`=5 WHERE `id`=1 LIMIT 1; UPDATE `comments` SET `postid`=5 WHERE `id`= LIMIT 1; /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 */ UPDATE `comments` SET `id`=2, `postid`=5 WHERE `id`= LIMIT 1; /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 */ UPDATE `comments` SET `id`=2, `postid`=5 WHERE `id`= LIMIT 1; /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 */ UPDATE `comments` SET `id`=2, `postid`=5 WHERE `id`= LIMIT 1; /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 */ UPDATE `comments` SET `id`=2, `postid`=5 WHERE `id`= LIMIT 1; /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 */ UPDATE `comments` SET `id`=2, `postid`=6 WHERE `id`= LIMIT 1; /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 */ UPDATE `comments` SET `id`=2, `postid`=6 WHERE `id`= LIMIT 1; /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 */ UPDATE `comments` SET `id`=3 WHERE `id`= LIMIT 1; /* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 */ SELECT `id`, `postid`, LEFT(`author`, 256), LEFT(`email`, 256), `ip`, `date` FROM `fotoblog`.`comments` LIMIT 0, 1000; SHOW CREATE TABLE `comments`; UPDATE `comments` SET `date`=1324391627 WHERE `id`=1 LIMIT 1; UPDATE `comments` SET `date`=1324391632 WHERE `id`=0 LIMIT 1; ALTER TABLE `comments` AUTO_INCREMENT=0, CHANGE COLUMN `id` `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST; SHOW TABLE STATUS FROM `fotoblog`; SHOW FUNCTION STATUS WHERE `Db`='fotoblog'; SHOW PROCEDURE STATUS WHERE `Db`='fotoblog'; SHOW TRIGGERS FROM `fotoblog`; SHOW EVENTS FROM `fotoblog`; SHOW CREATE TABLE `fotoblog`.`comments`; SELECT `id`, `postid`, LEFT(`author`, 256), LEFT(`email`, 256), `ip`, `date` FROM `fotoblog`.`comments` LIMIT 0, 1000; SHOW CREATE TABLE `comments`; INSERT INTO `comments` (`postid`) VALUES (5); SELECT LAST_INSERT_ID(); INSERT INTO `comments` (`postid`) VALUES (1); SELECT LAST_INSERT_ID(); UPDATE `comments` SET `author`='5a' WHERE `id`=1 LIMIT 1; UPDATE `comments` SET `author`='5b' WHERE `id`=3 LIMIT 1; UPDATE `comments` SET `author`='1a' WHERE `id`=2 LIMIT 1; UPDATE `comments` SET `author`='1b' WHERE `id`=4 LIMIT 1; UPDATE `comments` SET `email`='5a-email' WHERE `id`=1 LIMIT 1; UPDATE `comments` SET `email`='5b-email' WHERE `id`=3 LIMIT 1; UPDATE `comments` SET `email`='1a-email' WHERE `id`=2 LIMIT 1; UPDATE `comments` SET `email`='1b-email' WHERE `id`=4 LIMIT 1; UPDATE `comments` SET `ip`=1 WHERE `id`=1 LIMIT 1; UPDATE `comments` SET `ip`=2 WHERE `id`=3 LIMIT 1; UPDATE `comments` SET `ip`=3 WHERE `id`=2 LIMIT 1; UPDATE `comments` SET `ip`=4 WHERE `id`=4 LIMIT 1; UPDATE `comments` SET `date`=1324391806 WHERE `id`=3 LIMIT 1; UPDATE `comments` SET `date`=1324391810 WHERE `id`=4 LIMIT 1; SHOW CREATE TABLE `fotoblog`.`posts`; SELECT `id`, LEFT(`text`, 256), `time`, LEFT(`foto`, 256) FROM `fotoblog`.`posts` LIMIT 0, 1000; SHOW CREATE TABLE `posts`; ALTER TABLE `posts` CHANGE COLUMN `id` `id` INT(8) NOT NULL AUTO_INCREMENT FIRST; SHOW TABLE STATUS FROM `fotoblog`; SHOW FUNCTION STATUS WHERE `Db`='fotoblog'; SHOW PROCEDURE STATUS WHERE `Db`='fotoblog'; SHOW TRIGGERS FROM `fotoblog`; SHOW EVENTS FROM `fotoblog`; SHOW CREATE TABLE `fotoblog`.`posts`; SHOW CREATE TABLE `fotoblog`.`comments`; SELECT `id`, `postid`, LEFT(`author`, 256), LEFT(`email`, 256), `ip`, `date` FROM `fotoblog`.`comments` LIMIT 0, 1000; SHOW CREATE TABLE `comments`; 
Комментариев нет:
Отправить комментарий