PHP - Load Dynamic Content Into Div Via Ajax

Hello all,  I feel pretty good that I got my AJAX filter working properly. But it still needs some help. Now I am returning the content with Ajax that I want from the search filter of dropdown option (keep in mind there are several options to filter by). But the content returned is often to much to fit on one page - so I need to paginate the successfully returned html from my AJAX call.    Here is where I get stumped. Do I setup a normal page nav outside the AJAX area? 

</div><!-- AJAX return container-->

    	<nav class="pagenav">
			<ul id="pag-link">
				<li class="old"><?php next_posts_link('&laquo; Older Sermons', $sermons_query->max_num_pages) ?></li>
				<li class="new"><?php previous_posts_link('Newer Sermons &raquo;', $sermons_query->max_num_pages) ?></li>
			</ul>
		</nav>	

IF so, how do I update the links info?    or do I keep the page nav inside the AJAX area but use some custom code to retrieve the proper link? (I tried using the normal wordpress page nav functions in my php function but they provide the url of the page that the php function is on, not the actual page being viewed).    Do I need to make a separate AJAX call to a function that just builds my links? or is there a way to do it with my main call?    Here is my AJAX call:

	//Listen for the menu's to change except the main filter_by dropdown
	var ids = ['filter_preacher_dropdown', 'filter_sort_by_dropdown', 'filter_per_page_dropdown', 
	'filter_series_dropdown', 'filter_service_dropdown', 'filter_tag_dropdown', 'filter_book_dropdown', 'filter_year_dropdown'];
	$('#' + ids.join(',#')).change(function(e) {
		var pt = [ "preacher","series","service" ];
		if($.inArray(this.name, pt)!==-1){
		var mk 	= this.name;
		var mv 	= $(this).val();
		var ppp = $("#filter_per_page_dropdown").val();
		var ob 	= $("#filter_sort_by_dropdown").val();
		var data = {
			action: 'filter_sermons', 
			meta_key: mk, 
			meta_value: mv, 
			posts_per_page: ppp
			};
			$.post(mbsb_ajaxurl, data, function(response) {
				$('#sermonlists').fadeOut('slow', function() {
					$(this).html(response)
				}).fadeIn('slow');
			});
		}

and here is my php function (slightly paired down for viewing ease):

//ajax for sermons filter
add_action('wp_ajax_filter_sermons', 'check_ajax'); 
add_action('wp_ajax_nopriv_filter_sermons', 'check_ajax');


function check_ajax() {
	global $wpdb, $paged, $max_num_pages;
//check if filter is on post_type
if($_POST['meta_key']){
	$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
	$mk = '"'.$_POST['meta_key'].'"';
	$mv = intval($_POST['meta_value']);
	$ppp = intval($_POST['posts_per_page']);
	$offset = ($paged - 1) * $ppp;
	$sermons = $wpdb->get_results("SELECT SQL_CALC_FOUND_ROWS sermons.* FROM {$wpdb->prefix}posts AS sermons, {$wpdb->prefix}postmeta WHERE meta_key = {$mk} AND meta_value = {$mv} AND sermons.ID = {$wpdb->prefix}postmeta.post_id LIMIT {$offset}, {$ppp}", OBJECT);
	$sql_posts_total = $wpdb->get_var( "SELECT FOUND_ROWS();" );
    $max_num_pages = ceil($sql_posts_total / $ppp);	
}elseif($_POST['name']){	
	//another custom query
}elseif ($_POST['book_number']){
	//another custom query

}
    $posts = get_posts();                		// returns posts in an array

	if($sermons) {
		global $post; 
		foreach ($sermons as $post){
		setup_postdata($post); 
		
			//custom query info returned here
		}

          //Would the Pagination for the AJAXED content go here?

	}else{ ?>
    <h2 class="center">Not Found</h2>
    <p class="center">Sorry, but you are looking for something that isn't here.</p>
 <?php 
 } 

	die();
}

Stop posting non-PHP questions in the PHP Coding Help section.  We have many sub-forums, including both a JavaScript forum and one dedicated entirely to Ajax.

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=327454.0

(not sure if this should be in php or javascript section)

I am trying to create a dropdown list that loads content according to the option chosen..

The idea is that you select from 4 or so dropdown boxes, which then selects the appropriate content  that the user picked

Pretty much like http://www.cooldiamonds.com/ (after you click enter)

This is what I've got so far:

Option.html
Code: [Select]

<script src="http://code.jquery.com/jquery-latest.js" type="text/javascript"></script><br>

<script type="text/javascript">

$(document).ready(function(){
  $('.select').change(function() {
   
    var option = $(this).val();
    $.get('option.php', {select:option}, function(data) {
      $('#result').html(data).hide().fadeIn(1000);
    });
  });
 
});
</script>

</head>

<body>


<p> Selection 1</p>
<select name="select" id="select" class="select">
<option value="">Select</option>
<option value="option1">Option 1</option>
<option value="option2">Option 2</option>
</select>


<p> Selection 2</p>
<select name="select2" id="select2" class="select">
<option value="">Select</option>
<option value="option3">Option 3</option>
<option value="option4">Option 4</option>
</select>

<p> Selection 3</p>
<select name="select3" id="select3" class="select">
<option value="">Select</option>
<option value="option5">Option 5</option>
<option value="option6">Option 6</option>
</select>

<p> Selection 4</p>
<select name="select3" id="select3" class="select">
<option value="">Select</option>
<option value="option7">Option 7</option>
<option value="option8">Option 8</option>
</select>


<div id="result" style="border:1px solid #000;padding:10px;color:#ff0000;display:none;"></div>

option.php
Code: [Select]
<?php

   // Multiple Selections
if ($_GET['select'] == 'option1' && $_GET['select2'] == 'option3') {
  echo 'the option you have chosen is 1 and 3';} 
elseif ($_GET['select2'] == 'option4' && $_GET['select3'] == 'option5' && $_GET['select4'] == 'option7') {
  echo 'the option you have chosen is 4, 5 and 7';}   
  
  // and so on
  
  //Selection 1
  elseif($_GET['select'] == 'option1') {
  echo 'the option you have chosen is 1';} 
  elseif($_GET['select'] == 'option2') {
  echo 'the option you have chosen is 2';} 
  
  //Selection 2
  elseif($_GET['select2'] == 'option3') {
  echo 'the option you have chosen is 3';} 
  elseif($_GET['select2'] == 'option4') {
  echo 'the option you have chosen is 4';} 

  //Selection 3
  elseif($_GET['select3'] == 'option5') {
  echo 'the option you have chosen is 5';} 
  elseif($_GET['select3'] == 'option6') {
  echo 'the option you have chosen is 6';} 

  // Selection 4
  elseif($_GET['select4'] == 'option7') {
  echo 'the option you have chosen is 7';} 
  elseif($_GET['select4'] == 'option8') {
  echo 'the option you have chosen is 8';} 
 
?>

You can view it he http://adamwatkin.com/option.html

As you can see selection 1 works fine, but the other selections do not work and neither does multiple selections.

Its almost certainty theres errors in the code, does anyone have any idea what the problem is?

Any help will be appreciated
Cheers

Hi,

I am trying to load a block of code for all operating systems except Linux.

I have the following code. Does it look ok?- I am not too sure what to put in the IF statement.

if (navigator.appVersion.indexOf("Linux")!=-1){

 

  document.write('');

 

}



else{

  LoadFlash : function(flash_path, width, height){

        document.write('<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="'+ width +'" height="'+ height +'">');

        document.write('<param name="movie" value="'+ flash_path +'"/><param name="quality" value="best"/><param name="wmode" value="transparent"/><param name="play" value="true"/><embed pluginspage="http://www.macromedia.com/go/getflashplayer" src="'+ flash_path +'" type="application/x-shockwave-flash" wmode="transparent" quality="best" play="true" width="'+ width +'" height="'+ height +'"></embed>');

        document.write('</object>');

    }

}

Thanks!

Is there a way to create dynamic content without the use of a Content Management System?  I simply want to click on a link in my navigation menu and have that display the content in a div section and keep the content in a separate folder on the server.  I didnt want to have to use a CMS to accomplish that because every other feature of it will be unused as I just simply want to display the content in a div when I click on the link.  I use a simple test server on my Home PC that I use to format the articles in html from documents I have wrote in LibreOffice, so I dont really need all the features and sophistication of full blown CMS.  But I also dont want a bunch of different files in my root folder if I can avoid it.  I would rather keep the content in a separate folder and just pull it from there and display it on the main page when the link is clicked.

Anyway, I dont know if its even possible or if its the best way, so I am open to suggestions as well.  Some of the documents are quite long (like several chapters) and some are much shorter (just a few pages).  Any help and ideas are much appreciated.

Hello

Im trying to work out how i can display 2 sets of dynamic content depending on a link clicked.
Im currently using css, html, php & mysql.

I have my database set with a unique id for each row of data.

Heres what i am trying to get to work. I have links in div1 that pull info depending on different fields and display it in div2 (eg link 'title' will pull down the 'title' field, link 'author' would pull down the 'author' field) the info displayed in div2 is a series of dynamic links that i want to display the content of that row in div3 (eg the link 'title' 'math' would display all content from its row using the unique id)

i am able to set up the links (div1) to display content in div2 and the div2 dynamic links to display content in div3. But when ever i click a dynamic div2 link it displays the info in div3(like it should) but div 2 reverts back to default(which it shouldnt). how can i display the div2 dynamic links while displaying div3 content?

ive tried using a switch statement and also a form action statment ( if(action == title){display info}; )
is there something i can try to get this to work... i know it can be done using html frames but i want to stay away from frames as they are just crap (well i think they are)

any help or advice would be great.

cheers
P0PZ

ps. i hope i have explained what im trying to achieve ok... if i havent just let me know and ill try again.

Hey everyone, I'm new to web programming so I thought I would join a active community to help me out. Anyhow, I'm making a game portal and I want the users games to have a url like so... games/username/gamename. From what I understand I could get this structure by simply using data from my login session(username) and using my upload form(gamename) and mkdir. Then I would need to have an index page inside every gamename folder? How would I add the index pages inside such folders. This way seems pretty inefficient to do considering I could pull the games dynamically in a single php file. Is there a way I can make my url look nice and still use one file to handle the embedding of the games, comments etc. Thanks

Hi all,

I'm not sure if this is a PHP question or javascript, so if it needs to be moved can an admin please do so...

Anyway, basically I have the following code:

Code: [Select]
<a href = "javascript:void(0)" onclick = "document.getElementById('light').style.display='block';document.getElementById('fade').style.display='block'">View Availability</a>
This pops up a divs with a black alpha background, so that it appears the new content is displaying over the top of the current content. This all works fine, however the content I am displaying in the top level div is (or should be) dynamic.

In order for the content to be useful I need to grab the id.

Normally I would simply do this:

Code: [Select]
<a href = "[b]url.php?uniqueidentifier=<?php echo $row['id'];?>[/b]" onclick = "document.getElementById('light').style.display='block';document.getElementById('fade').style.display='block'">View Availability</a>
However what happens in this instance is that the page loads with the javascript and the id in the url but it then disappears...

Has anyone got any ideas on how I might be able to get around this?

Many thanks,

Greens85

Firstly, I'd just like to say hello, seeing as this is my first post.
I've had a look about and I think I'm going to enjoy my stay here.

Now, here's my problem.

I'm using $_GET to power dynamic-content.

Code: [Select]
<?php
  //creates page variable
  $page = isset($_GET['page']) ? $_GET['page'] : 'home';
?>
Code: [Select]
<?php
        //checks if there is content for the chosen
        if(file_exists('content/'.$page.'.php'))
        {
          //if there is, it is included
          include('content/'.$page.'.php');
        }
        else
        {
          if(file_exists('content/404.php'))
          {
            //if their wasn't any content
            include('content/404.php');
          }
        }
?>
So say, for example, I have "Hello World!" in a file called helloworld.php and I go to websiteurl.com/helloworld (I've set up .HTACCESS to ignore "index.php?page=")
The "Hello World!" would display fine.

The problem I'm having is if someone tries an url like this:
websiteurl.com/directory/file

It will display the content for the default (in this case home, since that's what I set it to at the start) in the directory. This means there is no styling and I run into a whole load of problems after that.

So, that's my problem.
Does anyone know how I would solve this? I'm unsure if it's because of the .HTACCESS or the way the PHP is being used.
I'd also like to know if there are any other security flaws with this code?

I'm also sorry if I've been unclear or if my sentences don't make sense (it's rather later and I'm not sleeping lately)
And lastly, I'm sorry if I've broken any forum rules, since this is my first post I'm a little weary.

Thanks a lot guys.
Pete.

This might be a very easy problem to solve. I am literally brand new to php.
I am trying to create a simple site that will load content depending on what page 'id' is in the URL and if it doesn't exist to show a page for that scenario.
eg index.php?id=1 will show the page 1.php
 
It works fine apart from showing an error when there is no id at all,
eg  www.website.com will show an error but www.website.com/index.php?id=1 will show a page
I want to be able to show the homepage if there is no 'id' at all.

Code: [Select]
<?php
$id = $_GET['id'];


if(file_exists("./".$id.".php"))
  {
  include ("./".$id.".php");
  }
else
  {
  include ("404.php");
  }

?>
Any help  is appreciated
Thanks

Hi there,

I have a simple question - is it possible to send out an html email containing PHP/MySQL code so that when the user receives the email it checks the date and serves up content from a database? I have created a page that works fine online, but when I try to email the page, it doesn't work from within the user's email client (such as outlook, or gmail).

When I look at the raw email source, it looks like the PHP code isn't getting executed by the email program. If anyone knows a reason or workaround, I would appreciate it!

Thanks in advance,
Rick

Code: [Select]
<?php
$day = date("Y-m-d");

// Connects to your Database
mysql_connect("empowermentoftheday.com", "username", "password") or die(mysql_error()) ;
mysql_select_db("etd_emails") or die(mysql_error()) ;

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$query = sprintf("SELECT * FROM daily WHERE date = '%s'",
    mysql_real_escape_string($day));

// Perform Query
$Recordset1 = mysql_query($query);

// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$Recordset1) {
    $message  = 'Invalid query: ' . mysql_error() . "\n";
    $message .= 'Whole query: ' . $query;
    die($message);
}

$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

?>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<meta name="description" content="Free inspirational Picture of the Day as well as a Free daily Wellness Break. Start your day off right and Empower Yourself Today. Empowerment of the Day is meant to inpire you each and every day and is brought to you by the Remakable Success Group Team.Empower Yourself Today." />

<meta name="keywords" content="inspirational quote, picture of the day, wellness quote, inspirational saying, inspirational story, today's wellness break, empowerment, empower yourself, empowerment of the day, health tip, wellness tip" />

<title>Empowerment Of The Day</title>

</head>

<body marginheight="0" marginwidth="0" topmargin="0" leftmargin="0">

<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" align="center">

<div style="background:#DBAE13">
<img src="http://www.empowermentoftheday.com/email/images/header.jpg" alt="Empowerment of the Day" width="650" height="77" /></div>

<div>
<table width="650" border="0" cellpadding="0" cellspacing="0">
 <tr>
   <td align="center" valign="middle"><img src="http://www.empowermentoftheday.com/email/images/message2.jpg" alt="Picture of the Day" width="306" height="34" vspace="15" /></td>
   </tr>

 <tr>
   <td align="center" valign="middle">
   
   <table border="0" cellspacing="0" cellpadding="5" bgcolor="#000000">
  <tr height="10px">
    <td height="10px"></td>
    <td height="10px"></td>
    <td height="10px"></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><img src="http://www.empowermentoftheday.com/email/images/photos/<?php echo $row_Recordset1['photo']; ?>" alt="Picture of the Day" /></td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="center">   
    <div><font color="#FFFFFF" face="Helvetica, Arial, sans-serif"><?php echo $row_Recordset1['quote']; ?></font></div>
</td>

<td>&nbsp;</td>
</tr>

</table>

</td>
</tr>
<tr>
  <td align="center" valign="middle">
      <img src="http://www.empowermentoftheday.com/email/images/message3.jpg" alt="Today's Wellness Break" width="360" height="44" vspace="15" /></td>
</tr>
<tr>
  <td align="center" valign="middle"><p><font color="#000000" face="Helvetica, Arial, sans-serif"><?php echo $row_Recordset1['wellness']; ?><br>
<br>
</font></p></td>
</tr>
</table>

<script language="JavaScript1.2" type="application/javascript">

/*
Disable right click script II (on images)- By Dynamicdrive.com
For full source, Terms of service, and 100s DTHML scripts
Visit http://www.dynamicdrive.com
*/

var clickmessage="Right click disabled on images!"

function disableclick(e) {
if (document.all) {
if (event.button==2||event.button==3) {
if (event.srcElement.tagName=="IMG"){
alert(clickmessage);
return false;
}
}
}
else if (document.layers) {
if (e.which == 3) {
alert(clickmessage);
return false;
}
}
else if (document.getElementById){
if (e.which==3&&e.target.tagName=="IMG"){
alert(clickmessage)
return false
}
}
}

function associateimages(){
for(i=0;i<document.images.length;i++)
document.images[i].onmousedown=disableclick;
}

if (document.all)
document.onmousedown=disableclick
else if (document.getElementById)
document.onmouseup=disableclick
else if (document.layers)
associateimages()
</script>
</div>
<div style="background:#D0A615">
<img src="http://www.empowermentoftheday.com/email/images/footer.jpg" alt="Copyright 2010 Remarkable Success Group Inc. Design by Ortega.ca" width="650" height="74" border="0" usemap="#Map" />
<map name="Map"><area shape="rect" coords="456,28,617,55" href="http://www.ortega.ca" alt="Design by Ortega.ca" target="_blank"></map>
</map></div>

<!-- GOOGLE ANALYTICS -->

<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-2910054-6']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>

</td>
</tr>
</table>

</body>
</html>
<?php
mysql_free_result($Recordset1);
?>

Hi there,
I know that php does not recognize onMouseOver events. however, Im wondering if their is a tricky way to get a javascript response from dynamic text. I am working on a nav menu in a wordpress site. wordpress has a function that displays a list of pages created in the admin. I want to be able to display a secondary list of pages when a top-level nav item is moused over. heres the code:
<div id="top">
<script type="text/javascript">
function Show(who) {
Clear();
divel=document.getElementById("drop"+who);
divel.style.display="inline";
divel=document.getElementById("hn"+who);
divel.className="selected";
}

function Hide(who) {
divel=document.getElementById("drop"+who);
divel.style.display="none";
divel=document.getElementById("hn"+who);
divel.className="";
}

function Clear() {
for (i=1;i<=3;i++) {
divel=document.getElementById("drop"+i);
divel.style.display="none";
divel=document.getElementById("hn"+i);
divel.className="";
}
}
</script>

<div id="home-nav" onMouseOut="Clear();">
<ul>
<li id="hn1"><a href="wp_demo/profile" onMouseOver="Show('1')"><?php wp_list_pages(include=4&title_li=' ); ?></a></li> 
<li id="hn2"><a href="wp_demo/services" onMouseOver="Show('2')"><?php wp_list_pages( 'include=6&title_li=' ); ?></a></li> 
<li id="hn3"><a href="wp_demo/portfolio" onMouseOver="Show('3')"><?php wp_list_pages( 'include=8&title_li=' ); ?></a></li> 
<li id="hn4"><a href="wp_demo/contact" onMouseOver="Clear();"><?php wp_list_pages( 'include=12&title_li=' ); ?></a></li> 
<li id="hn5"><a href="wp_demo/hospitality" onMouseOver="Clear();"><?php wp_list_pages( 'include=10&title_li=' ); ?></a></li>
</ul>
</div> <!-- #homenav -->


<div id="wrapper">

<div id="drop1" onMouseOver="Show('1')" onMouseOut="Hide('1')"> 
<img src="<?php bloginfo('stylesheet_directory'); ?>/images/blank.gif" alt="" width="960" height="8" border="0" /><br /> 
<div id="menu1"><ul> 
 <?php wp_list_pages( 'child_of=4&sort_column=menu_order&title_li=' ); ?> 
</ul></div></div> 
 
<div id="drop2" onMouseOver="Show('2')" onMouseOut="Hide('2')"> 
<img src="<?php bloginfo('stylesheet_directory'); ?>/images/blank.gif" alt="" width="960" height="8" border="0" /><br /> 
<div id="menu2"><ul> 
 <?php wp_list_pages( 'child_of=6&sort_column=menu_order&title_li=' ); ?> 
</ul></div></div> 
 
<div id="drop3" onMouseOver="Show('3')" onMouseOut="Hide('3')"> 
<img src="<?php bloginfo('stylesheet_directory'); ?>/images/blank.gif" alt="" width="960" height="8" border="0" /><br /> 
<div id="menu3"><ul> 
 <?php wp_list_pages( 'child_of=8&sort_column=menu_order&title_li=' ); ?> 

</ul></div></div> 


Does anybody know a trick to get the dynamic text to be seen by the javascript? for example, if i put a &nbsp; inside the anchor tags before the php script starts, the onmouseover will register it, and display the secondary nav. I would place invisible divs with links on top of the dynamic text with z-index, but I want the text to be completely dynamic and the client to be able to add as many links as he/she wants.

thanks!

This topic has been moved to mod_rewrite.

http://www.phpfreaks.com/forums/index.php?topic=357949.0

Working on a site with a couple hundred virtually identical landing pages to maximize SEO.

Rather than hard code the pages, I am wondering if there is a way to have one page that handles all the url's and dynamically codes and loads with title, keywords, content & alt tags all specific to the particular url requested.

Seems like the challenge is doing it in a way that does not constitute a redirect.

Is it better to do this in the .htaccess?

Hi, I currently have this code which displays text on clicking the image:

<a href="javascript:;" onclick="document.getElementById('text').style.display='block';window.open('url...');"><img src="image..."></a>
<div id="text" style="display:none;">
...text to be displayed here
</div>

it works fine but I want to integrate this with php which is where I am struggling.

I have a mySQL database with 4 fields (id;name;description;url), what i would like to do is name the div to be opened on click with the 'id' field from the database so that it would become '<div id="id"> and then more than one function could be implemented on each page. I would also like to replace '...text to be displayed here' with the field 'name' from the database and '...url' with the field 'url from the database.

Any help would be very much appreciated. Thanks in advance.