Programming Help

Web Development



What's Here?

  • Members: 150,138
  • Replies: 507,703
  • Topics: 80,045
  • Snippets: 2,668
  • Tutorials: 707
  • Total Online: 2,283
  • Members: 100
  • Guests: 2,183

Welcome to Dream.In.Code
Become a PHP Expert!

Join 150,138 PHP Programmers for FREE! Get instant access to thousands of PHP experts, tutorials, code snippets, and more! There are 2,283 people online right now. Registration is fast and FREE... Join Now!




Inserting Multiline text field into MYSQL from PHP

2 Pages V  1 2 >  
 Reply to this topicStart new topic

Inserting Multiline text field into MYSQL from PHP
noobiez
20 Aug, 2008 - 03:12 AM
Post #1

New D.I.C Head
*

Joined: 20 Aug, 2008
Posts: 18
Hi Guys,

I've a form which has a multiline text field that returns me an error when i submit. Can anyone tell me what i am doing wrong?

QUOTE
Acct.html is the form itself

CODE
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>:: TWC | Customer Account Creation ::</title>
<link href="form.css" rel="stylesheet" type="text/css" />
</head>

<body>
<form id="form1" name="AccountCreation" method="post" action="account_creation.php">
  <table width="700" border="1" align="center" cellpadding="5" cellspacing="1" bordercolor="#000066">
    <tr>
      <td width="0" height="17" colspan="2" bordercolor="#FFFFFF" bgcolor="#b5cbef" class="MainTitle">Customer Account Creation </td>
    </tr>
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" bgcolor="#b5cbef" class="SubTitle">Basic Information </td>
    </tr>
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" class="BodyNotice">*Please fill in all the required information </td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">First Name </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BAS_FN" type="text" class="BodyInput" id="BAS_FN" size="40" maxlength="25" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Last Name </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BAS_LN" type="text" class="BodyInput" id="BAS_LN" size="40" maxlength="25" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Social Security/NRIC/Passport No. </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BAS_SS" type="text" class="BodyInput" id="BAS_SS" size="40" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Date Of Birth </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BAS_DOB" type="text" class="BodyInput" id="BAS_DOB" value="DD/MM/YYYY" size="40" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" bgcolor="#b5cbef" class="SubTitle">Contact Information </td>
    </tr>
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyNotice">*Please fill in all the required information </td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Cell-Phone No. </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="CI_CPN" type="text" class="BodyInput" id="CI_CPN" size="40" maxlength="15" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Residential No. </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="CI_RN" type="text" class="BodyInput" id="CI_RN" size="40" maxlength="15" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Office No. </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="CI_ON" type="text" class="BodyInput" id="CI_ON" size="40" maxlength="15" />
        <span class="BodySnippets">(Optional)</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Email</td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="CI_EA" type="text" class="BodyInput" id="CI_EA" size="40" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Residential Address </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <textarea name="CI_RAD" cols="35" rows="4" class="BodyInput" id="CI_RAD"></textarea>
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Mailing Address </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <textarea name="CI_MAD" cols="35" rows="4" class="BodyInput" id="CI_MAD"></textarea>
        <span class="BodySnippets">(Optional)</span></label></td>
    </tr>
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" bgcolor="#b5cbef" class="SubTitle">Account Information</td>
    </tr>
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyNotice">*Please fill in all the required information </td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Account Username </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="AI_UN" type="text" class="BodyInput" id="AI_UN" size="30" />
        <span class="BodyRequired">*</span> <span class="BodySnippets">(Not less than 4 or more than 8 Characters )</span> </label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Account Password </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="AI_UP" type="password" class="BodyInput" id="AI_UP" size="30" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Confirm Password </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="AI_UPC" type="password" class="BodyInput" id="AI_UPC" size="30" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" bgcolor="#b5cbef" class="SubTitle">Security  Information</td>
    </tr>
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyNotice">*Please fill in all the required information </td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Choose Security Question </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <select name="SI_CSQ" class="BodyInput" id="SI_CSQ">
          <option>Who is my fave person?</option>
          <option>What is my mother's maiden name?</option>
          <option>What is my first pet name?</option>
          <option>Who is my Beneficiary Bank?</option>
          <option>What is my most hated food?</option>
        </select>
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Security Answer </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="SI_SA" type="text" class="BodyInput" id="SI_SA" size="40" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Chosen Person Identification </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <select name="SI_CPI" class="BodyInput" id="SI_CPI">
          <option>--Relationship--</option>
          <option>Father</option>
          <option>Mother</option>
          <option>Brother</option>
          <option>Sister</option>
          <option>Wife</option>
          <option>Others</option>
        </select>
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Full Name </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="SI_FN" type="text" class="BodyInput" id="SI_FN" size="40" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Social Security/NRIC/Passport No. </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="SI_SS" type="text" class="BodyInput" id="SI_SS" size="40" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" bgcolor="#b5cbef" class="SubTitle">Billing Information </td>
    </tr>
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyNotice">*Please fill in all the required information </td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Country</td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <select id="BI_C" name="BI_C" class="BodyInput">
          <option value="">-- Choose a Country --</option>
          <option value="US">United States</option>
          <option value="AL">Albania</option>
          <option value="DZ">Algeria</option>
          <option value="AD">Andorra</option>
          <option value="AO">Angola</option>
          <option value="AI">Anguilla</option>
          <option value="AG">Antigua and Barbuda</option>
          <option value="AR">Argentina</option>
          <option value="AM">Armenia</option>
          <option value="AW">Aruba</option>
          <option value="AU">Australia</option>
          <option value="AT">Austria</option>
          <option value="AZ">Azerbaijan Republic</option>
          <option value="BS">Bahamas</option>
          <option value="BH">Bahrain</option>
          <option value="BB">Barbados</option>
          <option value="BE">Belgium</option>
          <option value="BZ">Belize</option>
          <option value="BJ">Benin</option>
          <option value="BM">Bermuda</option>
          <option value="BT">Bhutan</option>
          <option value="BO">Bolivia</option>
          <option value="BA">Bosnia and Herzegovina</option>
          <option value="BW">Botswana</option>
          <option value="BR">Brazil</option>
          <option value="VG">British Virgin Islands</option>
          <option value="BN">Brunei</option>
          <option value="BG">Bulgaria</option>
          <option value="BF">Burkina Faso</option>
          <option value="BI">Burundi</option>
          <option value="KH">Cambodia</option>
          <option value="CA">Canada</option>
          <option value="CV">Cape Verde</option>
          <option value="KY">Cayman Islands</option>
          <option value="TD">Chad</option>
          <option value="CL">Chile</option>
          <option value="C2">China</option>
          <option value="CO">Colombia</option>
          <option value="KM">Comoros</option>
          <option value="CK">Cook Islands</option>
          <option value="CR">Costa Rica</option>
          <option value="HR">Croatia</option>
          <option value="CY">Cyprus</option>
          <option value="CZ">Czech Republic</option>
          <option value="CD">Democratic Republic of the Congo</option>
          <option value="DK">Denmark</option>
          <option value="DJ">Djibouti</option>
          <option value="DM">Dominica</option>
          <option value="DO">Dominican Republic</option>
          <option value="EC">Ecuador</option>
          <option value="SV">El Salvador</option>
          <option value="ER">Eritrea</option>
          <option value="EE">Estonia</option>
          <option value="ET">Ethiopia</option>
          <option value="FK">Falkland Islands</option>
          <option value="FO">Faroe Islands</option>
          <option value="FM">Federated States of Micronesia</option>
          <option value="FJ">Fiji</option>
          <option value="FI">Finland</option>
          <option value="FR">France</option>
          <option value="GF">French Guiana</option>
          <option value="PF">French Polynesia</option>
          <option value="GA">Gabon Republic</option>
          <option value="GM">Gambia</option>
          <option value="DE">Germany</option>
          <option value="GI">Gibraltar</option>
          <option value="GR">Greece</option>
          <option value="GL">Greenland</option>
          <option value="GD">Grenada</option>
          <option value="GP">Guadeloupe</option>
          <option value="GT">Guatemala</option>
          <option value="GN">Guinea</option>
          <option value="GW">Guinea Bissau</option>
          <option value="GY">Guyana</option>
          <option value="HN">Honduras</option>
          <option value="HK">Hong Kong</option>
          <option value="HU">Hungary</option>
          <option value="IS">Iceland</option>
          <option value="IN">India</option>
          <option value="ID">Indonesia</option>
          <option value="IE">Ireland</option>
          <option value="IL">Israel</option>
          <option value="IT">Italy</option>
          <option value="JM">Jamaica</option>
          <option value="JP">Japan</option>
          <option value="JO">Jordan</option>
          <option value="KZ">Kazakhstan</option>
          <option value="KE">Kenya</option>
          <option value="KI">Kiribati</option>
          <option value="KW">Kuwait</option>
          <option value="KG">Kyrgyzstan</option>
          <option value="LA">Laos</option>
          <option value="LV">Latvia</option>
          <option value="LS">Lesotho</option>
          <option value="LI">Liechtenstein</option>
          <option value="LT">Lithuania</option>
          <option value="LU">Luxembourg</option>
          <option value="MG">Madagascar</option>
          <option value="MW">Malawi</option>
          <option value="MY">Malaysia</option>
          <option value="MV">Maldives</option>
          <option value="ML">Mali</option>
          <option value="MT">Malta</option>
          <option value="MH">Marshall Islands</option>
          <option value="MQ">Martinique</option>
          <option value="MR">Mauritania</option>
          <option value="MU">Mauritius</option>
          <option value="YT">Mayotte</option>
          <option value="MX">Mexico</option>
          <option value="MN">Mongolia</option>
          <option value="MS">Montserrat</option>
          <option value="MA">Morocco</option>
          <option value="MZ">Mozambique</option>
          <option value="NA">Namibia</option>
          <option value="NR">Nauru</option>
          <option value="NP">Nepal</option>
          <option value="NL">Netherlands</option>
          <option value="AN">Netherlands Antilles</option>
          <option value="NC">New Caledonia</option>
          <option value="NZ">New Zealand</option>
          <option value="NI">Nicaragua</option>
          <option value="NE">Niger</option>
          <option value="NU">Niue</option>
          <option value="NF">Norfolk Island</option>
          <option value="NO">Norway</option>
          <option value="OM">Oman</option>
          <option value="PW">Palau</option>
          <option value="PA">Panama</option>
          <option value="PG">Papua New Guinea</option>
          <option value="PE">Peru</option>
          <option value="PH">Philippines</option>
          <option value="PN">Pitcairn Islands</option>
          <option value="PL">Poland</option>
          <option value="PT">Portugal</option>
          <option value="QA">Qatar</option>
          <option value="CG">Republic of the Congo</option>
          <option value="RE">Reunion</option>
          <option value="RO">Romania</option>
          <option value="RU">Russia</option>
          <option value="RW">Rwanda</option>
          <option value="VC">Saint Vincent and the Grenadines</option>
          <option value="WS">Samoa</option>
          <option value="SM">San Marino</option>
          <option value="ST">S&atilde;o Tom&eacute; and Pr&iacute;ncipe</option>
          <option value="SA">Saudi Arabia</option>
          <option value="SN">Senegal</option>
          <option value="SC">Seychelles</option>
          <option value="SL">Sierra Leone</option>
          <option value="SG" selected="selected">Singapore</option>
          <option value="SK">Slovakia</option>
          <option value="SI">Slovenia</option>
          <option value="SB">Solomon Islands</option>
          <option value="SO">Somalia</option>
          <option value="ZA">South Africa</option>
          <option value="KR">South Korea</option>
          <option value="ES">Spain</option>
          <option value="LK">Sri Lanka</option>
          <option value="SH">St. Helena</option>
          <option value="KN">St. Kitts and Nevis</option>
          <option value="LC">St. Lucia</option>
          <option value="PM">St. Pierre and Miquelon</option>
          <option value="SR">Suriname</option>
          <option value="SJ">Svalbard and Jan Mayen Islands</option>
          <option value="SZ">Swaziland</option>
          <option value="SE">Sweden</option>
          <option value="CH">Switzerland</option>
          <option value="TW">Taiwan</option>
          <option value="TJ">Tajikistan</option>
          <option value="TZ">Tanzania</option>
          <option value="TH">Thailand</option>
          <option value="TG">Togo</option>
          <option value="TO">Tonga</option>
          <option value="TT">Trinidad and Tobago</option>
          <option value="TN">Tunisia</option>
          <option value="TR">Turkey</option>
          <option value="TM">Turkmenistan</option>
          <option value="TC">Turks and Caicos Islands</option>
          <option value="TV">Tuvalu</option>
          <option value="UG">Uganda</option>
          <option value="UA">Ukraine</option>
          <option value="AE">United Arab Emirates</option>
          <option value="GB">United Kingdom</option>
          <option value="UY">Uruguay</option>
          <option value="VU">Vanuatu</option>
          <option value="VA">Vatican City State</option>
          <option value="VE">Venezuela</option>
          <option value="VN">Vietnam</option>
          <option value="WF">Wallis and Futuna Islands</option>
          <option value="YE">Yemen</option>
          <option value="ZM">Zambia</option>
        </select>
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">First Name </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BI_FN" type="text" class="BodyInput" id="BI_FN" size="40" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Last Name </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BI_LN" type="text" class="BodyInput" id="BI_LN" size="40" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Credit/Debit Card No. </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BI_CDCN" type="text" class="BodyInput" id="BI_CDCN" value="XXXX-XXXX-XXXX-XXXX" size="40" maxlength="20" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Card Type </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label></label>
          <select name="BI_TP" class="BodyInput" id="BI_TP">
            <option>--Card Type--</option>
            <option>VISA</option>
            <option>MASTER</option>
            <option>DISCOVER</option>
            <option>AMEX</option>
          </select>
          <span class="BodyRequired">*</span></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Expiration Date </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BI_EDMM" type="text" class="BodyInput" id="BI_EDMM" value="MM" size="5" maxlength="2" />
        /
        <input name="BI_EDYY" type="text" class="BodyInput" id="BI_EDYY" value="YYYY" size="7" maxlength="4" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">CSC No. </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BI_CSC" type="text" class="BodyInput" id="BI_CSC" value="CSC" size="6" maxlength="3" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Billing Address Line 1 </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BI_BAL1" type="text" class="BodyInput" id="BI_BAL1" size="40" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Billing Address Line 2</td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BI_BAL2" type="text" class="BodyInput" id="BI_BAL2" size="40" />
        <span class="BodyHandle"><span class="BodySnippets">(Optional)</span> </span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">City</td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BI_CT" type="text" class="BodyInput" id="BI_CT" size="40" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">State / Province / Region</td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BI_SPR" type="text" class="BodyInput" id="BI_SPR" size="40" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle">Postal Code </td>
      <td bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <input name="BI_PC" type="text" class="BodyInput" id="BI_PC" size="40" />
        <span class="BodyRequired">*</span></label></td>
    </tr>
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" bgcolor="#d6dfef"><label>
        <div align="center">
          <input name="FE_A" type="checkbox" id="FE_A" value="checkbox" />
            &nbsp;
          <span class="FooterDeclare"> I hereby CERTIFy that the information given above is true to the best of my knowledge and that I have done my due diligence in filling up this form to the best of my ability.</span></div>
          </label></td>
    </tr>
  </table>
  <div align="center">
    <input type="submit" name="Submit" value="Submit" />
    <input name="Reset" type="reset" id="Reset" value="Reset" />
  </div>
</form>
</body>
</html>

QUOTE
account_creation.php is the processing script

CODE

<?php

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// Get values from form
$BAS_FN=$_POST['BAS_FN'];
$BAS_LN=$_POST['BAS_LN'];
$BAS_SS=$_POST['BAS_SS'];
$BAS_DOB=$_POST['BAS_DOB'];
$CI_CPN=$_POST['CI_CPN'];
$CI_RN=$_POST['CI_RN'];
$CI_ON=$_POST['CI_ON'];
$CI_EA=$_POST['CI_EA'];
$CI_RAD=$_POST['CI_RAD'];
$CI_MAD=$_POST['CI_MAD'];
$AI_UN=$_POST['AI_UN'];
$AI_UP=$_POST['AI_UP'];
$SI_CSQ=$_POST['SI_CSQ'];
$SI_SA=$_POST['SI_SA'];
$SI_CPI=$_POST['SI_CPI'];
$SI_FN=$_POST['SI_FN'];
$SI_SS=$_POST['SI_SS'];
$BI_C=$_POST['BI_C'];
$BI_FN=$_POST['BI_FN'];
$BI_LN=$_POST['BI_LN'];
$BI_CDCN=$_POST['BI_CDCN'];
$BI_TP=$_POST['BI_TP'];
$BI_EDMM=$_POST['BI_EDMM'];
$BI_EDYY=$_POST['BI_EDYY'];
$BI_CSC=$_POST['BI_CSC'];
$BI_BAL1=$_POST['BI_BAL1'];
$BI_BAL2=$_POST['BI_BAL2'];
$BI_CT=$_POST['CI_CT'];
$BI_SPR=$_POST['BI_SPR'];
$BI_PC=$_POST['BI_PC'];
$FE_A=$_POST['FE_A'];

// Insert data into mysql
$sql="INSERT INTO $tbl_name(BAS_FN, BAS_LN, BAS_SS, BAS_DOB, CI_CPN, CI_RN, CI_ON, CI_EA, CI_RAD, CI_MAD, AI_UN, AI_UP, SI_CSQ, SI_SA, SI_CPI, SI_FN, SI_SS, BI_C, BI_FN, BI_LN, BI_CDCN, BI_TP, BI_EDMM, BI_EDYY, BI_CSC, BI_BAL1, BI_BAL2, BI_CT, BI_SPR, BI_PC, FE_A)VALUES('$BAS_FN', '$BAS_LN', '$BAS_SS', '$BAS_DOB', '$CI_CPN', '$CI_RN', '$CI_ON', '$CI_EA', '$CI_RAD', '$CI_MAD', '$AI_UN', '$AI_UP', '$SI_CSQ', '$SI_SA', '$SI_CPI', '$SI_FN', '$SI_SS', '$BI_C', '$BI_FN', '$BI_LN', '$BI_CDCN', '$BI_TP', '$BI_EDMM', '$BI_EDYY', '$BI_CSC', '$BI_BAL1', '$BI_BAL2', '$BI_CT', '$BI_SPR', '$BI_PC', '$FE_A')";
$result=mysql_query($sql);

// if successfully insert data into database, displays message "Successful".
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='processed.html'>Please Click here to continue.</a>";
}
else {
echo "ERROR";
}

// close connection
mysql_close();
?>

QUOTE
Processed.html is the Thank you Page

CODE

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>:: TWC | Customer Account Creation - Data Submitted ::</title>
<link href="form.css" rel="stylesheet" type="text/css" />
</head>
<body>

  <table width="700" border="1" align="center" cellpadding="5" cellspacing="1" bordercolor="#000066">
    <tr>
      <td width="0" height="17" colspan="2" bordercolor="#FFFFFF" bgcolor="#b5cbef" class="MainTitle">Customer Account Creation </td>
    </tr>
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" bgcolor="#b5cbef" class="SubTitle">Data Submitted ! </td>
    </tr>
    
    <tr>
      <td colspan="2" bordercolor="#FFFFFF" bgcolor="#d6dfef" class="BodyHandle"><p>Thank you for your Submission. We will process and revert to you on your account status. Have a nice day!</p>
      <p>-TWC Admin Support.  </p></td>
    </tr>
  </table>

</body>
</html>

So guys any ideas? Thanks for all help...

Rgrds,
Nobiez.
User is offlineProfile CardPM
+Quote Post

kummu4help
RE: Inserting Multiline Text Field Into MYSQL From PHP
20 Aug, 2008 - 03:24 AM
Post #2

D.I.C Head
Group Icon

Joined: 4 Aug, 2008
Posts: 184



Thanked: 2 times
Dream Kudos: 25
My Contributions
what is the error u r getting noobiez
User is offlineProfile CardPM
+Quote Post

pemcconnell
RE: Inserting Multiline Text Field Into MYSQL From PHP
20 Aug, 2008 - 07:34 AM
Post #3

D.I.C Regular
Group Icon

Joined: 5 Aug, 2008
Posts: 403



Thanked: 38 times
Dream Kudos: 75
My Contributions
is it a quotation mark that's causing the issue? You should clean any type of data before it is insterted into a database anyway - a hacker could break that system quite easily.

Tip:

Change this line:

CODE

$result=mysql_query($sql);


To this:

CODE

$result=mysql_query($sql)or die(mysql_error());


And it'll help you debug your code.

*edit*

You'll prob want to use the nl2br() function for your textareas

This post has been edited by pemcconnell: 20 Aug, 2008 - 07:37 AM
User is offlineProfile CardPM
+Quote Post

JBrace1990
RE: Inserting Multiline Text Field Into MYSQL From PHP
20 Aug, 2008 - 07:54 AM
Post #4

D.I.C Regular
Group Icon

Joined: 9 Mar, 2008
Posts: 479



Thanked: 24 times
Dream Kudos: 350
My Contributions
from what I see, neither $username, $password, or $tbl_name are set...

This post has been edited by JBrace1990: 20 Aug, 2008 - 07:54 AM
User is offlineProfile CardPM
+Quote Post

noobiez
RE: Inserting Multiline Text Field Into MYSQL From PHP
20 Aug, 2008 - 08:46 AM
Post #5

New D.I.C Head
*

Joined: 20 Aug, 2008
Posts: 18
Hi Guys!

Your support has been extremely GREAT! Really don't know what i'd do without you guys... Anyways the problem was this. Initially when i set up the field in MYSQL, i chose the type to be varchar instead of text. Now after changing to text, i found that it works. Thanks for the headsup for the security weakness in my syntax.

This solved, i have another question. You notice my thank you page code?
CODE

if($result){
echo "Successful";
echo "<BR>";
echo "<a href='processed.html'>Please Click here to continue.</a>";
}
else {
echo "ERROR";
}

How do i instead of showing success just redirect the users to that page rather than making them click on it. Any ideas? And guys, thank you for bearing with my noobieness. smile.gif

Rgrds,
Noobiez.
User is offlineProfile CardPM
+Quote Post

brandon99337
RE: Inserting Multiline Text Field Into MYSQL From PHP
20 Aug, 2008 - 12:42 PM
Post #6

D.I.C Head
**

Joined: 14 Feb, 2008
Posts: 144



Thanked: 2 times
My Contributions
The best way to do this would be to use a header redirect,

It would end up looking like this:
CODE

if($result){
header("Location:processed.html");
}
else {
echo "ERROR";
}
User is offlineProfile CardPM
+Quote Post

noobiez
RE: Inserting Multiline Text Field Into MYSQL From PHP
20 Aug, 2008 - 02:21 PM
Post #7

New D.I.C Head
*

Joined: 20 Aug, 2008
Posts: 18
Hi Brandon,

Thanks for your wonderful suggestion! I was trying to fiddle around with the header redirect and got a few errors from it. That is until you finally helped with the correct syntax. I guess there is alot to learn about PHP and pratice... Anyways, i was wondering would it be hard to add in sessions and perhaps IP logging? Thanks again! Everyone...

Rgrds,
Noobiez.
User is offlineProfile CardPM
+Quote Post

brandon99337
RE: Inserting Multiline Text Field Into MYSQL From PHP
20 Aug, 2008 - 08:39 PM
Post #8

D.I.C Head
**

Joined: 14 Feb, 2008
Posts: 144



Thanked: 2 times
My Contributions
To log an IP you would have to make one more column in your table, probably name it loggedip or something along those lines.

The code would be (add this to your existing INSERT query)

CODE

mysql_query("INSERT INTO $tblname (loggedip)
VALUES
('$_SERVER['REMOTE_ADDR']')");


This post has been edited by brandon99337: 20 Aug, 2008 - 08:40 PM
User is offlineProfile CardPM
+Quote Post

noobiez
RE: Inserting Multiline Text Field Into MYSQL From PHP
22 Aug, 2008 - 08:21 AM
Post #9

New D.I.C Head
*

Joined: 20 Aug, 2008
Posts: 18
QUOTE(brandon99337 @ 20 Aug, 2008 - 01:42 PM) *

The best way to do this would be to use a header redirect,

It would end up looking like this:
CODE

if($result){
header("Location:processed.html");
}
else {
echo "ERROR";
}



Hi,

I am just wondering looking at this code. From reading the changes that was made, is it true that regardless of what the outcome, it will still display the page "Processed.html"? What can i do to make it display the specific errors if there is any? Sorry if this is considered bumping thread but i saw that it wasn't closed so i figured i'd try my luck.

Rgrds,
Noobiez.
User is offlineProfile CardPM
+Quote Post

noobiez
RE: Inserting Multiline Text Field Into MYSQL From PHP
22 Aug, 2008 - 08:30 AM
Post #10