var db = require('mysql');
var db_data = {/* ... */};
db = db.createConnection(db_data);
db.connect();
init_content();
function init_content ()
{
console.log('func init_content');
var dbe_sql = "SELECT id, path, parent_id FROM content";
var dbe_res = dbe(dbe_sql, []);
console.log('func init_content (debug):');
console.dir(dbe_res);
}
function dbe (sql, stored)
{
if (typeof sql != "undefined")
{
console.log('func dbe: ' + sql + ' (' + stored + ')');
var wrk = {};
db.query(sql, stored, function(err, rows, fields)
{
if (err) console.log('func dbe (error): ' + err);
if (!err && typeof rows != "undefined" && typeof fields != "undefined")
{
console.log('func dbe (debug):');
console.dir({ f: 'zensiert', r: rows });
wrk = { f: 'zensiert', r: rows };
}
else
{
console.log('func dbe (debug): no data');
wrk = { f: '', r: '' };
}
});
console.log('func dbe (debug2):');
console.dir(wrk);
return wrk;
}
}node sqltest.jsWie man sieht, ist schon wrk bei return leer. Und "dbe debug" kommt immer zuletzt.
func init_content
func dbe: SELECT id, path, parent_id FROM content ()
func dbe (debug2):
{}
func init_content (debug):
{}
func dbe (debug):
{ f: 'zensiert',
r:
[ { id: 1, path: 'test', parent_id: 0 },
{ id: 2, path: 'test/1', parent_id: 1 } ] }
Node.js is a platform built on Chrome's JavaScript runtime for easily building fast, scalable network applications. Node.js uses an event-driven, non-blocking I/O model that makes it lightweight and efficient, perfect for data-intensive real-time applications that run across distributed devices.
$result_jane = $jane->query("SELECT ID, kestraid FROM RELEASES where kestraid IS NOT NULL AND mus = 0 LIMIT $start, $limit");
$get_same_st = $kestra->prepare("SELECT same FROM demos WHERE id = ? LIMIT 1"));
$get_same_st->bind_param("i", $kestraid);
while ($j_row = $result_jane->fetch_assoc()) {
// get same field from kestra
$kestraid = $j_row['kestraid'];
$get_same_st->execute();
}Das wird durch fetch_assoc() automatisch hoch gezählt.interpreter schrieb:müsstest du dann nicht $result-jane verändern damit das ergebnis von fetch_assoc sich verändert und die Schleife abbrechen kann?
Async is a utility module which provides straight-forward, powerful functions for working with asynchronous JavaScript. Although originally designed for use with node.js, it can also be used directly in the browser.
Async provides around 20 functions that include the usual 'functional' suspects (map, reduce, filter, forEach…) as well as some common patterns for asynchronous control flow (parallel, series, waterfall…). All these functions assume you follow the node.js convention of providing a single callback as the last argument of your async function.