hi
i have problem with submitting form and save value in database
i attached form screen shot
and code i use to enter data in DB is
------------------------------------
<?php
function dsa_query(&$fields){
global $modx;
echo "<pre><h1>Application form submited sucessfully.</h1> <a href=’[~127~]’> Continue</a>";
print_r($fields);
print_r($fields[’bank_name’]);
$dbTable[’fullname’] = $fields[’fullname’];
$dbTable[’phone_mobile’] = $fields[’phone_mobile’];
$dbTable[’email’] = $fields[’email’];
$dbTable[’city’] = $fields[’city’];
$dbTable[’product’] = $fields[’product1’].’, ’.$fields[’product2’].’, ’.$fields[’product3’].’, ’.$fields[’product4’].’, ’.$fields[’product5’].’, ’.$fields[’product6’].’, ’.$fields[’product7’];
$dbTable[’message’] = $fields[’message’];
$dbTable[’bank_name’]=’’;
if(is_array($fields[’bank_name’]) && !empty($fields[’bank_name’]))
{
foreach($fields[’bank_name’] as $k )
{
$dbTable[’bank_name’] .= $k.’, ’;
}
}else{
$dbTable[’bank_name’] = $fields[’bank_name’];
}
print_r($dbTable);
$dbQuery = $modx->db->insert($dbTable, ’dsa_query’ );
return true;
}
?>
------------------------------------
and this is a html part
------------------------------------
<p class="error">[+validationmessage+]</p>
<form method="post" action="[~[*id*]~]" id="form" name="form">
<p>
<span class=’label’ >Your name:</span>
<span><input name="fullname" id="fullname" class="text" type="text" style="width:190" eform="Your Name::1:" /></span>
</p>
<p>
<span class="label">Mobile/Phone Number </span>
<span><input id="phone_mobile" name="phone_mobile" type="text" maxlength="10" style="width:190" eform="Mobile::1::#REGEX /^[0-9]/i " /></span>
</p>
<p>
<span class=’label’>Your Email Address:</span>
<span><input name="email" id="email" class="text" type="text" style="width:190" eform="Email Address:email:1" /></span>
</p>
<p>
<span class=’label’>City:</span>
<span><select id="city" name="city" eform"city::1:" style="width:190">
<option>Please Select</option>
<option value="mumbai">Mumbai</option>
<option value="delhi">Delhi/NCR</option>
<option value="thane">Thane</option>
<option value="hyderabad">Hyderabad</option>
<option value="bangalore">Bangalore</option>
<option value="gurgaon">Gurgaon</option>
<option value="newmumbai">New Mumbai</option>
<option value="chennai">Chennai</option>
<option value="noida">Noida</option>
<option value="kolkata">Kolkata</option>
<option value="pune">Pune</option>
<option value="chandigarh">Chandigarh</option>
<option>----------------</option>
<option value="ahmedabad">Ahmedabad</option>
<option value="aurangabad">Aurangabad</option>
<option value="baroda">Baroda</option>
<option value="bhopal">Bhopal</option>
<option value="bhubneshwar">Bhubneshwar</option>
<option value="cochin">Cochin</option>
<option value="coimbatore">Coimbatore</option>
<option value="cuttack">Cuttack</option>
<option value="dehradun">Dehradun</option>
<option value="faridabad">Faridabad</option>
<option value="guwahati">Guwahati</option>
<option value="hosur">Hosur</option>
<option value="indore">Indore</option>
<option value="jabalpur">Jabalpur</option>
<option value="jaipur">Jaipur</option>
<option value="jamshedpur">Jamshedpur</option>
<option value="kanpur">Kanpur</option>
<option value="kochi">Kochi</option>
<option value="lucknow">Lucknow</option>
<option value="ludhiana">Ludhiana</option>
<option value="madurai">Madurai</option>
<option value="mangalore">Mangalore</option>
<option value="mysore">Mysore</option>
<option value="nagpur">Nagpur</option>
<option value="nasik">Nasik</option>
<option value="patna">Patna</option>
<option value="ranchi">Ranchi</option>
<option value="sahibabad">Sahibabad</option>
<option value="secundrabad">Secundrabad</option>
<option value="surat">Surat</option>
<option value="thiruvanthapuram">Thiruvanthapuram</option>
<option value="trichy">Trichy</option>
<option value="trivandrum">Trivandrum</option>
<option value="vadodara">Vadodara</option>
<option value="vishakapatanam">Vishakapatanam</option>
<option>----------------</option>
<option value="others">Others</option></select>
</span>
</p>
<p>
<span class="label">Product</span>
</p>
<p>
<span class="label"><input name="product1" id="product1" type="checkbox" eform="product1::0:" value="Personal_loan" /></span>
<span>Personal Loan</span>
</p>
<P>
<span class="label"><input name="product2" id="product2" type="checkbox" eform="product2::0:" value="home_loan" /></span>
<span>Home Loan</span>
</P>
<P>
<span class="label"><input name="product3" id="product3" type="checkbox" eform="product3::0:" value="vehicle_loan" /></span>
<span>Vehicle Loan</span>
</P>
<P>
<span class="label"><input name="product4" id="product4" type="checkbox" eform="product4::0:" value="education_loan" /></span>
<span>Education Loan</span>
</P>
<P>
<span class="label"><input name="product5" id="product5" type="checkbox" eform="product5::0:" value="business_loan" /></span>
<span>Business Loan</span>
</P>
<P>
<span class="label"><input name="product6" id="product6" type="checkbox" eform="product6::0:" value="loan_against_property" /></span>
<span>Loan Against Property</span>
</P>
<P>
<span class="label"><input name="product7" id="product7" type="checkbox" eform="product7::0:" value="credit_card" /></span>
<span>Credit Card</span>
</P>
<p>
<span class="label">Bank affiliated with<b>Please Select</b></span>
<span>
<select id="bank_name" name="bank_name" style="width:190; height:90 " multiple="multiple">
<option value="Allahabad Bank">
Allahabad Bank</option>
<option value="Andhra Bank">
Andhra Bank</option>
<option value="Axis Bank">
Axis Bank</option>
<option value="Bank of Baroda">
Bank of Baroda</option>
<option value="Bank of India">
Bank of India</option>
<option value="Bank of Maharashtra">
Bank of Maharashtra</option>
<option value="Bank of Rajasthan">
Bank of Rajasthan</option>
<option value="Canara Bank">
Canara Bank</option>
<option value="Central Bank of India">
Central Bank of India</option>
<option value="Centurian Bank">
Centurian Bank</option>
<option value="Citibank">
Citibank</option>
<option value="Corporation Bank">
Corporation Bank</option>
<option value="DCB">
DCB</option>
<option value="Dena Bank">
Dena Bank</option>
<option value="Deutsche Bank">
Deutsche Bank</option>
<option value="Dhanalakshmi Bank">
Dhanalakshmi Bank</option>
<option value="Federal Bank">
Federal Bank</option>
<option value="HDFC Bank">
HDFC Bank</option>
<option value="HSBC">
HSBC</option>
<option value="ICICI Bank">
ICICI Bank</option>
<option value="IDBI">
IDBI</option>
<option value="Indian Bank">
Indian Bank</option>
<option value="Indian Overseas Bank">
Indian Overseas Bank</option>
<option value="IndusInd Bank">
IndusInd Bank</option>
<option value="Jammu and Kashmir Bank">
Jammu and Kashmir Bank</option>
<option value="Karur Vysya Bank">
Karur Vysya Bank</option>
<option value="Kotak Mahindra Bank">
Kotak Mahindra Bank</option>
<option value="Oriental Bank of Commerce">
Oriental Bank of Commerce</option>
<option value="Punjab and Sind Bank">
Punjab and Sind Bank</option>
<option value="Punjab National Bank">
Punjab National Bank</option>
<option value="SBI Commercial and International Bank Ltd">
SBI Commercial and International Bank Ltd</option>
<option value="South Indian Bank">
South Indian Bank</option>
<option value="Standard Chartered Bank">
Standard Chartered Bank</option>
<option value="State Bank of Bikaner and Jaipur">
State Bank of Bikaner and Jaipur</option>
<option value="State Bank of Hyderabad">
State Bank of Hyderabad</option>
<option value="State Bank of India">
State Bank of India</option>
<option value="State Bank of Indore">
State Bank of Indore</option>
<option value="State Bank of Mysore">
State Bank of Mysore</option>
<option value="State Bank of Patiala">
State Bank of Patiala</option>
<option value="State Bank of Saurashtra">
State Bank of Saurashtra</option>
<option value="State Bank of Travancore">
State Bank of Travancore</option>
<option value="Syndicate Bank">
Syndicate Bank</option>
<option value="UCO Bank">
UCO Bank</option>
<option value="Union Bank of India">
Union Bank of India</option>
<option value="United Bank of India">
United Bank of India</option>
<option value="Vijaya Bank">
Vijaya Bank</option>
<option value="Other">
Other</option>
</select>
</span>
<label>Use ( Ctrl + Left Mouse click ) for multiple selection </label>
</p>
<p>
<span class=’label’>Message:</span>
<span><textarea name="message" id="cfMessage" rows="4" cols="19" style="width:190px;" eform="Message:textarea:1"></textarea></span>
</p>
<p>
<span class="label"></span>
<span><input type="submit" name="contact" id="cfContact" value="Send This Message" /></span>
</p>
</form>
------------------------------------
additional info
i want to insert multiple banks name in DB but when i use
<select id="bank_name" name="bank_name" style="width:190; height:90 " multiple="multiple">
like this it takes last bank name from all selected banks
and when i use
<select id="bank_name[]" name="bank_name[]" style="width:190; height:90 " multiple="multiple">
it give me an error "incorrect value "after removing [] from id and name form submit all values of bank which i have selected
please help me on this and sorry for my poor English
thanks in advance
