BASH script get's row data from mySQL and uses that to launch PHP scrips

Question

I've been trying for a few hours now to store row data into a BASH var then use that to launch some PHP scripts.

So far, I've only been able to echo out the whole result set. I have since broken that script, so I can't even paste it here. This is what I have, that's not working at all.

#! bin/bash
query=`echo "SELECT id FROM searches WHERE running=1 AND id_user=2" | mysql -u root`

I've never used BASH before, so I'm completely lost.

What I'm asking for is some resources that can show me how I can connect to mysql, then loop through a result set using the data from that row.

Thanks.

Chris Trahey · Accepted Answer · 2012-08-25 01:01:55Z

2

You can read mysql --silent output into Bash vars with while read:

>sql="SELECT id FROM searches WHERE running=1 AND id_user=2"
>mysql --silent -u ctrahey test -e "$sql" |while read myid; do
 php -f my_processor.php $myid; 
done
>

Notes:

sql="... sets a Bash variable of your sql (not actually necessary, just aides readability)
mysql -e the -e option allows you to pass in a query, so you don't need STDIN
mysql --silent --silent suppresses the extra formatting mysql usually does. in my testing, this was actually also unnecessary (the pipe chars in the output did not mess up Bash)
php -f .. this executes a php file, passing the current id as an arg.

answered Aug 25, 2012 at 1:01

Chris Trahey

18.3k1 gold badge44 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

geirha · Accepted Answer · 2012-08-25 00:50:18Z

0

Bash is not a good language for interacting with mysql, it only works for very very simple cases. Use php instead (since you mentioned php), it has an api for interacting with mysql databases sanely. And yes, you can run a php script as you would a bash script.

answered Aug 25, 2012 at 0:50

geirha

6,4751 gold badge33 silver badges38 bronze badges

Comments

Roy · Accepted Answer · 2012-08-25 00:59:10Z

0

If you want to run a single command with MySQL, use mysql -e or mysql --execute. They are the same command, but the second version is more memorable. If you add this flag to the above, the rows will be stored in the variable.

However, as mentioned by geirha, BASH may not be the best language to get row data. But if you choose to parse it wish BASH, mysql -e is the right command to execute queries.

answered Aug 25, 2012 at 0:59

Roy

3,6342 gold badges32 silver badges40 bronze badges

Collectives™ on Stack Overflow

BASH script get's row data from mySQL and uses that to launch PHP scrips

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related