how to create a nested array and store it in database? [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed 9 years ago.

Improve this question

i have a data like

 <table>
   <tr>
     <th>title 1</th>
     <td>para1</td>
   </tr>
 </table>
 <table>
   <tr>
     <th>title 2</th>
     <td>para1</td>
     <td>para2</td>
     <td>para3</td>
   </tr>
 </table>
 <table>
   <tr>
     <th>title 3</th>
     <td>para1</td>
     <td>para2</td>
   </tr>
 </table>

now how can i take this data and make into an array..it will be really helpful if i can get a solution for this.

In my problem i have a table as shown above and want to store the data in a nested/ multidimensional array. All the solution above doesnot answer my question

thanks in advance

use javascript and ajax technologies to gather all the needed data and send it to server — RomanPerekhrest
– RomanPerekhrest, Commented Feb 24, 2016 at 19:37
Possible duplicate of How to connect html pages to mysql database? — bryce
– bryce, Commented Feb 24, 2016 at 19:37
Possible duplicate of Displaying a nested array in an HTML table — Kyle Williamson
– Kyle Williamson, Commented Feb 24, 2016 at 19:38
And just like that duplicate question, this kind of question is really too broad to answer on this site. — Ageonix
– Ageonix, Commented Feb 24, 2016 at 19:39
Possible duplicate of What is the fastest way to convert html table to php array? — Ageonix
– Ageonix, Commented Feb 24, 2016 at 19:40

Zak · Accepted Answer · 2016-02-24 21:20:39Z

1

I think I know what you are looking for... It's actually pretty simple.

You want to iterate through the <table> tags first .. And subsequently iterate the children tr - tds.

I'd surround the tables with a surrounding div to make grabbing them much easier.

Then I'd use jQuery because the library makes it easy to choose children etc etc. Then for Storage into the database .. I'd "Json-ify" the array(s)

IE

$(document).ready(function() {
  myHTML = $('#myDiv').html();
});

var tableNumber = $('#myDiv').children('table').length;

var items = [];

for (i = 0; i < tableNumber; i++) {
  var title = $($("table tr th")[i]).html();

  var paras = [];

  $($("table tr")[i]).find('td').each(function() {
    paras.push($(this).html());
  });
  items.push(title, paras);
}

var outPut = JSON.stringify(items);

$('#jsonOut').html(outPut);

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

<div id="myDiv">
  <table>
    <tr>
      <th>title 1</th>
      <td>para 1-1</td>
    </tr>
  </table>
  <table>
    <tr>
      <th>title 2</th>
      <td>para 2-1</td>
      <td>para 2-2</td>
      <td>para 2-3</td>
    </tr>
  </table>
  <table>
    <tr>
      <th>title 3</th>
      <td>para 3-1</td>
      <td>para 3-2</td>
    </tr>
  </table>
</div>

<br>
<pre>
 <div id="jsonOut">
 
 </div> 
</pre>

You can also view the FIDDLE

Hope this helps.

answered Feb 24, 2016 at 21:20

Zak

7,5812 gold badges29 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Susan Williams Over a year ago

i am trying to parse that html in php

Zak Over a year ago

You're not being clear.. What EXACTLY are you doing? From beginning to end. Are you receiving that HTML from a database? Are you trying to do what I just did, but in PHP? Give us a 30,000 foot view of the process from beginning to end..

Collectives™ on Stack Overflow

how to create a nested array and store it in database? [closed]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related