creating the row dynamically and saving the data to a database

hello guys...

today i need again help...
actually i face problem the in adding new row at run time...

coding....

Expand|Select|Wrap|Line Numbers

 
<html>

<script type ="text/javascript">

Expand|Select|Wrap|Line Numbers

 
var counter=0;

function addRow()

{
 
 var trow=document.getElementById('tblGrid').insertRow();
 
 var tdata1=trow.insertCell(0);

 var tdata2=trow.insertCell(1);
 
tdata1.innerHTML="<input type='text' id='product' maxlength='50' class='Text' name='product'>";

tdata2.innerHTML="<input type='text' id='price' maxlength='50' class='Text' name='price'>";

}

Expand|Select|Wrap|Line Numbers

 
</script>

<body>

<form name="sample" action="sample1.php" method="post">

  <table id="tblGrid" style="table-layout:fixed">

    <tr>

      <th width="150">Product Name</th>

      <th width="150">Price</th>

      <input name="button" type="button" onClick= "return addRow();" value="Add" >

      <input type="submit" value = "save" name="submit">

    </tr>

    <tr>

      <td height="21"></td>

      <td></td>

      <td width="14">&nbsp;&nbsp;</td>

    </tr>

  </table>

</form>

</body>

</html>

the above is my code which create the row dynmically...
my problem is thati want to store the value of each row in database using php...
how we accomplish this task...
pleas tell me...
i try last one week but not successfull...
so please help me...
and send me the solution...
i requested u to please try solve this problem using example...
i shall be very thank ful to you...
i wait your reply...

vivek kumar

Sep 24 '07 #1

Subscribe Post Reply

4108

pbmods

5,821

Expert 4TB

Heya, Vivek.

Please use CODE tags when posting source code:

[CODE=html]
HTML code goes here.
[/CODE]

This is not the first time you've been asked.

PHP operates on the server side. To dynamically create a row, you need to use JavaScript. To communicate with the server, you'll want to use AJAX.

I'm going to go ahead and move this thread to the JavaScript / AJAX forum, where our resident Experts will be better able to help you out.

Sep 24 '07 #2

Lmac

This is a similar problem I am having. I have used a clone tool, but I find your way of going about it even better.

The problem I'm faced with however is making the new rows uniquely identifiable in my SQL Database. Any suggestions on how to go about that?

Here is the current code I've been using (obviously I won't be able to use the clone method anymore, so I don't know how helpful it will be - it's based on code I found somewhere around the web)

Expand|Select|Wrap|Line Numbers

  
<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;

    }

    var insertHere = document.getElementById('writeroot');

    insertHere.parentNode.insertBefore(newFields,insertHere);

}

window.onload = moreFields;
 
function toggleField(val) {

var o = document.getElementById('other');

(val == 'other')? o.style.display = 'block' : o.style.display = 'none';

} 
 
</script>
 
<div id="readroot" style="display: none">
 
    <input type="button" value="Remove review"

        onclick="this.parentNode.parentNode.removeChild(this.parentNode);" /><br /><br />
 
    <input name="cd" value="title" />
 
    <select name="rankingsel">

        <option>Dansblog</option>

        <option value="excellent">Excellent</option>

        <option value="good">Good</option>

        <option value="ok">OK</option>

        <option value="poor">Poor</option>

        <option value="bad">Bad</option>

    </select><br /><br />

<input type="text" name="other" id="other" style="display: none;">

    <textarea rows="5" cols="20" name="review">Short review</textarea>

    <br />Radio buttons included to test them in Explorer:<br />

    <input type="radio" name="something" value="test1" />Test 1<br />

    <input type="radio" name="something" value="test2" />Test 2

<form action="" method="post">

<select name="sel" id="sel" onChange="toggleField(this.value);">

<option value="">No Option</option>

<option value="Out of Office">Out of Office</option>

<option value="Holiday/Birthday">Holiday/Birthday</option>

<option value="other">other</option>

</select>

<input type="text" name="other" id="other" style="display: none;">

</form>

</div>
 
    <span id="writeroot"></span>
 
    <input type="button" onClick="moreFields()" value="Give me more fields!" />

    <input type="submit" value="Send form" />
 
</form>

Apologies for over running the thread, but i had a similar problem and thought it would be better to discuss in a pre-existing thread.

Sep 26 '07 #3

acoder

16,027

Expert Mod 8TB

Welcome to TSDN!

The problem I'm faced with however is making the new rows uniquely identifiable in my SQL Database. Any suggestions on how to go about that?

Is this uniquely identifiable over all records or just within one page use? If it's over all records, you will need to use Ajax to query the database for a unique number.

Sep 26 '07 #4

Lmac

Welcome to TSDN!
Is this uniquely identifiable over all records or just within one page use? If it's over all records, you will need to use Ajax to query the database for a unique number.

Well, to describe the problem more in depth.

What I want to do is include a career pathway section. These values (course, date enrolled, course start date, course end date etc) need to be stored in the database. The first one is fine obviously, but I need to add another 3 of these forms, and they all need to be unique to help keep track of all 4 career pathways.

Just to clarify, there is a table for the student's details and another table for the pathways. The pathways already have an automatically incrementing ID, so keeping them separate probably isn't the root of the problem. More so actually being able to create the fields to be unique (ie careerPath1, careerPath2 etc.) so that I may withdraw the data from the form into the database.

I hope that makes sense.

I'm not particularly well versed in AJAX, in all honesty I don't think we've even been taught how to use it nor when it would be good to use. So any help on this matter is appreciated.

Thanks for the welcome.

Sep 27 '07 #5

acoder

16,027

Expert Mod 8TB

Create a counter and increment it each time. If careerPath1, 2, 3, etc. is for just the page and it's only used to identify fields on the next page, that will be fine.

However, if you already have, say, careerPath1 through to 12 in the database and you need the next field to be called careerPath13, you could check the database with the server-side code when loading the page and set the counter to that value.

Sep 27 '07 #6

Similar topics

saving data to xml

by: adrin | last post by:

hi, i am writing a program that is supposed to create a database of my music and albums. i want it to consist of 3 'modules' input<->processing<->output. input should enable reading data from cd...

C# / C Sharp

Create EnterpriseLibrary.Data.Database object from connection stri

by: Jake_adl | last post by:

Is there any way to create a Microsoft.Practices.EnterpriseLibrary.Data.Database object without reading from a configuration file? I am writing a utility that manages databases in SQL Server....

.NET Framework

DataGrid: how to have a footer row dynamically sum data

by: Roger Moore | last post by:

I have a DataGrid that needs to dynamically sum data for each column of data into the footer. The number of rows will differ for each person based on the projects they are working on at the time -...

ASP.NET

Creating a SQL Server Database

by: Barry | last post by:

Hi can anyone tell me if there if any code snippet available for creating a SQL Server Database and Table using C# web application. TIA Barry

ASP.NET

Saving Data Question

by: pmclinn | last post by:

I have a formated a structure as follows: <Serializable()>public structure stcOutPut private data as string private visi as string end structure Instances of this strucuture are stored in an...

Visual Basic .NET

saving data

by: alex | last post by:

hi whats the different methods in saving a database i'm alternathing between laptop& desktop and external hard drive.losing data here and there. will "briefcase" help me and or shall i upgrate to...

Microsoft Access / VBA

MS Walkthrough: Saving Data to a Database (Multiple Tables)

by: Magnus | last post by:

I'm testing walkthrough saving data to a Database (Multiple Tables). http://msdn2.microsoft.com/en-us/library/4esb49b4(VS.80).aspx In the famous Customer/Order example, I'm getting referential...

C# / C Sharp

How to save a url dynamically into a database.

by: fjm | last post by:

Hello all.. Can someone recommend a tutorial on how to go about uploading a file (Image) and saving the url to the database? It would be great if the script could name the file also. There...

PHP

landscape printing of dynamically generated data in ie6

by: meenakshia | last post by:

hi forum i m using ie6 and the solution is for a standalone no internet connected machine there is dynamically generated data in tables and i m trying to get that printed in landscape mode. pls...

Javascript

creating dynamically populated XML files using data from database

by: kayox007 | last post by:

hello everyone, am having trouble creating dynamically populated XML files using data from a database. i wouldn't mind coldfussion script that can do that. thanks ya'll

ColdFusion

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++