PHP - Code No Adding

Hi, I have some code which displays my blog post in a foreach loop, and I want to add some social sharing code(FB like button, share on Twitter etc.), but the problem is the way I have my code now, creates 3 instances of the sharing buttons, but if you like one post, all three are liked and any thing you do affects all of the blog post. How can I fix this?


<?php
include ("includes/includes.php");

$blogPosts = GetBlogPosts();

foreach ($blogPosts as $post)
{
echo "<div class='post'>";
echo "<h2>" . $post->title . "</h2>";
echo "<p class='postnote'>" . $post->post . "</p";
echo "<span class='footer'>Posted By: " . $post->author . "</span>";
echo "<span class='footer'>Posted On: " . $post->datePosted . "</span>";
echo "<span class='footer'>Tags: " . $post->tags . "</span>";
echo '
<div class="addthis_toolbox addthis_default_style ">
<a class="addthis_button_facebook_like" fb:like:layout="button_count"></a>
<a class="addthis_button_tweet"></a>
<a class="addthis_counter addthis_pill_style"></a>
</div>
<script type="text/javascript">var addthis_config = {"data_track_clickback":true};</script>
<script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#username=webguync"></script>';

echo "</div>";
}


?>

I had a piece of code which limited the number of items printed from a database.  However, I can no longer get it to work. 

Code: [Select]
$query = "SELECT * FROM productfeed WHERE description like '%$description%' LIMIT 0, 3";
This is the code I am trying to limit, but I cant get it to work.

Code: [Select]
<?php

ini_set('display_errors', 1);
error_reporting(-1);



$query = "SELECT * FROM productfeed";

if(isset($_GET['description']) && !empty($_GET['description'] ))
{
$description = $_GET['description'];
$query .= " WHERE description like '%$description%'";
}

if(isset($_GET['price']) && !empty($_GET['price']))
{
$price = explode('-', $_GET['price']);
$lowPrice = (int)$price[0];
$highPrice = (int)$price[1];

$query .= " AND price BETWEEN $lowPrice AND $highPrice";
}


$result = mysql_query($query);

while($row = mysql_fetch_assoc($result))

{

$id = $row['id'];
$image = $row['awImage'];
$link = $row['link'];
$description = $row['description'];
$fulldescription = $row['fulldescription'];
$price = $row['price'];

echo "<div class='productdisplayshell'>
<div class='productdisplayoutline'>
<div class='productborder'><center>
<a href='$link' target='_blank'><img src='$image' width=\"95%\" /></a>
</center> </div></div>
<div class='productdescriptionoutline'>
<div class='productdescriptionbox'>
<a href='$link' target='_blank' >$description</a>
</div>
<div class='productfulldescriptionbox'>$fulldescription</div>
</div>
<div class='productpriceoutline'>
<div class='productpricebox'>
<center>&#38;#163; $price</center>
</div>
<div class='productbuybutton'>
<center><a href='$link' target='_blank' ><img src=/images/buybutton.png /></a></center>
</div>
</div>
</div>";
} 

if ($_GET['description'] == $description ) {
echo 'Sorry, this product is not available.  Please visit our <a href="http://www.ukhomefurniture.co.uk">Homepage</a>.';
}


?>

<?php
function sanitizeString($description)
{
$description = mysql_real_escape_string($description);
$description = stripslashes($description);
$description = htmlentities($description);
return $var;

$price = mysql_real_escape_string($price);
$price = stripslashes($price);
$price = htmlentities($price);
return $var;


}
?>

Hi,

Is it possible to add PHP code into a TPL file?

Ive tried adding my code in as standard PHP and also tried it with the {php}.....{/php} tags but it still doesnt work. 

Any help appreciated!

Thanks
Tom

Hi, I am using Mouseflow analytics in a phpbb forum.
In my specific application, I need to add their application's javascript code inside php code.
How do I properly add Javascript code inside a php code.
Thanks

This is how I would add it to an html file

    <script type="text/javascript">
        var _mfq = _mfq || [];
        (function () {
        var mf = document.createElement("script"); mf.type = "text/javascript"; mf.async = true;
        mf.src = "//cdn.mouseflow.com/projects/b22343cd9-0049-4443-8326-954444462d6515.js";
        document.getElementsByTagName("head")[0].appendChild(mf);
      })();
    </script>
 

Hi.

I currently have php java to get my database results and limit the amount of data shown by a given value.  The js includes buttons to go forward or backward in the database.  Everything is all fine and dandy except I'm trying to add a very simple search for the user as well.


I want the user to be able to select either "firstname" or "lastname" to search through the database and display the resulting rows based of the first three characters entered into the search criteria.


I'm not sure where to start on this... Do I have to add something the js (I'm not very familiar with js), or should I add mysql_query's in the php linked file?



Current Page Code:
Link To Current Page Test
Code: [Select]
<!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>
<title>Ness Physiotherapy and Sports Injury Clinic Web site - Site Map</title>
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<meta name="description" content="Ness Physiotherapy and Sports Injury Clinic Our mission is to provide quality, evidenced based service in a safe, friendly, professional environment." />
<meta name="keywords" content="pain,rehabilitation,rehab,exercise,manipulation,musculoskeletal,pain,management,massage therapy,physiotherapy,sports injury,injury,injured,chronic pain,quality care,quality life,muscle balance,spinal fitness assessment, BMR PT, CAFCI, RMT" />
<!--Ness Physiotherapy and Sports Injury Clinic is owned by Sean Springer, Tamara Silvari and Charles Dirks. -->
<meta name="language" content="EN" />
<meta name="copyright" content="Ness Physiotherapy and Sports Injury Clinic" />
<meta name="robots" content="ALL" />
<meta name="document-classification" content="Health" />
<meta name="document-classification" content="Health" />
<meta name="document-rights" content="Copyrighted Work" />
<meta name="document-type" content="Public" />
<meta name="document-rating" content="General" />
<meta name="document-distribution" content="Global" />
<link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
<script type="text/javascript" src="../scripts/preloadimages.js"></script>
<script type="text/javascript" src="../scripts/p7exp.js"></script>
<script type="text/javascript" src="../scripts/formajax.js"></script>
<!--[if lte IE 7]>
<style>
#menuwrapper, #p7menubar ul a {height: 1%;}
a:active {width: auto;}
</style>
<![endif]-->
<!--[if IE 5]>
<style type="text/css">
/* place css box model fixes for IE 5* in this conditional comment */
.twoColFixRtHdr #sidebar1 { width: 220px; }
</style>
<![endif][if IE]>
<style type="text/css">
/* place css fixes for all versions of IE in this conditional comment */
.twoColFixRtHdr #sidebar1 { padding-top: 30px; }
.twoColFixRtHdr #mainContent { zoom: 1; }
/* the above proprietary zoom property gives IE the hasLayout it needs to avoid several bugs */
</style>
<![endif]-->
<link href="../css/p7exp.css" rel="stylesheet" type="text/css" />
<link href="../css/basiclayout.css" rel="stylesheet" type="text/css" />
<link href="../css/general.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="../css/form_member_admin.css"/>
</head>
<body class="twoColFixRtHdr" onload="ajaxFunction('fw')">
<div id="container2">
  <!-- Header Secion edit header.php if needed-->
  <?php require("../header.php"); ?>
  <div id="BasCon">
    <form id="myForm" action="ajaxFunction(this.form); return false">
      <div>
        <input type="hidden" name="st" value="0" >
        </input>
      </div>
      <table id="tbl_search">
      <tr>
        <td colspan="5"><b>MEMBER LIST</b></td>
        </tr>
        <tr>
          <td><input type="button" id="back" value="Prev" onclick="ajaxFunction('bk'); return false" /></td>
          <td align="right"><input type="button" value="Next" id="fwd" onclick="ajaxFunction('fw');  return false" /></td>
        </tr>
        <tr>
          <td colspan="2"><div id="txtHint"><b>Records will be displayed here</b></div></td>
        </tr>
      </table>
     <div class="formdiv">
    <label for="searchby">Search By:</label>
    <?php
//get databast access file
  require "../dbConfigtest.php";

$query = "SELECT firstname,lastname FROM $usertable"; 
$result = mysql_query($query) or die(mysql_error());
?>
    <select size="1" name="searchby" class="searchby">
    <?php
$i = 0;
while ($i < mysql_num_fields($result)){
   $fieldname = mysql_field_name($result, $i);
   echo '<option value="'.$fieldname.'">'.$fieldname.'</option>';
   $i++;
} 
?>
    </select>
   
    <label for="newsearch">Search Value:</label>
    <input name='newsearch' type='text' value='' maxlength="32"  />
    <p>&nbsp;</p>
    <input class="button" type="submit" value="Search" name="search" />
    </div><!--End Div formdiv-->
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    </form>
  </div>
    <!-- This clearing element should immediately follow the #mainContent div in order to force the #container div to contain all child floats -->
  <br class="clearfloat" />
  <div id="footer_abv_2"></div>
  <!-- end #footer abv -->
  <!-- Footer Secion edit footer.php if needed-->
  <?php require("../footer.php"); ?>
</div>
<!-- end #container2 -->
</body>
</html>


PHP Code from "pagelisting.php" which is called from the java.

<?
//get databast access file
include "../dbConfigtest.php";

//////////////////////////////// Main Code sarts /////////////////////////////////////////////
$endrecord=$_GET['endrecord'];// To take care global variable if OFF
if(strlen($endrecord) > 0 and !is_numeric($endrecord)){
echo "Data Error";
exit;
} 

$limit=25;// Number of records per page
$nume=mysql_num_rows(mysql_query("select * from $usertable"));
//echo "endrecord=$endrecord limit=$limit ";
if($endrecord < $limit) {$endrecord = 0;}

switch($_GET['direction'])
{
case "fw":
$eu = $endrecord ;
break;

case "bk":
$eu = $endrecord - 2*$limit;
break;

default:
echo "Data Error";
exit;
break;
}
if($eu < 0){$eu=0;}
$endrecord =$eu+$limit;

$t=mysql_query("select * from $usertable limit $eu,$limit");

$str= "{ \"data\" : [";

while($nt=mysql_fetch_array($t)){
$str=$str."{\"id\" : \"$nt[id]\", \"firstname\" : \"$nt[firstname]\", \"lastname\" : \"$nt[lastname]\", \"email\" : \"$nt[email]\", \"enewsletter\" : \"$nt[enewsletter]\"},";
//$str=$str."{\"myclass\" : \"$nt[class]\"},";

}
$str=substr($str,0,(strLen($str)-1));

if(($endrecord) < $nume ){$end="yes";}
else{$end="no";}

if(($endrecord) > $limit ){$startrecord="yes";}
else{$startrecord="no";}


$str=$str."],\"value\" : [{\"endrecord\" : $endrecord,\"limit\" : $limit,\"end\" : \"$end\",\"startrecord\" : \"$startrecord\"}]}";
echo $str;
//echo json_encode($str);
/////////////////////////////////////////////////////////////////////////////////////////////
?>


Current js Code:
Code: [Select]
function ajaxFunction(val)
{

//document.writeln(val)
var httpxml;
try
  {
  // Firefox, Opera 8.0+, Safari
  httpxml=new XMLHttpRequest();
  }
catch (e)
  {
  // Internet Explorer
  try
    {
    httpxml=new ActiveXObject("Msxml2.XMLHTTP");
    }
  catch (e)
    {
    try
      {
      httpxml=new ActiveXObject("Microsoft.XMLHTTP");
      }
    catch (e)
      {
      alert("Your browser does not support AJAX!");
      return false;
      }
    }
  }
function stateChanged()
    {
    if(httpxml.readyState==4)
      {
var myObject = eval('(' + httpxml.responseText + ')');


var str="<table><tr><th>LINK</th><th>ID</th><th>FirstName</th><th>LastName</th><th>Email</th></tr>";
for(i=0;i<myObject.data.length;i++)
{
//var sPath = window.location.pathname;
//var sPath = sPath.substring(sPath.lastIndexOf('/') + 1);
var sPath = "testing/member_update_test.php";
var site_link = "www.nessphysiotherapy.com/";
var urlLink = site_link + sPath + "?id=" + myObject.data[i].id;
var site_title = "EDIT";
str = str + "<tr><td>" + "<a href=\"http:\/\/" + urlLink + "\" title=\"site_title\">" +site_title + "<\/a>" + "<td>" + myObject.data[i].id + "</td><td>" + myObject.data[i].firstname +  "</td><td>" + myObject.data[i].lastname +  "</td><td>" + myObject.data[i].email + "</td></tr>"
}
var endrecord=myObject.value[0].endrecord


document.forms.myForm.st.value=endrecord;
if(myObject.value[0].end =="yes"){ document.getElementById("fwd").style.display='inline';
}else{document.getElementById("fwd").style.display='none';}


if(myObject.value[0].startrecord =="yes"){ document.getElementById("back").style.display='inline';
}else{document.getElementById("back").style.display='none';}


str = str + "</table>"
document.getElementById("txtHint").innerHTML=str;
    }
    }

var url="../scripts/pagelisting.php";
var myendrecord=document.forms.myForm.st.value;
url=url+"?endrecord="+myendrecord;
url=url+"&direction="+val;

url=url+"&sid="+Math.random();
//alert(url)
httpxml.onreadystatechange=stateChanged;
httpxml.open("GET",url,true);
httpxml.send(null);
  document.getElementById("txtHint").innerHTML="Please Wait....";

}