如何以html格式将数据条目导出到.csv文件? [英] How to export data entry in html form to .csv file?
问题描述
我是新手,还是初学者,可以根据需要通过搜索和编辑从互联网上获取一些代码,但是现在我想将html格式的数据条目保存到data.csv文件中,当我单击提交"按钮时,它应该保存每单击一次提交按钮,将内容添加到新行中的data.csv中.此html代码仅在本地计算机上运行.我不知道这是MWE.预先感谢您的帮助
I am new and beginner and got some codes from internet by searching and editted according to my needs, but now i want to save the data entry in html form to data.csv file, when i click submit button it should save the contents into data.csv in new line for every click submit button. This html codes i am running local computer only. I don't know how do i that here is MWE. Thanking you in advance for any help
<html>
<head>
<script type="text/javascript" src="validate.js"></script>
</head>
<body>
<form action="#" name="StudentRegistration" onSubmit="return(validate());">
<table cellpadding="2" width="20%" bgcolor="99FFFF" align="center"
cellspacing="2">
<tr>
<td colspan=2>
<center><font size=4><b>Student Registration Form</b></font></center>
</td>
</tr>
<tr>
<td>Name</td>
<td><input type=text name=textnames id="textname" size="30"></td>
</tr>
<tr>
<td>Father Name</td>
<td><input type="text" name="fathername" id="fathername"
size="30"></td>
</tr>
<tr>
<td>Postal Address</td>
<td><input type="text" name="paddress" id="paddress" size="30"></td>
</tr>
<tr>
<td>Personal Address</td>
<td><input type="text" name="personaladdress"
id="personaladdress" size="30"></td>
</tr>
<tr>
<td>Sex</td>
<td><input type="radio" name="sex" value="male" size="10">Male
<input type="radio" name="sex" value="Female" size="10">Female</td>
</tr>
<tr>
<td>Stream</td>
<td><select name="Stream">
<option value="-1" selected>Select..</option>
<option value="ARTS">ARTS</option>
<option value="COMMERCE">COMMERCE</option>
<option value="SCIENCE">SCIENCE</option>
</select></td>
</tr>
<tr>
<td>Core-1</td>
<td><select name="Core-1">
<option value="-1" selected>Select..</option>
<option value="English">English</option>
</select></td>
</tr>
<tr>
<td>Core-2</td>
<td><select name="Core-2">
<option value="-1" selected>Select..</option>
<option value="Alternative English">Alternative English</option>
</select></td>
</tr>
<tr>
<td>Elective-1</td>
<td><select name="Elective-1">
<option value="-1" selected>Select..</option>
<option value="MIL (Hindi)">MIL (Hindi)</option>
<option value="MIL (Bengali)">MIL (Bengali)</option>
<option value="MIL (Nepali)">MIL (Nepali)</option>
<option value="Political Science">Political Science</option>
<option value="Education">Education</option>
<option value="Economics">Economics</option>
<option value="History">History</option>
<option value="Geography">Geography</option>
<option value="Sociology">Sociology</option>
<option value="Logic & Philosophy">Logic & Philosophy</option>
<option value="Advance Assamese">Advance Assamese</option>
<option value="Advance Bengali">Advance Bengali</option>
<option value="Physics">Physics</option>
<option value="Chemistry">Chemistry</option>
<option value="Biology">Biology</option>
<option value="Mathematics">Mathematics</option>
<option value="Computer Science & Applications">Computer Science & Applications</option>
<option value="Accountancy">Accountancy</option>
<option value="Business Studies">Business Studies</option>
<option value="Banking">Banking</option>
<option value="Statistics">Statistics</option>
</select></td>
</tr>
<tr>
<td>Elective-2</td>
<td><select name="Elective-2">
<option value="-1" selected>Select..</option>
<option value="MIL (Hindi)">MIL (Hindi)</option>
<option value="MIL (Bengali)">MIL (Bengali)</option>
<option value="MIL (Nepali)">MIL (Nepali)</option>
<option value="Political Science">Political Science</option>
<option value="Education">Education</option>
<option value="Economics">Economics</option>
<option value="History">History</option>
<option value="Geography">Geography</option>
<option value="Sociology">Sociology</option>
<option value="Logic & Philosophy">Logic & Philosophy</option>
<option value="Advance Assamese">Advance Assamese</option>
<option value="Advance Bengali">Advance Bengali</option>
<option value="Physics">Physics</option>
<option value="Chemistry">Chemistry</option>
<option value="Biology">Biology</option>
<option value="Mathematics">Mathematics</option>
<option value="Computer Science & Applications">Computer Science & Applications</option>
<option value="Accountancy">Accountancy</option>
<option value="Business Studies">Business Studies</option>
<option value="Banking">Banking</option>
<option value="Statistics">Statistics</option>
</select></td>
</tr>
<tr>
<td>Elective-3</td>
<td><select name="Elective-3">
<option value="-1" selected>Select..</option>
<option value="MIL (Hindi)">MIL (Hindi)</option>
<option value="MIL (Bengali)">MIL (Bengali)</option>
<option value="MIL (Nepali)">MIL (Nepali)</option>
<option value="Political Science">Political Science</option>
<option value="Education">Education</option>
<option value="Economics">Economics</option>
<option value="History">History</option>
<option value="Geography">Geography</option>
<option value="Sociology">Sociology</option>
<option value="Logic & Philosophy">Logic & Philosophy</option>
<option value="Advance Assamese">Advance Assamese</option>
<option value="Advance Bengali">Advance Bengali</option>
<option value="Physics">Physics</option>
<option value="Chemistry">Chemistry</option>
<option value="Biology">Biology</option>
<option value="Mathematics">Mathematics</option>
<option value="Computer Science & Applications">Computer Science & Applications</option>
<option value="Accountancy">Accountancy</option>
<option value="Business Studies">Business Studies</option>
<option value="Banking">Banking</option>
<option value="Statistics">Statistics</option>
</select></td>
</tr>
<tr>
<td>Elective-4</td>
<td><select name="Elective-4">
<option value="-1" selected>Select..</option>
<option value="MIL (Hindi)">MIL (Hindi)</option>
<option value="MIL (Bengali)">MIL (Bengali)</option>
<option value="MIL (Nepali)">MIL (Nepali)</option>
<option value="Political Science">Political Science</option>
<option value="Education">Education</option>
<option value="Economics">Economics</option>
<option value="History">History</option>
<option value="Geography">Geography</option>
<option value="Sociology">Sociology</option>
<option value="Logic & Philosophy">Logic & Philosophy</option>
<option value="Advance Assamese">Advance Assamese</option>
<option value="Advance Bengali">Advance Bengali</option>
<option value="Physics">Physics</option>
<option value="Chemistry">Chemistry</option>
<option value="Biology">Biology</option>
<option value="Mathematics">Mathematics</option>
<option value="Computer Science & Applications">Computer Science & Applications</option>
<option value="Accountancy">Accountancy</option>
<option value="Business Studies">Business Studies</option>
<option value="Banking">Banking</option>
<option value="Statistics">Statistics</option>
</select></td>
</tr>
<tr>
<td>Compulsory</td>
<td><select name="Compulsory">
<option value="-1" selected>Select..</option>
<option value="Environmental Education">Environmental Education</option>
</select></td>
</tr>
<tr>
<td>Institute</td>
<td><select name="Institute">
<option value="-1" selected>Select..</option>
<option value="Institute-1">Institute-1</option>
<option value="Institute-2">Institute-2</option>
<option value="Institute-3">Institute-3</option>
</select></td>
</tr>
<tr>
<td>State</td>
<td><select Name="State">
<option value="-1" selected>select..</option>
<option value="New Delhi">NEW DELHI</option>
<option value="Mumbai">MUMBAI</option>
<option value="Goa">GOA</option>
<option value="Bihar">BIHAR</option>
</select></td>
</tr>
<tr>
<td>PinCode</td>
<td><input type="text" name="pincode" id="pincode" size="30"></td>
</tr>
<tr>
<td>EmailId</td>
<td><input type="text" name="emailid" id="emailid" size="30"></td>
</tr>
<tr>
<td>DOB</td>
<td><input type="text" name="dob" id="dob" size="30"></td>
</tr>
<tr>
<td>MobileNo</td>
<td><input type="text" name="mobileno" id="mobileno" size="30"></td>
</tr>
<tr>
<td><input type="reset"></td>
<td colspan="2"><input type="submit" value="Submit Form" /></td>
</tr>
</table>
</form>
</body>
</html>
以下是上述html代码的输出
Here is the output of the above html codes
我已经根据Bill的建议创建了一个.php文件作为proces.php文件,但是内容不是在编写,而是仅给出,",,"这是我的php脚本
I have created a .php as proces.php file according to Bill suggestion but content not writing but giving only ,,,,,,, here is my php script
<?php
$fieldA = $_POST["textnames"];
$fieldB = $_POST["fathername"];
$fieldC = $_POST["paddress"];
$fieldD = $_POST["personaladdress"];
$fieldE = $_POST["sex"];
$fieldF = $_POST["Stream"];
$fieldG = $_POST["Core-1"];
$fieldH = $_POST["Core-2"];
$fieldI = $_POST["Elective-1"];
$fieldJ = $_POST["Elective-2"];
$fieldK = $_POST["Elective-3"];
$fieldL = $_POST["Elective-4"];
$fieldM = $_POST["Compulsory"];
$keys = array($fieldA,$fieldB,$fieldC,$fieldD,$fieldE,$fieldF,$fieldG,$fieldH,$fieldI,$fieldJ,$fieldK,$fieldL,$fieldM); //THIS IS WHERE YOU PUT THE FORM ELEMENTS ex: array('$fieldA','$fieldB',etc)
$csv_line = array();
foreach($keys as $key){
array_push($csv_line,'' . $_GET[$key]);
}
$fname = 'data.csv'; //NAME OF THE FILE
$csv_line = implode(',',$csv_line);
if(!file_exists($fname)){$csv_line = "\r\n" . $csv_line;}
$fcon = fopen($fname,'a');
$fcontent = $csv_line;
fwrite($fcon,$fcontent);
fclose($fcon);
?>
并将我的原始html代码从< form action =#" name ="StudentRegistration" onSubmit ="return(validate());">
修改为< formname ="StudentRegistration" action ="proces1.php" method ="post">
,所以这是我新的最终html编码
and edited my original html codes from <form action="#" name="StudentRegistration" onSubmit="return(validate());">
to <form name="StudentRegistration" action="proces1.php" method="post">
so here is my new final html coding
<html>
<head>
<script type="text/javascript" src="validate.js"></script>
</head>
<body>
<form name="StudentRegistration" action="proces.php" method="post">
<table cellpadding="2" width="20%" bgcolor="99FFFF" align="center"
cellspacing="2">
<tr>
<td colspan=2>
<center><font size=4><b>Student Registration Form</b></font></center>
</td>
</tr>
<tr>
<td>Name</td>
<td><input type=text name=textnames id="textname" size="30"></td>
</tr>
<tr>
<td>Father Name</td>
<td><input type="text" name="fathername" id="fathername"
size="30"></td>
</tr>
<tr>
<td>Postal Address</td>
<td><input type="text" name="paddress" id="paddress" size="30"></td>
</tr>
<tr>
<td>Personal Address</td>
<td><input type="text" name="personaladdress"
id="personaladdress" size="30"></td>
</tr>
<tr>
<td>Sex</td>
<td><input type="radio" name="sex" value="male" size="10">Male
<input type="radio" name="sex" value="Female" size="10">Female</td>
</tr>
<tr>
<td>Stream</td>
<td><select name="Stream">
<option value="-1" selected>Select..</option>
<option value="ARTS">ARTS</option>
<option value="COMMERCE">COMMERCE</option>
<option value="SCIENCE">SCIENCE</option>
</select></td>
</tr>
<tr>
<td>Core-1</td>
<td><select name="Core-1">
<option value="-1" selected>Select..</option>
<option value="English">English</option>
</select></td>
</tr>
<tr>
<td>Core-2</td>
<td><select name="Core-2">
<option value="-1" selected>Select..</option>
<option value="Alternative English">Alternative English</option>
</select></td>
</tr>
<tr>
<td>Elective-1</td>
<td><select name="Elective-1">
<option value="-1" selected>Select..</option>
<option value="MIL (Hindi)">MIL (Hindi)</option>
<option value="MIL (Bengali)">MIL (Bengali)</option>
<option value="MIL (Nepali)">MIL (Nepali)</option>
<option value="Political Science">Political Science</option>
<option value="Education">Education</option>
<option value="Economics">Economics</option>
<option value="History">History</option>
<option value="Geography">Geography</option>
<option value="Sociology">Sociology</option>
<option value="Logic & Philosophy">Logic & Philosophy</option>
<option value="Advance Assamese">Advance Assamese</option>
<option value="Advance Bengali">Advance Bengali</option>
<option value="Physics">Physics</option>
<option value="Chemistry">Chemistry</option>
<option value="Biology">Biology</option>
<option value="Mathematics">Mathematics</option>
<option value="Computer Science & Applications">Computer Science & Applications</option>
<option value="Accountancy">Accountancy</option>
<option value="Business Studies">Business Studies</option>
<option value="Banking">Banking</option>
<option value="Statistics">Statistics</option>
</select></td>
</tr>
<tr>
<td>Elective-2</td>
<td><select name="Elective-2">
<option value="-1" selected>Select..</option>
<option value="MIL (Hindi)">MIL (Hindi)</option>
<option value="MIL (Bengali)">MIL (Bengali)</option>
<option value="MIL (Nepali)">MIL (Nepali)</option>
<option value="Political Science">Political Science</option>
<option value="Education">Education</option>
<option value="Economics">Economics</option>
<option value="History">History</option>
<option value="Geography">Geography</option>
<option value="Sociology">Sociology</option>
<option value="Logic & Philosophy">Logic & Philosophy</option>
<option value="Advance Assamese">Advance Assamese</option>
<option value="Advance Bengali">Advance Bengali</option>
<option value="Physics">Physics</option>
<option value="Chemistry">Chemistry</option>
<option value="Biology">Biology</option>
<option value="Mathematics">Mathematics</option>
<option value="Computer Science & Applications">Computer Science & Applications</option>
<option value="Accountancy">Accountancy</option>
<option value="Business Studies">Business Studies</option>
<option value="Banking">Banking</option>
<option value="Statistics">Statistics</option>
</select></td>
</tr>
<tr>
<td>Elective-3</td>
<td><select name="Elective-3">
<option value="-1" selected>Select..</option>
<option value="MIL (Hindi)">MIL (Hindi)</option>
<option value="MIL (Bengali)">MIL (Bengali)</option>
<option value="MIL (Nepali)">MIL (Nepali)</option>
<option value="Political Science">Political Science</option>
<option value="Education">Education</option>
<option value="Economics">Economics</option>
<option value="History">History</option>
<option value="Geography">Geography</option>
<option value="Sociology">Sociology</option>
<option value="Logic & Philosophy">Logic & Philosophy</option>
<option value="Advance Assamese">Advance Assamese</option>
<option value="Advance Bengali">Advance Bengali</option>
<option value="Physics">Physics</option>
<option value="Chemistry">Chemistry</option>
<option value="Biology">Biology</option>
<option value="Mathematics">Mathematics</option>
<option value="Computer Science & Applications">Computer Science & Applications</option>
<option value="Accountancy">Accountancy</option>
<option value="Business Studies">Business Studies</option>
<option value="Banking">Banking</option>
<option value="Statistics">Statistics</option>
</select></td>
</tr>
<tr>
<td>Elective-4</td>
<td><select name="Elective-4">
<option value="-1" selected>Select..</option>
<option value="MIL (Hindi)">MIL (Hindi)</option>
<option value="MIL (Bengali)">MIL (Bengali)</option>
<option value="MIL (Nepali)">MIL (Nepali)</option>
<option value="Political Science">Political Science</option>
<option value="Education">Education</option>
<option value="Economics">Economics</option>
<option value="History">History</option>
<option value="Geography">Geography</option>
<option value="Sociology">Sociology</option>
<option value="Logic & Philosophy">Logic & Philosophy</option>
<option value="Advance Assamese">Advance Assamese</option>
<option value="Advance Bengali">Advance Bengali</option>
<option value="Physics">Physics</option>
<option value="Chemistry">Chemistry</option>
<option value="Biology">Biology</option>
<option value="Mathematics">Mathematics</option>
<option value="Computer Science & Applications">Computer Science & Applications</option>
<option value="Accountancy">Accountancy</option>
<option value="Business Studies">Business Studies</option>
<option value="Banking">Banking</option>
<option value="Statistics">Statistics</option>
</select></td>
</tr>
<tr>
<td>Compulsory</td>
<td><select name="Compulsory">
<option value="-1" selected>Select..</option>
<option value="Environmental Education">Environmental Education</option>
</select></td>
</tr>
<tr>
<td>Institute</td>
<td><select name="Institute">
<option value="-1" selected>Select..</option>
<option value="Institute-1">Institute-1</option>
<option value="Institute-2">Institute-2</option>
<option value="Institute-3">Institute-3</option>
</select></td>
</tr>
<tr>
<td>State</td>
<td><select Name="State">
<option value="-1" selected>select..</option>
<option value="New Delhi">NEW DELHI</option>
<option value="Mumbai">MUMBAI</option>
<option value="Goa">GOA</option>
<option value="Bihar">BIHAR</option>
</select></td>
</tr>
<tr>
<td>PinCode</td>
<td><input type="text" name="pincode" id="pincode" size="30"></td>
</tr>
<tr>
<td>EmailId</td>
<td><input type="text" name="emailid" id="emailid" size="30"></td>
</tr>
<tr>
<td>DOB</td>
<td><input type="text" name="dob" id="dob" size="30"></td>
</tr>
<tr>
<td>MobileNo</td>
<td><input type="text" name="mobileno" id="mobileno" size="30"></td>
</tr>
<tr>
<td><input type="reset"></td>
<td colspan="2"><input type="submit" value="Submit Form" /></td>
</tr>
</table>
</form>
</body>
</html>
推荐答案
谢谢大家现在,我通过将procode.php脚本更改为 $ csv_line = array();
之后,终于得到了输出.到 $ csv_line = $ keys;
并从 if(!file_exists($ fname)){$ csv_line ="\ r \ n".$ csv_line;}
到 if(!file_exists($ fname)){$ csv_line = $ csv_line."\ r \ n";}
这是我最终的.php文件
Thanks to everyone Now I finally got the output after editing the proces.php script by changing the line from $csv_line = array();
to $csv_line = $keys;
and from if(!file_exists($fname)){$csv_line = "\r\n" . $csv_line;}
to if(!file_exists($fname)){$csv_line = $csv_line."\r\n" ;}
here is my final .php file
<?php
$fieldA = $_POST["textnames"];
$fieldB = $_POST["fathername"];
$fieldC = $_POST["paddress"];
$fieldD = $_POST["personaladdress"];
$fieldE = $_POST["sex"];
$fieldF = $_POST["Stream"];
$fieldG = $_POST["Core-1"];
$fieldH = $_POST["Core-2"];
$fieldI = $_POST["Elective-1"];
$fieldJ = $_POST["Elective-2"];
$fieldK = $_POST["Elective-3"];
$fieldL = $_POST["Elective-4"];
$fieldM = $_POST["Compulsory"];
$keys = array($fieldA,$fieldB,$fieldC,$fieldD,$fieldE,$fieldF,$fieldG,$fieldH,$fieldI,$fieldJ,$fieldK,$fieldL,$fieldM); //THIS IS WHERE YOU PUT THE FORM ELEMENTS ex: array('$fieldA','$fieldB',etc)
$csv_line = $keys;
foreach( $keys as $key ){
array_push($csv_line,'' . $_GET[$key]);
}
$fname = 'data.csv'; //NAME OF THE FILE
$csv_line = implode(',',$csv_line);
if(!file_exists($fname)){$csv_line = $csv_line."\r\n" ;}
$fcon = fopen($fname,'a');
$fcontent = $csv_line;
fwrite($fcon,$csv_line);
fclose($fcon);
?>
这篇关于如何以html格式将数据条目导出到.csv文件?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!