|
JavaScript - Populate An Html Form With Php Db Results
Hi,
I'm working on a menu update form. I'm pulling the existing data from mysql and posting it into a form, using php. This works fine. But now I want the user to be able to modify the data and perform and update query to the database with the changes. I cannot figure out how to get the modified php text box data into my html form text boxes so I can run an update query. I would be ok with a button that transfers the php text box data to the html form data. Hope this is clear what I'm trying to do, seems simple enough, but I can't figure it out. Thanks in advance for any ideas. Similar TutorialsHello All, I have a form where the number of input fields (lets call them B through N) is determined by the length of a php array. Above those input fields is another field (lets call this field input A) that I would like to be auto populated based on what the user enters in fields B through N. Here is my code. The first table (with all of the "totals" fields) holds all of the input fields that I would like to auto update. These fields should auto update so that every input in EACH of the "fy" fields in the second table is added together. Example: every input in the id="fy_{$fy.fy}_high_impact_cost" field should be added together as the user enters them, and the id="totals_high_impact_cost" field should be auto updated with that total. Code: <form method="post" name="submit" action="new_item.php" accept-charset='UTF-8'> <table border="box" width="100%"> <tr> <td align="center">$<input id="totals_high_impact_cost" size="3" name="totals_high_impact_cost" maxlength="20" style="text-align: right" />M</td> <td align="center">$<input id="totals_most_likely_impact_cost" size="3" name="totals_most_likely_impact_cost" maxlength="20" style="text-align: right" />M</td> <td align="center">$<input id="totals_low_impact_cost" size="3" name="totals_low_impact_cost" maxlength="20" style="text-align: right" />M</td> <td align="center">$<input id="totals_actual_expense" size="3" name="totals_actual_expense" maxlength="20" style="text-align: right" />M</td> <td align="center">$<input id="totals_high_mitigation_cost" size="3" name="totals_high_mitigation_cost" maxlength="20" style="text-align: right" />M</td> <td align="center">$<input id="totals_most_likely_mitigation_cost" size="3" name="totals_most_likely_mitigation_cost" maxlength="20" style="text-align: right" />M</td> <td align="center">$<input id="totals_low_mitigation_cost" size="3" name="totals_low_mitigation_cost" maxlength="20" style="text-align: right" />M</td> <td align="center">$<input id="totals_cost_in_scope" size="3" name="totals_cost_in_scope" maxlength="20" style="text-align: right" />M</td> <td align="center">$<input id="totals_unfunded_threat" size="3" name="totals_unfunded_threat" maxlength="20" style="text-align: right" />M</td> </tr> </table> {foreach value=fy from=$php_array} <table> <tr> <td align="center">$<input id="fy_{$fy.fy}_high_impact_cost" size="3" name="fy_{$fy.fy}_high_impact_cost" maxlength="20" style="text-align: right" value="{$fy.high_impact_cost}" onchange="update_totals_high_impact_cost()" />M</td> <td align="center">$<input id="fy_{$fy.fy}_most_likely_impact_cost" size="3" name="fy_{$fy.fy}_most_likely_impact_cost" maxlength="20" style="text-align: right" value="{$fy.most_likely_impact_cost}" />M</td> <td align="center">$<input id="fy_{$fy.fy}_low_impact_cost" size="3" name="fy_{$fy.fy}_low_impact_cost" maxlength="20" style="text-align: right" value="{$fy.low_impact_cost}" />M</td> <td align="center">$<input id="fy_{$fy.fy}_actual_expense" size="3" name="fy_{$fy.fy}_actual_expense" maxlength="20" style="text-align: right" value="{$fy.actual_expense}" />M</td> <td align="center">$<input id="fy_{$fy.fy}_high_mitigation_cost" size="3" name="fy_{$fy.fy}_high_mitigation_cost" maxlength="20" style="text-align: right" value="{$fy.high_mitigation_cost}" />M</td> <td align="center">$<input id="fy_{$fy.fy}_most_likely_mitigation_cost" size="3" name="fy_{$fy.fy}_most_likely_mitigation_cost" maxlength="20" style="text-align: right" value="{$fy.most_likely_mitigation_cost}" />M</td> <td align="center">$<input id="fy_{$fy.fy}_low_mitigation_cost" size="3" name="fy_{$fy.fy}_low_mitigation_cost" maxlength="20" style="text-align: right" value="{$fy.low_mitigation_cost}" />M</td> <td align="center">$<input id="fy_{$fy.fy}_cost_in_scope" size="3" name="fy_{$fy.fy}_cost_in_scope" maxlength="20" style="text-align: right" value="{$fy.cost_in_scope}" />M</td> </tr> </table> {/foreach} </form> Please email me at alexhall12315@yahoo.com if you would like more explanation. Thanks in advance for any help!!! =) hello i am trying to fire a form which after the call to retrieve the data, populate the form with the data. i can see from firebug that the json data is being captured, but cannot seem to be able to populate the form with it. i am using a jquery plugin facybox, that opens the form, but the fields are blank. i have attached my code and would be grateful if someone could tell me where i am going wrong? many thanks js code Code: <script type="text/javascript">
function edit(com, grid) {
if (com == 'Edit') {
if($('.trSelected').length>0){
if($('.trSelected').length>1){
alert('Please select just one row');
return;
}
var items = $('.trSelected');
var itemlist ='';
for(i=0;i<items.length;i++){
itemlist+= items[i].id.substr(3);
}
$.ajax({
type: "POST",
dataType: "json",
url: "tempcontact.php",
data: "items="+itemlist,
success: function(data){
document.getElementById('id').value = data.id;
document.getElementById('email').value = data.email;
$("#flex1").flexReload();
}
});
/*and so on then you can call facybox*/
jQuery.facybox({ div: "#editform"});
} else{
alert('Please select a row to edit.');
}
}
}
</script>
form Code: <div id="editform" style="display:none;"> <form action="conedit.php" method="post" class="webform"> <fieldset> <legend><span>Update Contact</span></legend> <br /> <div id="dataText">Please delete the fields if there is no data 'No data to display'.</div> <label for="id">ID:</label> <input id="id" name="id" class="text" type="text" value="" /> <label for="name">Full Name:</label> <input id="name" name="name" class="text" type="text" value="" /> <label for="email">Email address:</label> <input id="email" name="email" class="text" type="text" value="" /> <label for="phone">Telephone:</label> <input id="phone" name="phone" class="text" type="text" value="" /> <label for="mobile">Mobile:</label> <input id="mobile" name="mobile" class="text" type="text" value="" /> <label for="fax">Fax:</label> <input id="fax" name="fax" class="text" type="text" value="" /> <label for="notes">Notes:</label> <textarea name="notes" cols="25" rows="3"></textarea> </fieldset> <input class="submit" type="submit" name="submit" value="Update" /> </form> </div> I have two slightly different forms on the same page, but I want the values in form1 to auto populate the same form fields in form2. 1 field is a text field, the rest are drop down menus. How would I accomplish this? Link to tutorial would be much appreciated. Thanks
Hi Guys, I am after populating a HTML box (or another language if html wont do) with a number of different files pdfs, exe's etc for customer to download. The content of this box will depend on the choices from two drop down lists. I have got two drop down lists setup filtering off each other... I have thought about tagging each document and then pulling up a file off the choices selected? Not sure the best way to go about this. Regards Heres the code so far.... Code: <HTML>
<HEAD><TITLE>prototype CP</Title>
<style type="text/css">
.style1 {
text-align: center;
}
.style2 {
font-size: small;
color: #FFFFFF;
}
.style3 {
font-size: small;
}
</style>
</Head>
<BODY OnLoad="BuildContacts(0);" style="background-color: #336699; background-image: url('back.jpeg')">
<FORM Name="myForm">
<div class="style1">
<span class="style2">I have a
</span>
<font color="#000000">
<SELECT Name="SalesNames" OnChange="BuildContacts(this.selectedIndex);" class="style3">
<OPTION Value="">
<OPTION Value="nexgen">nexgen
<OPTION Value="zimbra">zimbraCS
<OPTION Value="exchange">exchange
</Select></font><span class="style2">
mailbox and I want to set it up on:
</span>
<font color="#000000">
<SELECT Name="SalesContacts" class="style3">
<OPTION Value="">--------
</Select>
</font>
</div>
</Form>
</Body>
</Html>
<SCRIPT Language="JavaScript"><!--
//Build arrays for each mailbox type
Contacts=new Array(4);
Contacts[0]=new Array(3);
Contacts[1]=new Array(2);
Contacts[2]=new Array(5);
Contacts[3]=new Array(4);
//Nexgen
Contacts[0][0]="";
Contacts[0][1]="Outlook";
Contacts[0][2]="mac mail";
Contacts[0][3]="entourage";
Contacts[0][4]="iPhone";
Contacts[0][5]="Blackberry";
Contacts[0][6]="other mobile phone";
//Zimbra
Contacts[1][0]="Outlook";
Contacts[1][1]="mac mail";
Contacts[1][2]="entourage";
Contacts[1][3]="iPhone";
Contacts[1][4]="Blackberry";
Contacts[1][5]="other mobile phone";
//Exchange
Contacts[2][0]="Outlook";
Contacts[2][1]="mac mail";
Contacts[2][2]="entourage";
Contacts[2][3]="iPhone";
Contacts[2][4]="Blackberry";
Contacts[2][5]="other mobile phone";
//Call this to build the Contact list for the specified Salesperson
function BuildContacts(num)
{
//Select the first Contact
document.myForm.SalesContacts.selectedIndex=0;
//For every contact in the array for this person, add a new option
for(ctr=0;ctr<Contacts[num].length;ctr++)
{
document.myForm.SalesContacts.options[ctr]=new Option(Contacts[num][ctr],Contacts[num][ctr]);
}
//Set the length of the select list
document.myForm.SalesContacts.length=Contacts[num].length;
}
//--></Script>
I want to loop through a form containing various fields and replace them with values I have in a JS object. E.g. (1) <form id="theform"> <input type="text" name="field_1" value="" /> <input type="checkbox" name="field_2" value="" /> </form (2) object.field_1 = "Dave"; object.field_2 = ""; // empty as not checked, else holds value of checked one -- The problem is: what about checkboxes and <select> drop downs, and radios?? Is there a script like this around as I'm guessing this could be useful for Ajax to populate input boxes in some situations (depending on the content etc.) so I'm guessing I'm not the only one who needs this? This form collects info of the customer who wishes to select add-ons that would be applied to their digital photos. Examples of add-ons: Photo makeover Add object or person Crop image Have a look at the form Once a customer selects one of the options (Photo Manipulation or Photo Restoration for example - radio buttons) and then one or more Add-ons (check boxes in the Html form), enter their details and upload a photo, they hit the submit button and it then takes them to the PayPal checkout page where the total amount is shown. (see image below) The Issue: In the PayPal page, it now shows the total amount whichever add-ons you select, however it keeps showing "Add object or person" as well as all the 5 main options (radio buttons on the form) no matter what I select. This will be an issue as I will not know exactly which add-ons the customer has selected. Can someone please help me complete the coding so that the add-ons show on the PayPal checkout page. I look forward to your reply/replies. Kind Regards Rafi p.s: Could this be a possible solution? Even if it is, can someone help by completing the code? In order to send the options/add-ons the customer selects I may need to use the onX and osX variables (Where X is a number starting with 0 and incrementing by 1 see below), These can be used to set options for the add-onsthey select. The onO is the "option name" and os0 is the "option choice". So for example: <input type="hidden" name="on0" value="Photo manipulation"> <input type="hidden" name="os0" value="Whatever add-ons the customer selects"> <input type="hidden" name="on1" value="Photo restoration"> <input type="hidden" name="os1" value="Whatever add-ons the customer selects"> i want to use arrays to populate an HTML list. I can populate the main list items but I can't seem to get the sub list items to work. Can anyone point out my mistake? Code:
<HTML>
<Body>
<ul>
<script>
var pages = ["page1", "page2","page3"];
var subPages = ["sub1","sub2"];
for(var i = 0; i < pages.length; i++){
var page = pages[i];
document.write('<li>' + page + '</li>');
if (page == "page2"){
document.write('<ul>');
for(var i = 0; i < subPages.length; i++){
var subPage = subPages[i];
document.write('<li>' + subPage + '</li>');
}
document.write('</ul'>);
}
}
</script>
</ul>
</body>
</HTML>
Hi all I have relatively easy task I need to accomplish but as per usual I have very little idea of how to do it. I have done a google search to no avail. Basically I need to: 1. Pull a value from inside a div Code: <div id="number">(invoice #1017)</span> 2. Populate a form input field with that value. Does this make sense? If not let me know if you need any more info. Thanks I would like to set up an image gallery so that when customer clicks on their chosen image, the image caption populates into the associated field in the form below the gallery, on the same page. Any way you know of to do this? I am not really a coder, I only know this and that, so examples or detailed instructions will be most helpful. Thanks very much. Hi All! Thanks in advance to any and all who help me. What we are trying to do is have a form where customers can use a conditional logic based form that upon submission will redirect to checkout with an appropriate product bundle being populated in the shopping cart. I have some experience with creating forms, in fact I have made a decent form that I have modified from an online form builder... the problem is I have no idea how to auto-fill the shopping cart... period. From what I have read in my research this should be a function of Javascript. I have a decent working knowledge of php, and html, but I am pretty clueless when it comes to Javascript, if anyone could point me in the right direction for this project I would really appreciate it. Hello, I have 2 things I'm trying to figure out. 1. First form on the page has questions with radio buttons. Each radio's value is a number so a score is assessed at the end. 2. Second form on the page is an email the admin form, which duplicates the score in one field. Question: I would like to know how to write the form results to a text area in second form. However, I can't do this for one, and secondly, the value is a number, can I use labels? Here's the code I've 'made up' so far... JS (i know it's wrong) Code: <script LANGUAGE="JavaScript" type="text/javascript">
function display() {
message = "<ul><li><b>Question 1: </b>" + document.quizform.Q1.label;
message = "<li><b>Question 2: </b>" + document.quizform.Q2.label;
message = "<li><b>Question 3: </b>" + document.quizform.Q3.label;
message = "<li><b>Question 4: </b>" + document.quizform.Q4.label;
message = "<li><b>Question 5: </b>" + document.quizform.Q5.label;
message = "<li><b>Question 6: </b>" + document.quizform.Q6.label + "</ul>";
document.write(message);
}
</script>
Form field example: Code: Question 1:<BR> <label for="Yes"><input type="radio" name="Q1" value="0" checked></label>Yes<br> <label for="No"><input type="radio" name="Q1" value="10"></label>No<br> <label for="I don't know"><input type="radio" name="Q1" value="10"></label>I don't know<br> I am working on a page where the user will select a location from a dynamically generated dropdown list. I was able to create the php multidimensional array (tested and working) from a MySql database using the users information at login, but I'm having problems converting it to a javascript multidimensional array. I need to be able to access variables that I can pass to a number of text fields within an html form. For instance, if a user belongs to a company with multiple addresses, I need to be able to let them select the address they need to prepopulate specific text fields. php array creation: Code: if ($row_locations)
{
while ($row_locations = mysql_fetch_assoc($locations))
{
$mail[$row_locations['comp_id']]=array('mailto'=>$row_locations['mailto'], 'madd'=>$row_locations['madd'], 'madd2'=>$row_locations['madd2'], 'mcity'=>$row_locations['mcity'], 'mstate'=>$row_locations['mstate'], 'mzip'=>$row_locations['mzip'], 'billto'=>$row_locations['billto'], 'badd'=>$row_locations['badd'], 'badd2'=>$row_locations['badd2'], 'bcity'=>$row_locations['bcity'], 'bstate'=>$row_locations['bstate'], 'bzip'=>$row_locations['bzip']);
}
}
javascript function - this should create the array and send variables to text fields. Code: function updateAddress() {
var mail = $.parseJSON(<?php print json_encode(json_encode($mail)); ?>);
{
if (comp_id in mail) {
document.getElementById('mailto').value=mail.comp_id.mailto.value;
document.getElementById('madd').value=mail.comp_id.madd.value;
document.getElementById('madd2').value=mail.comp_id.madd2.value;
document.getElementById('mcity').value=mail.comp_id.mcity.value;
document.getElementById('mstate').value=mail.comp_id.mstate.value;
document.getElementById('mzip').value=mail.comp_id.mzip.value;
} else {
document.getElementById('mailto').value='';
document.getElementById('madd').value='';
document.getElementById('madd2').value='';
document.getElementById('mcity').value='';
document.getElementById('mstate').value='';
document.getElementById('mzip').value='';
}
}
}
Where is this breaking? Thanks in advance. Hi I'm putting together the following website, HGV/LGV Training and have an issue regarding a form submit action. Basically I've used an open-source script for the search form so can't get any support from the Author. My problem is that I need the search results to appear in a different URL but at the moment they just appear in a new DIV on the home page. My knowledge of JS is limited and can't get my head around what the OS script is doing. I think the relevant section of the search form is as follows: <form method=post action=<?echo $_PHP_SELF;?>> <input type="text" name="zipcode"> <? echo show_country_codes(); ?> Any help on this would be greatly appreciated. Keith. Fixed.
I have a form with results and ID's for each field, I can get an alert to popup with the results, is there anyway to display this on the webpage? This is what I have so far: Code: document.getElementById('result').write(account.value +" "+ rep.value +" "+ error1.value +" "+ fix.value);
along with this in the HTML: Code: <p id='result'></p> I am having some trouble with this form and I was hoping someone could help me with it. It is not returning any errors, it is simply not returning the results of the form fields. The clear form works, the redirect works, the layout is fine, just no results. I am just beginning to learn Javascripts and I know this is a pretty basic script, but could someone be so kind to show me what it is I am doing wrong and teach me the right way to do this? I know it has to be something very simple but I keep going over it and i can not see what I am doing wrong. Rather than just post a snipit of the code I included the whole form so I do not forget to include any information. Thanks guys, I really appreciate it! Code: <form name="evaluation"
action="http://www.YOURURL.com/webformmailer.php"
target="_self" method="post"><input
value="Submission" name="subject" type="hidden" /><input
value="evaluationreturn.html" name="redirect"
type="hidden" />
<span style="font-family: Arial,Helvetica,sans-serif;"><span
style="font-weight: bold;"><br />
<table bgcolor="F7F5F2" border="0"
cellpadding="0" cellspacing="0" width="456">
<tbody>
<tr>
<td><span style="color: rgb(40, 89, 161);">Comment 1</span><br
style="color: rgb(40, 89, 161);" />
<br style="color: rgb(40, 89, 161);" />
<span style="color: rgb(40, 89, 161);">Comment 2</span><br
style="color: rgb(40, 89, 161);" />
<br style="color: rgb(40, 89, 161);" />
<span style="color: rgb(40, 89, 161);">comment 3</span><br />
<br />
</td>
</tr>
<tr>
<td height="28" valign="top">
<table style="width: 456px; height: 52px;"
border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="width: 137px; text-align: left; color: rgb(40, 89, 161);"
class="text_1">Your name:</td>
<td style="width: 40px;"><img
src="images/spacer.gif" height="1" width="1" /></td>
<td style="width: 271px;"><input
name="yourname" class="form_1" type="text" /></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td height="28" valign="top">
<table style="width: 456px; height: 52px;"
border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="width: 137px; text-align: left; color: rgb(40, 89, 161);"
class="text_1">Business name:</td>
<td style="width: 40px;"><img
src="images/spacer.gif" height="1" width="1" /></td>
<td style="width: 271px;"><input
name="businessname" class="form_1" type="text" /></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td height="75" valign="top">
<table style="width: 456px;" border="0"
cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td class="text_1"
style="padding-top: 3px; width: 138px; text-align: left; vertical-align: middle; color: rgb(40, 89, 161);">Business
Location:</td>
<td style="width: 38px;"><img
src="images/spacer.gif" height="1" width="1" /></td>
<td style="width: 272px;"><textarea
name="location" class="form_1"></textarea></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td height="40" valign="top">
<table style="width: 456px;" border="0"
cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="padding-top: 3px; width: 138px; text-align: left; vertical-align: middle; color: rgb(40, 89, 161);"
class="text_1">Business
Hours:</td>
<td style="width: 38px;"><img
src="images/spacer.gif" height="1" width="1" /></td>
<td style="width: 272px;"><textarea
name="businesshours" class="form_1"></textarea></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td height="28" valign="top">
<table style="width: 456px; height: 50px;"
border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="text-align: left; width: 143px; color: rgb(40, 89, 161);"
class="text_1">Reservation required?</td>
<td style="width: 34px;"><img
src="images/spacer.gif" height="1" width="1" /></td>
<td style="width: 271px;"><input
name="reservation" class="form_1" type="text" /></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td height="28" valign="top">
<table style="width: 456px; height: 50px;"
border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="width: 138px; text-align: left; color: rgb(40, 89, 161);"
class="text_1">Reservation Telephone Number:</td>
<td style="width: 39px;"><img
src="images/spacer.gif" height="1" width="1" /></td>
<td style="width: 271px;"><input
name="reservationphone" class="form_1" type="text" /></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td height="28" valign="top">
<table style="width: 456px; height: 50px;"
border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="width: 138px; text-align: left; color: rgb(40, 89, 161);"
class="text_1">E-mail address:</td>
<td style="width: 39px;"><img
src="images/spacer.gif" height="1" width="1" /></td>
<td style="width: 271px;"><input
name="email" class="form_1" type="text" /></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td height="28" valign="top">
<table style="width: 456px; height: 50px;"
border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="width: 138px; text-align: left; color: rgb(40, 89, 161);"
class="text_1">Your contact number:</td>
<td style="width: 39px;"><img
src="images/spacer.gif" height="1" width="1" /></td>
<td style="width: 271px;"><input
name="yournumber" class="form_1" type="text" /></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td height="91" valign="top">
<table style="width: 456px;" border="0"
cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td class="text_1"
style="vertical-align: top; padding-top: 3px; width: 138px; text-align: left; color: rgb(40, 89, 161);">Select
dates to perform evaluation: From/To <br />
Maximum of 30 days</td>
<td style="width: 38px;"><img
src="images/spacer.gif" height="1" width="1" /></td>
<td style="width: 272px;"><textarea
name="performdate" class="form_2"></textarea></td>
</tr>
<tr>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<br />
</span></span>
<table style="text-align: left; width: 458px;"
border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="width: 220px; text-align: center;">
<p> <input value="Clear Form"
onclick="reset(); return false;" type="reset" /></p>
<input value="alpha" name="form_order"
type="hidden" />
</td>
<td style="width: 218px; text-align: center;">
<p> <input value="Submit"
onclick="submit();" type="submit" /></p>
<input value="alpha" name="form_order"
type="hidden" />
</td>
</tr>
</tbody>
</table>
<span style="font-family: Arial,Helvetica,sans-serif;"><span
style="font-weight: bold;"></span></span></form>
I have a form that is submitted via jquery into a mysql database using php Code: <form method="post" name="add_loc_form" id="add_loc_form">
<table width="100%" align="center" cellspacing="0">
<tr>
<td class="cat"><h2>Add Location</h2></td>
<td align="right" class="cat"><a href="#" class="loc_help_a"><img src="{T_THEME_PATH}/images/help.gif" /></a></td>
</tr>
</table>
<div id="loc_help" style="width:95%; display:none; padding:2.5%; background-color:#FFE9D2"> help txt</div>
<table width="70%" align="center">
<tr>
<td valign="top">latitude</td>
<td valign="top"><input type="text" name="loc_long" id="loc_long" size="20" /></td>
</tr>
<tr>
<td valign="top">Longitude</td>
<td valign="top"><input type="text" name="loc_lat" id="loc_lat" size="20" /></td>
</tr>
<tr>
<td valign="top">Place name</td>
<td valign="top"><input type="text" name="loc_place" id="loc_place" size="40" /></td>
</tr>
<tr>
<td valign="top">Description</td>
<td><textarea cols="30" rows="3" id="loc_desc" name="loc_desc"></textarea></td>
</tr>
<tr>
<td colspan="2" align="center" valign="top"><input type="submit" value="add" name="add_loc" id="add_loc" />
<button class="close_add_loc">close</button></td>
</tr>
</table>
</form>
Its is then passed to the jquery Code: $("#add_loc_form").submit(function() {
var loc_long = $('#loc_long').val();
var loc_lat = $('#loc_lat').val();
var loc_place = $('#loc_place').val();
var loc_desc = $('#loc_desc').val();
var dataString = "loc_long="+ loc_long +"&loc_lat="+ loc_lat +"&loc_place="+ loc_place +"&loc_desc="+ loc_desc;
if(loc_long=='') {
$("loc_long").css("border-color:red");
return false;
}
if(loc_lat=='') {
$("loc_lat").css("border-color:red");
return false;
}
if(loc_place=='') {
$("loc_place").css("border-color:red");
return false;
}
if(loc_desc=='') {
$("loc_desc").css("border-color:red");
return false;
}
$.ajax({
type: "POST",
url: "./ajax.php",
data: dataString,
success: function()
{
$('form').clearForm();
$("#add_map_locations").fadeOut(600);
$("#map_add_success").fadeIn(600);
}
});
return false;
});
the php is PHP Code: mysql_query("INSERT INTO table_locations (longitude, latitude, place_name, description, user_id) VALUES ('$loc_long', '$loc_lat', '$loc_place', '$loc_desc', '$user_id')"); The problem is when each entry has a number in it its submitting a rounded number to the database ie loc_long's value is -2.329102 but its submitting -2 for some reason, if you put numbers in the place or description fields its saving as a rounded number as above. If you put text in any of the fields its saving 0 instead of the text. The fields in the database as set to varchar so its not that. Can anyone help please. hello everybody, I need help about, I need to change the result to opening a url page. This script results in a value and I need the result to be open a url page. Can anyone help me?? <SCRIPT language="Javascript"> nome = new Array(4); nome[0] = new Array(4); nome[1] = new Array(4); nome[2] = new Array(4); nome[3] = new Array(4); nome[0][0]="1500"; nome[0][1]="1250"; nome[0][2]="1300"; nome[1][0]="800"; nome[1][1]="850"; nome[1][2]="900"; nome[2][0]="500"; nome[2][1]="520"; nome[2][2]="540"; nome[3][0]="400"; nome[3][1]="356"; nome[3][2]="234"; function affi() { document.form.txt.value=nome[document.form.liste.selectedIndex][document.form.taille.selectedIndex]; } </SCRIPT> <form name="form" class="texto" > Choose the article : <select name="liste"> <option>Camisas <option>Polos <option>T-shirts <option>base corporal </select> <br> Choose the size: <select name="taille"> <option>T. Small <option>T. Médium <option>T. Large </select> <br> <input type="button" value="Obter preço" onClick="affi(this.form)" name="button"> <br> <br> <input type="TEXT" name="txt"> </form> Thank's in advance rui All, I currently have a form on my page and I found this on the jQuery website: Code: $.post("test.php", $("#testform").serialize());
However, I want to do something after the results are posted so I think I need a hybrid of the one above and this one: Code: $.post("test.php", function(data) {
alert("Data Loaded: " + data);
});
Any help would be greatly appreciated. My form id is saveCrop, not sure if that makes a difference or not. Thanks in advance! |
|||||||