Web lists-archives.com

Re: [PHP] Re: How to explode an array from a Database?




First of all, I would recommend using
http://php.net/manual/en/book.pdo.php PDO.
Having something like
db_query($db_link, "SELECT serial,$category FROM categories");
is a bad idea if you are running this code in a web page, because of SQL
injections.

There is a fetch for assoc and then you can find the array key of the
associate array.

You'll find a lot of resources just googling some of these words. Maybe
look into using the preg_split function and finding a regular expression to
split on if you have to do that anywhere.

More of the code and samples of data would also help with helping you.

On Mon, 29 May 2017 at 02:34 Michelle Konzack <linux4michelle@xxxxxxxxx>
wrote:

> I tried to use the following (base) code:
>
> ----8<------------------------------------------------------------------
> [01] $db_link   = db_connect();
> [02]  $db_result = db_query($db_link, "SELECT serial,$category FROM
> categories");
> [03]  $cat_array = db_fetch_all($db_result);
> [04]
> [05]  sort($cat_array, SORT_NUMERIC);
> [06]
> [07]  foreach($cat_array as $row) {
> [08]    extract($row);
> [09]    $strg .= "        <a
> href=\"/?what=category&num=$serial\">$category</a><BR>\n";
> [10]  }
> [11]
> [12]  db_close($db_link);
> ----8<------------------------------------------------------------------
>
> the problem is in db_query (line 02) with "$category"  where  the  value
> can change between e.g.
>
> category
> cat_de
> cat_fr
> cat_ee
> cat_ru
> ...
>
> so, how I can evaluate the name of the value of the  variable  $category
> in line 09?
>
> Thanks
>
> --
> Michelle Konzack        Miila ITSystems @ TDnet
> GNU/Linux Developer     00372-54541400 <+372%205454%201400>
>