New Posting Features - New Posts show up in external website.

Hey Guys,

Well I have been looking for something like this everywhere but just couldn't find it, being a basic coder I just couldn't get my head round it, but I tried my best and this is the outcome.

What is it?
Maybe you have a forum and a HTML/PHP website (externally) and you want it to show the latest post in a little navbit or what not, well this is the answer. It's something I whipped up in a few minutes so don't expect anything awesome.

It only shows the latest post, ideal for a little in line frame in the corner of your site.

| 2x Files
|- db.php
|- index.html


Ok, first you need to create a new PHP file called "db.php" (I advise something more harder to guess ?*$&*hy8^5t) once done, put this code in. Make sure you edit it to your MYSQL settings.

PHP Code:

<?
$dbh=mysql_connect ("localhost", "YOUR_DB_USER", "YOUR_DB_PASS***WORD") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("YOUR_DB_NAME");
$mysql_table=post
?>

After that create "index.php" or what ever you want to call it.

PHP Code:

<style type="text/css">
<!--
.style1 {
    font-size: 12px;
    font-weight: bold;
    font-family: Verdana, Arial, Helvetica, sans-serif;
}
.style2 {
    font-size: 11px;
    font-family: Verdana, Arial, Helvetica, sans-serif;
    font-style: italic;
}
body,td,th {
    color: ffffff;
}
body {
    background-color: #797979;
}

-->
</style>
<span class="style1">
<?
include("EDIT THE FILE PATH TO THE DB.php FILE");
$query = mysql_query("SELECT * FROM $mysql_table");
$query = mysql_query("SELECT * FROM `$mysql_table`
ORDER BY `postid` DESC
LIMIT 0 , 1");
if(mysql_error()) {
print(mysql_error());
}
while($row = mysql_fetch_array($query)) {


echo "

".$row['title']." -
".$row['username']."
<p>
";
}
?>
</span>









<span class="style2">
<?
include("EDIT THE FILE PATH TO THE DB.php FILE");
$query = mysql_query("SELECT * FROM $mysql_table");
$query = mysql_query("SELECT * FROM `$mysql_table`
ORDER BY `postid` DESC
LIMIT 0 , 1");
if(mysql_error()) {
print(mysql_error());
}
while($row = mysql_fetch_array($query)) {


echo "

".$row['pagetext']."
<p>
";
}
?>
</span>

Then upload, make sure you change the file paths, like I said this is not good at all, but might come in handy for some. It is easy to install and I do expect to be making upgrades (to post more than 1 post etc).

You can add more info to the 'index.php' file, for example the IP address it was made posted by, by putting.

PHP Code:

".$row['ipaddress']." 


You can replace ipaddress and put anything, these are your options.

postid
threadid
parentid
username
userid
title
dateline
pagetext
allowsmilie
showsignature
ipaddress
iconid
visible
attach
infraction
reportthreadid

Have fun, I know this is a sort of bad mod so don't flame . I am new to this and it's just the start .

Jac

[EnIgMa1234]

Just to let you know, including global.php will connect to the database. Also you can use templates to do this. If you would like to fix up this code, PM me for a guide

[icemanic]

please do clean up/fix up this code, it seems useful

[waller99]

I am using joomla and I could use this. Thanks for the effort.

[JacBowen]

I'm working on a new version whole different coding but with same feature, should be coming very soon.

Jac

[LouiseDM]

good im looking to post vb stuff on my external website so thanks for this little code

[Safice]

Uhmm, what if i want it to display only ONE forum's new posts.

[ShadowOne]

Nice MOD, Not Something I Would Need Though....

[Marco van Herwaarden]

What makes this different then using the default RSS Feed option?

Also, please upload the files used in a zip-file. Al modifications should be uploaded in a zip-file.

[MiahBeSmokin420]

ya thats about the most easiest way to have your DB hacked