Normal arrays in jQuery to MySQL

Question

I have a script that extracts the p elements in a document using jQuery. With jQuery I map these to a normal array. I was just looking for some insight on how to store this in a database through jQuery.

EDIT: I use jQuery to scrape the p elements on a set of pages

var textnode = $(source).children("p:not(:has(img))").map(function() {
    return $(this).outerHTML();
    }).get();

I was wondering how I would get started on storing this array into a database

it really depends on how you're modelling your data - are you trying to store each element from the array in its own record? — kinakuta
– kinakuta, Commented Jun 27, 2011 at 0:02

Nimantha · Accepted Answer · 2021-11-01 04:58:43Z

1

Typically, jQuery does not talk directly to a database. The main issue is that jQuery usually runs on the client side and databases for web applications are typically (although, of course, not always) on the server side.

In a few cases, storing the information client-side via HTML5 or something else might be an option. In most cases, that will result in problems around varying levels of HTML5 support in different versions of different browser and/or might be inappropriate for other reasons (such as perhaps multiple clients need to be able to read the same data back).

In some cases, it may be OK to send the data to a server (via any number of ways: .ajax() is one) that can store it in a database. In many cases, there will be issues around security/encryption/privacy with this approach.

edited Nov 1, 2021 at 4:58

Nimantha

6,5476 gold badges32 silver badges78 bronze badges

answered Jun 27, 2011 at 0:05

Trott

70.7k27 gold badges184 silver badges218 bronze badges

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

2 Comments

re1man Over a year ago

can the values in a normal array generated by jquery be accessed by a php script?

Trott Over a year ago

Typically, jQuery runs on the client side and PHP runs on the server side. So, in the typical set up, the answer is no.

Collectives™ on Stack Overflow

Normal arrays in jQuery to MySQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related