|
|
|
เรียก id จาก page echo ค่าออกมาแล้วขึ้นแต่บันทึกไม่ขึ้นช่วยดูทีครับเหมือนมี fuction มันติดๆขัดๆ |
|
|
|
|
|
|
|
Code (PHP)
<?php
include('dbcon.php');
function checkValues($value)
{
$value = trim($value);
if (get_magic_quotes_gpc()) {
$value = stripslashes($value);
}
$value = strtr($value,array_flip(get_html_translation_table(HTML_ENTITIES)));
$value = strip_tags($value);
$value = mysql_real_escape_string($value);
$value = htmlspecialchars ($value);
return $value;
}
function clickable_link($text = '')
{
$text = preg_replace('#(script|about|applet|activex|chrome):#is', "\\1:", $text);
$ret = ' ' . $text;
$ret = preg_replace("#(^|[\n ])([\w]+?://[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"\\2\" target=\"_blank\">\\2</a>", $ret);
$ret = preg_replace("#(^|[\n ])((www|ftp)\.[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"http://\\2\" target=\"_blank\">\\2</a>", $ret);
$ret = preg_replace("#(^|[\n ])([a-z0-9&\-_.]+?)@([\w\-]+\.([\w\-\.]+\.)*[\w]+)#i", "\\1<a href=\"mailto:\\2@\\3\">\\2@\\3</a>", $ret);
$ret = substr($ret, 1);
return $ret;
}
$next_records = 10;
$show_more_button = 0;
if(checkValues($_REQUEST['value']))
{
$pageid = $REQUEST['p_id'];
$userip = $_SERVER['REMOTE_ADDR'];
echo "INSERT INTO facebook_posts (post,f_name,userip,date_created) VALUES('".checkValues($_REQUEST['value'])."','wowball','".$userip."','".strtotime(date("Y-m-d H:i:s"))."','".$userip."')";
mysql_query("INSERT
INTO facebook_posts (post,f_name,userip,date_created,f_idpage) VALUES ('".checkValues($_REQUEST['value'])."','wowball','".$userip."','".strtotime(date("Y-m-d H:i:s"))."','".$pageid."')");
$result = mysql_query("SELECT *,
UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit 1");
}
elseif($_REQUEST['show_more_post']) // more posting paging
{
$next_records = $_REQUEST['show_more_post'] + 10;
$result = mysql_query("SELECT *,
UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit ".$_REQUEST['show_more_post'].", 10");
$check_res = mysql_query("SELECT * FROM facebook_posts order by p_id desc limit ".$next_records.", 10");
$show_more_button = 0; // button in the end
$check_result = mysql_num_rows(@$check_res);
if($check_result > 0)
{
$show_more_button = 1;
}
}
else
{
$show_more_button = 1;
$result = mysql_query("SELECT *,
UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit 0,10");
}
while ($row = mysql_fetch_array($result))
{
$comments = mysql_query("SELECT *,
UNIX_TIMESTAMP() - date_created AS CommentTimeSpent FROM facebook_posts_comments where post_id = ".$row['p_id']." order by c_id asc"); ?>
<div class="friends_area" id="record-<?php echo $row['p_id']?>">
<img src="99.jpeg" style="float:left;" alt="" />
<label style="float:left" class="name">
<b><?php echo $row['f_name'];?></b>
<em><?php echo clickable_link($row['post']);?></em>
<br clear="all" />
<span>
<?php
// echo strtotime($row['date_created'],"Y-m-d H:i:s");
$days = floor($row['TimeSpent'] / (60 * 60 * 24));
$remainder = $row['TimeSpent'] % (60 * 60 * 24);
$hours = floor($remainder / (60 * 60));
$remainder = $remainder % (60 * 60);
$minutes = floor($remainder / 60);
$seconds = $remainder % 60;
if($days > 0)
echo date('F d Y', $row['date_created']);
elseif($days == 0 && $hours == 0 && $minutes == 0)
echo "few seconds ago";
elseif($days == 0 && $hours == 0)
echo $minutes.' minutes ago';
else
echo "few seconds ago";
?>
</span>
<a href="javascript: void(0)" id="post_id<?php echo $row['p_id']?>" class="showCommentBox">Comments</a>
</label>
<?php
$userip = $_SERVER['REMOTE_ADDR'];
if($row['userip'] == $userip){?>
<a href="#" class="delete"> Remove</a>
<?php
}?>
<br clear="all" />
<div id="CommentPosted<?php echo $row['p_id']?>">
<?php
$comment_num_row = mysql_num_rows(@$comments);
if($comment_num_row > 0)
{
while ($rows = mysql_fetch_array($comments))
{
$days2 = floor($rows['CommentTimeSpent'] / (60 * 60 * 24));
$remainder = $rows['CommentTimeSpent'] % (60 * 60 * 24);
$hours = floor($remainder / (60 * 60));
$remainder = $remainder % (60 * 60);
$minutes = floor($remainder / 60);
$seconds = $remainder % 60;
?>
<div class="commentPanel" id="record-<?php echo $rows['c_id'];?>" align="left">
<img src="small.png" width="40" class="CommentImg" style="float:left;" alt="" />
<label class="postedComments">
<?php echo clickable_link($rows['comments']);?>
</label>
<br clear="all" />
<span style="margin-left:43px; color:#666666; font-size:11px">
<?php
if($days2 > 0)
echo date('F d Y', $rows['date_created']);
elseif($days2 == 0 && $hours == 0 && $minutes == 0)
echo "few seconds ago";
elseif($days2 == 0 && $hours == 0)
echo $minutes.' minutes ago';
else
echo "few seconds ago";
?>
</span>
<?php
$userip = $_SERVER['REMOTE_ADDR'];
if($rows['userip'] == $userip){?>
<a href="#" id="CID-<?php echo $rows['c_id'];?>" class="c_delete">Delete</a>
<?php
}?>
</div>
<?php
}?>
<?php
}?>
</div>
<div class="commentBox" align="right" id="commentBox-<?php echo $row['p_id'];?>" <?php echo (($comment_num_row) ? '' :'style="display:none"')?>>
<img src="small.png" width="40" class="CommentImg" style="float:left;" alt="" />
<label id="record-<?php echo $row['p_id'];?>">
<textarea class="commentMark" id="commentMark-<?php echo $row['p_id'];?>" name="commentMark" cols="60"></textarea>
</label>
<br clear="all" />
<a id="SubmitComment" class="small button comment"> Comment</a>
<br clear="all" />
</div>
</div>
<?php
}
if($show_more_button == 1){?>
<div id="bottomMoreButton">
<a id="more_<?php echo @$next_records?>" class="more_records" href="javascript: void(0)">Older Posts</a>
</div>
<?php
}?>
ลอง echo ค่า $pageid = $REQUEST['p_id']; มันก็แสดง
Tag : PHP
|
|
|
|
|
|
Date :
2012-07-02 19:05:04 |
By :
hixor |
View :
1010 |
Reply :
4 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
เยอะขนาดนี้ดูยากน่ะครับ
|
|
|
|
|
Date :
2012-07-02 22:33:25 |
By :
mr.win |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ขอเรียก No.1 พี่วินละกันนะครับ
เห็นด้วยที่สุด ตัดเอาเฉพาะที่ ข้องใจได้ป่ะคับ ดูย๊ากยาก
|
|
|
|
|
Date :
2012-07-02 22:51:10 |
By :
osiris2k |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ลองเช็คดูตรงนี้นะครับ ผมเห็นมัน insert 2 รอบ และเป็น table เดียวกัน ผมไม่รู้ว่าคุณต้องการให้มัน insert 2 รอบหรือว่าคุณลืมเอาออก
และอีกอย่างครับ fild ใน table facebook_posts ประการศไว้ 4 แต่ค่าที่ต้องการ insert มีอยู่ 5 ตรวจดูครับ
Code (PHP)
echo "INSERT INTO facebook_posts (post,f_name,userip,date_created) VALUES('".checkValues($_REQUEST['value'])."','wowball','".$userip."','".strtotime(date("Y-m-d H:i:s"))."','".$userip."')";
mysql_query("INSERT
INTO facebook_posts (post,f_name,userip,date_created,f_idpage) VALUES ('".checkValues($_REQUEST['value'])."','wowball','".$userip."','".strtotime(date("Y-m-d H:i:s"))."','".$pageid."')");
|
|
|
|
|
Date :
2012-07-03 05:55:54 |
By :
000su000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
echo คือแสดงค่าเฉยๆอะครับไม่ได้เก็บเข้าฐานข้อมูล
Code (PHP)
if(checkValues($_REQUEST['value']))
{
$pageid = $REQUEST['p_id']; // ตรงนี้มันไม่มีค่าออกมาแต่ถ้าไว้ในส่วนอื่นก็จะมีค่าออกมา
$userip = $_SERVER['REMOTE_ADDR'];
echo "INSERT INTO facebook_posts (post,f_name,userip,date_created) VALUES('".checkValues($_REQUEST['value'])."','wowball','".$userip."','".strtotime(date("Y-m-d H:i:s"))."','".$userip."')";
mysql_query("INSERT
INTO facebook_posts (post,f_name,userip,date_created,f_idpage) VALUES ('".checkValues($_REQUEST['value'])."','wowball','".$userip."','".strtotime(date("Y-m-d H:i:s"))."','".$pageid."')");
$result = mysql_query("SELECT *,
UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit 1");
}
|
|
|
|
|
Date :
2012-07-03 07:09:07 |
By :
hixor |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 02
|