salve, vorrei un piccolo aiuto.
Mi trovo in questa situazione: ho una funzione del genere e tutto funziona correttamente; ora ho bisogno di recuperare il numero di righe della tabella e passarle a un'altra funzione. Come posso fare?
function moodledata_search_submit($a=null,&$b=null){
$name=$b['values']['stext'];
if ($name==null || empty($name)){
$name='';
}
$course=$b['values']['course_name'];
if ($course==null || empty($course)){
$course='';
}
$file_type=$b['values']['file_type'];
if ($file_type==null || empty($file_type)){
$file_type='';
}
$date_field=$b['values']['date_field'];
if ($date_field==null || empty($date_field)){
$date_field='';
} else {
$date_field= strtotime($date_field, $now = null);
}
db_set_active('moodle');
if(($name=='')&&($course=='')&&($file_type=='')&&($date_field=='')){
$result = db_query("SELECT mdl_resource.id, fullname, course, name, type, reference, mdl_resource.summary, mdl_resource.timemodified FROM mdl_resource JOIN mdl_course ON mdl_resource.course = mdl_course.id");
} else {
$result = db_query("SELECT mdl_resource.id, fullname, course, name, type, reference, mdl_resource.summary, mdl_resource.timemodified FROM mdl_resource JOIN mdl_course ON mdl_resource.course = mdl_course.id WHERE fullname LIKE '%%" .$course ."%' AND name LIKE '%%" .$name ."%' AND type LIKE '%%" .$file_type ."%' AND mdl_resource.timemodified > '" .$date_field ."'");
}
db_set_active('default');
$header = array(
t("Select Item"),
t("Course name"),
t("Name"),
t("Type"),
t("Reference"),
t("Description"),
t("Last Modified")
);
$format="Y-m-d";
if($result ->num_rows == 0){
drupal_set_message('No results found for chosen criteria');
} else{
$i=0;
while($user = db_fetch_array($result)){
$temp[$i]=$user['id'];
$timestamp = $user['timemodified'];
$date=date($format,$timestamp);
$rows[] = array(
drupal_get_form('boh',$i),
//drupal_get_form($form_id,$node),
$user['fullname'],
$user['name'],
$user['type'],
"" .$user['reference'] ."",
$user['summary'],
$date
);
$i++;
}
}
drupal_get_form('get_numrows',$i);
$output .= drupal_render_form('search_by_name',$a);
if($a!=null && !empty($a)){
$output .= drupal_render_form('select_button',$a);
} else {
$output .= drupal_get_form('select_button');
}
$output .= theme('table', $header, $rows);
$output .= drupal_get_form('download');
print theme('page', $output);
}
ho provato con variabile globale ma non funziona... vi prego aiutatemi!!!
