Add/remove input field and mysql.

3faces

How add one more input value and save same row database two values.
Like this:
Name:
[Textbox1]
Values:
[Textbox2][textbox2] [add new]

[Submit]

Create new table in database and table name is "Textbox1" values.
And save that new table one row "textbox2" and "textbox3" values.

Thanks for help!

traq

It is difficult to understand what you are asking.

From what I can guess, you have a form with a variable/unknown number of fields that you want to save in your database? Like so:

 form id | text1 | text2 | text3
---------+-------+-------+-------
 form 1  | hi!   | bye!  |
 form 2  | silly |
 form 3  | a lot | of    | text  | (more textfields than DB fields!)

Is this correct?

If so, then the solution is to put each textfield+value in its own row. You need one table to represent the form, and one table to store the textfield values.

CREATE TABLE form_submission(
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY
    -- other form info, like user, date/time, etc.
)ENGINE=InnoDB;

CREATE TABLE form_textfield(
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY
   ,text VARCHAR( 250 ) NOT NULL --text from textarea
   ,form_id INT UNSIGNED --id of form submission text belongs to
   ,FOREIGN KEY( form_id )
    REFERENCES form_submission( id ) --tells mysql that this must be a form_submission id
)ENGINE=InnoDB;

If that's not what you are asking, please explain your question more clearly.

3faces

I have that form. but it dont work.... cant save new values.

index.php

<html>
 <head>
  <title>Silmaring</title>
  <script src="js/jquery.js"></script>	
  <script src="js/script.js"></script>	
  <script src="js/jquery-ui-1.8.17.custom.min.js"></script>	
  <link rel="stylesheet" href="css/style.css">
 </head>
 <body>
 <br>
   <div style="margin-left: 20%;margin-top: 5%;">
	  <input type="button" value="Lisa" id="add_new"><p>
	  <table width="70%" border="0" cellpadding="0" cellspacing="0" class="table-list">
		<tr>
			<th width="20%">Kooli nimi</th>
			<th width="40%">Kustuta</th>
		</tr>
	  </table>
	</div>
	<div class="entry-form">
		<form name="userinfo" id="userinfo"> 
		<table width="100%" border="0" cellpadding="4" cellspacing="0">
			<tr>
				<td colspan="2" align="right"><a href="#" id="close">Sulge</a></td>
			</tr>
			<tr>
				<td>Kooli nimi</td>
				<td><input type="text" name="kool"></td>
			</tr>
			<tr>
				<td align="right"></td>
				<td><input type="button" value="Salvesta" id="save"><input type="button" value="Tühista" id="cancel"></td>
			</tr>
		</table>
		</form>
	</div>
 </body>
</html>

ajax.php

<?
error_reporting(E_ALL);
ini_set('display_errors', '1');
$conn = mysql_connect("localhost","user","pass") or die(mysql_error());
mysql_select_db("silmaring",$conn) or die(mysql_error());
if(isset($_POST) && count($_POST)){
$kool = $_POST['kool'];
$item_id = $_POST['$item_id'];
$action  = $_POST['action'];   

if($action == "save"){
$res = mysql_query("insert into kool values('','".$kool."')");
if($res){
echo json_encode(
array(
"success" => "1",
"row_id" => time(),
"kool" => htmlentities($kool),
)
);
}
}
else if($action == "delete"){
$res = mysql_query("delete from info where id = $");
if($res){
echo json_encode(
array(
"success" => "1",
"item_id" => $item_id
)
);
}
}
}else{
echo "No data set";
}
?>

script.js

$(document).ready(function(){

$("#save").click(function(){
	ajax("save");
});

$("#add_new").click(function(){
	$(".entry-form").fadeIn("fast");	
});

$("#close").click(function(){
	$(".entry-form").fadeOut("fast");	
});

$("#cancel").click(function(){
	$(".entry-form").fadeOut("fast");	
});

$(".del").live("click",function(){
	ajax("delete",$(this).attr("id"));
});

function ajax(action,id){
	if(action =="save")
		data = $("#userinfo").serialize()+"&action="+action;
	else if(action == "delete"){
		data = "action="+action+"&item_id="+id;
	}

	$.ajax({
		type: "POST", 
		url: "ajax.php", 
		data : data,
		dataType: "json",
		success: function(response){
			if(response.success == "1"){
				if(action == "save"){
					$(".entry-form").fadeOut("fast",function(){
						$(".table-list").append("<tr><td>"+response.kool+"</td><td><a href='#' id='"+response.row_id+"' class='del'>Kustuta</a></a></td></tr>");	
						$(".table-list tr:last").effect("highlight", {
							color: '#4BADF5'
						}, 1000);
					});	
				}else if(action == "delete"){
					var row_id = response.item_id;
					$("a[id='"+row_id+"']").closest("tr").effect("highlight", {
						color: '#4BADF5'
					}, 1000);
					$("a[id='"+row_id+"']").closest("tr").fadeOut();
				}
			}else{
				alert(response.msg);
			}
		},
		error: function(res){
			alert("Unexpected error! Try again.");
		}
	});
}
});

3faces

And here is database.

-- phpMyAdmin SQL Dump
-- version 3.5.4

-- http://www.phpmyadmin.net

-- Host: localhost
-- Generation Time: May 01, 2013 at 10:11 PM
-- Server version: 5.1.67
-- PHP Version: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/!40101 SET NAMES utf8 /;

-- Database: `silmaring`

-- Table structure for table `kool`

CREATE TABLE IF NOT EXISTS kool (
nr time NOT NULL,
kool varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;

traq

3faces;11027547 wrote:
but it dont work...

"it dont work" is very useless information. What does not work?

Describe the problem.

-- How far is your form submission being processed?

-- What does the query you construct look like?

-- Are you getting any errors from mysql?
-- etc.

It also seems you haven't applied any of the suggestions I offered.

As I said earlier, if my guess at your problem was not correct, you'll need to explain the issue in more detail.

(Also, you should not post sensitive information like your DB username and password in public. You should edit your post (or ask a moderator to edit it) and obfuscate that information.)