Gotta Love me!

Sunday, July 06, 2008

« x Blog x Philes x »

My First MySql Project has begub

My First MySql php application is alive!

Heres' the code:

include("../head.inc");
$username="afourthd_afourth";
$password="scootre";
$database="afourthd_hawkwynd";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query ="Select Event_Title, DATE_FORMAT(Event_Date_Start,'%M %D, %Y') AS
Start_Date,
DATE_FORMAT(Event_Date_End,'%M %D, %Y') AS
End_Date,Event_Time_Start,Event_Time_End,
Event_Location,Event_Address,Event_City,Event_State,Event_Zipcode,Event_Host
,
Event_Price,Event_Description,Event_Contact_Name,Event_Contact_Phone,Event_C
ontact_Email,
Event_Contact_URL,Event_Events,Event_WWW_URL,Event_Submit_Email_Address from
events
WHERE DATE_SUB(CURDATE(), INTERVAL 60 DAY)<= Event_Date_Start ORDER BY
Start_Date DESC LIMIT 0, 30";

$result=mysql_query($query);
$num=mysql_numrows($result);

mysql_close();

// Let 'er rip!

$i=0;
while ($i < $num) {
$Event_Title=mysql_result($result,$i,"Event_Title");
$Event_Date_Start=mysql_result($result,$i,"Start_Date");
$Event_Date_End=mysql_result($result,$i,"End_Date");
$Event_Time_Start=mysql_result($result,$i,"Event_Time_Start");
$Event_Time_End=mysql_result($result,$i,"Event_Time_End");
$Event_Location=mysql_result($result,$i,"Event_Location");
$Event_Address = mysql_result($result,$i,"Event_Address");
$Event_City = mysql_result($result,$i,"Event_City");
$Event_State = mysql_result($result,$i,"Event_State");
$Event_Zipcode = mysql_result($result,$i,"Event_Zipcode");
$Event_Host = mysql_result($result,$i,"Event_Host");
$Event_Price = mysql_result($result,$i,"Event_Price");
$Event_Description = mysql_result($result,$i,"Event_Description");
$Event_Contact_Name = mysql_result($result,$i,"Event_Contact_Name");
$Event_Contact_Phone =
mysql_result($result,$i,"Event_Contact_Phone");
$Event_Contact_Email =
mysql_result($result,$i,"Event_Contact_Email");
$Event_Contact_URL = mysql_result($result,$i,"Event_Contact_URL");
$Event_Events = mysql_result($result,$i,"Event_Events");
$Event_WWW_URL = mysql_result($result,$i,"Event_WWW_URL");
$Event_Submit_Email_Address =
mysql_result($result,$i,"Event_Submit_Email_Address");



echo "";
echo "";
echo "";
echo "";

if ($Event_Date_End){
echo "";
}

echo "";

// check for some digits at the start of the string, on match echo the url
to mapquest.

if (ereg ("^[0-9]+.*", $Event_Address)) {

// Build me an army worthy of Mordor..

$strURLToMapQuest="http://www.mapquest.com/maps/map.adp?country=USA&address=
".$Event_Address

."&state=".$Event_State."&city=".$Event_City."&county=".$Event_County."&zipc
ode=".$Event_Zipcode
."&countryId=250&zoom=6";

echo "";

}else{
echo "";
}

echo "";
echo "";
echo "";
echo "";
if ($Event_Contact_Email){echo "";}
if ($Event_Contact){echo "";}
if ($Event_Events){echo "";}
if ($Event_WWW_URL){echo "";}
echo "

Event Title	class=events>$Event_Title
Hosted by:	class=events>$Event_Host
Start Date	class=events>"; echo $Event_Date_Start." at ".$Event_Time_Start; echo "
End Date	class=events>".$Event_Date_End."
Location	class=events>$Event_Location
Address	class=events>$Event_Address href='$strURLToMapQuest'>* MapQUEST.com *
Address	class=events>$Event_Address
City, State, Zip	class=events>$Event_City, $Event_State $Event_Zipcode
Description	style=\"text-align:justify;\">$Event_Description
Contact Name	class=events>$Event_Contact_Name
Contact Phone	class=events>$Event_Contact_Phone
Contact Email	href='mailto:$Event_Contact_Email'>$Event_Contact_Email
Contact URL	href='$Event_Contact_URL'>HhtmlEncode('$Event_Contact_URL')
Events	class=events>$Event_Events
URL	class=events>href='$Event_WWW_URL'>".urldecode($Event_WWW_URL)."

";

$i++;
}

echo "

";

?>