[SOLVED] Query then write to file

tedtucker · 04-20-2012, 01:20 AM

I have a dynamic address the I need read into a file every minute. I was looking to write something simple to do this.

When I query this address:
http://abc.com/get_url.php it returns:

__devices__url="http://123.123.123.123/index.php?123abc"
__devices__status__code=0
__devices__error="0"

This then needs to get into url.txt like:

http://123.123.123.123/index.php

Would this be a job for php then call it via cron?

MensaWater · 04-20-2012, 07:34 AM

You could do it with a simple shell script. You don't say what command you're using for the "query" so I'll just use "query" in my example - you'd substitute the real command:

Code:

#!/bin/bash
query http://abc.com/get_url.php |grep http |awk -F= '{print $2}'|awk -F? '{print $1}' >url.txt

The above assumes your query output only has one line with http and that it is formatted the way you show.

Of course you could do it with php, perl or any other scripting language you know how to write.

pan64 · 04-20-2012, 09:00 AM

instead of grep, awk, awk, use only one awk:

Code:

query http://abc.com/get_url.php | awk -F\" ' /http/ { print $2 } ' > url.txt

tedtucker · 04-20-2012, 12:45 PM

Unfortantly that is where I get hung up... the responce includes this:

__devices__url="http://123.123.123.123/index.php?123abc"
__devices__status__code=0
__devices__error="0"

AND I just need:

http://123.123.123.123/index.php?123abc

Would wget or php or lynx be an appopriate way to call it?

Thanks for taking your free time to help with my problems! Simply amazing people. I will make sure to pay it forward!

-Ted

MensaWater · 04-20-2012, 01:49 PM

You just repeated your original question which is of no help.

What, if anything, did you TRY based on the replies we already made?

When you reply don't just say "I tried it and it didn't work". Tell us the EXACT syntax you typed and the EXACT response it gave you.

You still haven't even told us what you're doing to "query" that is giving you the response. How could we tell you what would be better? EXACTLY what are you typing that is giving the response - don't just say you're doing a query.

schneidz · 04-20-2012, 01:56 PM

this mite help:

Code:

[schneidz@hyper ~]$ cat ./xbmc/bin/onion.ksh
#!/bin/bash

cd ~/win/stuff/clips/onion
wget http://www.theonion.com/feeds/onn/

i=1
for mp4 in `grep enclosure index.html | awk -F "http" '{print $3}' | awk -F "mp4" '{print "http" $1 "mp4" }'`
do
 last=`basename $mp4`
 if [ "`ls *$last`" ]
 then
  mv *$last `zero-pad-2.x $i`-$last 
  else
   wget $mp4
   mv $last `zero-pad-2.x $i`-$last
 fi
 i=`expr $i + 1`
done

rm index.html

tedtucker · 04-20-2012, 02:43 PM

dear god, it worked.

GET 'http://abc.com/get_url.php?u=user&p=pass' | awk -F\" ' /http/ { print $2 } ' > url.txt

Thanks everybody!