|
$self = $_SERVER['PHP_SELF'];
// Connect
$conn = mysql_connect($hnam,$unam,$pnam) or die(mysql_error());
$rs = mysql_select_db($dnam, $conn) or die(mysql_error());
// Select Data
$sql = "select * from cms_menu where menuCategory='yof' order by menuOrder asc";
// Execute Query
$rs = mysql_query( $sql, $conn ) or die(mysql_error());
echo " ";
while( $row = mysql_fetch_array( $rs ) )
{
echo ( "![" . $row["menuName"] . "](" . $row["menuIMG"] . ") " );
}
echo " ";
?> |
$self = $_SERVER['PHP_SELF'];
$appName = $_POST['appName'];
$appDOB_Day = $_POST['appDOB_Day'];
$appDOB_Mon = $_POST['appDOB_Mon'];
$appDOB_Year = $_POST['appDOB_Year'];
$appWard = $_POST['appWard'];
$appPhone = $_POST['appPhone'];
$appEmail = $_POST['appEmail'];
$appType = $_POST['appType'];
$appCompleting = $_POST['appCompleting'];
$appAmount = $_POST['appAmount'];
$appFullCost = $_POST['appFullCOst'];
$appDescription = $_POST['appDescription'];
$appBreakdown = $_POST['appBreakdown'];
$appSporting = $_POST['appSporting'];
$appCultural = $_POST['appCultural'];
$appRecreational = $_POST['appRecreational'];
$appVolunteering = $_POST['appVolunteering'];
$appSafe = $_POST['appSafe'];
$appHealth = $_POST['appHealth'];
$appEnjoy = $_POST['appEnjoy'];
$appEconomic = $_POST['appEconomic'];
$appPositive = $_POST['appPositive'];
$appHowInvolved = $_POST['appHowInvolved'];
$appYPBenefit = $_POST['appYPBenefit'];
$appBefore = $_POST['appBefore'];
$appBeforeHow = $_POST['appBeforeHow'];
$appChequeTo = $_POST['appChequeTo'];
$appSupportWorker = $_POST['appSupportWorker'];
$appAgency = $_POST['appAgency'];
$appSupportContact = $_POST['appSupportContact'];
?>
if( $appName and $appDOB_Day and $appDOB_Mon and $appDOB_Year and $appWard and $appPhone and $appType and $appCompleting and $appAmount and $appFullCost and $appDescription and $appBreakdown and $appHowInvolved and $appYPBenefit and $appBefore and $appBeforeHow and $appChequeTo )
{
$conn=mysql_connect( "$hnam", "$unam", "$pnam" )
or die(mysql_error());
$rs = mysql_select_db( "$dnam", $conn )
or die(mysql_error());
$sql="insert into cms_yof_apps ( appName, appDOB_Day, appDOB_Mon, appDOB_Year, appWard, appPhone, appEmail, appType, appCompleting, appAmount, appFullCost, appDescription, appBreakdown, appSporting, appCultural, appRecreational, appVolunteering, appSafe, appHealth, appEnjoy, appEconomic, appPositive, appHowInvolved, appYPBenefit, appBefore, appBeforeHow, appChequeTo, appSupportWorker, appAgency, appSupportContact )
values ( '$appName', '$appDOB_Day', '$appDOB_Mon', '$appDOB_Year', '$appWard', '$appPhone', '$appEmail', '$appType', '$appCompleting', '$appAmount', '$appFullCost', '$appDescription', '$appBreakdown', '$appSporting', '$appCultural', '$appRecreational', '$appVolunteering', '$appSafe', '$appHealth', '$appEnjoy', '$appEconomic', '$appPositive', '$appHowInvolved', '$appYPBenefit', '$appBefore', '$appBeforeHow', '$appChequeTo', '$appSupportWorker', '$appAgency', '$appSupportContact' )";
$rs = mysql_query( $sql, $conn );
if($rs){ echo( "Application Submitted" ); }
}
?>
|