พี่ninenik ครับช่วยหน่วย พ่อดีผมเขียนระบบ Comments แต่มันไม่อ่านภาสาลาว

ถาม-ตอบ แนะนำไอเดียว โค้ดตัวอย่าง แนวทาง วิธีแก้ปัญหา พี่ninenik ครับช่วยหน่วย พ่อดีผมเขียนระบบ Comments แต่มันไม่อ่านภาสาลาว

พี่ninenik ครับช่วยหน่วย พ่อดีผมเขียนระบบ Comments แต่มันไม่อ่านภาสาลาว
พี่ninenik ครับช่วยหน่วย พ่อดีผมเขียนระบบ Comments แต่มันไม่อ่านภาสาลาว ผมเป็นคนลาวครับแต่ผม เรืยนที่ประเทดไทย ผมมีปันหาเลื่อง PHP มันไม่อ่านพาสาลาว พี่ พี่ช่วยที ขอบคุณครับ.......
<br>
vasplus_programming_blog_PHP.php
<br>
<!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>Untitled Document</title>
</head>
 
<body>
<?php
/********************************************************************************
* Comment System Version 4.0
* Written by Vasplus Programming Blog
* Website: www.vasplus.info
*
*********************************Copyright Info***********************************
* This script must not be sold or 
* use for commercial purpose without the consent of Vasplus Programming Blog
* Please do not remove this copyright information from the top of this page
* All Copy Rights Reserved by Vasplus Programming Blog
***********************************************************************************/
 
 
include "config.php"; //Include the database connection settings file
 
//This function will UPPERCASE the first letters of users fullnames 
function vpb_format_users_fullnames($vpb_fullnames=NULL) 
{
/* Formats a first or last name, and returns the formatted version */
if (empty($vpb_fullnames))
return false;
 
// Run through and uppercase any multi-barrelled name
 
for ($i = 0; $i < count($vpb_fullnamess_array); $i++) 
{
// "McDonald", "O'Conner"..
if (strncmp($vpb_fullnamess_array[$i],'mc',2) == 0 || preg_match('/^[oO]'[a-zA-Z]/',$vpb_fullnamess_array[$i]))  
{
$vpb_fullnamess_array[$i][2];
}
// Always set the first letter to uppercase, no matter what
$vpb_fullnamess_array[$i];
}
// Piece the names back together
 
// Return upper-casing on all missed (but required) elements of the $vpb_fullnames var
return utf8_encode($vpb_fullnames);
}
 
//This function is responsible for date/time formatting
function vpb_time_commented( $timestamp )
{
    if( !is_numeric( $timestamp ) ) {
        $timestamp = strtotime( $timestamp );
        if( !is_numeric( $timestamp ) )
{
            return "";
        }
    }
    $difference = time() - $timestamp;
    $periods = array( "second", "minute", "hour", "day", "week", "month", "years", "decade" );
    $lengths = array( "60","60","24","7","4.35","12","10");
    if ($difference > 0) {
// this was in the past
        $ending = "ago";
    }
else {
// this was in the future
        $difference = -$difference;
        $ending = "to go";
    }
    for( $j=0; $difference>=$lengths[$j] and $j < 7; $j++ )
        $difference /= $lengths[$j];
    $difference = round($difference);
    if( $difference != 1 ) {
        // Also change this if needed for an other language
        $periods[$j].= "s";
    }
    $vpb_Text = "$difference $periods[$j] $ending";
    return $vpb_Text;
}
 
//This function formats all URLs in a comment
function vpb_add_link_to_urls($vpb_Text = '')
{
$vpb_Text = preg_replace('#(script|about|applet|activex|chrome):#is', "1:", $vpb_Text);
$vpb_replacements = ' ' . $vpb_Text;
$vpb_replacements = preg_replace("#(^|[ ])([w]+?://[w#$%&~/.-;:=,?@[]+]*)#is", "1<span class='ccc'><a href="2" target="_blank"><font style='font-family: Verdana, Geneva, sans-serif;color: blue;font-size:11px; line-height:20px;'>2</font></a></span>", $vpb_replacements);
$vpb_replacements = preg_replace("#(^|[ ])((www|ftp).[w#$%&~/.-;:=,?@[]+]*)#is", "1<span class='ccc'><a href="http://2" target="_blank"><font style='font-family: Verdana, Geneva, sans-serif;color: blue;font-size:11px; line-height:20px;'>2</font></a></span>", $vpb_replacements);
$vpb_replacements = preg_replace("#(^|[ ])([a-z0-9&-_.]+?)@([w-]+.([w-.]+.)*[w]+)#i", "1<span class='ccc'><a href="mailto:2@3"><font style='font-family: Verdana, Geneva, sans-serif;color: blue;font-size:11px; line-height:20px;'>2@3</font></a></span>", $vpb_replacements);
$vpb_replacements = substr($vpb_replacements, 1);
return $vpb_replacements;
}
 
if(isset($_POST["page"]) && !empty($_POST["page"])) //Page Validation
{
//Post Comment Page Starts from here
if($_POST["page"] == "postComment")
{
$vpb_posted_comment = trim($_POST["posted_comment"]);
 
if(isset($_POST["fullname_id"]) && !empty($_POST["fullname_id"]) && $_POST["fullname_id"] != "Fullname" && isset($_POST["email_id"]) && !empty($_POST["email_id"]) && $_POST["email_id"] != "Email Address" && isset($_POST["posted_comment"]) && !empty($vpb_posted_comment) && isset($_POST["page_url"]) && !empty($_POST["page_url"]))
{
$fullname_id = $_POST["fullname_id"];
$email_id = strip_tags($_POST["email_id"]);
$page_url = $_POST["page_url"];
 
$query = strip_tags(htmlspecialchars($_POST['posted_comment']));
function no_magic_quotes($query) 
{
$data = explode("",$query);
$cleaned = implode("",$data);
return $cleaned;
}
 
mysql_query("insert into `comment_system_by_vasplus_programming_blog` values('', '".mysql_real_escape_string($fullname_id)."', '".mysql_real_escape_string($email_id)."', '".mysql_real_escape_string(no_magic_quotes($query))."', '".mysql_real_escape_string($page_url)."', '".mysql_real_escape_string(strip_tags(strtotime(date("Y-m-d H:i:s"))))."')");
 
$checkLastInsertedComment = mysql_query("select * from `comment_system_by_vasplus_programming_blog` where `email` = '".mysql_real_escape_string(strip_tags($_POST["email_id"]))."' order by `id` desc limit 1");
 
$getLastInsertedComment = mysql_fetch_array($checkLastInsertedComment);
?>
            
<div class="vpb_commentWrapper" id="comment_<?php echo strip_tags($getLastInsertedComment["id"]); ?>">
            <vasplus_programming_blog_wrap_contents>
            <center><div style="width:450px;" align="center" id="deleting_comment_<?php echo strip_tags($getLastInsertedComment["id"]); ?>"></div></center>
            <br clear="all">
               
            <div style="width:430px;float:left;" align="left">
            <b style="color:#400080; cursor:pointer; font-family:'Saysettha OT'; font-size:12px;"><?php echo vpb_format_users_fullnames(strip_tags($getLastInsertedComment["fullname"])); ?></b>
            </div>
            
            <div style="width:60px;float:right; font-family:'Saysettha OT';" align="right">
            <?php if(isset($_COOKIE["email_id"])) { ?>
            <span id="deletion_button" class="ccc"><a style="" href="javascript:void(0);" onclick="deleteThisComment(<?php echo strip_tags($get_more_comments["id"]); ?>);"><font face="Saysettha OT"><img src="remove.png" alt="" width="17" title="ລົບ/Delete" height="17" border="0" /></font></a><a style="" href="javascript:void(0);" onClick="deleteThisComment(<?php echo strip_tags($getLastInsertedComment["id"]); ?>);"></a></span>
            <?php } else { } ?>
            </div>
            <br clear="all">
            
            <div style="width:490px;float:left; padding-top:5px; font-family:'Saysettha OT'; font-size:12px;" align="left">
            <?php echo vpb_add_link_to_urls(nl2br(strip_tags($getLastInsertedComment["comment"]))); ?>
            </div>
            <br clear="all">
            
            <div style="width:490px;float:right; padding-top:5px;" align="right">
            <span style="font-family:Arial,Helvetica,sans-serif;font-size:11px;color:#999;" title="<?php echo date("l jS of F Y h:i:s a", strip_tags($getLastInsertedComment["date"])); ?>">
            <?php echo strip_tags(stripslashes(vpb_time_commented($getLastInsertedComment["date"]))); ?>
            </span>
            </div>
            <br clear="all">
            <br clear="all">
            </vasplus_programming_blog_wrap_contents>
            </div>
<?php
 
}
else
{
echo '<font style="font-size:0px;">errormessage</font>';
echo "<div class='info'><font face='Saysettha OT' color=red>Sorry, the comment could not be posted at the moment.<br>Please be sure that the comment box is not empty and try again or contact this website admin to report this error message if the problem persist (1). Thanks.</font></div>";
}
}
//Post Comment Page Ends here
 
 
//Load More Comment Page Starts from here
elseif($_POST["page"] == "load_more_comments")
{
if(isset($_POST["last_loaded_id"]) && !empty($_POST["last_loaded_id"]) && isset($_POST["page_url"]) && !empty($_POST["page_url"]))
{
$last_loaded_id = strip_tags($_POST["last_loaded_id"]);
$page_url = $_POST["page_url"];
 
$check_for_more_comments = mysql_query("select * from `comment_system_by_vasplus_programming_blog` where `id` > '".mysql_real_escape_string($last_loaded_id)."' and `page_url` = '".mysql_real_escape_string($page_url)."' order by `id` asc limit 5");
 
//Check for the name of the admin for comment moderation purpose
$check_for_admin_name = mysql_query("select * from `comment_system_moderation_by_vasplus_programming_blog` order by `id` asc limit 1");
$getr_admin_name = mysql_fetch_array($check_for_admin_name);
 
 
if(mysql_num_rows($check_for_more_comments) > 0)
{
while($get_more_comments = mysql_fetch_array($check_for_more_comments))
{
$last_loaded_id = strip_tags($get_more_comments["id"]);
?>
<div class="vpb_commentWrapper" id="comment_<?php echo strip_tags($get_more_comments["id"]); ?>">
<vasplus_programming_blog_wrap_contents>
<center><div style="width:450px;" align="center" id="deleting_comment_<?php echo strip_tags($get_more_comments["id"]); ?>"></div></center>
<br clear="all">
  
<div style="width:430px;float:left; font-family:'Saysettha OT'; font-size:12px;" align="left">
<b style="color:#400080; cursor:pointer;"><?php echo vpb_format_users_fullnames($get_more_comments["fullname"]); ?></b>
</div>
 
<div style="width:60px;float:right;" align="right">
<?php if(isset($_COOKIE["email_id"]) && $_COOKIE["email_id"] == strip_tags($get_more_comments["email"]) || $_COOKIE["email_id"] == strip_tags($getr_admin_name["admin_email_address"])) { ?>
<span id="deletion_button" class="ccc"><a style="" href="javascript:void(0);" onClick="deleteThisComment(<?php echo strip_tags($get_more_comments["id"]); ?>);"><font face="Saysettha OT"><img src="remove.png" width="17" title="ລົບ/Delete"  height="17" border="0" /></font></a></span>
<?php } else { } ?>
</div>
<br clear="all">
 
<div style="width:490px;float:left; font-family:'Saysettha OT'; font-size:12px; padding-top:5px;" align="left">
<?php echo vpb_add_link_to_urls(nl2br(strip_tags($get_more_comments["comment"]))); ?>
</div>
<br clear="all">
 
<div style="width:490px;float:right; padding-top:5px;" align="right">
<span style="font-family:Arial,Helvetica,sans-serif;font-size:11px;color:#999;" title="<?php echo date("l jS of F Y h:i:s a", strip_tags($get_more_comments["date"])); ?>">
<?php echo strip_tags(stripslashes(vpb_time_commented($get_more_comments["date"]))); ?>
</span>
</div>
<br clear="all">
<br clear="all">
</vasplus_programming_blog_wrap_contents>
</div>
<?php
}
//Do final checking for the load more button to see if it should be hiden now or not
$check_for_more_comments_again = mysql_query("select * from `comment_system_by_vasplus_programming_blog` where `id` > '".mysql_real_escape_string($last_loaded_id)."' and `page_url` = '".mysql_real_escape_string($page_url)."' order by `id` asc limit 5");
if(mysql_num_rows($check_for_more_comments_again) < 1)
{
?>
                     <div class="vpb_show_more_or_the_ends" align="center"><center><font style="font-family:Saysettha OT; font-size:12px; color:gray;">ບໍ່ມີຄວາມຄິດເຫັນຕໍ່ໄປແລ້ວ.</font></center></div>
                     
                     <script type="text/javascript">$(document).ready(function(){ $("#vpb_more_button").remove(); });</script>
                     <br clear="all" />
                     <?php
}
else {}
?>
        <script type="text/javascript"> $(document).ready(function(){ $("#last_displayed_comment_id").val(parseInt('<?php echo $last_loaded_id; ?>'));  }); </script>
        <?php
}
else
{
?>
                 <div class="vpb_show_more_or_the_ends" align="center"><center><font style="font-family:Saysettha OT; font-size:12px; color:gray;">ບໍ່ມີຄວາມຄິດເຫັນຕໍ່ໄປແລ້ວ.</font></center></div>
                 
                 <script type="text/javascript">$(document).ready(function(){ $("#vpb_more_button").remove(); });</script>
                 <br clear="all" />
                 <?php
                 exit;
}
}
else
{
echo '<font style="font-size:0px;">errormessage</font>';
echo "<div class='info'>Sorry, the operation you were trying to perform could not be completed at the moment.<br>Please try again or contact this website admin to report this error message if the problem persist (2). Thanks.</div>";
}
}
//Load More Comment Page Ends here
 
 //Comment Deletion Page Starts from here
elseif($_POST["page"] == "deleteComment")
{
mysql_query("delete from `comment_system_by_vasplus_programming_blog` where `id` = '".mysql_real_escape_string(strip_tags($_POST["comment_id"]))."'");
if(!empty($_POST["page_url"]))
{
$check_if_there_are_still_comments_for_this_page = mysql_query("select * from `comment_system_by_vasplus_programming_blog` where `page_url` = '".mysql_real_escape_string($_POST["page_url"])."'");
 
if(mysql_num_rows($check_if_there_are_still_comments_for_this_page) < 1)
{
echo '<div id="default_no_comments" class="info"><font face="Saysettha OT" font size="2">ບໍ່ມີຄວາມຄິດເຫັນຢູ່ໃນໜ້ານີ້....Thanks!.</font></div>';
}
else
{
//Do not show any message since there are still comments on the specified page
}
}
}
//Comment Deletion Page Ends here
else
{
echo '<font style="font-size:0px;">errormessage</font>';
echo "<div class='info'>Sorry, the operation you were trying to perform could not be completed at the moment.<br>Please try again or contact this website admin to report this error message if the problem persist (2). Thanks.</div>";
}
}
else
{
echo '<font style="font-size:0px;">errormessage</font>';
echo "<div class='info'>Sorry, the operation you were trying to perform could not be completed at the moment.<br>Please try again or contact this website admin to report this error message if the problem persist (3). Thanks.</div>";
}
?>
</body>
</html>
 


Fong Vang 202.137.157.xxx 01-09-2014 17:39:36

คำแนะนำ และการใช้งาน

สมาชิก กรุณา ล็อกอินเข้าระบบ เพื่อตั้งคำถามใหม่ หรือ ตอบคำถาม สมาชิกใหม่ สมัครสมาชิกได้ที่ สมัครสมาชิก


  • ถาม-ตอบ กรุณา ล็อกอินเข้าระบบ
  • เปลี่ยน


    ( หรือ เข้าใช้งานผ่าน Social Login )

 ความคิดเห็นที่ 1
ไม่แน่ใจคำถามว่า ไม่อ่านข้อมูล หมายถึงอะไร

ถ้าหมายถึง ไม่แสดงข้อมูลจากฐานข้อมูลที่บันทึก อันนี้ต้องไปดูว่า ฐานข้อมูลเราใช้ เป็นแบบไหน แนะนำให้เก็บเป็น 
utf8 Unicode 

คือ พยายามให้ทุกๆอย่างเป็น utf8 ทั้ง ฐานข้อมูล 
การ encoding ไฟล์ php
meta ใน head ของแท็ก html

คร่าวๆ ก็ประมาณนี้ ต้องลองไล่ดู


ninenik 1.47.19.xxx 01-09-2014






เว็บไซต์ของเราให้บริการเนื้อหาบทความสำหรับนักพัฒนา โดยพึ่งพารายได้เล็กน้อยจากการแสดงโฆษณา โปรดสนับสนุนเว็บไซต์ของเราด้วยการปิดการใช้งานตัวปิดกั้นโฆษณา (Disable Ads Blocker) ขอบคุณครับ