Coonect calculator to Mysql database?

Discussion in 'PHP' started by ushaas, Sep 19, 2009.

0
  1. #1
    Hello friends i have an insurance calculator which it has to be pasted in wordpress blog.To make it run in wordpress which database i have to use?How can i connect to a database to populate relevant information when people asked for a insurance quote.Help me friends?

    Down given the code for insurance calculator:
    *****************************************************************************************************************
    <div class="module">
    <h3>Health Insurance or Mediclaim Insurance Premium Calculator</h3>

    <p class="green_14">Please fill-in the following information to get Quotes and Compare Health Insurance Plans.</p>

    <form id="getquote" name="getquote" action="/health/healthquote.php" method="GET" onSubmit="return validatehealthform(this)">
    <input type="hidden" name="Profile" value="Individual" />

    <table border="0" cellpadding="2" class="blueB_12" >
    <tr>
    <td align="right">Do you want to <sup style="color:#FF0000">*</sup></td>
    <td width="5" align="center">&nbsp;</td>

    <td class="black_11">

    <table>
    <tr>
    <td><input type="radio" name="renewal_flag" id="renewal_flag_new" value="1" checked rel="none"/><label for ="renewal_flag_new">Buy New Policy </label></td>
    <td><input type="radio" name="renewal_flag" id="renewal_flag_renew" value="2" rel="renewal" /><label for ="renewal_flag_renew">Renew Existing Policy</label></td>
    </tr>
    </table>

    </tr>


    <tr rel="renewal">
    <td align="right">Previous Policy Issued By</td>
    <td width="5" align="center">&nbsp;</td>
    <td class="black_11">
    <select name="prev_ins_company">
    <option value=-1 selected >Select a Company</option>
    <option value=14 >Apollo DKV</option>
    <option value=2 >Bajaj Allianz</option>
    <option value=5 >Cholamandlam MS</option>

    <option value=27 >Future Generali</option>
    <option value=1 >ICICI Lombard</option>

    <option value=6 >IFFCO-TOKIO</option>
    <option value=8 >New India Assurance</option>
    <option value=9 >National Insurance</option>
    <option value=11 >Oriental Insurance</option>
    <option value=4 >Reliance General</option>
    <option value=7 >Royal Sundaram</option>

    <option value=12 >Star Health</option>
    <option value=10 >United India</option>
    </select>

    </td>

    </tr>

    <tr>
    <td align="right"><a class="help" href="javascript:showHelp(1)">Select City of Residence</a><sup style="color:#FF0000">*</sup></td>
    <td width="5" align="center">&nbsp;</td>
    <td><select id="city_id" name="city_id" >
    <OPTION value='1' rel="none">Mumbai</OPTION>

    <OPTION value='2' rel="none">Chennai</OPTION>
    <OPTION value='3' rel="none">Kolkata</OPTION>

    <OPTION value='4' rel="none"SELECTED>Delhi</OPTION>
    <OPTION value='5' rel="none">Bangalore</OPTION>
    <OPTION value='6' rel="none">Rest of India</OPTION>
    <OPTION value='7' rel="none">Hyderabad</OPTION>
    <OPTION value='8' rel="none">Ahmedabad</OPTION>

    </select>

    </td>
    </tr>
    <tr>

    <tr>
    <td align="right">Do you have any Pre-existing Medical Condition</td>
    <td width="5" align="center">&nbsp;</td>
    <td>
    <table class="black_11">
    <tr>
    <td>

    <input type="radio" name="medical_condition" value="Yes" id="medical_condition_yes" rel="medical_condition_detail" /><label for= "medical_condition_yes">Yes</label></td>
    <td>

    <input type="radio" name="medical_condition" value="No" id="medical_condition_no" rel="none" checked/><label for= "medical_condition_no" >No</label></td>
    </tr>
    </table>
    </td>
    </tr>

    <tr rel="medical_condition_detail">

    <td align="right">Select whichevers are applicable</td>
    <td width="5" align="center">&nbsp;</td>
    <td>
    <table class="black_11">

    <tr>
    <td>
    <input type="checkbox" name="pre_existing_conditions[Diabetes]" value="Y" id="pre_existing_conditions_diabetes" rel="none" /><label for= "pre_existing_conditions_diabetes">Diabetes</label></td>
    <td>
    <input type="checkbox" name="pre_existing_conditions[Hypertension]" value="Y" id="pre_existing_conditions_hypertension" rel="none" /><label for= "pre_existing_conditions_hypertension">Hypertension</label></td>

    <td>
    <label><input type="checkbox" name="pre_existing_conditions[Cholesterol]" value="Y" id="pre_existing_conditions_cholesterol" rel="none" /><label for= "pre_existing_conditions_cholesterol">Cholesterol</label></td>

    <td>
    <td>
    <label><input type="checkbox" name="pre_existing_conditions[Asthma]" value="Y" id="pre_existing_conditions_others" rel="none" /><label for= "pre_existing_conditions_others">Asthma</label></td>
    <td>
    </tr>

    </table>
    </td>
    </tr>

    <tr>

    <td align="right">Do you Smoke</td>
    <td width="5" align="center">&nbsp;</td>
    <td>
    <table class="black_11">
    <tr>
    <td>

    <input type="radio" name="smoke_flag" value="Y" id="smoke_flag_yes" /><label for= "smoke_flag_yes">Yes</label></td>
    <td>
    <input type="radio" name="smoke_flag" value="N" id="smoke_flag_no" checked /><label for= "smoke_flag_no" >No</label></td>

    </tr>
    </table>
    </td>
    </tr>

    <tr>

    <td align="right">Married?<sup style="color:#FF0000">*</sup></td>
    <td width="5" align="center">&nbsp;</td>
    <td>
    <table class="black_11">

    <tr>
    <td>
    <input type="radio" name="married_flag" value="Y" id="married_flag_yes" /><label for= "married_flag_yes">Yes</label></td>

    <td>
    <input type="radio" name="married_flag" value="N" id="married_flag_no" checked /><label for= "married_flag_no" >No</label></td>
    </tr>
    </table>
    </td>

    </tr>
    <tr>
    <td align="right"><a class="help" href="javascript:showHelp(8)">Date of Birth</a> <span class="red_11">(dd/mm/yyyy)</span><sup style="color:#FF0000">*</sup>

    </td>
    <td width="5" align="center">&nbsp;</td>
    <td><input name="Birthdate" type="text" size="10" value="" onChange="check_date_format(Birthdate)">
    </td>
    </tr>
    <tr>
    <td align="right"><a class="help" href="javascript:showHelp(9)">Coverage Amount</a></td>

    <td width="5" align="center">&nbsp;</td>
    <td>
    <table>

    <td><SELECT size=1 name="sumassured">
    <OPTION Value=Any selected rel="none">Any Amount</OPTION>
    <!--<OPTION value=25000 rel="none">Rs. 25,000 </OPTION>-->
    <OPTION value=50000 rel="none">Rs. 50,000 </OPTION>
    <OPTION value=75000 rel="none">Rs. 75,000 </OPTION>
    <OPTION value=100000 rel="none">Rs. 1.0 Lakh </OPTION>

    <OPTION value=150000 rel="none">Rs. 1.5 Lakhs </OPTION>
    <OPTION value=200000 rel="none">Rs. 2.0 Lakhs </OPTION>
    <OPTION value=250000 rel="none">Rs. 2.5 Lakhs </OPTION>

    <OPTION value=300000 rel="none">Rs. 3.0 Lakhs </OPTION>
    <OPTION value=350000 rel="none">Rs. 3.5 Lakhs </OPTION>
    <OPTION value=400000 rel="none">Rs. 4.0 Lakhs </OPTION>
    <OPTION value=450000 rel="none">Rs. 4.5 Lakhs </OPTION>
    <OPTION value=500000 rel="none">Rs. 5.0 Lakhs </OPTION>
    <OPTION value=750000 rel="none">Rs. 7.5 Lakhs </OPTION>

    <OPTION value=1000000 rel="none">Rs. 10 Lakhs </OPTION>
    </select></td>

    <td>
    <SELECT name="sumassured_range" )">
    <OPTION value="Min" rel="none">Minimum</OPTION>
    <OPTION value="Max" rel="none">Maximum</OPTION>
    <OPTION value="Exact" rel="none">Exact</OPTION>

    <OPTION value="Range" selected rel="none">Range</OPTION>

    </select>
    </td>
    </table>
    </td>
    </tr>

    <tr>
    <td align="right"><a class="help" href="javascript:showHelp(10)">Insurance Companies preference, if any</a></td>

    <td width="5" align="center">&nbsp;</td>

    <td>
    <ul class="checklist cl1">
    <li><label for= "ins_company_id_1" onclick="this.checked = true"><input type="checkbox" name="ins_company_id[]" value="1" id="ins_company_id_1"/>ICICI Lombard</label></li>
    <li><label for= "ins_company_id_2" onclick="this.checked = true"><input type="checkbox" id="ins_company_id_2" name="ins_company_id[]" value="2" />Bajaj Allianz</label></li>
    <li><label for= "ins_company_id_14" onclick="this.checked = true"><input type="checkbox" id="ins_company_id_14" name="ins_company_id[]" value="14" />Apollo DKV</label></li>
    <li><label for= "ins_company_id_4" onclick="this.checked = true"><input id="ins_company_id_4" name="ins_company_id[]" type="checkbox" value="4" />Reliance General</label></li>

    <li><label for= "ins_company_id_3" onclick="this.checked = true"><input id="ins_company_id_27" name="ins_company_id[]" type="checkbox" value="27" />Future Generali</label></li>
    <li><label for= "ins_company_id_5" onclick="this.checked = true"><input id="ins_company_id_5" name="ins_company_id[]" type="checkbox" value="5" />Cholamandlam MS</label></li>
    <li><label for= "ins_company_id_6" onclick="this.checked = true"><input id="ins_company_id_6" name="ins_company_id[]" type="checkbox" value="6" />IFFCO-TOKIO</label></li>
    <li><label for= "ins_company_id_12" onclick="this.checked = true"><input id="ins_company_id_12" name="ins_company_id[]" type="checkbox" value="12" />Star Health</label></li>
    <li><label for= "ins_company_id_7" onclick="this.checked = true"><input id="ins_company_id_7" name="ins_company_id[]" type="checkbox" value="7" />Royal Sundaram</label></li>
    <li><label for= "ins_company_id_8" onclick="this.checked = true"><input id="ins_company_id_8" name="ins_company_id[]" type="checkbox" value="8" />New India Assurance</label></li>

    <li><label for= "ins_company_id_9" onclick="this.checked = true"><input id="ins_company_id_9" name="ins_company_id[]" type="checkbox" value="9" />National Insurance</label></li>
    <li><label for= "ins_company_id_10" onclick="this.checked = true"><input id="ins_company_id_10" name="ins_company_id[]" type="checkbox" value="10" />United India</label></li>
    <li><label for= "ins_company_id_11" onclick="this.checked = true"><input id="ins_company_id_11" name="ins_company_id[]" type="checkbox" value="11" />Oriental Insurance</label></li>


    </ul>
    </td>
    </tr>

    <!--<tr>
    <td align="right"><a class="help" href="javascript:showHelp(10)">Insurance Company preference, if any</a></td>
    <td width="5" align="center">&nbsp;</td>
    <td><select name="ins_company_id">
    <OPTION value='14' rel="none">Apollo DKV</OPTION>
    <OPTION value='2' rel="none">Bajaj Allianz</OPTION>
    <OPTION value='27' rel="none">Future Generali</OPTION>
    <OPTION value='13' rel="none">HDFC Ergo</OPTION>
    <OPTION value='6' rel="none">IFFCO-TOKIO</OPTION>
    <OPTION value='9' rel="none">National Insurance</OPTION>
    <OPTION value='8' rel="none">New India Assurance</OPTION>
    <OPTION value='11' rel="none">Oriental Insurance</OPTION>
    <OPTION value='4' rel="none">Reliance General</OPTION>
    <OPTION value='12' rel="none">Star Health</OPTION>
    <OPTION value='10' rel="none">United India</OPTION>
    </select></td>
    </tr>
    <tr> -->

    <tr class="green_11"><td height="30" colspan="3" align="center">Note : Click on the links to see the detail description and help for each of these criteria.</td></tr>
    <tr> <b>
    <td height="46" align="right"><input type="submit" class="reg_txt" value="Search All Plans"> </td>
    <td width="5" align="center">&nbsp;</td>
    <td><input type="reset" class="reg_txt" value="Reset Form"> </td></tr>
    </table>

    </form>


    </div> <!-- End of Calculator Module -->
    *********************************************************************************************
     
    ushaas, Sep 19, 2009 IP
  2. astrazone

    astrazone Member

    Messages:
    358
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    33
    #2
    health/healthquote.php here you get all the info by $_POST[].
    connect to a db and insert all the data.
     
    astrazone, Sep 19, 2009 IP
  3. ushaas

    ushaas Peon

    Messages:
    109
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    can u please explain me some wat detailedly.
     
    ushaas, Sep 20, 2009 IP