Reply to thread

Message

<blockquote data-quote="djames42" data-source="post: 396069" data-attributes="member: 13241">For what it's worth, here's a very simple snippet of code I just hacked together. This takes a few parameters pushed to it by way of wget (which, if you're not familiar with, is a way of emulating a web browser in code to pass a URL to a server and retrieve any html pushed from that server). It takes the passed parameters and loads them into a local mysql database. You should be able to use this to see a very simple way of putting data in to your database. Getting it out is slightly more complicated, but not much...[CODE]&lt;?PHP$server=$_GET['server'];$sessioncnt=$_GET['sessioncnt'];$totalsessions=$_GET['totalsessions'];$date=date('Y-m-d H:i:s');$db_conn = mysql_connect('localhost', '[I]username[/I]', '[I]password[/I]');if (!$db_conn) {&nbsp; &nbsp; die('Could not connect: ' . mysql_error());}$db_selected = mysql_select_db('[I]database_name[/I]', $db_conn);if (!$db_selected) {&nbsp; &nbsp; die ('Can\'t use database_name : ' . mysql_error());}$insert=sprintf(&quot;insert into session_history values('%s','%s',%d,%d)&quot;,&nbsp; &nbsp; &nbsp; &nbsp; mysql_real_escape_string($server),&nbsp; &nbsp; &nbsp; &nbsp; mysql_real_escape_string($date),&nbsp; &nbsp; &nbsp; &nbsp; $sessioncnt, $totalsessions);mysql_query($insert,$db_conn);mysql_close($db_conn);?&gt;[/CODE]The way this script is called is by running the following command:[CODE]wget -q --delete-after &quot;http://web_url/~user/path/scrpt.php?server=${hostname}&amp;sessioncnt=${usedprocs}&amp;totalsessions=${maxprocs}&quot;[/CODE]</blockquote>

[QUOTE="djames42, post: 396069, member: 13241"] For what it's worth, here's a very simple snippet of code I just hacked together. This takes a few parameters pushed to it by way of wget (which, if you're not familiar with, is a way of emulating a web browser in code to pass a URL to a server and retrieve any html pushed from that server). It takes the passed parameters and loads them into a local mysql database. You should be able to use this to see a very simple way of putting data in to your database. Getting it out is slightly more complicated, but not much... [CODE]<?PHP $server=$_GET['server']; $sessioncnt=$_GET['sessioncnt']; $totalsessions=$_GET['totalsessions']; $date=date('Y-m-d H:i:s'); $db_conn = mysql_connect('localhost', '[I]username[/I]', '[I]password[/I]'); if (!$db_conn) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db('[I]database_name[/I]', $db_conn); if (!$db_selected) { die ('Can\'t use database_name : ' . mysql_error()); } $insert=sprintf("insert into session_history values('%s','%s',%d,%d)", mysql_real_escape_string($server), mysql_real_escape_string($date), $sessioncnt, $totalsessions); mysql_query($insert,$db_conn); mysql_close($db_conn); ?>[/CODE] The way this script is called is by running the following command: [CODE]wget -q --delete-after "http://web_url/~user/path/scrpt.php?server=${hostname}&sessioncnt=${usedprocs}&totalsessions=${maxprocs}"[/CODE] [/QUOTE]

Verification

Name this item 🌈