PHP - Php Function Similar To Mysql Like?

im trying to run a query which will get posts from the database that have tags similar to the current ones.
Unfortunatly the echoed result isnt displaying as it should.


$query = $link->query("SELECT t.*, p.* 
                                FROM ".TBL_PREFIX."topics t
                                JOIN ".TBL_PREFIX."posts p
                                ON (p.p_tid = t.t_tid)
                                WHERE t.t_name = '".decode_url($_GET['t_name'])."'
                                LIMIT 1")
                                or die(print_link_error());
            $row = $query->fetch(PDO::FETCH_ASSOC);
            
            $tag_query = $link->query("SELECT p_name
                                    FROM ".TBL_PREFIX."posts
                                    WHERE MATCH (p_tags) 
                                    AGAINST ('".$row['p_tags']."' IN BOOLEAN MODE)
                                    ")or die(print_link_error());
            $result = $tag_query->fetch();
            
            foreach($result as $key => $value)
            {
                echo 'Name = '.$result[$key]['p_name'].'<br />';
            }


i have done a dump of result and it shows:

Code: [Select]
$ => Array (2)
(
    ['p_name'] = String(12) "File Updates"
    ['0'] = String(12) "File Updates"
)
but there should only be one item in this array(p_name).
I dont know where the second is coming from. The query has pulled the right results, it just isnt displaying it right.

hi My first language is not english so i hope you bear it
i am new to php am am making my shopping Cart as my web engineering course i have made everything i all want to know how to i show similar products when a user click on any product details it open new page and shows a detail of that page i want to show similar products list below to details so can any tell me how to do it plzz kindly see the pic in atttachment i have posted snap shop of my page i put similar product statically i want to show it dynamically from tha data base kindly answer please
regards

Hello,

I am looking for a push in the right direction. I would like to be able to view a website that is duplicated on many servers by specifying the IP address. Similar to how one would use the hosts file.

I can do this using netcat
nc 1.2.3.4 80
Host: example.com
GET /contact-us.html
<CR><CR>

Can someone tell me how I would go about porting this to PHP? I would just like to set up a small page on my webserver where I can enter the domain and IP address and have the page displayed back to me.

Thanks Colin

How can I check if an array contains two items that are the same?

For example ("apples", "bananas", "oranges") returns false
But ("apples", "bananas", "bananas") returns true

Hi Folks, i have been at this for ages and its now depressing me as i cannot figure out why i cant get it to work.

I am using a re-hashed version of a facebook style wall post system where it limits the amount of replies, you click a button and gets the next set and so on until there are no more results to get.
The original script runs ok but is not really suitable for what i need
So to my script which is based loosley on the same principal.

Ok i have a veiwmember.php page which uses pagination to limit the amount of wall posts to 5.
I have included the various javascript files jquery and another which is needed.

The function used is this one:

Code: [Select]
<script type="text/javascript" src="jquery.livequery.js"></script>
<script type="text/javascript" src="jquery-1.2.6.min.js"></script>

<script type="text/javascript">
//more records show
$('a.more_records').livequery("click", function(e){

var next =  $(this).attr('id').replace('more_','');

$.post("data.php?show_more_post="+next, {

}, function(response){
$('#bottomMoreButton').remove();
$('#posting').append($(response).fadeIn('slow'));

});

});

</script>

The php code in veiwmember.php that gets the wall posts is:

Code: [Select]
Pagination code here
<?php 
$getwallposts= ("SELECT * FROM wallposts WHERE recipientid='$memberid' ORDER BY id DESC LIMIT $offset, $rowsperpage");
$result = mysql_query($getwallposts,$con);
while ($row2 = mysql_fetch_assoc($result)) {
$messageid= $row2['id'];
$senderid= $row2['senderid'];
$wallpost= $row2['wallpost'];
$timesent= $row2['timesent'];
$timestamp = strtotime($timesent);
$likes= $row2['likes'];
$getname= ("SELECT fname, lname, image1 FROM memocp WHERE unid='$senderid'");
$nameresult= mysql_query($getname,$con);
while ($rowws = mysql_fetch_array($nameresult)) {
$fname= $rowws['fname'];
$lname= $rowws['lname'];
$wallpostprofilethumb= "{$rowws['image1']}";
if (empty($wallpostprofilethumb)) {$wallpostprofilethumb= "noimage.png";}
}
?>
<div class="wallpost"><div class="from"><div class"profilethumb"><img src="profilethumb/<?php echo $wallpostprofilethumb; ?>"></div><a href="veiwmember.php?membid=<?php echo "$senderid"; ?>"><?php echo "$fname $lname"; ?></a></div><div class="postbody"><?php echo txt2link($wallpost) ?><div class="timesent"><?php echo date('l jS F Y @ H:i a', $timestamp); ?></div></div><div class="likes"><form action="like.php" method="post"><?php if (isset($_GET['currentpage'])) {$currentpage= $_GET['currentpage']; echo "<input name=\"currentpage\" type=\"hidden\" value=\"$currentpage\">";} ?><input name="messageid" type="hidden" value="<?php echo "$messageid"; ?>"><input name="base" type="hidden" value="<?php echo "$memberid"; ?>"><input name="like" type="image" src="ima/like.jpg"><?php echo " $likes people like this"; ?></form></div></div>
<?php include_once('data.php'); ?>



<?php }
rest of pagination

The pagination sort of works, but only displays one result per page when it should show 5 results plus how ever many replies, but i can sort that out later, would prefer to get the replies working first.


You will see that data.php is included which gets the replies to the wall posts.
It should limit the amount of replies shown to five, and then if there is more, it will show a link to get more.
If that link is clicked it should get the next five results and show them. However it shows the first five and the link if there are more results, but if the link is clicked, nothing happens.

data.php

Code: [Select]
require ("database.php");
$next_records = 5;
$show_more_button = 0;

if(isset($_REQUEST['show_more_post'])) // more posting paging

{

   // button has been clicked so we need to get next set of results
   $next_records = $_REQUEST['show_more_post'] + 5;

   $result = mysql_query("SELECT * FROM wallreplies2 WHERE messageid='$messageid' ORDER BY wallreplyid DESC limit ".$_REQUEST['show_more_post'].", 5");

   // see if there are any more replies to get
   $check_res = mysql_query("SELECT * FROM wallreplies2 order by wallreplyid DESC limit ".$next_records.", 5");
   $show_more_button = 0; // button in the end

   $check_result = mysql_num_rows($check_res);
   if($check_result > 0)
   {
   // if there any more results counted the button needs to be shown
   $show_more_button = 1;
   }

}
// if the button hasnt been clicked we need to get the first results
else
{


   // lets count the number of results that exist
   $countreplies= mysql_query("SELECT * FROM wallreplies2 WHERE messageid='$messageid'");
   $countresult= mysql_num_rows($countreplies);


   // if there are more than 5 results
   if ($countresult > 5)
{
   // the button needs to be shown
   $show_more_button = 1;
}
   else
{
   // if there are 5 or less replies in total, dont show the button
   $show_more_button = 0;}
   //there are only 5 or less replies to get so get the first results
   $result = mysql_query("SELECT * FROM wallreplies2 WHERE messageid='$messageid' ORDER BY wallreplyid DESC limit 0,5");

}





//$replyresult = mysql_query($result,$con);
while ($roww = mysql_fetch_array($result)) {
$wallreplyid= $roww['wallreplyid'];
$sendid= $roww['senderid'];
$wallreply= $roww['wallreply'];
$time= $roww['timesent'];
$Timestamp = strtotime($time);
$like= $roww['likes'];
$getreplynames = ("SELECT fname, lname, image1 FROM memocp WHERE unid='$sendid'");
$nameresults = mysql_query($getreplynames,$con);
while ($roww = mysql_fetch_array($nameresults)) {
$fnames= $roww['fname'];
$lnames= $roww['lname'];
$wallreplyprofilethumb= "{$roww['image1']}";
if (empty($wallreplyprofilethumb)) {$wallreplyprofilethumb= "noimage.png";}
}
?>
<div class="wallreplies" id="record-<?php echo"$wallreplyid"; ?>">
<div class="wallreplywrap">
<div class="wallfrom">
<div class"profilethumb"><img src="profilethumb/<?php echo $wallreplyprofilethumb; ?>"></div>
<a href="veiwmember.php?membid=<?php echo "$sendid"; ?>"><?php echo"$fnames $lnames"; ?></a>
</div>
<div class="wallmessbody"><?php echo txt2link($wallreply) ?></div>
<div class="timesent"><?php echo date('l jS F Y @ H:i a', $Timestamp); ?></div>
<div class="likes"><form action="like2.php" method="post"><?php if (isset($_GET['currentpage'])) {$currentpage= $_GET['currentpage']; echo "<input name=\"currentpage\" type=\"hidden\" value=\"$currentpage\">";} ?><input name="messageid" type="hidden" value="<?php echo "$wallreplyid"; ?>"><input name="base" type="hidden" value="<?php echo "$memberid"; ?>"><input name="like" type="image" src="ima/like2.jpg"><?php echo " $like people like this"; ?></form>
</div>
</div>
</div>
<?php }
if($show_more_button == 1){
echo "<div class=\"bottomMoreButton\">
<a id=\"more_$next_records\" class=\"more_records\" href=\"javascript: void(0)\">Get more replies</a>
</div>"; }?>
<div class="wallreply">
<form action="wallreply.php" method="post">
<input name="sendrid" type="hidden" value="<?php echo "$loginuniqid"; ?>">
<input name="messageid" type="hidden" value="<?php echo "$messageid"; ?>">
<input name="base" type="hidden" value="<?php echo "$memberid"; ?>">
<?php if (isset($_GET['currentpage'])) {$currentpage= $_GET['currentpage']; echo "<input name=\"currentpage\" type=\"hidden\" value=\"$currentpage\">";} ?>
<textarea  class="newwallpostreply<?php echo $i++ ; ?>" name="wallreply" autocomplete="off" maxlength="1000" placeholder="Reply"></textarea>
<span class="wallreply-holder<?php echo $p++; ?>">
<div class="button_block">
<input type="submit" class="post" value="Post">
<input type="submit" class="cancel" value="Cancel">
</div>
</span>
</form>
</div>

I know its a lot of info there, but if anyone can see the problem i would be greatful.