Dando algum problema com o Bando de dados ou com os codigos

[Mark Augusto 0]

Gente! Esse código esta dando uma Noticia de erro, ou coisa do tipo. esta dando a seguinte mensagem em Inglês:

 

Notice: Undefined index: value in C:\wamp\www\megapli\admin-sdweb\users\facebookwallpostsystem\posts.php on line 35

 

Notice: Undefined index: show_more_post in C:\wamp\www\megapli\admin-sdweb\users\facebookwallpostsystem\posts.php on line 46

 

Bom do esses dois erros, deve ser o codigo que esta algo errado, ou o Wampserver, que deve esta com problema ou falta de acionar algum plugin do mesmo... obrigado, espero ajuda.. Vlw

 

<?php
include('../conect.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']))
{
$userip = $_SERVER['REMOTE_ADDR'];
echo "INSERT INTO facebook_posts (post,f_name,userip,date_created) VALUES('".checkValues($_REQUEST['value'])."','55Points','".$userip."','".strtotime(date("Y-m-d H:i:s"))."')";

mysql_query("INSERT INTO facebook_posts (post,f_name,userip,date_created) VALUES('".checkValues($_REQUEST['value'])."','55Points','".$userip."','".strtotime(date("Y-m-d H:i:s"))."')");

$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>
</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
}?>

[rockrgo 138]

quais são as linhas 35 e 46 ?

[Williams Duarte 431]

Notice: Undefined index: value in C:\wamp\www\megapli\admin-sdweb\users\facebookwallpostsystem\posts.php on line 35

 

Notice: Undefined index: show_more_post in C:\wamp\www\megapli\admin-sdweb\users\facebookwallpostsystem\posts.php on line 46

 

O erro é bem claro, ta falando que ela não foi definida, para isso use isset