[support] managing automated cron generated html pages via drupal

[Craig Gardner]

Rahul,

I've done something similar quite a few times using Drupal.  The guts of my
code are:

> function scoreboard_menu() {

  $items = array();


> $items['scoreboard'] = array(

'title' => t('My Scoreboard'),

'description' => t('Scoreboard'),

'page callback' => 'scoreboard_main_page',

'access arguments' => array('access content'),

'type' => MENU_CALLBACK,

);


> return $items;

}



function scoreboard_main_page() {
>   $output = '';
> $table = array();
> $header = array(
> );
> $date = date('Y-m-d');
>
> db_set_active('customdb');
> $results = db_query('SELECT * FROM WHERE filter LIKE "%s%%" GROUP BY
> groupfield ORDER BY orderfield DESC', $date);
> db_set_active();




> while ($line = db_fetch_object($results)) {
> $table[] = $line;
> }
>
> $output .= theme('table', $header, $table, array('class' =>
> 'scoreboard-table'));
> return $output;
> }


Just make sure you have your database settings in your settings.php.  Seems
to work for me for simple tasks

On Wed, Jul 22, 2009 at 1:11 PM, Rahul Nabar<rpnabar at gmail.com> wrote:
> On Wed, Jul 22, 2009 at 2:21 PM, sivaji j.g<sivaji2009 at gmail.com> wrote:
>> On Thu, Jul 23, 2009 at 12:45 AM, Rahul Nabar <rpnabar at gmail.com> wrote:
>>>
>>> We have a mysql database storing a bunch of scientific data and I have
>>> a cron script querying the database and making html tables of key
>>> data. Is there a way how this content (the resulting html pages) can
>>> be integrated and managed via drupal? Especially the link structure
>>> etc.?
>>
>> It is very difficult to answer with this minimal information.
>
> Sorry if I was terse.  I'll try to do better:
>
> I have data in a mysql database. In order to present this I (or rather
> a cron script) usually run on the command line something like:
>
> echo 'SELECT * FROM footable' | mysql -h foo.bar.edu -u foouser -p
> --html bar_db > temp.html
>
> Then a webpage.php file adds some more headers, css styling etc. and
> presents this page. Something like:
>
> http://files.getdropbox.com/u/118481/mqsql_html.jpg
>
>
> Unfortunately there are several such "autogenerated" pages and it is
> hard to keep track of up-to-date menus, links etc. I was wondering if
> this was facilitated by Drupal. Maybe even if Drupal was the right
> tool for this job at all.
>
> --
> Rahul
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.drupal.org/pipermail/support/attachments/20090727/162cc267/attachment-0001.htm>