PHP - Group Posts By Date

I have made a website that deals with the sales of different products. It handles the total sales of a specific product. One of the aspects of the website is that it can change the current sales data of the products.

At the moment I can change the sales figures fine however I have to click the submit button once and then physically refresh the page for it to change the data in the table.

Is there a way that I can automatically refresh the page once the submit button is pressed?

I have tried using headers for example:
Code: [Select]

 if (!empty($_POST['NSales']))
{
header('location: currentpage.php');
}
 


however this just constantly refreshes the page.

Any help would be greatly appreciated

Hey! So, I don't know if this is the current section, couldn't really decide on what section/board to post it, so ..    I've got a code that I got from a friend of mine (it was a gaming website (a game server), but he shut it down, I asked for some scripts, he sent me the whole site ..). I got all other scripts correctly, but I do not know how to get this Last Forum Posts to work (IP.Board). I've got the SEO set up as it should and everything, doesn't work.   When I use this

<?php
	$_handlerForum = new mysql("Forum","localhost","*********_fqipb2","*********_fqipb2","password");
	
	$topics = $_handlerForum->fetch("SELECT `tid`,`title`,`last_post`,`title_seo`,`last_poster_name` FROM `topics` ORDER BY `last_post` DESC LIMIT 0,3;",array());

	$content = "";

	foreach($topics as $topic) {
		$content .= "<a href='http://website.com/forum/index.php?/topic/".$topic['tid']."-".$topic['title_seo']."' target='_blank'>".$topic['title']."</a><br />
			<small class='dim'>".$topic['last_poster_name']." - ".date("H:i F d, Y",$topic['last_post'])."</small><hr style='margin: 5px 0px;' />";
	}
	
	return $content;
	
	return "Under Construction";
?>

I get this error

Fatal error: Class 'mysql' not found in /home/***/***/***/public_html/extra/forum.php on line 2

Thought that the problem was "new mysql" (on line 2), so I put in mysql_connect, still get an error. Can anyone help?

Hi there, I have a piece of code that takes all posts with the category of 'model' and puts it on the models page. It then displays the post as a gallery using fancy box. The problem is I want all posts with the category of 'faces' to go on the faces page, but at the moment they are appearing on both pages. Here is the code I have. Any help will guarantee a donation as I am at my wits end trying to figure this out.

Code: [Select]
<?php
  global $post;

  $args = array(
    'numberposts'     => 8,
    'offset'          => 0,
    'category'        => 'models',
    'orderby'         => 'post_date',
    'order'           => 'DESC',
    'post_type'       => 'post',
    'post_status'     => 'publish' );

  $posts_array = get_posts( $args );
  $x = 1; // track model
  foreach( $posts_array as $post ) {
    setup_postdata($post); ?>
    <div id="model-thumb">
<?php
    $arg2 = array( 'post_type' => 'attachment', 'numberposts' => -1, 'order' => 'ASC', 'post_status' => null, 'post_parent' => $post->ID );
    $attachments = get_posts($arg2);
    if ($attachments) {
        $i = 1; // track images
        foreach ( $attachments as $attachment ) {
            $image_attributes = wp_get_attachment_image_src( $attachment->ID, 'full' );
            if ($i == 1) { // Get thumbnail info to display with second image
                $img1src = $image_attributes[0];
                $img1w = $image_attributes[1];
                $img1h = $image_attributes[2];
            } elseif ($i == 2) { // Display thumbnail with link to second image
?>
           <a class="allModels" rel="gallery<?php echo $x; ?>" href="<?php echo $image_attributes[0]; ?>" 
?><img src="<?php echo $img1src; ?>" width="<?php echo $img1w; ?>" height="<?php echo $img1h; ?>"/></a><br /><p><?php the_content();?></p></div>

<?php
            } else { // Other images
?>
                <div style="display:none;"><a class="allModels" rel="gallery<?php echo $x; ?>" href="<?php echo $image_attributes[0]; ?>"><img src="<?php echo $image_attributes[0]; ?>" width="<?php echo $image_attributes[1]; ?>" height="<?php echo $image_attributes[2]; ?>"/></a></div>

<?php
            }
            $i++; // Increase image count
        }
    }

    $x++; // Increase model count
  }

?>

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.

Alright I didn't really know what to name the thread but w/e. I'm working on writing a blog, just for the purpose of something to apply what I'm learning it's not for production.

I need someone to point me in the general direction of how the front page would look where after a post is made its on top and the older posts are below it:
-- new post
-- old post
-- old post

I don't want the code just a general direction of how I should go about it. Thanks much.

hey I am not usually in this php forum, I am usually around html/css but a task arose and I figure since this forum uses smf it would be a perfect place to ask. Not saying you are all smf experts though.

My question is how do I display the latest posts for smf in a page thats not a forum page. Like  On my index page I want to display the latest posts on the forum. Help anyone?

example :

Code: [Select]
<?php
code;
?>

how to change CSS (i guess this is the method) using php or javascript to organize text/code like <code></code> here !

i did a search and didnt found anything useful!

Hey all,

I have a relationship where a zone has many posts and a category has many zones but a zone can also have many categories. The zones are basically parts of a page, such as the main area and sidepanel stored in database as records with name fields such as 'panel' and 'main'. There's a serious flaw right now and I would like to know the best solution to address it. Right now I access the posts of a zone of a category like this:

Code: [Select]
$category->zone->get()->post->get();

The above ends up displaying all the posts in the database for any given category because when category is selected, it searches for the associating zones, and then selects all posts related to those zones, which is wrong. i want to select all posts of the zones associated with that particular category.

Current database:

Code: [Select]
posts
id zone_id

zones
id name

categories_zones
id zone_id category_id

categories
id

What should I do? Add a category_id column to the posts table and relate the post directly to the category as well as directly to the zones table so the post table would have two foreign keys: category_id and zone_id

Would this be the most effective thing to do given my requirements?

Thanks for response.

Hi,

I've been passed the below code which converts rss to php and then displays HTML. It works well.
However, I've 2 issues with it:
1) I'd like to set it so only say 5 posts are shown
2) How can I truncate the description, so it only shows say 100 chars or 20 words?

Any help is much appreciated.

Here's the code:

<?php

// DO NOT EDIT BELOW THIS LINE

date_default_timezone_set("GMT");

$itemArray = array();

if($text = preg_replace("/[\t\r\n]/", " ", htmlentities(@file_get_contents($rss_feed_url), ENT_QUOTES)))
{
while(strpos($text, "&acirc;") == true)
{
$text = substr($text, 0, strpos($text, "&acirc;")) ."'". substr($text, strpos($text, "&acirc;")+9, strlen($text));
}

$items = explode("<item>", html_entity_decode($text));

foreach($items as $item)
{
$title = "";
$link = "";
$desc = "";
$pubdate = "";
$image = "";

$item = html_entity_decode($item, ENT_QUOTES);
$item = preg_replace('/&(?!amp;|quot;|nbsp;|gt;|lt;|laquo;|raquo;|copy;|reg;|bul;|rsquo;|mdash;|#)/', '&amp;', $item); 
$item = str_replace("<![CDATA[","", $item);
$item = str_replace("]]>","", $item);

if(stripos($item, "</item>") == true)
{
if(preg_match('|<title>(.*)</title>|', $item, $match))
{
$title = $match[1];
}

if(preg_match('|<pubDate>(.*)</pubDate>|', $item, $match))
{
$pubdate = strtotime($match[1]);
}

if(preg_match('|url="(.*)|', $item, $match))
{
$search = $match[1];
$imageArray = explode('"', $search);
$image = $imageArray[0];
}

if(preg_match('|<description>(.*)</description>|', $item, $match))
{
$desc = $match[1];
$desc = strip_tags($desc);
}

if(preg_match('|<link>(.*)</link>|', $item, $match))
{
$link = $match[1];
$link = end(explode("*", $link));
}

if($title && $link && $desc)
{
array_push($itemArray, "$pubdate|$title|$link|$desc|$image|");
}
}
}
}
else
{
print "<p>Whoops! We could not connect to: <a href=\"$rss_feed_url\">$rss_feed_url</a></p>";
}

if(sort($itemArray))
{
foreach(array_reverse($itemArray) as $iA)
{
list($pubdate,$title,$link,$desc,$image) = explode("|", $iA);

$timenow = time();

$difference = $timenow-$pubdate;

$days = 0;
$hours = 0;
$minutes = 0;

print "<p>";

if($hotlink_images && $image)
{
if($open_links_in_new_window)
{
print "<a class=\"thumb\" href=\"$link\" onclick=\"openInNewWindow('$link'); return false\">" .
  "<img src=\"$image\" alt=\"$title\"></a>";
}
else
{
print "<a class=\"thumb\" href=\"$link\"><img src=\"$image\" alt=\"$title\"></a>";
}
}

if($open_links_in_new_window)
{
print "<a href=\"$link\" onclick=\"openInNewWindow('$link'); return false\">$title</a><br>";
}
else
{
print "<a href=\"$link\">$title</a><br>";
}

if($pubdate)
{
print "<span class=\"sub\">Posted ";

if(sprintf("%01.0d", $difference/(60*60*24)))
{
$days = sprintf("%01.0d", $difference/(60*60*24));
$difference -= $days*(60*60*24);

if($days > 1)
{
print "$days days ";
}
else
{
print "$days day ";
}
}

if(!(sprintf("%01.0d", $difference/(60*60*24))) && sprintf("%01.0d", $difference/(60*60)))
{
$hours = sprintf("%01.0d", $difference/(60*60));
$difference -= $hours*(60*60);

if($hours > 1)
{
print "$hours hours ";
}
else
{
print "$hours hour ";
}
}

if(!(sprintf("%01.0d", $difference/(60*60*24))) && sprintf("%01.0d", $difference/60))
{
$minutes = sprintf("%01.0d", $difference/60);

if($minutes > 1)
{
print "$minutes minutes ";
}
else
{
print "$minutes minute ";
}
}

print "ago</span><br>";
}

print "$desc</p>\n<div class=\"hr\">&nbsp;</div>\n";
}
}

?>

Thanks again

How can I prevent the less than and greater than signs in the username field, and message on the post?    As well as slashes. / \.

Code: [Select]
<form method="post" action="" id="reply">
<script type="text/javascript">
function hi(id){
var val = id.options[id.selectedIndex].value;
var text = id.options[id.selectedIndex].text;
if (val.length != 0){document.getElementById('user').value = text;hide('passrow');}
else {
document.getElementById('user').value = '';
document.getElementById('passrow').style.cssText = '';
}
}
</script>

<div id="userpass" style="background: #000;">
<table style="border: 2px solid #252564; background: #1F1F5D;" width="100%" cellpadding="0" class="quick_userpass">
<tr>
<td background="/images/bg3.jpg" height="26px"><font face=arial size=2 color="white">&nbsp;&nbsp;&nbsp;<b>Your Name or Nickname</b></td>
</tr>
<tr>
<td><input size=50 name="user" id="user" value="" style="margin-left: 10px;"></td>
</tr>
<tr><td background="/images/bg3.jpg" height=26px></td></tr>
</table>

<div id="passrow" style="">
<p>
<table width=100% cellpadding=0 class="quick_userpass" style="border: 2px solid #252564; background: #1F1F5D;">
<tr><td background="/images/bg3.jpg" height=26px style=""><font face=arial size=2 color="white">&nbsp;&nbsp;&nbsp;<b>Password (optional)</b></td></tr>
<tr><td style=""><input size=50 name="pass" id="pass" type="password" style="margin-left: 10px;"  value=""></td></tr>
<tr><td background="/images/bg3.jpg" height=26px></td></tr>
</table>
</p>
</div>

<p>
<table width=100% cellspacing=0 cellpadding=4 class="quick_userpass" style="border: 2px solid #252564; background: #1F1F5D;">
<tr bgcolor="#121236"><td><font face=arial size=2 color="white"><b>Enter your message here</b></font></td></tr>
<tr><td><center><textarea id="quickreply" name="message" rows=10 cols=50 wrap="VIRTUAL" ></textarea></center></td></tr>
</table>
<div id="preview" style="display: none;"></div>
</p>
<br />
<center>
<font face=arial size=2>When you're happy with your message, click:</font>
<div id="javano"><input type="submit" value=" Post Message "></div>
</center>
<input type="hidden" name="tid" value="<?php echo $_GET["tid"];?>" />
</div>
</form>

That is the code I'm using for User/Pass/message fields.

Hi all.

This seems like a pretty basic function but I can't work it out.

I'm developing a WordPress site and want to list posts (products) by category. I'm using Advanced Custom Fields and have set up the taxonomy of 'category'.

I just want to produce a heading for that category and then list all of the posts with that category assigned.

Please see below functions.php excerpt and section-archive.php excerpt.

Can anyone please help??? Massive good karma if you can.

----------------------- functions.php --------------------------------------

//Assign Category to Products

function taxonomy ()
{

    $args = array (
    
        'labels' => array(
            
            'name' => 'Category',
            'singular_name' => 'Category',
        ),    
        'public' => true,
        'hierarchical' => true, 
    
    );
    
    register_taxonomy('name', array('products'), $args);

};
add_action('init', 'taxonomy');

?>

------------------------- section-archive.php ------------------------------------------------

<?php if(have_posts()):while(have_posts()): the_post();?>

  

****** if product category= this

***** Category heading

****** Posts

******* Else

****** if product category= this2

***** Category heading

****** Posts

**** etc

 

 <div class="prod-listing">
    
        <div class="align-top d-flex">
       
            <div class="blog-content">
        
            <h2><?php the_title();?></h2>
        
            <?php the_content();?>
        
            </div>
            
        </div>
    
    </div>
    
<?php endwhile; else: endif;?>

 

 

 

Hello Everyone,

I'm not a programmer, so please bear with me.

I have a form, and on submit, need for it to send the data 1. to formmail.cgi (a PERL script) that emails me the information and then 2. sends the data to a shopping cart script called phpcart.php

I'm told the best way to do this, is to have the forms ACTION post to a php script, which executes the two scripts above.

I imagine something like this:

<?php
send data to formmail.cgi.  When finished
send data to phpcart.php
exit
?>

I've installed a few PHP applications on my site, but writing code is beyond me.

Can anyone help?

I would surely appreciate it.

James

I have a self-built blog website, done with PHP and MySQL. How to write the posts offline? How is it done? Which tools are used?   Any suggestions?

I've added a download button to all of my posts using custom fields in wordpress. I know there is an easier way just not sure how. Right now I have to add the custom field on each post, instead I'd like to just have a download button (with css) automatically on all posts (download button will be going to the same url on each post).

My current code
Code: [Select]
<div id="downloadbutton">
<?php if(get_post_meta($post->ID, "download_link", $single = true) != ""){ ?>
    <a href="<?php echo get_post_meta($post->ID, "download_link", $single = true); ?>"<img src="http://www.MYSITE.com/images/downloadbutton.png" border="0"></a>
<?php } ?>
</div>
Appreciate the help!

Hi folks, i have been playing with a script i downloaded from the net and have made some progress with it, however i have a couple of issues which i cannot figure out.

There are two undefined variables which keep cropping up, and i cant figure out why or how to deal with it.

<?php
include('dbcon.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'])."','99Points','".$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'])."','99Points','".$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
   {
i have highlighted the two variables which are showing as undefined.

The javascript code (not complete script) which goes in hand with this script is:

Code: [Select]
<script type="text/javascript">

// <![CDATA[

$(document).ready(function(){

$('#shareButton').click(function(){

var a = $("#watermark").val();
if(a != "What's on your mind?")
{
$.post("posts.php?value="+a, {

}, function(response){

$('#posting').prepend($(response).fadeIn('slow'));
$("#watermark").val("What's on your mind?");
});
}
});

$('a.more_records').livequery("click", function(e){

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

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

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

});

});
Does anyone have any idea on how or what i can do to stop these error messages appearing?
Any help would be appreciated...