Jump to content

Insert/Update Record form help


Recommended Posts

Hi, i'm currently going through hell trying to get this to work; In my website I have a section where the user (on first visit) submits his profile details, there on after I have a conditional region where my form then echos his previous entries for which he can update; However I cant seem to get my "insert" form to work correctly, Any helps greatly appreciated

Heres my code on the insert record

 

<form method="post" id="form1" action="<?php echo KT_escapeAttribute(KT_getFullUri()); ?>">
          <table cellpadding="2" cellspacing="0" class="KT_tngtable">
            <tr>
              <td class="KT_th"><label for="profile_address">Profile_address:</label></td>
              <td><input type="text" name="profile_address" id="profile_address" value="<?php echo KT_escapeAttribute($row_rsmember_profile['profile_address']); ?>" size="32" />
                <?php echo $tNGs->displayFieldHint("profile_address");?> <?php echo $tNGs->displayFieldError("member_profile", "profile_address"); ?> </td>
            </tr>
            <tr>
              <td class="KT_th"><label for="profile_selfsummary">Self summary of expertise:</label></td>
              <td><input type="text" name="profile_selfsummary" id="profile_selfsummary" value="<?php echo KT_escapeAttribute($row_rsmember_profile['profile_selfsummary']); ?>" size="32" />
                <?php echo $tNGs->displayFieldHint("profile_selfsummary");?> <?php echo $tNGs->displayFieldError("member_profile", "profile_selfsummary"); ?> </td>
            </tr>
            <tr>
              <td class="KT_th"><label for="profile_certifications">Certifications:</label></td>
              <td><input type="text" name="profile_certifications" id="profile_certifications" value="<?php echo KT_escapeAttribute($row_rsmember_profile['profile_certifications']); ?>" size="32" />
                <?php echo $tNGs->displayFieldHint("profile_certifications");?> <?php echo $tNGs->displayFieldError("member_profile", "profile_certifications"); ?> </td>
            </tr>
            <tr>
              <td class="KT_th"><label for="profile_educatonal_background">Educational background:</label></td>
              <td><input type="text" name="profile_educatonal_background" id="profile_educatonal_background" value="<?php echo KT_escapeAttribute($row_rsmember_profile['profile_educatonal_background']); ?>" size="32" />
                <?php echo $tNGs->displayFieldHint("profile_educatonal_background");?> <?php echo $tNGs->displayFieldError("member_profile", "profile_educatonal_background"); ?> </td>
            </tr>
            <tr>
              <td class="KT_th"><label for="profile_licenses">Licenses:</label></td>
              <td><input type="text" name="profile_licenses" id="profile_licenses" value="<?php echo KT_escapeAttribute($row_rsmember_profile['profile_licenses']); ?>" size="32" />
                <?php echo $tNGs->displayFieldHint("profile_licenses");?> <?php echo $tNGs->displayFieldError("member_profile", "profile_licenses"); ?> </td>
            </tr>
            <tr>
              <td class="KT_th"><label for="profile_expertise">Areas of expertise:</label></td>
              <td><select name="profile_expertise" id="profile_expertise">
                <option value="" >item1</option>
              </select>
                <?php echo $tNGs->displayFieldError("member_profile", "profile_expertise"); ?> </td>
            </tr>
            <tr>
              <td class="KT_th"><label for="profile_workonsite_1">Profile_workonsite:</label></td>
              <td><div>
                <input <?php if (!(strcmp(KT_escapeAttribute($row_rsmember_profile['profile_workonsite']),"1"))) {echo "CHECKED";} ?> type="radio" name="profile_workonsite" id="profile_workonsite_1" value="1" />
                <label for="profile_workonsite_1">Yes</label>
              </div>
                <div>
                  <input <?php if (!(strcmp(KT_escapeAttribute($row_rsmember_profile['profile_workonsite']),"0"))) {echo "CHECKED";} ?> type="radio" name="profile_workonsite" id="profile_workonsite_2" value="0" />
                  <label for="profile_workonsite_2">No</label>
                </div>
                <?php echo $tNGs->displayFieldError("member_profile", "profile_workonsite"); ?> </td>
            </tr>
            <tr>
              <td class="KT_th"><label for="profile_rate">Working rate:</label></td>
              <td><input type="text" name="profile_rate" id="profile_rate" value="<?php echo KT_escapeAttribute($row_rsmember_profile['profile_rate']); ?>" size="32" />
                <?php echo $tNGs->displayFieldHint("profile_rate");?> <?php echo $tNGs->displayFieldError("member_profile", "profile_rate"); ?> </td>
            </tr>
            <tr>
              <td class="KT_th"><label for="profile_paymentterms">Payment terms:</label></td>
              <td><input type="text" name="profile_paymentterms" id="profile_paymentterms" value="<?php echo KT_escapeAttribute($row_rsmember_profile['profile_paymentterms']); ?>" size="32" />
                <?php echo $tNGs->displayFieldHint("profile_paymentterms");?> <?php echo $tNGs->displayFieldError("member_profile", "profile_paymentterms"); ?> </td>
            </tr>
            <tr>
              <td class="KT_th"><label for="profile_misc">Profile_misc:</label></td>
              <td><input type="text" name="profile_misc" id="profile_misc" value="<?php echo KT_escapeAttribute($row_rsmember_profile['profile_misc']); ?>" size="32" />
                <?php echo $tNGs->displayFieldHint("profile_misc");?> <?php echo $tNGs->displayFieldError("member_profile", "profile_misc"); ?> </td>
            </tr>
            <tr class="KT_buttons">
              <td colspan="2"><input type="submit" name="KT_Insert1" id="KT_Insert1" value="Insert record" />              </td>
            </tr>
                    </table>
          <input type="hidden" name="profile_id" id="profile_id" value="<?php echo KT_escapeAttribute($row_rsmember_profile['profile_id']); ?>" />
          <input type="hidden" name="profile_member_id" id="profile_member_id" value="<?php echo KT_escapeAttribute($row_rsmember_profile['profile_member_id']); ?>" />
                  </form>

 

 

Link to comment
https://forums.phpfreaks.com/topic/105478-insertupdate-record-form-help/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.