Return to Question

added 2 characters in body

edited Oct 9, 2015 at 18:29

My HTML: Date Teacher ? Hour Subject Class Room (Teacher) (Room) XYY Information (Le.) nach 24.9. ~~(削除) Dohe (削除ここまで)~~ Free 1 ~~(削除) Math (削除ここまで)~~ (9) --- ~~(削除) Dohe (削除ここまで)~~ A001 Free. 26.9. ~~(削除) John (削除ここまで)~~ Free 8 ~~(削除) Bio (削除ここまで)~~ (9) --- ~~(削除) John (削除ここまで)~~ A021 Freeeeeee.

<html>
<TABLE border="3" rules="all" bgcolor="#E7E7E7" cellpadding="1" cellspacing="1">
<TR>
<TH align=center><font size="3" face="Arial">Date</font></TH>
<TH align=center><font size="3" face="Arial"><B>Teacher</B></font></TH>
<TH align=center><font size="3" face="Arial">?</font></TH>
<TH align=center><font size="3" face="Arial">Hour</font></TH>
<TH align=center><font size="3" face="Arial">Subject</font></TH>
<TH align=center><font size="3" face="Arial">Class</font></TH>
<TH align=center><font size="3" face="Arial">Room</font></TH>
<TH align=center><font size="3" face="Arial">(Teacher)</font></TH>
<TH align=center><font size="3" face="Arial">(Room)</font></TH>
<TH align=center><font size="3" face="Arial">XYY</font></TH>
<TH align=center><font size="3" face="Arial"><B>Information</B></font></TH>
<TH align=center><font size="3" face="Arial">(Le.) nach</font></TH>
</TR>
<TR><TD align=center><font size="3" face="Arial">24.9.</font></TD>
<TD align=center><font size="3" face="Arial"><B><strike>Dohe</strike></B></font></TD>
<TD align=center><font size="3" face="Arial">Free</font></TD>
<TD align=center><font size="3" face="Arial">1</font></TD>
<TD align=center><font size="3" face="Arial"><strike>Math</strike></font> </TD>
<TD align=center><font size="3" face="Arial">(9)</font> </TD>
<TD align=center><font size="3" face="Arial">---</font> </TD>
<TD align=center><font size="3" face="Arial"><strike>Dohe</strike></font></TD>
<TD align=center><font size="3" face="Arial">A001</font></TD>
<TD align=center>&nbsp;</TD>
<TD align=center>&nbsp;</TD>
<TD align=center><font size="3" face="Arial">Free.</font></TD>
</TR>
<TR><TD align=center><font size="3" face="Arial">26.9.</font></TD>
<TD align=center><font size="3" face="Arial"><B><strike>John</strike></B></font></TD>
<TD align=center><font size="3" face="Arial">Free</font></TD>
<TD align=center><font size="3" face="Arial">8</font></TD>
<TD align=center><font size="3" face="Arial"><strike>Bio</strike></font> </TD>
<TD align=center><font size="3" face="Arial">(9)</font> </TD>
<TD align=center><font size="3" face="Arial">---</font> </TD>
<TD align=center><font size="3" face="Arial"><strike>John</strike></font></TD>
<TD align=center><font size="3" face="Arial">A021</font></TD>
<TD align=center>&nbsp;</TD>
<TD align=center>&nbsp;</TD>
<TD align=center><font size="3" face="Arial">Freeeeeee.</font></TD>
</TR>
</TABLE>
<script type="text/javascript">
 jQuery(document).ready(function(){
 data = new Array();
 columns = [];
 var row = new Array();
 $('table tr').each(function(index,tr){
 var index = index;
 if(index == 0){ // First we get column names from th.
 $(tr).find('th').each(function(thIndex,thValue){
 columns.push($(thValue).text());
 });
 } else {
 $(tr).find('td').each(function(tdIndex,tdValue){
 row[tdIndex] = $(tdValue).text(); // Put each td value in row
 });
 data.push(row); // now push each row in data.
 row = new Array(); // reset row after push
 }
 });
 // Send it to PHP for further work:
 $.post('json.php', { data: data, columns: columns }, function(response){
 // TODO with response
 });
 })
 </script>
</html>

<script type="text/javascript">
 jQuery(document).ready(function(){
 data = new Array();
 columns = [];
 var row = new Array();
 $('table tr').each(function(index,tr){
 var index = index;
 if(index == 0){ // First we get column names from th.
 $(tr).find('th').each(function(thIndex,thValue){
 columns.push($(thValue).text());
 });
 } else {
 $(tr).find('td').each(function(tdIndex,tdValue){
 row[tdIndex] = $(tdValue).text(); // Put each td value in row
 });
 data.push(row); // now push each row in data.
 row = new Array(); // reset row after push
 }
 });
 // Send it to PHP for further work:
 $.post('json.php', { data: data, columns: columns }, function(response){
 // TODO with response
 });
 })
 </script>
</html>

My HTML:

<html>
<TABLE border="3" rules="all" bgcolor="#E7E7E7" cellpadding="1" cellspacing="1">
<TR>
<TH align=center><font size="3" face="Arial">Date</font></TH>
<TH align=center><font size="3" face="Arial"><B>Teacher</B></font></TH>
<TH align=center><font size="3" face="Arial">?</font></TH>
<TH align=center><font size="3" face="Arial">Hour</font></TH>
<TH align=center><font size="3" face="Arial">Subject</font></TH>
<TH align=center><font size="3" face="Arial">Class</font></TH>
<TH align=center><font size="3" face="Arial">Room</font></TH>
<TH align=center><font size="3" face="Arial">(Teacher)</font></TH>
<TH align=center><font size="3" face="Arial">(Room)</font></TH>
<TH align=center><font size="3" face="Arial">XYY</font></TH>
<TH align=center><font size="3" face="Arial"><B>Information</B></font></TH>
<TH align=center><font size="3" face="Arial">(Le.) nach</font></TH>
</TR>
<TR><TD align=center><font size="3" face="Arial">24.9.</font></TD>
<TD align=center><font size="3" face="Arial"><B><strike>Dohe</strike></B></font></TD>
<TD align=center><font size="3" face="Arial">Free</font></TD>
<TD align=center><font size="3" face="Arial">1</font></TD>
<TD align=center><font size="3" face="Arial"><strike>Math</strike></font> </TD>
<TD align=center><font size="3" face="Arial">(9)</font> </TD>
<TD align=center><font size="3" face="Arial">---</font> </TD>
<TD align=center><font size="3" face="Arial"><strike>Dohe</strike></font></TD>
<TD align=center><font size="3" face="Arial">A001</font></TD>
<TD align=center>&nbsp;</TD>
<TD align=center>&nbsp;</TD>
<TD align=center><font size="3" face="Arial">Free.</font></TD>
</TR>
<TR><TD align=center><font size="3" face="Arial">26.9.</font></TD>
<TD align=center><font size="3" face="Arial"><B><strike>John</strike></B></font></TD>
<TD align=center><font size="3" face="Arial">Free</font></TD>
<TD align=center><font size="3" face="Arial">8</font></TD>
<TD align=center><font size="3" face="Arial"><strike>Bio</strike></font> </TD>
<TD align=center><font size="3" face="Arial">(9)</font> </TD>
<TD align=center><font size="3" face="Arial">---</font> </TD>
<TD align=center><font size="3" face="Arial"><strike>John</strike></font></TD>
<TD align=center><font size="3" face="Arial">A021</font></TD>
<TD align=center>&nbsp;</TD>
<TD align=center>&nbsp;</TD>
<TD align=center><font size="3" face="Arial">Freeeeeee.</font></TD>
</TR>
</TABLE>
<script type="text/javascript">
 jQuery(document).ready(function(){
 data = new Array();
 columns = [];
 var row = new Array();
 $('table tr').each(function(index,tr){
 var index = index;
 if(index == 0){ // First we get column names from th.
 $(tr).find('th').each(function(thIndex,thValue){
 columns.push($(thValue).text());
 });
 } else {
 $(tr).find('td').each(function(tdIndex,tdValue){
 row[tdIndex] = $(tdValue).text(); // Put each td value in row
 });
 data.push(row); // now push each row in data.
 row = new Array(); // reset row after push
 }
 });
 // Send it to PHP for further work:
 $.post('json.php', { data: data, columns: columns }, function(response){
 // TODO with response
 });
 })
 </script>
</html>

added 3769 characters in body

Source Link

edited Oct 9, 2015 at 16:57

Marius Schönefeld

edited Oct 9, 2015 at 16:57

Marius Schönefeld

aadand this the PHP

<?php
$data = $_POST['data']; // Each rows values
$columns = $_POST['columns']; // Columns names
for($i = 0; $i < count($data); $i++) {
 $json[] = array(($i+1) => array_combine($columns, $data[$i]));
}
// 
$json1 = json_encode(array('values' => $json));
$jsonString = str_replace(utf8_encode("\u00a0"),"",$json1);
$jsonString1 = str_replace(utf8_encode("["),"",$jsonString);
$jsonString2 = str_replace(utf8_encode("]"),"",$jsonString1);
//str_replace(array('[',']',array('{','}'),$json1)) 
file_put_contents('data.json', $jsonString2) 
?>

<script type="text/javascript">
 jQuery(document).ready(function(){
 data = new Array();
 columns = [];
 var row = new Array();
 $('table tr').each(function(index,tr){
 var index = index;
 if(index == 0){ // First we get column names from th.
 $(tr).find('th').each(function(thIndex,thValue){
 columns.push($(thValue).text());
 });
 } else {
 $(tr).find('td').each(function(tdIndex,tdValue){
 row[tdIndex] = $(tdValue).text(); // Put each td value in row
 });
 data.push(row); // now push each row in data.
 row = new Array(); // reset row after push
 }
 });
 // Send it to PHP for further work:
 $.post('json.php', { data: data, columns: columns }, function(response){
 // TODO with response
 });
 })
 </script>
</html>

aad this the PHP

<?php
$data = $_POST['data']; // Each rows values
$columns = $_POST['columns']; // Columns names
for($i = 0; $i < count($data); $i++) {
 $json[] = array(($i+1) => array_combine($columns, $data[$i]));
}
// 
$json1 = json_encode(array('values' => $json));
$jsonString = str_replace(utf8_encode("\u00a0"),"",$json1);
$jsonString1 = str_replace(utf8_encode("["),"",$jsonString);
$jsonString2 = str_replace(utf8_encode("]"),"",$jsonString1);
//str_replace(array('[',']',array('{','}'),$json1)) 
file_put_contents('data.json', $jsonString2) 
?>

and this the PHP

<?php
$data = $_POST['data']; // Each rows values
$columns = $_POST['columns']; // Columns names
for($i = 0; $i < count($data); $i++) {
 $json[] = array(($i+1) => array_combine($columns, $data[$i]));
}
// 
$json1 = json_encode(array('values' => $json));
$jsonString = str_replace(utf8_encode("\u00a0"),"",$json1);
$jsonString1 = str_replace(utf8_encode("["),"",$jsonString);
$jsonString2 = str_replace(utf8_encode("]"),"",$jsonString1);
//str_replace(array('[',']',array('{','}'),$json1)) 
file_put_contents('data.json', $jsonString2) 
?>

<script type="text/javascript">
 jQuery(document).ready(function(){
 data = new Array();
 columns = [];
 var row = new Array();
 $('table tr').each(function(index,tr){
 var index = index;
 if(index == 0){ // First we get column names from th.
 $(tr).find('th').each(function(thIndex,thValue){
 columns.push($(thValue).text());
 });
 } else {
 $(tr).find('td').each(function(tdIndex,tdValue){
 row[tdIndex] = $(tdValue).text(); // Put each td value in row
 });
 data.push(row); // now push each row in data.
 row = new Array(); // reset row after push
 }
 });
 // Send it to PHP for further work:
 $.post('json.php', { data: data, columns: columns }, function(response){
 // TODO with response
 });
 })
 </script>
</html>

deleted 1 character in body

Source Link

edited Oct 9, 2015 at 15:37

Marius Schönefeld

edited Oct 9, 2015 at 15:37

Marius Schönefeld

{"value": {"1":{"Hello":"Test", "Test":"Hello"},{"2":{"Jello":"Test", "Test":"Jello"}}}

{"value": {"1":{"Hello":"Test", "Test":"Hello"},{"2":{"Jello":"Test", "Test":"Jello"}}}

{"value": {"1":{"Hello":"Test", "Test":"Hello"},"2":{"Jello":"Test", "Test":"Jello"}}}

Source Link

asked Oct 9, 2015 at 14:26

Marius Schönefeld

asked Oct 9, 2015 at 14:26

Marius Schönefeld

default

CollectivesTM on Stack Overflow

Return to Question