Announcements on a side box on website

[RPS]

Sorry RPS i have spent the last hour reading and changing the code as stated in this topic but still no luck.

 

the code i am using is here

 

http://www.cg-computers.co.uk/announcements.php

- Read post # 36. The guy has the exact same problem as you. He fixed it by using a php extension. If you did that, then there is probably something wrong with php.

 

Maybe try replacing that file with <? phpinfo(); ?> and see if anything comes up.

[Bucket]

My Version:

 

<?
$x=1; // requested edit
// truncate the text to only 65 chars, add ... to the end
function truncate($text) {
   $text = substr($text,0,60);
   $text = substr($text,0,strrpos($text,' '));
   $text = $text."...";
   return $text;
}

// format the date to mm/dd/yyyy
function formatdate($date) {
   $year = substr ($date, 0, 4);
   $month = substr ($date, 5, 2);
   $day = substr ($date, 8, 2);
   return $month.'/'.$day.'/'.$year;
}

// limit the number of announcements to return
$limit = 2;

 echo('<p class="header">Announcements</p>');
require '/home/USERNAME/public_html/WHMCSLINK/configuration.php';
$link = mysql_connect($db_host,$db_username,$db_password);
mysql_select_db($db_name);

$result = mysql_query("SELECT * FROM tblannouncements WHERE published='on' ORDER BY id DESC LIMIT ".$limit);
while($data = mysql_fetch_array ($result))
{
$id = $data["id"];
$date = $data["date"];
$title = $data["title"];
$announcement = $data["announcement"];
$date = fromMySQLDate($date);
 echo("<p><font color=#cccccc>$date</font> - <b>$title</b> <br>$announcement</p>");
 echo('<a href="/whmcs/announcements.php?id='.$id.'">More Info</a><br>');
 echo('<hr />');
}
if(!$x) echo '<p>News & Announcements: <a href="announcements.php">View More</a></p>';
if($x) echo '<p>News & Announcements: <a href="announcements.php">View More</a></p>';
?> 

[AxlF]

...
 echo("<p><font color=#cccccc>$date</font> - <b>$title</b> ...

 

I don't wanna bash you. This is only a hint:

 

The <font> tag in HTML is deprecated

[Parnian]

My Version:

 

<?
$x=1; // requested edit
// truncate the text to only 65 chars, add ... to the end
function truncate($text) {
   $text = substr($text,0,60);
   $text = substr($text,0,strrpos($text,' '));
   $text = $text."...";
   return $text;
}

// format the date to mm/dd/yyyy
function formatdate($date) {
   $year = substr ($date, 0, 4);
   $month = substr ($date, 5, 2);
   $day = substr ($date, 8, 2);
   return $month.'/'.$day.'/'.$year;
}

// limit the number of announcements to return
$limit = 2;

 echo('<p class="header">Announcements</p>');
require '/home/USERNAME/public_html/WHMCSLINK/configuration.php';
$link = mysql_connect($db_host,$db_username,$db_password);
mysql_select_db($db_name);

$result = mysql_query("SELECT * FROM tblannouncements WHERE published='on' ORDER BY id DESC LIMIT ".$limit);
while($data = mysql_fetch_array ($result))
{
$id = $data["id"];
$date = $data["date"];
$title = $data["title"];
$announcement = $data["announcement"];
$date = fromMySQLDate($date);
 echo("<p><font color=#cccccc>$date</font> - <b>$title</b> <br>$announcement</p>");
 echo('<a href="/whmcs/announcements.php?id='.$id.'">More Info</a><br>');
 echo('<hr />');
}
if(!$x) echo '<p>News & Announcements: <a href="announcements.php">View More</a></p>';
if($x) echo '<p>News & Announcements: <a href="announcements.php">View More</a></p>';
?> 

 

This code has a problem! in echo's, you need to put your parameters like this :

". $title ."

So, this :

echo("<p><font color=#cccccc>$date</font> - <b>$title</b> <br>$announcement</p>");

Would just display $date, $title and $announcement. But if you change it to this :

echo("<p><font color=#cccccc>". $date ."</font> - <b>". $title ."</b> <br>". $announcement ."</p>");

It works completly. I have tested this and I wanted to help users that don't have PHP experience and are stuck on this.

Hope it helps...

[Bucket]

What do you think of my code. The only thing is that it shows the WHOLE announcement... I do not know how to fix it...

 

Lol... if someone can please post it.

[RPS]

What do you think of my code. The only thing is that it shows the WHOLE announcement... I do not know how to fix it...

 

Lol... if someone can please post it.

- Look at my first post:

 

// truncate the text to only 65 chars, add ... to the end
function truncate($text) {
   $text = substr($text,0,60);
   $text = substr($text,0,strrpos($text,' '));
   $text = $text."...";
   return $text;
} 

[Bucket]

Can you post the my version with the 65 text limit added?

[Bucket]

Updated with 65 character Limit:

 

<?
$x=1; // requested edit
// truncate the text to only 65 chars, add ... to the end
function truncate($text) {
   $text = substr($text,0,60);
   $text = substr($text,0,strrpos($text,'   '));
   $text = $text."...";
   return $text;
}

// format the date to mm/dd/yyyy
function formatdate($date) {
   $year = substr ($date, 0, 4);
   $month = substr ($date, 5, 2);
   $day = substr ($date, 8, 2);
   return $month.'/'.$day.'/'.$year;
}

// limit the number of announcements to return
$limit = 2;

 echo('<p class="header">Announcements</p>');
require '/home/USERNAME/public_html/WHMCSLINK/configuration.php';
$link = mysql_connect($db_host,$db_username,$db_password);
mysql_select_db($db_name);

$result = mysql_query("SELECT * FROM tblannouncements WHERE published='on' ORDER BY id DESC LIMIT ".$limit);
while($data = mysql_fetch_array ($result))
{
$id = $data["id"];
$date = $data["date"];
$title = $data["title"];
$announcement = $data["announcement"];
$date = fromMySQLDate($date);
 echo("<p><font color=#cccccc> '.$date.' </font> - <b> '.$title.' </b> 
<br> '.$announcement.' </p>");
 echo('<a href="/whmcs/announcements.php?id='.$id.'">More Info</a><br>');
 echo('<hr />');
}
if(!$x) echo '<p>News & Announcements: <a href="announcements.php">View More</a></p>';
if($x) echo '<p>News & Announcements: <a href="announcements.php">View More</a></p>';
?> 

[messer]

small modification if someone want to use mysqli instead mysql

 

<?PHP
$x=1;
// truncate the text to only 65 chars, add ... to the end
function truncate($text) {
   $text = substr($text,0,65);
   $text = substr($text,0,strrpos($text,' '));
   $text = $text."...";
   return $text;
}

// format the date to mm/dd/yyyy
function formatdate($date) {
   $year = substr ($date, 0, 4);
   $month = substr ($date, 5, 2);
   $day = substr ($date, 8, 2);
   return $year.'/'.$month.'/'.$day;
}

// limit the number of announcements to return
$limit = 2;


require '/home/user/public_html/whmcs/configuration.php';
$sql = new mysqli($db_host,$db_username,$db_password,$db_name);

$result = $sql->query("SELECT * FROM tblannouncements WHERE published='on' ORDER BY id DESC LIMIT ".$limit);

while ($row = $result->fetch_object())
{
$id = $row->id;
$date = $row->date;
$announcement = truncate($row->announcement);
$date = formatdate($date); 

   echo'<p><span>'.$date.'</span> - '.$announcement.' <a href="/whmcs/announcements.php?id='.$id.'"><img src="/images/more.gif" alt="more info" /></a></p>';
   echo'<hr />';
   $x=false;
}
$result->close();
$sql->close();


if(!$x) echo '<p>News & Announcements: <a href="announcements.php">View More</a></p>';
if($x) echo '<p>News & Announcements: <a href="announcements.php">View More</a></p>';
?>

[epicseeds]

sorry to bring an old thread back to life, but this seems like a neat feature. I am just a bit confused how to do this - at first I thought you were just supposed to copy the code and put it somewhere inside you index.html and change the code around a bit...but this is wrong lol apparently it is supposed to be in its own .php file?

 

I just made its own .php file - now how do i get it to display on one of my webpages?! lol...sorry I am completely ignorant in how these things work!

[sgrayban]

You can use something like this...

 

{php}
echo file_get_contents("/path-to/remote.php");
{/php}

[Greenix]

I have a simple .html page and for obvious reasons don't want to convert to .php extensions. How would I go about including the announcements via WHMCS?

 

Thanks!

Meredith

[RPS]

You would have to use javascript to grab the content, and display it that way. Check out something like this: http://www.javascriptkit.com/dhtmltutors/ajaxincludes.shtml

[Greenix]

That's a help!!

I was searching and saw a few similar scripts but they weren't working out.

Thanks, I'll try it.

[nimafire]

Hello

how can i change unicod to utf-8 ?

becasue it show me

 

وزارت خزانه داری آمریکا تØ*ریم های اینترنتی علیه کاربران ایران سودان Ùˆ کوبا را لغو کرده Ùˆ از شرکت های ارایه دهنده Û

[RPS]

Pretty sure you need to do that within your HTML template. Applying this mod shouldn't require you to change anything like that.

[Greenix]

I just found some great ones today - but this is the one I like the most. It's nice to be able to upgrade and then you can remove the linkbacks which doesn't always look good in certain circumstances. Plus you can use with multiple sites and this can help you easily tie your network together.

 

http://www.rssinclude.com/

[Riply]

You could always use a RSS feedburner or something like that? I am using wordpress and will use a RSS feed reader/publisher plugin to grab the announcements and put them on the front-end.

[Greenix]

That's about the only thing I miss with CMS are the super handy collections of extensions. I did away with Joomla on some new sites as I was tired of the security problems, but now I have to go and search out the old fashioned way for my plain ole html pages. But I have to say, (knock on wood) not one of them has been hacked from external sources as long as I've had them since 1998

 

thanks for the rss feedburner tip.

[Nimitz1061]

I have a simple .html page and for obvious reasons don't want to convert to .php extensions. How would I go about including the announcements via WHMCS?

 

Thanks!

Meredith

 

Javascript? Sheesh.

 

Just configure your system to parse html files for PHP code - then follow the instructions previously given..

 

David

[Greenix]

Is javascript awful now? talk to me...

[sajthosting]

Thanks for this tutorial, it helps alot.

[luangjokaj]

Thanks for this. But for example if i want the news box in another language and not in default language? How can i do that?

[urbee]

I also cannot fix the encoding (scarons). They work on the website (joomla) they work in whmcs, but with this link the announcements are not encoded correctly on the website.

[Buzz]

I am wanting to display my announcements in my header banner image and want it to scroll through the announcements

I was looking for an rss feed to work with my site and whmcs to pull announcements from whmcs and display it in a certain area of my website the area is a small box so it is going to be limited to how much information is displayed so I was thinking that rss feeds would work better this way I have have it scroll through it or something

Edited September 26, 2011 by Buzz