PHP - Simple Dynamic Content Site Help

Hi All,   Am hoping someone can point out my perhaps obvious issue here.   I've a series of links that are dynamically created:

<a class="team-link" rel="<?php the_ID(); ?>" href="#">

When a link is clicked, I'm trying to get content to load into this DIV:

<div id="single-post-container"></div>

I have the following jquery:

<script>
$(document).ready(function(){
 
        $.ajaxSetup({cache:false});
        $(".team-link").click(function(){

			var post_id = $(this).attr("rel");

            $.ajax({
                url        : "http://www.domain.co.uk/wp-content/themes/name/loop.php",				
                data       : {"the_team": post_id },
				type       : "POST",
                dataType   : "html",                
				success: function(response) {
					$("#single-post-container").html(response);						
				}
        return false;
        });
		
 
});
</script>

This is my loop.php file:

require_once('../../../wp-load.php');

// Our variables
$the_team = (isset($_GET['post_id'])) ? $_GET['post_id'] : 0;

echo $the_team;

query_posts(array(
			'post_type' => 'work',
			'meta_key' => 'author_name',
			'meta_value' => $the_team
));

// our loop
if (have_posts()) {
	while (have_posts()){
	the_post();	
	?>

		<h1><?php the_title(); ?></h1>
		<?php the_content(); ?>
        <hr />
	
	<?php
	}
}
wp_reset_query();

However, when you click the link, nothing happens. I know loop.php works as I can specify a value and manually browse to it to see the content.   I feel I'm missing something obvious as I'm new to AJAX.   Your help/patience is very much appreciated

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

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

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.

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 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);
?>

I got a question  regarding a news website content that i want to make ! my question is how do i   call my contents without using a lot of page?   i explain   let's say i got 10 news how do i put this 10 news in different pages without using 10 pages ? ex: you can see some links having a number like this http://bbc.uk/news/murder_case-12 then the next page got http://bbc.uk/news/finance-13 the title and the number id change but the page news doesnt change    thanks for your answer.

I have set up a site for a local orchestra. I have a simple mysql db from which 'News' items are pulled using php.

I have set up the following pages:
1. view_news.php
2. insert_news_item.php
3. delete_news_item.php
4. edit_news_item.php

All pages are working fine.

Now, rather than continually having to do news updates for the orchestra myself, I want to give a person on the orchestra committee access to the above pages so that he/she can do news updates for the orchestra, as required.

What is the best way of proceeding from here? I thought about creating a password protected directory and putting pages 2, 3 and 4 above into that directory and then giving the committee member the protected directory password. Is that the way to go?

What is the conventional way of doing this sort of thing?

Two things to note: I'm new to php and the job is non-paying. I've set up the site as the willing parent of kids in the orchestra.

Any advice will be much appreciated.

<?php 

$foo = 5; 

$too = 7;

${"foo"}++; 
${"too"}++;
echo $foo;
echo '<br />' . $too;

$my_var_name = "foo";

${$my_var_name}++;

echo $foo;
    
?>

I understand the part that $my_var_name is going to increment $foo. But I don't understand that when we used ${"foo"} we did not add the $ sign with it. But when we use ${$my_var_name} we have to add another $ sign. why is that?

Hi there, I'm a movie freak and I'm planning of building a simple dynamic movie list. There are some movie lister software available on internet, but I want it lighter and customized. Here is the idea:



It looks like yahoo mail inbox...I want to create this script based on php and sql. I think this is the right place where can I get some help. Thanks in advance.

NaimeniM

I wrote this basic script yesterday to process and generate a Google Site Map. And it works! BUT I want to advance this script to accommodate for something else and I don't know the correct path to take from here, but I will tell you what I've found out so far..

Current Situation:

1 - Currently my below script generates urls in the site map like:
http://abcdefg.com/index.php?dispatch=products.view&product_id=29826

2 - I have .htaccess configured to rewrite the urls to the products name data like:
http://abcdefg.com/pennies/wheat-pennies/lincoln-wheat-penny-cent.html (just an example) and these urls are ONLY active if clicking on the site links themselves - meaning if I enter: http://abcdefg.com/index.php?dispatch=products.view&product_id=29826 directly into the url, the url does not resolve to this natural friendly url name.

What Id like to achieve (which I don't know what direction I should be looking!):

- I'd like my xml output urls (as current) to be written in the natural format (as in #2 above).

FYI here is a current example output item in my sitemap:

Code: [Select]
<url>
  <loc>http://abcdefg.com/index.php?dispatch=products.view&amp;product_id=29803</loc>
  <changefreq>weekly</changefreq>
  <lastmod>2010-09-24T08:00:00+04:00</lastmod>
 </url>
Can anyone give me some guidance on what method might work for this? Do you think it's more a mod_rewrite issue? Or can this be handled easier with straight up modifications to my below? I'm just a bit confused on what direction I should be looking.. Thanks for any input.

<?php
header("Content-Type: text/xml;charset=iso-8859-1");
  echo '<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
 //include('config.local.php');
  $cxn = mysqli_connect($config['db_host'], $config['db_user'], $config['db_password'], $config['db_name']);
  $query = "SELECT cscart_product_descriptions.product_id, cscart_products.product_id, cscart_products.timestamp
FROM cscart_product_descriptions JOIN cscart_products ON cscart_product_descriptions.product_id = cscart_products.product_id
WHERE cscart_products.status='A' LIMIT 10000";
  $result = mysqli_query($cxn, $query);
  $row = mysqli_fetch_array($result);
  while ($row = mysqli_fetch_array($result)) {
  $formatedTime = $row['timestamp'];
      echo '<url>
  <loc>http://abcdefg.com/index.php?dispatch=products.view&amp;product_id=' . $row['product_id'] . '</loc>
  <changefreq>weekly</changefreq>
  <lastmod>'. date('c',$formatedTime) .'</lastmod>
  </url>';
  } //while ($row = mysqli_fetch_array($result))
  echo '</urlset>';
?>

Hello All,

I am new to php and programming in general. My question is as follows.

I have created a header.inc.php and the index.php which includes header.inc.php. I have title set in header.inc.php under the "head".

Code: [Select]
<title><?php echo $title; ?>
In the index.php, I have set variable $title to "Home Page"
$title = "Home Page";

But whenever I visit index.php, the title is never called. Is it because the header has no clue where the $title is?

Hi there,   I want to make script which will execute via crontab every Sunday at 0:01h and will stop at 23:59h. My goal is to put(show) some tekst on the site. The problem is how to put this tekst in the site? I mean I know how to configure Cron Jobs but how to include the tekst in index.php for example? crontab will be.

1 0 * * 0     /usr/bin/php Start.php
59 23 * * 0   /usr/bin/php Stop.php

I've used a little PHP but I am not great. Is there any way to take information from a html page written in basic text and have it dynamically displayed.

The content I want is found he
http://www.kitco.com/texten/texten.html

I want to take the information from the following chart - only Metal and Ask and create a ticker.
New York Spot Price
MARKET IS OPEN
Will close in 2 hour 24 minutes
----------------------------------------------------------------------
Metals Bid Ask Change Low High
----------------------------------------------------------------------
Gold 1822.80 1823.80 -12.30 -0.67% 1810.70 1840.90
Silver 41.45 41.55 +0.10 +0.24% 41.08 42.15
Platinum 1844.00 1852.00 -7.00 -0.38% 1826.00 1861.00
Palladium 783.00 788.00 +10.00 +1.29% 775.00 794.00
----------------------------------------------------------------------

So basically I would just take the word: Gold - $1823.80 Silver - $41.55 Platinum $1852.00 Palladium - $788.00

Can someone help me through this or point me in a direction where I can read more about accomplishing this? I've been searching google for articles but still haven't found what I'm looking for.

nofx1728