alguem pode me ensinar como criar codigo de post, partilha e like

capango · Fevereiro 3, 2018

este é o add.php

<?php
session_start();
include_once("functions.php");
include_once('conecta.php');

$userid = $_SESSION['userid'];
$body = substr($_POST['body'],0,140);

add_post($userid,$body);
$_SESSION['message'] = "o teu post foi adicionado!";

header("Location:index.php");
?>

este é cadastro.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Cadastro de usuário</title>
</head>

<body>
<h1>Cadastro de Usuário</h1>
<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="post" enctype="multipart/form-data" name="cadastro" >
Nome:<br />
<input type="text" name="nome" /><br /><br />
Email:<br />
<input type="text" name="email" /><br /><br />
Foto de exibição:<br />
<input type="file" name="foto" /><br /><br />
<input type="submit" name="cadastrar" value="Cadastrar" />
</form>
</body>
</html>

este é conecta.php

<?php
$conexao = mysqli_connect('localhost', 'root', '', 'loja');
?>

este é a função.php

<?php
function add_post($userid,$body){
$sql = "insert into posts (user_id, body, stamp)
values ($userid, '". mysql_real_escape_string($body). "',now())";

$result = mysql_query($sql);
}

function show_posts($userid,$limit=0){
$posts = array();
$user_string = implode(',', $userid);
$extra = " and id in ($user_string)";

if ($limit > 0){
$extra = "limit $limit";
}else{
$extra = '';
}

$sql = "select user_id, body, stamp from posts
where user_id in ($user_string)
order by stamp desc $extra";
echo $sql;
$result = mysql_query($sql);

while($data = mysql_fetch_object($result)){
$posts[] = array( 'stamp' => $data->stamp,
'userid' => $data->user_id,
'body' => $data->body
);
}
return $posts;

}

// esta funçaõ mostra todos os usuarios do sistema

// esta funçaõ fara o usuario deixar de seguir
function following($userid){
$users = array();

$sql = "select distinct user_id from following
where follower_id = '$userid'";
$result = mysql_query($sql);

while($data = mysql_fetch_object($result)){
array_push($users, $data->user_id);

}

return $users;

}
// esta funçaõ fara a verificaçaõ se ha relacionamento nesta tabela seguir ou deixar de segui

function check_count($first, $second){
$sql = "select count(*) from following
where user_id='$second' and follower_id='$first'";
$result = mysql_query($sql);

$row = mysql_fetch_row($result);
return $row[0];

}

function follow_user($me,$them){
$count = check_count($me,$them);

if ($count == 0){
$sql = "insert into following (user_id, follower_id)
values ($them,$me)";

$result = mysql_query($sql);
}
}

function unfollow_user($me,$them){
$count = check_count($me,$them);

if ($count != 0){
$sql = "delete from following
where user_id='$them' and follower_id='$me'
limit 1";

$result = mysql_query($sql);
}
}

// esta funçaõ exibir uma lista de outros usuários que o usuário está
//seguindo na página inicial. Já existe uma função show_users() , mas isso mostra todos os usuários.

?>

funçao.php

<?php
$SERVER = 'localhost';
$USER = 'root';
$PASS = '';
$DATABASE = 'loja';

if (!($mylink = mysql_connect( $SERVER, $USER, $PASS))){
echo "<h3>Sorry, could not connect to database.</h3><br/>
Please contact your system's admin for more help\n";
exit;
}

index.php

<?php
session_start();

include_once('functions.php');
include_once('conecta.php');

$_SESSION['userid'] = 1;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Postes Listit</title>
</head>
<body>
<p><a href='users.php'>Veja a lista de usuarios</a></p>

<?php
if (isset($_SESSION['message'])){
echo "<b>". $_SESSION['message']."</b>";
unset($_SESSION['message']);
}
?>
<form method='post' action='add.php'>
<p>Your status:</p>
<textarea name='body' rows='5' cols='40' wrap=VIRTUAL></textarea>
<p><input type='submit' value='submit'/></p>
</form>

<?php
$posts = show_posts($_SESSION['userid']);

if (count($posts)){
?>
<table border='1' cellspacing='0' cellpadding='5' width='500'>
<?php
foreach ($posts as $key => $list){
echo "<tr valign='top'>\n";
echo "<td>".$list['userid'] ."</td>\n";
echo "<td>".$list['body'] ."<br/>\n";
echo "<small>".$list['stamp'] ."</small></td>\n";
echo "</tr>\n";
}
?>
</table>
<?php
}else{
?>
<p><b>Ainda não postaste nada!</b></p>
<?php
}
?>

<h2>Users you're following</h2>

<?php
$users = show_users($_SESSION['userid']);

if (count($users)){
?>
<ul>
<?php
foreach ($users as $key => $value){
echo "<li>".$value."</li>\n";
}
?>
</ul>
<?php
}else{
?>
<p><b>nao esta seguindo ninguem!</b></p>
<?php
}
?>

</body>
</html>

user.php

<?php
session_start();
include_once("header.php");
include_once("functions.php");

?>

<body>

<h1>List of Users</h1>
<?php
$users = show_users();
$following = following($_SESSION['userid']);

if (count($users)){
?>
<table border='1' cellspacing='0' cellpadding='5' width='500'>
<?php
foreach ($users as $key => $value){
echo "<tr valign='top'>\n";
echo "<td>".$key ."</td>\n";
echo "<td>".$value;
if (in_array($key,$following)){
echo " <small>
<a href='action.php?id=$key&do=unfollow'>unfollow</a>
</small>";
}else{
echo " <small>
<a href='action.php?id=$key&do=follow'>follow</a>
</small>";
}
echo "</td>\n";
echo "</tr>\n";
}
?>
<p><b>There are no users in the system!</b></p>
<?php
}
?>
</body>
</html>

action.php

<?php
session_start();
include_once("conecta.php");
include_once("functions.php");

$id = $_GET['id'];
$do = $_GET['do'];

switch ($do){
case "follow":
follow_user($_SESSION['userid'],$id);
$msg = "You have followed a user!";
break;

case "unfollow":
unfollow_user($_SESSION['userid'],$id);
$msg = "You have unfollowed a user!";
break;

}
$_SESSION['message'] = $msg;

header("Location:index.php");
?>

produtos_view.php

<body>

<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Celke</a>
</div>
<div id="navbar" class="navbar-collapse collapse">
<ul class="nav navbar-nav">
<li><a href="#">Home</a></li>
<li><a href="#about">About</a></li>
<li><a href="#contact">Contact</a></li>
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Dropdown <span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="#">Action</a></li>
<li><a href="#">Another action</a></li>
<li><a href="#">Something else here</a></li>
<li role="separator" class="divider"></li>
<li class="dropdown-header">Nav header</li>
<li><a href="#">Separated link</a></li>
<li><a href="#">One more separated link</a></li>
</ul>
</li>
</ul>
</div>
</div>
</nav>
<div class="container theme-showcase" role="main">
<div class="page-header">
<h1>Vitrine de produtos</h1>
</div>

<?php
require('./conf/Config.inc');
$read = new Read;
$read->ExeRead('produtos', 'LIMIT :limit', 'limit=12');

View::Load('conf/view/produtos');
?>
<div class="row"> <?php
foreach ($read->getResult() as $produto):
extract($produto);
View::Show($produto);
endforeach;
?>
</div>

</div>

produto.add.php

<!DOCTYPE html>
<html lang="pt-br">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Celke - Upload</title>

</head>
<body>
<?php
require('./conf/Config.inc');
$addinfo = filter_input_array(INPUT_POST, FILTER_DEFAULT);
if ($addinfo && $addinfo['addArquivo']):
unset($addinfo['addArquivo']);
$addinfo['imagem'] = ($_FILES['imagem']['tmp_name'] ? $_FILES['imagem'] : null);
$file = $_FILES['imagem'];

$artigo = new Produto();
$artigo->CreateProdutos($addinfo);
if (!$artigo->getResult()):
echo $artigo->getMsg();
else:
$upload = new Upload();
$upload->Imagem($file, 'produtos/'.$artigo->getResult().'/');
echo $artigo->getMsg();
endif;
endif;
?>

<form name="addArquivoForm" action="" method="post" enctype="multipart/form-data">
<label><span>Titulo</span>
<input type="text" name="titulo"/><br><br>
</label>
<label><span>Conteúdo</span>
<input type="text" name="conteudo"/><br><br>
</label>
<label><span>Imagem</span>
<input type="file" name="imagem"/><br><br>
</label>
<input type="submit" name="addArquivo" value="Cadastrar Arquivo"/>
</form>
</body>
</html>

mysql_select_db( $DATABASE );
?>

capango · Fevereiro 3, 2018

este é o DB

-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: 03-Fev-2018 às 23:06
-- Versão do servidor: 10.1.28-MariaDB
-- PHP Version: 7.1.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

/*!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 utf8mb4 */;

--
-- Database: `loja`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `following`
--

CREATE TABLE `following` (
`user_id` int(11) NOT NULL,
`follower_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `posts`
--

CREATE TABLE `posts` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`body` varchar(140) NOT NULL,
`stamp` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `users`
--

CREATE TABLE `users` (
`id` int(11) NOT NULL,
`username` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(8) NOT NULL,
`status` enum('active','inactive') NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Estrutura da tabela `usuarios`
--

CREATE TABLE `usuarios` (
`id` int(11) NOT NULL,
`nome` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`foto` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `usuarios`
--

INSERT INTO `usuarios` (`id`, `nome`, `email`, `foto`) VALUES
(8, 'faael', 'faelcalves@hotmail.com', '2dd945d3c0471656ce5f0a4bb587bcbf.jpg');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `following`
--
ALTER TABLE `following`
ADD PRIMARY KEY (`user_id`,`follower_id`);

--
-- Indexes for table `posts`
--
ALTER TABLE `posts`
ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);

--
-- Indexes for table `usuarios`
--
ALTER TABLE `usuarios`
ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `usuarios`
--
ALTER TABLE `usuarios`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Entrar

Arquivado

alguem pode me ensinar como criar codigo de post, partilha e like

Recommended Posts

capango 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

capango 0

Compartilhar este post

Link para o post

Compartilhar em outros sites

PHP+Codeigniter - Dúvida em Relação a Teclas

Conexão mysql com outro domínio

[Resolvido] JavaScript - Exibir logo dentro da Tabela html

Conteúdo Similar

Este projeto é apoiado pelas empresas

Fóruns

Tempo Real

Informação importante