[SOLVED] Multiple Variables from a BASH Command

zer0signal · 11-11-2012, 02:31 AM

Hey all...

I am kinda stuck, limited by the amount of variables I can get from the (set) command.. I am kinda looking for another way to get multiple variables from one command, and then those variables are passed to SQL on an (insert). This is a weekend project for me to learn a little about database's, and interacting w/ them (BASH,PHP,MYSQL).

Any suggestions on how I should approach this..?

PHP Code:



set $(hostname -f; sar -q 1 1 |tail -2 |egrep -v 'Average|RESTART')

mysql -h database -u sar -e "INSERT INTO SAR.LOAD (ID, SERVER, DATE_TIME, RUNQ, PLIST, LOAD1, LOAD5, LOAD15) VALUES (NULL, '$1', NOW(), '$4', '$5', '$6', '$7', '$8');"

SAbhi · 11-11-2012, 05:21 AM

well i cant get your question exactly... can you please explain what exactly what you need.
Do you want a command to output $1 $2 $3 $4 in some random variables from a command line.

zer0signal · 11-11-2012, 10:02 AM

by executing this command:

set $(hostname -f; sar -q 1 1 |tail -2 |egrep -v 'Average|RESTART')

i get:

hostname-whatever
10:56:37 AM 0 430 0.41 0.45 0.29 0

and set creates variables for each field

$1 = hostname
$2 = 10:56:37
$3 = AM

Etc...

But w/ 'set' I am limited to $1-9 so if my output is bigger than 9 fields i cannot use set in that scenario... What I am looking to try and do is find another way to get each field into a variable (where i am not limited), and then I would select only the variables I want to pass to the database.

catkin · 11-11-2012, 10:10 AM

An array should work:

Code:

array=( $(hostname -f; sar -q 1 1 |tail -2 |egrep -v 'Average|RESTART') )

ntubski · 11-11-2012, 11:34 AM

Quote:

Originally Posted by zer0signal

But w/ 'set' I am limited to $1-9 so if my output is bigger than 9 fields i cannot use set in that scenario...

You can access the 10th field with ${10}.