Re: Help needed on php/mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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">&nbsp;</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

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux