'markup', '#markup' => '' ); $form["QR_code"] = array( "#type" => "textfield", "#title" => "Enter QR Code", "#default_value" => '', "#required" => TRUE ); $form["submit"] = array( "#type" => "submit", "#value" => "Verify", '#ajax' => array( 'callback' => 'verify_lab_migration_certificates_form_submit', 'progress' => array( 'message' => '' ) ) ); $form['displaytable'] = array( '#type' => 'markup', '#prefix' => '

', '#suffix' => '

', '#markup' => '' ); return $form; } function verify_lab_migration_certificates_form_submit($form, &$form_state) { $page_content = ""; $v = $form_state["values"]; $qr_code = $v["QR_code"]; $page_content = verify_qrcode_lm_fromdb($qr_code); $form['displaytable']['#markup'] = $page_content; $commands[] = ajax_command_html("#displaytable", drupal_render($form['displaytable'])); return array( '#type' => 'ajax', '#commands' => $commands ); } function verify_qrcode_lm_fromdb($qr_code) { $query = db_select('lab_migration_certificate_qr_code'); $query->fields('lab_migration_certificate_qr_code'); $query->condition('qr_code', $qr_code); $result = $query->execute()->fetchObject(); $proposal_id = $result->proposal_id; $certificate_id = $result->certificate_id; if ($proposal_id) { $query2 = db_query("SELECT * FROM {lab_migration_certificate} WHERE proposal_id= :prop_id AND id=:certificate_id", array( ':prop_id' => $proposal_id, ':certificate_id' => $certificate_id )); $data2 = $query2->fetchObject(); if ($data2->type == "Proposer") { $page_content = ""; $page_content .= "

Participation Details

"; //$page_content.=""; //$page_content.=""; $page_content .= ""; $page_content .= ""; $page_content .= ""; $page_content .= ""; $page_content .= ""; $page_content .= ""; $page_content .= ""; $page_content .= ""; $page_content .= ""; $page_content .= ""; $page_content .= ""; $page_content .= ""; $page_content .= "

Name	".$data2->name_title. ' '.$data2->name."
Project	Scilab Lab Migration Project
Lab completed	" . $data2->lab_name . "
Department	" . $data2->department . "
Semester Details	" . $data2->semester_details . "
Institute Name	" . $data2->institute_name . "
Institute Address	" . $data2->institute_address . "

"; } //$data2->type == "Proposer" elseif ($data2->type == "Participant") { $page_content = ""; $page_content .= "

Participation Details

Name	".$data2->name_title. ' '.$data2->name."
Project	Scilab Lab Migration Project
Contributed to complete the lab	" . $data2->lab_name . "
Participant	" . $data2->name_title . " " . $data2->name . "
Department	" . $data2->department . "
Semester Details	" . $data2->semester_details . "
Institute Name	" . $data2->institute_name . "
Institute Address	" . $data2->institute_address . "

"; } //$data2->type == "Participant" else { $page_content = "Sorry ! The serial number you entered seems to be invalid. Please try again ! "; } return $page_content; } //$proposal_id }