Can i have a solution for this
am getting results like this :
{"msg":"data "}
{"msg":"data "}
and so on.........
i want to return the whole data to single json like:
{"msg":" all data goes here"}
my $sth = $dbh->prepare("SELECT
snd.name, snd.country, m.item, m.eqty, m.price, m.line, m.prodct FRO
+M
buys as m
JOIN Busers as snd ON snd.id = m.buyer WHERE CASE WHEN (SELECT SUM(s
+tatus = ?) FROM buys) > 0 THEN m.status = ? ELSE m.status = ? OR m.
+status = ? OR m.status = ? END
ORDER BY created ASC");
$sth->execute('sold', 'forsell', 'bugt', 'paid', 'inshop');
my $Data = $sth->fetchall_arrayref();
foreach my $Data (@$Data) {
my ($name, $country, $item, $eqty, $price, $line, $prodct) = @$Dat
+a;
$html = "<tr>
<td>
<p>$name</p>
<p>
$eqty, $price, $line,
</p>
$prodct
$country
</td>
</tr>
";
my $json = encode_json(
{ msg => $html}
);
print $q->header( -type => 'application/json' ),$json;
}
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.