Get values of array shell script and set to variables

Question

How could I separate the values ​​obtained in an array according to the search string? Example: I use this code:

#!/bin/bash
#Ref =  https://www.linuxquestions.org/questions/programming-9/bash-to-loop-thorouh-mysql-select-array-882907/#post5798608#
#
DBUSER="user"
DBNAME="pass"
results=($(mysql --user ${DBUSER}  ${DBNAME} -Bse "select phonenumber, userattr from usersSis WHERE sendMSG = '0';"))
cnt=${#results[@]}

for (( i=0; i<${cnt}; i++ ))
do
    echo "Total. $i: ${results[$i]} "

#    NumPhone1=${results[0]};
#    CodPhone1=${results[1]};
#    NumPhone2=${results[2]};
#    CodPhone2=${results[3]};

echo "---------------------------------------------------------------------------------------------------"
done

The result is :

Total. 0: 1223121219
---------------------------------------------------------------------------------------------------
Total. 1: 667
---------------------------------------------------------------------------------------------------
Total. 2: 3223121219
---------------------------------------------------------------------------------------------------
Total. 3: 2005
---------------------------------------------------------------------------------------------------
Total. 4: 5223121219
---------------------------------------------------------------------------------------------------
Total. 5: 545454
---------------------------------------------------------------------------------------------------

Could they look like this? REF: Loop through an array of strings in Bash? Creating an associative array. A dictionary:

declare -A continent

continent[Vietnam]=Asia
continent[France]=Europe
continent[Argentina]=America

for item in "${!continent[@]}"; 
  do
    printf "$item is in ${continent[$item]} \n"
  done
Output:

 Argentina is in America
 Vietnam is in Asia
 France is in Europe

var1 = 1223121219 and var2 = 667 var3 = ... and var4 = ... ... ...

Answer 1

If I understand your query result format being "phonenum userattr" on each line, then you can create an associative array keyed by userattr (e.g. result[$userattr]=phonenum). To separate the values into the associative array, you can use process substitution (instead of command substitution) to provide input to a while loop that you use to create the associative array, e.g.

#!/bin/bash
#Ref =  https://www.linuxquestions.org/questions/programming-9/bash-to-loop-thorouh-mysql-select-array-882907/#post5798608#
#
DBUSER="user"
DBNAME="pass"

declare -A result

while read -r phone userattr; do
    result[$userattr]=$phone
done < <(mysql --user ${DBUSER}  ${DBNAME} -Bse "select phonenumber, userattr from usersSis WHERE sendMSG = '0';")

for attrib in "${!result[@]}"; do
    printf "%-8s : %s\n" "$attrib" "${result[$attrib]}"
done

(note: your cnt=${#result[@]} would work fine above as well)

I don't have your database to test with, but with your values above as "phonenum userattr" per-line of input, the output would be:

545454   : 5223121219
2005     : 3223121219
667      : 1223121219

(note: be aware that associative arrays do you preserve the order the data is input, it is an associative array, the order the elements were added in is irrelevant)

---

Test Input Used

Given the difficulty you are having, a couple of troubleshooting steps and comparisons are warranted. With your post of the output, the output of your command:

mysql --user ${DBUSER}  ${DBNAME} -Bse "select phonenumber, userattr from usersSis WHERE sendMSG = '0';"

should be:

1223121219 667
3223121219 2005
5223121219 545454

So let's test with a simple input file. Save what is above to a file on your computer. I have it in sqlout, e.g.

$ cat sqlout
1223121219 667
3223121219 2005
5223121219 545454

Now change the script to read the file instead of the process substitution, e.g.

#!/bin/bash

declare -A result

while read -r phone userattr; do
    result[$userattr]=$phone
done < sqlout

echo "${#result[@]} entries"

for attrib in "${!result[@]}"; do
    printf "%-8s : %s\n" "$attrib" "${result[$attrib]}"
done

Then run the script and check that you are getting all output, e.g.

Example Use/Output

$ bash readmysql.sh
3 entries
545454   : 5223121219
2005     : 3223121219
667      : 1223121219

Let me know if you do not get the same output and we will go from there.

Answer 2

mysql> select * from usersSis;
+----+-------+-------------+----------+------------+---------+
| id | ipNow | phonenumber | userattr | dateExpire | sendMSG |
+----+-------+-------------+----------+------------+---------+
|  1 | NULL  | 1223121219  | 667      | NULL       | 0       |
|  2 | NULL  | 3223121219  | 2005     | NULL       | 0       |
|  3 | NULL  | 5223121219  | 545454   | NULL       | 0       |
+----+-------+-------------+----------+------------+---------+
3 rows in set (0.00 sec)

mysql>

Result of cod: root@us:/var/www/html/arquivos# ./script.sh 545454 : 2005 : 667 :

in script > You script example code =D