-dg
http://www.rexruff.com
On Nov 2, 2004, at 4:58 AM, Garth Hapgood - Strickland wrote:
Well my page doesnt have any of the spoken about elements on it yet, because I am not clear as to go about it.
The fields I speak of are things that need to be added extra to my page.
Here is my pages code so far...........
<?php
require('includes/application_top.php');
require('registration_globals.php');
require('includes/form_check.js.php');
?>
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Matchmakers - empowerment opportunities network</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="style.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d .MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
<!-- Hide from old browsers function error_popup() { newwin = window.open("error_popup.php","sss","height=470,width=450") } // end hiding -->
//-->
</script>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- header //-->
<?php require('includes/header.php'); ?>
<!-- header_eof //-->
<!-- body //-->
<table width="100%" border="0" cellspacing="2" cellpadding="5" background="images/page_bg.gif">
<tr>
<td valign="top"><table width="130">
<tr>
<td width="120" align="right" class="pagetitle"><br>registration<img src="images/register_image.gif"></td>
</tr>
</table></td>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr valign="top">
<p><br><br><b>Fill in all the fields below correct and accurately, then click "Register Now.</b><br><br>
</tr>
<tr>
<td><table width="65%">
<form title="register" method="post" onsubmit="return check_form();">
<?php
if (isset($submit) && $submit == "Register Now"){
if (strlen($business_name) == 0) {}
else if (strlen($business_owner) == 0) {}
else if (strlen($street_address) == 0) {}
else if (strlen($suburb) == 0) {}
else if (strlen($city_town) == 0) {}
else if (strlen($province_desc) == 0) {}
$email_popup(); (the code i was trying to use to call popup window)
}
else {
$insertquery = "INSERT INTO business
(BusinessName, BusinessOwner, StreetAdress, Suburb, CityTown, ProvinceID, StreetCode, PostalAddress, PostalCode, WebsiteAddress, IndustryID, IndustryOther, BusinessAge, AnnualTurnoverID, EmpowermentProfileID, BEEScoreCardID, PreferredLocationID, PreferredProductService, PreferredMatchPartner, PreferredAgeID, PreferredTurnoverID, PreferredEmpowermentProfileID, DateRegistered, MarketSourceID)
VALUES
($business_name, $business_owner, $street_address, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',)";
echo "Your registration has been submitted"; }
?>
<tr>
<td class="formAreaTitle">.: Business Contact Details</td>
</tr>
<tr>
<td class="main">
<table border="0" width="100%" cellspacing="4" cellpadding="0" class="formArea">
<tr>
<td width="45%" align="right" class="content">Business Name:</td>
<td width="55%"><input class="content" type="text" size="35" maxlength="100" name="business_name"></td>
</tr>
<tr>
<td width="45%" align="right" class="content">Business Owner:</td>
<td width="55%"><input class="content" type="text" size="35" maxlength="100" name="business_owner"></td>
</tr>
<tr>
<td width="45%" align="right" class="content">Street Address:</td>
<td width="55%"><input class="content" type="text" size="35" maxlength="100" name="street_address"></td>
</tr>
<tr>
<td width="45%" align="right" class="content">Suburb:</td>
<td width="55%"><input class="content" type="text" size="35" maxlength="100" name="suburb"></td>
</tr>
<tr>
<td width="45%" align="right" class="content">City/Town:</td>
<td width="55%"><input class="content" type="text" size="35" maxlength="100" name="city_town"></td>
</tr>
<tr>
<td width="45%" align="right" class="content">Province:</td>
<td width="55%">
<select class="content" name="province_desc" id="select"><option value="">-- select one --</option>
<?PHP for($x=0;$x<$number_provinces;$x++)
{
echo('<option value="'.$rijprovinces["$x"]["ProvinceID"].'"');
echo('>'.$rijprovinces["$x"]["Description"].'</option>');
}
?>
</select>
</td>
</tr>
<tr>
<td width="45%" align="right" class="content">Street Code:</td>
<td width="55%"><input class="content" type="text" size="5" maxlength="4" name="street_code"></td>
</tr>
<tr>
<td width="45%" align="right" class="content">Postal Address:</td>
<td width="55%"><textarea rows="5" cols="35" class="content" name="postal_address"></textarea></td>
</tr>
<tr>
<td width="45%" align="right" class="content">Postal Code:</td>
<td width="55%"><input class="content" type="text" size="5" maxlength="4" name="postal_code"></td>
</tr>
<tr>
<td width="45%" align="right" class="content">Website Address:</td>
<td width="55%"><input class="content" type="text" size="35" maxlength="50" name="website_address"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="formAreaTitle">.: Business Information</td>
</tr>
<tr>
<td class="main" width="60%">
<table border="0" width="100%" cellspacing="4" cellpadding="0" class="formArea">
<tr>
<td width="45%" align="right" class="content">Industry:</td>
<td width="55%">
<select class="content" name="industry_desc" id="select"><option value="">-- select one --</option>
<?PHP for($x=0;$x<$number_industry;$x++)
{
echo('<option value="'.$rijindustry["$x"]["IndustryID"].'"');
echo('>'.$rijindustry["$x"]["Description"].'</option>');
}
?>
</select>
</tr>
<tr>
<td width="45%" align="right" class="content">Industry Other:</td>
<td width="55%"><input class="content" type="text" size="35" maxlength="100" name="industry_other"></td>
</tr>
<tr>
<td width="45%" align="right" class="content">Business Age (Years):</td>
<td width="55%"><input class="content" size="5" maxlength="4" type="text" name="business_age"></td>
</tr>
<tr>
<td width="45%" align="right" class="content">Annual Turnover:</td>
<td width="55%">
<select class="content" name="ann_turn_desc" id="select"><option value="">-- select one --</option>
<?PHP for($x=0;$x<$number_ann_turn;$x++)
{
echo('<option value="'.$rijann_turn["$x"]["AnnualTurnoverID"].'"');
echo('>'.$rijann_turn["$x"]["Description"].'</option>');
}
?>
</select>
</tr>
<tr>
<td width="45%" align="right" class="content">Empowerment Profile:</td>
<td width="55%">
<select class="content" name="empower_prof_desc" id="select"><option value="">-- select one --</option>
<?PHP for($x=0;$x<$number_empower;$x++)
{
echo('<option value="'.$rijempower["$x"]["EmpowermentProfileID"].'"');
echo('>'.$rijempower["$x"]["Description"].'</option>');
}
?>
</select>
</tr>
<tr>
<td width="45%" align="right" class="content">BEE Score Card:</td>
<td width="55%">
<select class="content" name="scorecard_desc" id="select"><option value="">-- select one --</option>
<?PHP for($x=0;$x<$number_scorecard;$x++)
{
echo('<option value="'.$rijscorecard["$x"]["BEEScoreCardID"].'"');
echo('>'.$rijscorecard["$x"]["Description"].'</option>');
}
?>
</select>
</tr>
</table>
</td>
</tr>
<tr>
<td class="formAreaTitle">.: Preferred Partner Information</td>
</tr>
<tr>
<td class="main" width="60%">
<table border="0" width="100%" cellspacing="4" cellpadding="0" class="formArea">
<tr>
<td width="45%" align="right" class="content">Preferred Product Service:</td>
<td width="55%"><textarea rows="5" cols="35" class="content" maxlength="255" type="text" name="preferred_product_service"></textarea></td>
</tr>
<tr>
<td width="45%" align="right" class="content">Preferred Match Partner:</td>
<td width="55%"><textarea rows="5" cols="35" class="content" maxlength="255" type="text" name="preferred_match_partner"></textarea></td>
</tr>
<tr>
<td width="45%" align="right" class="content">Preferred Location:</td>
<td width="55%">
<select class="content" name="prefer_location_desc" id="select"><option value="">-- select one --</option>
<?PHP for($x=0;$x<$number_provinces;$x++)
{
echo('<option value="'.$rijprovinces["$x"]["ProvinceID"].'"');
echo('>'.$rijprovinces["$x"]["Description"].'</option>');
}
?>
</select>
</tr>
<tr>
<td width="45%" align="right" class="content">Preferred Age:</td>
<td width="55%">
<select class="content" name="prefer_age_desc" id="select"><option value="">-- select one --</option>
<?PHP for($x=0;$x<$number_age;$x++)
{
echo('<option value="'.$rij_age["$x"]["AgeID"].'"');
echo('>'.$rij_age["$x"]["Description"].'</option>');
}
?>
</select>
</tr>
<tr>
<td width="45%" align="right" class="content">Preferred Annual Turnover:</td>
<td width="55%">
<select class="content" name="prefer_turnover_desc" id="select"><option value="">-- select one --</option>
<?PHP for($x=0;$x<$number_pref_turnover;$x++)
{
echo('<option value="'.$rij_pref_turnover["$x"]["PreferredAnnualTurnoverID"].'"');
echo('>'.$rij_pref_turnover["$x"]["Description"].'</option>');
}
?>
</select>
</tr>
<tr>
<td width="45%" align="right" class="content">Preferred Empowerment Profile:</td>
<td width="55%">
<select class="content" name="prefer_empower_desc" id="select"><option value="">-- select one --</option>
<?PHP for($x=0;$x<$number_pref_empower;$x++)
{
echo('<option value="'.$rij_pref_empower["$x"]["PreferredEmpowermentProfileID"].'"');
echo('>'.$rij_pref_empower["$x"]["Description"].'</option>');
}
?>
</select>
</tr>
<tr>
<td width="45%" align="right" class="content">Market Source:</td>
<td width="55%">
<select class="content" name="prefer_turnover_desc" id="select"><option value="">-- select one --</option>
<?PHP for($x=0;$x<$number_market_source;$x++)
{
echo('<option value="'.$rij_market_source["$x"]["PreferredAnnualTurnoverID"].'"');
echo('>'.$rij_market_source["$x"]["Description"].'</option>');
}
?>
</select>
</tr>
</table>
<tr>
<td align="right"><input type="submit" name="submit" value="Register Now"></td>
</tr>
</td>
<td width="60%">
</td> <tr> </tr> </form> </table></td> <td><table width="35%">
</table></td> </tr> </table> </td> <td width="15"> </td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require('includes/footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php ?>
Seeing the page might help. On Nov 1, 2004, at 2:52 AM, Garth Hapgood - Strickland wrote:
I have written a registration page in php and have a number of edit
boxes
and drop-down lists. The lists are pulling data out of their respective
tables, whereas the edit boxes are just for saving data.
Now my main table where all my data is being saved is called Business.
Onto
this I have a table called BusinessCommunication which has the fields
(BusinessCommunicationID, BusinessID, CommunicationTypeID,
Destination).
BusinessCommunicationID = Primary Key
BusinessID = Foreign key from Business Table
CommunicationTypeID = Foreign key from CommunicationType table (lists
all
communication types)
Destination = field where data is stored (tel number, email address or
fax
number etc)
Now the problem is that I want the person registering to be able to
select
the Communication Type/s he wants to add and then be able to enter the
relevant information for each selected CommType. There must also be
ability
to add 2 of the same CommType.
How can I achieve this as simply and affective as possible on my registration page.
If you have any solutions are need more information. Please let me know
Many thanx Garth
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-dg http://www.rexruff.com
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
