salam burda mene postu beyen/beyenme kodu lazimdi sade kodlarla bura kim uygunlasdirar?

xais pdo ile yazmayin.

likes tablem var post_id ve likes_id linyalariyla birge

<?php
require("head.php");
echo "<hr><a href=\"share.php\">Paylasim et</a><hr>";

echo "<hr><a href=\"?cokie=exit\">Cixiw et</a><hr>";
if($_GET["cokie"]=="exit"){

setcookie("login","",time()-(86400*30),"/");

setcookie("pass","",time()-(86400*30),"/");
}

$def=$db->query("select * from share");
foreach($def as $share){
echo $share["metn"]."<hr>";
echo "<img src=\"".$share["resim"]."\" alt=\"Resm\" width=\"240\" height=\"180\"><hr>";
echo "Paylasim vaxti: {$share["date"]}<hr>";
$id=$share["kim_id"];
$kimdi=$db->query("select * from users where id='$id'")->fetch_assoc();

echo "Paylasdi: {$kimdi["login"]}<hr>";

$count=$db->query("select * from share where id='{$share["id"]}'")->num_rows;
//print_r($count);

echo "<br><a href=\"beyen.php?id={$share["id"]}&kim={$share["kim_id"]}\">Beyen</a>({$count})<hr>";
}




?>

Shukur_23 said:

salam burda mene postu beyen/beyenme kodu lazimdi sade kodlarla bura kim uygunlasdirar?

xais pdo ile yazmayin.

likes tablem var post_id ve likes_id linyalariyla birge

<?php
require("head.php");
echo "<hr><a href=\"share.php\">Paylasim et</a><hr>";

echo "<hr><a href=\"?cokie=exit\">Cixiw et</a><hr>";
if($_GET["cokie"]=="exit"){

setcookie("login","",time()-(86400*30),"/");

setcookie("pass","",time()-(86400*30),"/");
}

$def=$db->query("select * from share");
foreach($def as $share){
echo $share["metn"]."<hr>";
echo "<img src=\"".$share["resim"]."\" alt=\"Resm\" width=\"240\" height=\"180\"><hr>";
echo "Paylasim vaxti: {$share["date"]}<hr>";
$id=$share["kim_id"];
$kimdi=$db->query("select * from users where id='$id'")->fetch_assoc();

echo "Paylasdi: {$kimdi["login"]}<hr>";

$count=$db->query("select * from share where id='{$share["id"]}'")->num_rows;
//print_r($count);

echo "<br><a href=\"beyen.php?id={$share["id"]}&kim={$share["kim_id"]}\">Beyen</a>({$count})<hr>";
}




?>

Genişləndirmək üçün klikləyin...

Shukur_23 said:

salam burda mene postu beyen/beyenme kodu lazimdi sade kodlarla bura kim uygunlasdirar?

xais pdo ile yazmayin.

likes tablem var post_id ve likes_id linyalariyla birge

<?php
require("head.php");
echo "<hr><a href=\"share.php\">Paylasim et</a><hr>";

echo "<hr><a href=\"?cokie=exit\">Cixiw et</a><hr>";
if($_GET["cokie"]=="exit"){

setcookie("login","",time()-(86400*30),"/");

setcookie("pass","",time()-(86400*30),"/");
}

$def=$db->query("select * from share");
foreach($def as $share){
echo $share["metn"]."<hr>";
echo "<img src=\"".$share["resim"]."\" alt=\"Resm\" width=\"240\" height=\"180\"><hr>";
echo "Paylasim vaxti: {$share["date"]}<hr>";
$id=$share["kim_id"];
$kimdi=$db->query("select * from users where id='$id'")->fetch_assoc();

echo "Paylasdi: {$kimdi["login"]}<hr>";

$count=$db->query("select * from share where id='{$share["id"]}'")->num_rows;
//print_r($count);

echo "<br><a href=\"beyen.php?id={$share["id"]}&kim={$share["kim_id"]}\">Beyen</a>({$count})<hr>";
}




?>

Genişləndirmək üçün klikləyin...

Aşağıda yazdığım kodlama daha işinə yarar
SQL də vote içində
person_id, voter, vote_up, vote_down, votedate, vote_ip
yaratmağı unutma




if($_GET["vote"] && $_SESSION["uin_id"]>0)
else
{
if($_GET["vote"]=="up" || $_GET["vote"]=="down")
{
$have_vote=mysql_fetch_array(mysql_query("SELECT * FROM vote WHERE person_id='".$db["id"]."' and voter='".$_SESSION["uin_id"]."'"));
if(!$have_vote)
{
mysql_query("INSERT INTO vote (person_id, voter, vote_up, vote_down, votedate, vote_ip) VALUES ('".$db["id"]."', '".$_SESSION["uin_id"]."', '".($_GET["vote"]=="up"?1:0)."', '".($_GET["vote"]=="down"?1:0)."', '".time()."', '".$_SERVER['REMOTE_ADDR']."')");
$msg="++.";
}
else
{
$msg="--";
}
}
else
{
$msg="--";
}
}
}
$vote_result=mysql_fetch_array(mysql_query("SELECT sum(`vote_up`), sum(`vote_down`) FROM `vote` WHERE `person_id`='".$db["id"]."'"));
else
{
if($_GET["vote"]=="up" || $_GET["vote"]=="down")
{
$have_vote=mysql_fetch_array(mysql_query("SELECT * FROM vote WHERE person_id='".$db["id"]."' and voter='".$_SESSION["uin_id"]."'"));
if(!$have_vote)
{
mysql_query("INSERT INTO vote (person_id, voter, vote_up, vote_down, votedate, vote_ip) VALUES
('".$db["id"]."', '".$_SESSION["uin_id"]."', '".($_GET["vote"]=="up"?1:0)."', '".($_GET["vote"]=="down"?1:0)."', '".time()."',
'".$_SERVER['REMOTE_ADDR']."')");
$msg="++.";
}
else
{
$msg="--";
}
}
else
{
$msg="++";
}
}
}
$vote_result=mysql_fetch_array(mysql_query("SELECT sum(`vote_up`), sum(`vote_down`) FROM `vote` WHERE `person_id`='".$db["id"]."'"));