如何在php中的csv文件中保存已编辑的表数据 [英] how to save the edited table data in csv file in php
问题描述
我目前在data.csv文件中保存表数据时遇到问题。使用这个javascript我从表中获取值并在警告框中显示它。但我想将此变量数据存储在adata.csv文件中。我已将隐藏字段值传递到此页面。请编辑我的代码。因为这是我的第一个PHP代码。
这是我的代码:
< html>
< head>
< script>
函数GetCellValues()
{
var str ='';
var rows = document.getElementsByTagName('tr');
var table = document.getElementById(project);
for(var i = 0; i< table.rows [0] .cells.length; i ++)>
{
if(i > 2)
{
str = str + table.rows [0] .cells [3] .innerHTML.replace(,);
}
其他
{
str = str +(table.rows [0] .cells [i] .innerHTML) +',';
}
}
for(var c = 1; c< rows.length; c ++)
{
str + ='\ n'+0+ c +',';
var row = rows [c];
var inputs = row.getElementsByTagName('input');
for(var k = 0; k< inputs.length; k ++)
if(k> 1)
{
str + = inputs [k] .value.replace(,);
}
else
{
str + =输入[k] .value +',';
}
}
文件。 getElementById('hiden')。value = str;
alert(document.getElementById('hiden')。value);
}
这里我有问题,我无法将表数据保存到文件中。
函数已保存()
{
$ handle = fopen(data.csv,w);
$ hiden = $ _REQUEST [hiden];
fwrite ($ handle,$ hiden);
}
?>
< / script>
< / head>
我按以下方式制作了按钮:
< body> ;
< form>
* * * PROJECTS * * *
< input type =hiddenid =hidenname =hidenvalue =>
< input type =buttonname =submitönclick=GetCellValues()Value =SAVE>
< input type =buttonname =submitönclick=document.write('');值=提交>
< / form>
这里我存储了来自.csv文件的数据在表格中显示:
$ handle = fopen(data.csv,w);
$ hide = $ _REQUEST ['hide'];
fwrite($ handle,$ hide);
$ file = file('data.csv') ;
$ lines = count($ file);
echo'
style =width:60 %; margin-removed auto; margin-removed auto; border-color:brown; background-color:grey;>';
echo'';
for ($ i = 1; $ i< $ lines; $ i ++)
{
$ part = explode(',',$ file [$ i]);
echo'
';
}
echo'
Sl.No。 | 项目名称 | ChangeDate | 更改者 |
---|---|---|---|
'。$ part [0]。' | < input type =textvalue =' 。$ part [1]。'> | < input type =textvalue ='。$ part [2]。'> | < input type =textvalue ='。$ part [3]。'> |
?>
< / body>
< / html>
I am currently having issues with save the table data in data.csv file. Using this javascript I am getting the value from table and show it in alert box. But I want to store this variable data in adata.csv file. I have passed the hidden field value into this page. Please edit my code. Because this is my first PHP code.
Here is my code:
<html>
<head>
<script>
function GetCellValues()
{
var str = '';
var rows = document.getElementsByTagName('tr');
var table=document.getElementById("project");
for (var i=0;i<table.rows[0].cells.length;i++)>
{
if (i > 2 )
{
str = str + table.rows[0].cells[3].innerHTML.replace(", ");
}
else
{
str = str + (table.rows[0].cells[i].innerHTML) + ', ' ;
}
}
for (var c = 1 ; c < rows.length ; c++)
{
str += '\n' + "0" + c + ', ';
var row = rows[c];
var inputs = row.getElementsByTagName('input');
for (var k = 0 ; k < inputs.length ; k++)
if (k > 1)
{
str += inputs[k].value.replace(", ");
}
else
{
str += inputs[k].value + ', ';
}
}
document.getElementById('hiden').value = str;
alert(document.getElementById('hiden').value);
}
Here I have the problem, I am not able to save the table data into the file.
function saved()
{
$handle = fopen("data.csv", "w");
$hiden = $_REQUEST["hiden"];
fwrite($handle,$hiden);
}
?>
</script>
</head>
I have made the buttons in the following way:
<body>
<form>
* * * PROJECTS * * *
<input type = "hidden" id = "hiden" name = "hiden" value = "">
<input type = "button" name = "submit" önclick = "GetCellValues()" Value = "SAVE">
<input type = "button" name = "submit" önclick = "document.write('');" Value = "submit">
</form>
Here I stored the data from .csv file and display it in table:
$handle = fopen("data.csv", "w");
$hide = $_REQUEST['hide'];
fwrite($handle,$hide);
$file = file('data.csv');
$lines = count($file);
echo'
style = "width: 60%; margin-removed auto; margin-removed auto; border-color: brown; background-color:gray;">';
echo'';
for ($i=1; $i<$lines; $i++)
{
$part = explode(',', $file[$i]);
echo'
';
}
echo'
Sl.No. | Project Name | ChangeDate | Changed By |
---|---|---|---|
'.$part[0].' | <input type="text" value='.$part[1].'> | <input type="text" value='.$part[2].'> | <input type="text" value='.$part[3].'> |
?>
</body>
</html>
推荐答案
handle = fopen(data.csv,w);
handle = fopen("data.csv", "w");
hiden =
_REQUEST [hiden];
fwrite(
_REQUEST["hiden"];
fwrite(
这篇关于如何在php中的csv文件中保存已编辑的表数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!