Blog Changes - 1st April
It’s the 1st of April, well almost the 2nd and i thought I’d better get down to some drastic updates. There’s been vast changes and security upgrades to the site. This is the first few hours I’ve had to actually sit down and have a look at the security side of the blog. The first main worry was cursed spam posts, a few were traced a couple of weeks back and removed, I’ve now made it a requirement to register before posting. Sorry but it’s really annoying to keep removing spam otherwise.
Other issues were also the registering side of the Blog, it was a bit basic. So now you can choose your own password and other details like emails and im’s etc. I also added a reCAPTCHA to the end of it for more anti spam.
As for the Accounts side of the blog, custom avatar uploads are now availible, just go to your account page and near the bottom you’ll find a browse button for custom avatars. 
Posting is now more efficient with AJAX posting and updating, so there’s no need to refresh on the blog anymore 
I think that’s about it, Enjoy 
Jake
P.S If there’s anything to suggest drop a comment in here. Thanks
Fix IE. CSS changer for fixing IE problems
As you should already know, internet explorer is a terrible browser. Never the less its popular and you will need to make your website compatible with it. To fix the problems that come with this browser without having to compromise on how you would view it with any other browser is very simple.
the code is as follows;
-
<!–[if IE]>
-
<link href="ie.css" mce_href="ie.css" rel="stylesheet" type="text/css" />
-
<![endif]–>
This needs to be included in the head.
hope this helps!
please not that you only need to include the changes, not the entire CSS document.
PHP simple pagination script
This is a simple script that will allow you to have multiple content on one page and allow the user to pick specific areas of that content in which they would like to view.
i believe the concept is called pagination.
This script will be on one page only.
-
-
if($page =="0"){
-
$page=1;
-
}
-
if($page =="1"){
-
echo ' '; //Content for page two would go here}
-
elseif ($page =="2"){
-
echo ' '; //Content for page two would go here
-
}
-
echo '
-
<a href="work.php?page=1"><<</a>
-
<a href="work.php?page=1">1</a>
-
<a href="work.php?page=2">2</a>
-
<a href="work.php?page=2">>></a>
-
';
If you wish to extend the amount of pages then just copy the if statement and change the equal too number to suite the new page. also add another link to the bottom following the same variable name. This script is small and perfect for a limited amount of pages. but if you wish for more than a few you will need something a little more advanced.
PHP Post to page
This script will allow us to post a comment to a page on your website. This works much like a simple forum and will display both the comment and the user who posted the comment.
First we will need to set up a mysql connection which goes as follows,
-
$username="—"; // Mysql username
-
$password="—"; // Mysql password
-
$db_name="—"; // Database name
-
-
// Connect to server and select databse.
-
mysql_connect("$host", "$username", "$password")or die("cannot connect");
-
mysql_select_db("$db_name")or die("cannot select DB");
This will allow us to connect to the mysql database. Please make sure you have this enabled and you have a free table or this script will not work!
Next we will set up the mysql table. If you are unsure about how to set up tables then go find out! The table will need to have 3 feilds. The first is your primary key. Make this an auto incriment and it should start with 1. The second will be the comment and the 3rd will be the user. The user will be taken from the login script that you should allready have integrated into your website if not then i shall post a simple user login script to the site.
ok lets set up the first page for submitting the comments,
-
session_start();
-
/**
-
* @author JayWeb
-
* @copyright 2009
-
*/
-
-
if(isset($_SESSION['myusername']) && ($_REQUEST['comment']=="") && $_SESSION['mylevel']=="admin")
-
{
-
echo '
-
<form action="' . $_SERVER['PHP_SELF'] .'?page=sub" method="post">';
-
echo 'please insert your comment: ';
-
echo '<textarea cols="40" rows="6" name="comment"></textarea>
-
';
-
echo '';
-
echo '</form>
-
-
';
-
}
-
if(isset($_SESSION['myusername']) && $_REQUEST['comment']!="")
-
{
-
$query="insert into anouce values('$_REQUEST[comment]','$_SESSION[myusername]',NULL)";
-
echo 'comment: ' . $_REQUEST['comment'] . ' User : ' . $_SESSION['myusername'];
-
$result=mysql_query($query);
-
$_REQUEST['comment']=="";
-
echo '';
-
}
This page will look and if a comment has not been submitted then it will display the input form, if it has it will post the comment to the next page. please note that if the session “user” is not admin then the script will not appear. This ensures that only admins will be able to post. This can be changed by simply changing the “= admin”. Also note that there needs to be a username session active to take the current username and upload it with the comments.
The last page will go as follows
-
session_start();
-
/**
-
* @author JayWeb
-
* @copyright 2009
-
*/
-
$query2="select * from anounce";
-
$rt=mysql_query($query2);
-
echo mysql_error();
-
echo '';
-
echo '
-
<table id="comments" border="0">';
-
while($nt=mysql_fetch_array($rt)){
-
echo '
-
<tbody>
-
<tr>
-
<td>Comment</td>
-
<td>User</td>
-
</tr>
-
';
-
echo '
-
<tr>
-
<td>' . $nt[comment] . '</td>
-
<td>' . $nt[user] . '</td>
-
</tr>
-
';
-
}
-
echo '</tbody></table>
-
';
-
echo '';
If you have any questions, leave a comment
Thanks!
