"...Remember being a youngster, mom or dad telling you "close the door"? Well the same applies to HTML ...."

Go Back   Webmaster Forums > Code Forum > Javascript Forum

Reply
 
Thread Tools Rate this Webmaster Discussion
Old 10-30-2009, 10:27 AM   #1
dreadrocksean
New Member
 
Join Date: Oct 2009
Webmaster Discussions: 1
Rep Power: 6
dreadrocksean is on a distinguished road
Populate fields by javascript using MYSQL

Hi folks.
I have an html form button that runs a javascript function that in turn creates a row of fields on the same form as the button.
When this form is submitted, each row of fields is stored as a separate record in a mysql database on the server. Each of these records is stamped with the customer id of the logged in user. This works fine.
However, I would like to auto create these fields and populate them with the records that match a logged in user's customer id.
I have php code that retrieves the data just fine.
My problem is, how do I go about populating these rows of fields since they are dynamically produced from a javascript function? In other words, how do I get the data retrieved by my php queries INTO the javascript function that creates these fields in order to assign the values?

Here are the code snippets:

HTML Code:
        <tr>
          <td align="center"><div id="readroot" style="display: none">
			<input type="button" value="Remove Item"
				onclick="this.parentNode.parentNode.removeChild(this.parentNode);" />
            <input type="hidden" name="id" value="-1"/>
            <input name="field1" onFocus="this.value='';" onclick="this.value='';" value="1" size="3" maxlength="3" id="field1" />
            <input name="field2" onFocus="this.value='';" onclick="this.value='';" value="" size="20" maxlength="20" id="field2" />
            <input name="field3" onFocus="this.value='';" onclick="this.value='';" value="field3" size="20" maxlength="20" id="field3" />
            <input name="field4" onFocus="this.value='';" onclick="this.value='';" value="field4" size="10" maxlength="10" id="field4" />
            <input name="field5" id="field5" type="checkbox" value="1" checked />
            <!-- end #readroot -->
            </div>
            <span id="writeroot"></span>
            <input type="button" name="btnMoreFields" id="btnMoreFields" onclick="moreFields('perm', '1');" value="Add List Item" />
            <input type="submit" value="List" />
            <input type="button" name="btnPrevList" id="btnPrevList" onclick="prevList();" value="Show Prev List" />
            <input type="hidden" name="redirect" value="redirect_address" />
            <input type="hidden" name="form_order" value="default"/>
            <input type="hidden" name="form_delivery" value="default"/>
            <input type="hidden" name="form_format" value="html"/></td>
        </tr>
Code:
<script type="text/javascript">
var counter = 0;

function moreFields() {
	counter++;
	var newFields = document.getElementById('readroot').cloneNode(true);
	newFields.id = '';
	newFields.style.display = 'block';
	var newField = newFields.childNodes;
	for (var i=0;i<newField.length;i++) {
		var theName = newField[i].name
		if (theName) {
			newField[i].name = theName + counter;
			newField[i].value = newField[i].name;
		}
	}
	var insertHere = document.getElementById('writeroot');
	insertHere.parentNode.insertBefore(newFields,insertHere);
	pageScroll();
}
</script>


dreadrocksean is offline   Reply With Quote
Reply

Bookmarks

Tags
javascript

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Webmaster Discussions
Thread Webmaster Discussion Starter Forum Replies Last Post
Populate multi text field and saving them in mysql Kid Javascript Forum 0 10-14-2009 12:12 AM
[Javascript] Populate a Text field via MYSQL Drop Down xChAMaRx Javascript Forum 11 10-11-2009 07:27 AM
Populate fields when checkbox selected Working123 Javascript Forum 0 03-23-2007 03:22 PM
MySQL fields dependance eternity Databases 3 05-31-2005 04:44 AM
Help to populate DIV from an array woodknut Javascript Forum 3 07-19-2004 12:38 PM


All times are GMT -5. The time now is 09:07 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.