I can not get the values from the javascript add row to go dynamically as a row into MySql only the form values show up as the form below as one row. I made it as an array, but no such luck, I have tried this code around a multitude of ways. I don't know what I am doing wrong, kindly write out the correct way. - <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-
<html xmlns="http://www.w3.org/1999/xhtml">
-
<head>
-
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
-
<title>Dynamic Fields js/php to MySql need to submit dynamically to the database</title>
-
<?php
-
require ('database.php');
-
?>
-
<script type="text/javascript">
-
var counter = 1;
-
var collector = "";
-
-
function addfields(indx)
-
{
-
var tbl = document.getElementById('table_id');
-
var newtr = document.createElement('tr');
-
counter = counter + indx;
-
-
newtr.setAttribute('id','tr'+counter);
-
-
newtr.innerHTML = '<td><input type="checkbox" name="checkb'+counter+'" id="checkb'+counter+'" value="'+counter+'" onclick="checkme('+counter+')"></td><td><input type="text" name="text1[]"></td><td><textarea name="textarea1[]"></textarea></td>';
-
-
tbl.appendChild(newtr);
-
}
-
-
function checkme(dx)
-
{
-
collector += dx+",";
-
}
-
-
function deletetherow(indx)
-
{
-
var col = collector.split(",");
-
-
for (var i = 0; i < col.length; i++)
-
{
-
var remvelem = document.getElementById('tr'+col[i]);
-
var chckbx = document.getElementById("checkb"+col[i]);
-
if(remvelem && chckbx.checked)
-
{
-
var tbl = document.getElementById('table_id');
-
tbl.removeChild(remvelem);
-
}
-
}
-
}
-
</script>
-
</head>
-
<body>
-
<form enctype="multipart/form-data" id="1" style="background-color:#ffffff;" action="<?php echo $_SERVER['PHP_SELF']; ?>"></form>
-
<table id="table_id" >
-
<tr id="tr1" class="trmain">
-
<td>
-
</td>
-
<td>
-
<input type="text" name="text1[]">
-
</td>
-
<td>
-
<textarea name="textarea1[]"></textarea>
-
</td>
-
</tr>
-
</table>
-
<input type="button" value="Add" onClick="addfields(1);" />
-
<input type="button" value="Delete" onClick="deletetherow()" />
-
<input type="submit" value="Send" id="submit" name="submit"/>
-
-
<?php
-
if(isset($_POST['submit'])) {
-
for ($i=0; $i < count($_POST['text1']); $i++ )
-
{
-
$ced = stripslashes($_POST['text1'][$i]);
-
$erg = stripslashes($_POST['textarea1'][$i]);
-
}
-
-
-
$bnt = mysql_query("INSERT INTO tablename (first, second) VALUES ('$ced', '$erg')")or die('Error: '. mysql_error() );
-
$result = mysql_query($bnt);
-
}
-
-
?>
-
-
</body>
-
</html>
10  2457 
I suggest you need to use ajax in order to get all the values of the fields in the row, You need to loop your insertion, I can't explain it very well, I will create a sample program for you and you can customize it. Sorry if i replied so much late. I'm so busy this past few days, I'm creating a system for the company and edit some system for machine operation, using rockwell software.
I understand, and will await your reply. I have beat my head around this a lot. As in my other posts to you my other script worked as such but textarea issues, so merged and no luck as with child cells no good for textarea as re-populates innnerHTML. I really don't see why there isn't easy way dynamically. Okay, please be descriptive on your Ajax method as I am new with that language.
This is what i've got now -
var required_fieldz = false; //put this on the top of your initialized variables.
-
Copy paste this functions Note 1: make sure you put required to the fields that you want to be required. Note 2: Download a jquery package and include it to your page, for you to use some of functions i call and to use ajax also.
Go to this site to download jquery package. http://jquery.com/download/ and choose this Download the compressed, production jQuery 1.11.1 to download. -
//how to save to database.
-
function savedata()
-
{
-
$("form#myform").serialize();//get all fields in the form
-
getrequiredfields("myform");//go to function getrequiredfields("myform") with id to check some fields that are not field up
-
-
if(required_fieldz == false)
-
{
-
//all fields field up. use ajax to insert and loop your insertion
-
alert("insert");
-
}
-
else
-
{
-
//some fileds not yet field up
-
alert("no");
-
}
-
}
-
-
//check the required fields in the form
-
function getrequiredfields(formid)
-
{
-
var x = false;
-
var y = false;
-
var z = false;
-
-
$.each($('form#'+formid).serializeArray(), function(i, field)
-
{
-
if($('input[name='+field.name+']').attr('required')=="required" || $('textarea[name='+field.name+']').attr('required')=="required" || $('select[name='+field.name+']').attr('required')=="required"){
-
if($('input[name='+field.name+']').val()=='')
-
{
-
$('input[name='+field.name+']').css('box-shadow','0px 0px 2px 2px #F00');
-
//alert(field.name);
-
x = true;
-
}
-
else
-
{
-
$('input[name='+field.name+']').css('box-shadow','');
-
x = false;
-
}
-
-
-
if($('textarea[name='+field.name+']').val()=='')
-
{
-
//alert(field.name);
-
$('textarea[name='+field.name+']').css('box-shadow','0px 0px 2px 2px #F00');
-
-
y = true;
-
}
-
else
-
{
-
$('textarea[name='+field.name+']').css('box-shadow','');
-
y = false;
-
}
-
-
if($('select[name='+field.name+']').val()=='')
-
{
-
//alert(field.name);
-
$('select[name='+field.name+']').css('box-shadow','0px 0px 2px 2px #F00');
-
-
z = true;
-
}
-
else
-
{
-
$('select[name='+field.name+']').css('box-shadow','');
-
z = false;
-
}
-
-
if( x == true || y == true || z == true )
-
{
-
required_fieldz = true;
-
}
-
else
-
{
-
required_fieldz = false;
-
}
-
}//
-
});
-
}
-
-
I don't code yet to the insertion of your data, i will post it if i'm finish, you can post comment if you already implement the code. :)
by the way put this to your submit button in your form onclick="saveda ta();" example <input type="submit" name="saveme" id="saveme" value="Save me" onclick="saveda ta();"> and take note put your form id to getrequiredfiel ds("myform"); in savedata() function just replace the myform
I am a bit confused with all of this. I did implement the code. I usually use the CDN url from Google for jquery as in this case, whenever I have used it (jquery). I put required in the fields I wanted required already and as mentioned with HTML 5 its' cross browser with something like this fallback http://stackoverflow.com/questions/3...ttribute-html5 and have seen work in all browsers. But, I still tried to implement this code. Now, on submit, nothing happens. I put required as just mentioned in the fields and the
where needed. It works like that. Anyway, if you meant something else let me know.
Where jquery is
the myform is what the name of the form was set to and the
was in same instance gave my form the id of formid. I replaced wherever needed. I tried without also, still no result on submit, nothing happens. I don't follow you "and take note put your form id to getrequiredfiel ds("myform"); in savedata() function just replace the myform" as I did rename that with form id but still nothing on submit.
Since I have the html required attribute then all I am really worried about is getting the data dynamically into the MySQL database as separate rows. This is the milestone now that I can't break through, we'll and that what you gave me for the required is not working for me. I can post you a mini version if your not follow me of what have done.
coppy paste again the entire getrequiredfiel ds() function, i made updates there.
in savedata() function in the line with getrequiredfiel ds("myform"); the myform there is the id of your form, just replace it with the id that you put to your form. The $("form#myform" ).serialize(); we will use this later,
it must be work, did you put this to your submit button as its function ?
I made the sample system already. Whats your email address? I will send the files.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: P |
last post by:
Hi,
As the subject says, I would like to submit dynamically generated
hidden forms with javascript. I'm fairly new to javascript. I've
googled around but couldn't find a solution. I would appreciate if
someone can point me to the right direction.
Thanks
|
by: Darrel |
last post by:
I'm writing out my own Table via codebehind. Each row has an INPUT
TYPE="TEXT" that I am writing out dynamically as well.
I want people to be able to update this text, then, upon submit, I'm going
to walk through each one to update the DB.
How do I access these form fields from the codebehind? I know I can put a
RUNAT="SERVER" on this and then I could register it in the codebehind, but I
can't predict how many INPUTS I'll need on the...
|
by: Sparky Arbuckle |
last post by:
web.config
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<!-- application specific settings -->
<appSettings>
<add key="myConnection" value="Provider=Microsoft.Jet.OLEDB.4.0;Data
source=Customers.mdb;" />
|
by: =?Utf-8?B?SmVmZiBCZWVt?= |
last post by:
The default paging behavior of the gridview doesn't work well with very large
sets of data which means we have to implement some sort of custom paging.
The examples I have seen (4guysfromrolla, etc.) suggest using an
ObjectDataSource which has built-in paging functionality that, when used in
conjunction with certain SQL 2005 functionality, only works with the records
to be displayed on the page rather than the entire set. The problem with...
|
by: occyink |
last post by:
I run a website selling cartridges. My stock on the website is in a MySql database. My accounts package and invoicing software runs on an Access database. In my website databse there is a table called products, on my accounts Access database there is a table called items. I am trying to link certain fields in MySql database with certain fields in Access database. The reason for this is so when I update the price in the accounts database (access)...
| | |
by: webandwe |
last post by:
Hi,
I need to store database data in variables so I can work with it.
Please se below what I am trying to do in my script....
If you echo the stuff out is work fine. Meaning if I go echo $row; I get the data I want but I can't get the data to store in a vairable.
I need something that goes from $a1 to $a18 and in each of then store the data from one field in the database name a5.
Thanks
|
by: joeller |
last post by:
I need to dynamically load controls and access the methods and property of the control from the page. I need to load a different control depending on a selection made by the user. I have buttons on the page whose click events call methods on the controls that process the data selected by the user. I thought I could register one control on the page then call usercontrol.LoadControl(path) to redirect the registered control to a different ascx...
|
by: lion cave |
last post by:
Hi hello,
I have a task assignment regarding for the dynamic fields. My task is to create a table in postgresql database and make the fields of this table a dynamic.
This means that the table can be added, renamed and deleted the fields. On ther hand, the datatype of field can be changed also.
One that come up to my mind to solve this through procedural language for the PostgreSQL. But I'm a newbee for this. Well, I'm studying this...
|
by: Xicer |
last post by:
Hello everyone, this is my first post here so I will try to make it as clear as possible.
Firstly i have a database with a single table named "albums" with the following fields:
albumid int(11)
genreid varchar(30)
albumtitle varchar(30)
albumauthor varchar(30
numberofsongs int(11
price int(11)
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
