Useful PHP snippets

[ShadowedFigure]

This is just a few snippets that I commonly use in my scripts, I will notate wether I made it or I got it from a source:

MySQL Error Checking: This is a useful funtion for debugging you scrits when in the process of development (Public Source)

function check_mysql()
{
if (mysql_errno() > 0)
{
die("<BR> MySQL error " . mysql_errno() . ": " . mysql_error());
}
}


Connect to Database: Decently formated connect function (Public source)

$db = mysql_connect("localhost", "chris263", "jedmeyer");
if (!$db)
{
die("Failed to open connection to MySQL server.");
}

mysql_select_db("chris263_net");
check_mysql();


Portal News system: Good for anyone who wants a bulletin style news system (Custom script)


//Querry news database (3 parts)
//Get dates (part 1)
$query = "SELECT date FROM portal_news";
$result = mysql_query($query);
check_mysql();
$num = mysql_num_rows($result);
$date = mysql_fetch_row($result);

//Get Headers (part 2)
$query = "SELECT header FROM portal_news";
$result = mysql_query($query);
check_mysql();
$header = mysql_fetch_row($result);

//Get Bodies (part 3)
$query = "SELECT body FROM portal_news";
$result = mysql_query($query);
check_mysql();
$body = mysql_fetch_row($result);

//Display News
$i = 0;
while ($num - $i >= 1);
{
echo("<div class='news'> <div class='newsHeader'>".$header[$i]."</div><br> <div class='newsBody'>".$body[$i]."</div>
</div>");
$i++;
}