General developer forum

I’m new to Moodle, and have little coding experience resulting in my struggle to develop anything.

I was wondering if you could give me some pointers on where I’m going wrong. I have been trying different things out but don’t understand exactly what I’m doing.

Basically I have a block which has a text box for the user to input search criteria, this form is linking to a search.php page which should run the query and display the results. As far as I can tell the input from the form is being passed to the search.php page as it is displayed URL.

before I put my code in I thought that I’d just say that i may have little or no code that actually does what I think it should be doing but I am still trying to learn so if you could give me any advice I will be very grateful.

The code for my block is as follows

<?php

class block_moodle_archive extends block_base {

function init() {
$this->title = get_string('formaltitle', 'block_moodle_archive');
$this->version = 2010042000;
}

function instance_allow_config() {
return true;
}


function get_content() {
global $CFG, $THEME;

if($this->content !== NULL) {
return $this->content;
}

$this->content = new stdClass;
$this->content->footer = '';

if (empty($this->instance)) {
$this->content->text = '';
return $this->content;
}

$button = get_string('go', 'block_moodle_archive');
$search = get_string('search', 'block_moodle_archive');


$this->content->text = '<div class="searchform">';
$this->content->text .= '<form action="'.$CFG->wwwroot.'/blocks/moodle_archive/search.php" method="post"><fieldset class="invisiblefieldset">';
$this->content->text .= '<input name="id" type="hidden" value="'.$this->instance->pageid.'" />'; // course id
$this->content->text .= '<label class="accesshide" for="searchform_search">'.$titlesearch.'</label>'.
'<input id="searchform_search" name="search" type="text" size="16" />';
$this->content->text .= '<button id="searchform_button" type="submit" title="'.$titlesearch.'">'.$button.'</button><br />';
$this->content->text .= '</fieldset></form></div>';

return $this->content;
}


function applicable_formats() {
return array('site' => true, 'course' => true);
}

}
?>



then the code from my search.php page is

<?php

// includes and requires
require_once('../../config.php');

$titlesearch = trim(optional_param('search', '', PARAM_NOTAGS)); // search string

$sSQL = get_record('block_archive', 'title', '%$titlesearch%');



$rsarchive = $sSQL;

if(!$rsarchive->EOF)
{
while (!$rsarchive->EOF)
{
$str_id = $rsarchive->Fields("id")->value;
$str_courseid = $rsarchive->Fields("courseid")->value;
$str_title = $rsarchive->Fields("title")->value;
$str_category = $rsarchive->Fields("category")->value;
$str_description = $rsarchive->Fields("description")->value;
$str_url = $rsarchive->Fields("url")->value;

?>

<table width="100%" cellpadding="2" cellspacing="2" border="0">
<tr valign="top">
<td width="25%"><h3>.: Title</h3></td>
<td colspan="25"><h3>.: Category</h3></td>
<td width="25%"><h3>.: Description</h3></td>
<td width="25%"><h3>.: URL</h3></td>
</tr>
</table>

<table width="100%" cellpadding="2" cellspacing="2" border="0">
<tr valign="top">
<td width="25%" height="23"><?php echo $str_title?></td>
<td colspan="25"><?php echo $str_category?></td>
<td width="25%"><?php echo $str_description?></td>
<td width="25%"><?php echo $str_url?></td>
</tr>
</table>


any pointers please (apart from the obvious GIVE UP!!)

thanks

Mark