There's no need for that. The code you already have is actually better.
javascript/ajax to mysql db
Collapse
X
-
ok just looking over a tutorial and this code do i need to do changes to the function alertContents(h ttpRequest) or is that fine as well?Comment
-
no, it's fine. but if you only have an update query, you won't have a responsetext so it will be unnecessary.
[EDIT] unless you have a echo something in php like acoder said.
if you still want to alert something or hide a loader when the update is done, you can use that instead.Comment
-
what it is.....its a paypal form but i want to save the form details into a database before it goes to paypal then once the paypal purchase is complete the user would be redirected to a page to confirm their email address so a confimation email is sent to them with a username and password....i'v e had to go about it this way because paypal do not allow fo extra confirmation emails and refuse to add that option on any account, at 1st i tried to use curl but paypal doesn't allow that....so the only way was with javascript/ajax so it does it all on the same page then the user can just click submit and it will go straight to paypalComment
-
Code:<table width="675" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><form action="" method="post" target="paypal" id="form"> <p> <input type="hidden" name="on0" value="shipping To:" /> </p> <table width="675" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="825" background="images/leadBox.jpg"><table width="550" height="133" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="40"><div align="center"><span class="style112">All fields marked with <span class="style114">*</span> are required and must be entered before continuing to the secured paypal payment page.</span></div></td> </tr> <tr> <td height="25"> </td> </tr> <tr> <td><table width="490" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="28" bgcolor="#666666"><span class="style118">...</span><span class="style116">Product Order</span></td> </tr> <tr> <td><table width="550" border="1" cellspacing="0" cellpadding="0"> <tr> <td width="71" height="25" bgcolor="#CCCCCC" class="style96"><div align="center"><span class="style120">Quantity</span></div></td> <td width="407" bgcolor="#CCCCCC" class="style96"><div align="center"><span class="style120">Description</span></div></td> <td width="64" bgcolor="#CCCCCC" class="style96"><div align="center"><span class="style120">Price</span></div></td> </tr> <tr> <td><div align="center" class="style121">1</div></td> <td height="50"><table width="400" height="28" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><div align="left"><span class="style149">Adam Ginsberg’s ‘The Closely Guarded Secrets Of An eBay Millionaire – Make Money On eBay’</span></div></td> </tr> </table></td> <td height="30"><div align="center" class="style121"> <p>£97.00<br /> (inc VAT)</p> </div></td> </tr> <tr> <td height="32"> </td> <td><table width="400" height="28" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><div align="left"> <p class="style121">Postage & Packaging:<br /> <strong>Calculated via Royal Mail according to Country of Residence</strong></p> </div></td> </tr> </table></td> <td height="32"> </td> </tr> <tr> <td height="23" bgcolor="#CCCCCC"> </td> <td bgcolor="#CCCCCC"><div align="right" class="style123">Sub-Total<span class="style124">..</span></div></td> <td bgcolor="#CCCCCC"><div align="center" class="style123">£97.00</div></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="28" bgcolor="#FFFFFF"> </td> </tr> <tr> <td height="28" bgcolor="#666666"><span class="style118">...</span><span class="style116">Billing Information</span></td> </tr> </table> <table width="550" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td bgcolor="#CCCCCC"><table width="475" border="0" align="center" cellpadding="2" cellspacing="2"> <tr> <td> </td> <td> </td> <td> </td> </tr> <tr> <td><div align="left"><span class="style123">First Name: </span></div></td> <td><span class="style112"><span class="style114">*</span></span></td> <td><div align="left"> <input type="text" name="first_name" value="" /> </div></td> </tr> <tr> <td><div align="left"><span class="style123">Last Name: </span></div></td> <td><span class="style112"><span class="style114">*</span></span></td> <td><div align="left"> <input type="text" name="last_name" value="" /> </div></td> </tr> <tr> <td class="style123"><div align="left"><span class="style96">Address Line 1: </span></div></td> <td><span class="style112"><span class="style114">*</span></span></td> <td><div align="left"> <input type="text" name="address1" value="" /> </div></td> </tr> <tr> <td class="style123"><div align="left"><span class="style96">Address Line 2: </span></div></td> <td> </td> <td><div align="left"> <input type="text" name="address2" value="" /> </div></td> </tr> <tr> <td class="style123"><div align="left"><span class="style96">City: </span></div></td> <td><span class="style112"><span class="style114">*</span></span></td> <td><div align="left"> <input type="text" name="city" value="" /> </div></td> </tr> <tr> <td class="style123"><div align="left"><span class="style96">County/State/Province: </span></div></td> <td><span class="style112"><span class="style114">*</span></span></td> <td><div align="left"> <input type="text" name="state" value="" /> </div></td> </tr> <tr> <td class="style123"><div align="left"><span class="style96">Postal Code/Zip Code: </span></div></td> <td><span class="style112"><span class="style114">*</span></span></td> <td><div align="left"> <input type="text" name="zip" value="" /> </div></td> </tr> <tr> <td class="style123"><div align="left"><span class="style96">Country: </span></div></td> <td><span class="style112"><span class="style114">*</span></span></td> <td><div align="left"> <select name="os0" id="os0"> <option value="">Please Select ...</option> <option value="Albania">Albania</option> <option value="Algeria">Algeria</option> <option value="Andorra">Andorra</option> <option value="Angola">Angola</option> <option value="Anguilla">Anguilla</option> <option value="Antigua & Barbuda">Antigua & Barbuda</option> <option value="Argentina">Argentina</option> <option value="Armenia">Armenia</option> <option value="Aruba">Aruba</option> <option value="Australia">Australia</option> <option value="Austria">Austria</option> <option value="Azerbaijan">Azerbaijan</option> <option value="Bahamas">Bahamas</option> <option value="Bahrain">Bahrain</option> <option value="Barbados">Barbados</option> <option value="Belgium">Belgium</option> <option value="Belize">Belize</option> <option value="Benin">Benin</option> <option value="Bermuda">Bermuda</option> <option value="Bhutan">Bhutan</option> <option value="Bolivia">Bolivia</option> <option value="Bosnia-Herzegovina">Bosnia-Herzegovina</option> <option value="Botswana">Botswana</option> <option value="Brazil">Brazil</option> <option value="British Virgin Islands">British Virgin Islands</option> <option value="Brunei Darussalam">Brunei Darussalam</option> <option value="Bulgaria (Republic)">Bulgaria (Republic)</option> <option value="Burkina Faso">Burkina Faso</option> <option value="Burundi">Burundi</option> <option value="Cambodia">Cambodia</option> <option value="Canada">Canada</option> <option value="Cape Verde">Cape Verde</option> <option value="Cayman Islands">Cayman Islands</option> <option value="Chad">Chad</option> <option value="Chile">Chile</option> <option value="China (People's Republic)">China (People's Republic)</option> <option value="Cocos (Keeling Islands)">Cocos (Keeling Islands)</option> <option value="Colombia">Colombia</option> <option value="Comoros">Comoros</option> <option value="Congo (Democratic Republic)">Congo (Democratic Republic)</option> <option value="Congo (People's Republic of)">Congo (People's Republic of)</option> <option value="Cook Islands">Cook Islands</option> <option value="Costa Rica">Costa Rica</option> <option value="Croatia">Croatia</option> <option value="Cyprus">Cyprus</option> <option value="Czech Republic">Czech Republic</option> <option value="Denmark">Denmark</option> <option value="Djibouti">Djibouti</option> <option value="Dominica">Dominica</option> <option value="Dominican Republic">Dominican Republic</option> <option value="Ecuador">Ecuador</option> <option value="El Salvador">El Salvador</option> <option value="Equatorial Guinea">Equatorial Guinea</option> <option value="Eritrea">Eritrea</option> <option value="Estonia">Estonia</option> <option value="Ethiopia">Ethiopia</option> <option value="Falkland Islands">Falkland Islands</option> <option value="Faroe Islands">Faroe Islands</option> <option value="Fiji">Fiji</option> <option value="Finland">Finland</option> <option value="France">France</option> <option value="French Guiana">French Guiana</option> <option value="French Polynesia">French Polynesia</option> <option value="Gabon">Gabon Republic</option> <option value="Gambia">Gambia</option> <option value="Germany">Germany</option> <option value="Ghana">Ghana</option> <option value="Gibraltar">Gibraltar</option> <option value="Greece">Greece</option> <option value="Greenland">Greenland</option> <option value="Grenada">Grenada</option> <option value="Guadeloupe">Guadeloupe</option> <option value="Guatemala">Guatemala</option> <option value="Guinea">Guinea</option> <option value="Guinea-Bissau">Guinea-Bissau</option> <option value="Guyana">Guyana</option> <option value="Honduras">Honduras</option> <option value="Hong Kong">Hong Kong</option> <option value="Hungary">Hungary</option> <option value="Iceland">Iceland</option> <option value="India">India</option> <option value="Indonesia">Indonesia</option> <option value="Ireland (Republic)">Ireland (Republic)</option> <option value="Israel">Israel</option> <option value="Italy">Italy</option> <option value="Jamaica">Jamaica</option> <option value="Japan">Japan</option> <option value="Jordan">Jordan</option> <option value="Kazakhstan">Kazakhstan</option> <option value="Kenya">Kenya</option> <option value="Kiribati">Kiribati</option> <option value="Kuwait">Kuwait</option> <option value="Kyrgyzstan">Kyrgyzstan</option> <option value="Laos">Laos</option> <option value="Latvia">Latvia</option> <option value="Lesotho">Lesotho</option> <option value="Liechtenstein">Liechtenstein</option> <option value="Lithuania">Lithuania</option> <option value="Luxembourg">Luxembourg</option> <option value="Madagascar">Madagascar</option> <option value="Malawi">Malawi</option> <option value="Malaysia">Malaysia</option> <option value="Maldives">Maldives</option> <option value="Mali">Mali</option> <option value="Malta">Malta</option> <option value="Marshall Islands">Marshall Islands</option> <option value="Martinique">Martinique</option> <option value="Mauritania">Mauritania</option> <option value="Mauritius">Mauritius</option> <option value="Mayotte">Mayotte</option> <option value="Mexico">Mexico</option> <option value="Micronesia (Fed. States of)">Micronesia (Fed. States of)</option> <option value="Monaco">Monaco</option> <option value="Mongolia">Mongolia</option> <option value="Montserrat">Montserrat</option> <option value="Morocco">Morocco</option> <option value="Mozambique">Mozambique</option> <option value="Namibia">Namibia</option> <option value="Nauru">Nauru</option> <option value="Nepal">Nepal</option> <option value="Netherlands">Netherlands</option> <option value="Netherlands Antilles">Netherlands Antilles</option> <option value="New Caledonia">New Caledonia</option> <option value="New Zealand">New Zealand</option> <option value="Nicaragua">Nicaragua</option> <option value="Niger">Niger</option> <option value="Niue">Niue</option> <option value="Norfolk Island">Norfolk Island</option> <option value="Norway">Norway</option> <option value="Oman">Oman</option> <option value="Palau (Belau)">Belau (Pelau)</option> <option value="Panama">Panama</option> <option value="Papua New Guinea">Papua New Guinea</option> <option value="Peru">Peru</option> <option value="Philippines">Philippines</option> <option value="Pitcairn Islands">Pitcairn Islands</option> <option value="Poland">Poland</option> <option value="Portugal">Portugal</option> <option value="Qatar">Qatar</option> <option value="Reunion">Reunion</option> <option value="Romania">Romania</option> <option value="Russia">Russia</option> <option value="Rwanda">Rwanda</option> <option value="Samoa">Samoa</option> <option value="San Marino">San Marino</option> <option value="Sao Tome & Principe">Sao Tome & Principe</option> <option value="Saudi Arabia">Saudi Arabia</option> <option value="Senegal">Senegal</option> <option value="Seychelles">Seychelles</option> <option value="Sierra Leone">Sierra Leone</option> <option value="Singapore">Singapore</option> <option value="Slovakia">Slovakia</option> <option value="Slovenia">Slovenia</option> <option value="Solomon Islands">Solomon Islands</option> <option value="Somalia">Somalia</option> <option value="South Africa">South Africa</option> <option value="South Korea">South Korea</option> <option value="Spain">Spain</option> <option value="Sri Lanka">Sri Lanka</option> <option value="St Christopher(St Kitts) & Nevis">St Christopher(St Kitts) & Nevis</option> <option value="St Helena">St Helena</option> <option value="St Lucia">St Lucia</option> <option value="St Pierre & Miquelon">St Pierre & Miquelon</option> <option value="St Vincent & Grenadines">St Vincent & Grenadines</option> <option value="Suriname">Suriname</option> <option value="Svalbard and Jan Mayen Islands">Svalbard and Jan Mayen Islands</option> <option value="Suriname">Suriname</option> <option value="Swaziland">Swaziland</option> <option value="Sweden">Sweden</option> <option value="Switzerland">Switzerland</option> <option value="Syria">Syria</option> <option value="Taiwan">Taiwan</option> <option value="Tajikistan">Tajikistan</option> <option value="Tanzania">Tanzania</option> <option value="Thailand">Thailand</option> <option value="Togo">Togo</option> <option value="Tonga">Tonga</option> <option value="Trinidad & Tobago">Trinidad & Tobago</option> <option value="Tunisia">Tunisia</option> <option value="Turkey">Turkey</option> <option value="Turkmenistan">Turkmenistan</option> <option value="Turks & Caicos Islands">Turks & Caicos Islands</option> <option value="Tuvalu">Tuvalu</option> <option value="Uganda">Uganda</option> <option value="Ukraine">Ukraine</option> <option value="United Arab Emirates">United Arab Emirates</option> <option value="United Kingdom">United Kingdom</option> <option value="United States Of America">United States Of America</option> <option value="Uruguay">Uruguay</option> <option value="Vanuatu">Vanuatu</option> <option value="Vatican City State">Vatican City State</option> <option value="Venezuela">Venezuela</option> <option value="Vietnam">Vietnam</option> <option value="Wallis & Futuna Islands">Wallis & Futuna Islands</option> <option value="Yemen">Yemen</option> <option value="Zambia">Zambia</option> </select> </div></td> </tr> <tr> <td class="style123"><div align="left">Email Address</div></td> <td><span class="style150">*</span></td> <td><div align="left"> <input type="text" name="email" value="" id="email" /> </div></td> </tr> </table></td> </tr> <tr> <td height="50" bgcolor="#CCCCCC"><div align="center"> <input name="submit" type="image" onclick="CalculateOrder(this.form)" onmouseover="validate(this.form)" src="https://www.theauctionwinners.com/main/payment/images/paymentBtn.gif" alt="Continue To PayPal" width="152" height="50" border="0" /> <input type="hidden" name="upload" value="1" /> <input type="hidden" name="cmd" value="_cart" /> <input type="hidden" name="business" value="john@future-resourcings.com" /> <input type="hidden" name="item_name_1" value="Adam Ginsberg's The Closely Guarded Secrets Of An Ebay Millionaire - Make Money On eBay - FAST TRACK DVD Home Study Course (Inc VAT)" /> <input type="hidden" name="quantity_1" value="1" /> <input type="hidden" name="amount_1" value="97.00" /> <input type="hidden" name="shipping_1" /> <input type="hidden" name="item_number_1" /> <input type="hidden" name="country" /> <input type="hidden" name="currency_code" value="GBP"/> <input type="hidden" name="no_shipping" value="2" /> <input type="hidden" name="return" value="http://www.theauctionwinners.com/main" /> <input type="hidden" name="bn" value="TheAuctionWinners_ShopCart_WPS_GB" /> <!-- Enable override of payer’s stored PayPal address. --> <input type="hidden" name="address_override" value="1" /> </div></td> </tr> <tr> <td bgcolor="#FFFFFF"><div align="center"><span class="style125">I authorise Future Resourcings Ltd to charge me for the above sub-total and forthcoming postage & package. I further affirm that the personal information provided on this form are true and correct.</span></div></td> </tr> </table>Comment
-
Comment
-
For the fields, either add an ID so you can use document.getEle mentById() to access them or use:
To make a POST request (use the send() method), construct the field-value parameters, e.g.Code:document.getElementById("form").elements[name-of-field].value
Code:var urlparams = "first_name=" + encodeURIComponent(document.getElementById("first_name").value); urlparams += "&last_name=" + encodeURIComponent(document.getElementById("first_name").value); // and so on...Comment
-
That's what you would have to do to make a request to a PHP file, but in that PHP file, it should contain the code to deal with the passed values. The change you have to make to pass form values would be in makeRequest before you open:
assuming you already have a parameter, e.g. "file.php?var=1 ".Code:url += "&fieldname=" + encodeURIComponent(document.getElementById("fieldID").value);
you have lost me on here....im a newbie with ajax, i dont want any alerts as long as i test it and see the values going into the database that's fine.
"file.php?var=1 " <---where do i add this in?Comment
-
ok i understand on how to select the fields i need but i don't understand where to put that in the codeComment
-
Comment