how to save the edited table data in csv file in php

Question

0.00/5 (No votes)

See more:

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>

Posted 20-Nov-13 19:59pm

Member 10415837

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Killzone DeathMan · Answer 1 · 2014-01-02T00:58:00

Hello Member,
Its good that when you open the file "$handle = fopen("data.csv", "w");" then when you are done, you can close the file "fclose($handle);"...
So now to your question, just create a string with all the data in CSV format, like this:

PHP

$csv = "1,Hello World, 02-01-2014, Killzone\n2,Hello World 2, 02-01-2014, Killzone\n";
file_put_contents("adata.csv", $csv, FILE_APPEND);

In your case, you can build the csv string with the javascript and send it with a POST to a PHP file, and then in the PHP file make just this:

PHP

file_put_contents("adata.csv", $_POST['csv'], FILE_APPEND);

Any question, please feel free!
Regards,
KZ