<?php

function doctor_menu() {
$items = array();

$items['doctor'] = array(
    'title' => t('Doctors'),
    'page callback' => 'doctors_list',
    'access arguments' => array('access doctor'),
    'type' => MENU_NORMAL_ITEM,
);

$items['doctor/delete/%doctor_user'] = array(
    'title' => t('Delete doctor'),
    'page callback' => 'drupal_get_form',
    'page arguments' => array('doctor_delete_confirm', 2),
    'access arguments' => array('access doctor'),
    'type' => MENU_CALLBACK,
);

$items['doctor/edit/form'] = array(
    'title' => t('doctor'),
    'page callback' => 'drupal_get_form',
    'page arguments' => array('doctor_page',2),
    'access arguments' => array('access doctor'),
    'type' => MENU_NORMAL_ITEM,
);

$items['doctor/edit/%doctor_user'] = array(
    'title' => t('Edit Form'),
    'page callback' => 'drupal_get_form',
    'page arguments' => array('doctor_edit_confirm', 2),
   'access arguments' => array('access doctor'),
    'type' => MENU_NORMAL_ITEM,
);
return $items;
}

function doctors_list() {
    $header = array(t('Doctor Name'), t('Gender'), t('Status'), t('Action'));

    $query = "SELECT * FROM {doctor}";
    $rs = db_query($query);

    $row = array();

    if ($rs) {
        while ($data = db_fetch_object($rs)) {
            $gender = $data->gender;
            $status = $data->status ;
            $row[] = array(stripslashes(ucwords($data->firstname)) . ' ' . stripslashes(ucwords($data->lastname)), $gender, $status,
            "<a href='doctor/edit/{$data->doctorid}'>" . t('Edit') . "</a> | <a href='doctor/delete/{$data->doctorid}'>" . t('Delete') . "</a>");
        }
    }

    $str .= theme_table($header, $row);

    return $str;
}
function doctor_user_load($doctorid) {
    $query = "SELECT * FROM {doctor} WHERE doctorid = %d";
    $rs = db_query($query, $doctorid);

    if ($rs) {
        while ($data = db_fetch_object($rs)) {
            return $data;
        }
    }

    return FALSE;
}

function doctor_delete_confirm(&$form_state, $doctor) {
    $form['_doctor'] = array(
        '#type' => 'value',
        '#value' => $doctor,
    );

    return confirm_form($form,
        t('Are you sure you want to delete this doctor?'),
        isset($_GET['destination']) ? $_GET['destination'] : "doctor",
        t('This action cannot be undone.'),
        t('Delete'),
        t('Cancel'));
}

function doctor_delete_confirm_submit($form, &$form_state) {
    $form_values = $form_state['values'];

    if ($form_state['values']['confirm']) {
        $doctor = $form_state['values']['_doctor'];

                                     $query = "DELETE FROM {doctor} where doctorid=$doctor->doctorid";
                       $rs = db_query($query);

        //doctor_delete($form_state['values'], $doctor->doctorid);

        drupal_set_message(t('Doctor has been deleted successfully.'));
    }

    drupal_goto("doctor");
}

function doctor_edit_confirm(&$form_state,$doctor){
$form = array();
$form['_doctor'] = array(
        '#type' => 'value',
        '#value' => $doctor,
    );
$form['firstname']=array(
        '#title'=>t('First Name'),
        '#type'=>'textfield',
                                     //'#prefix'=>'<table class="formtable"><tr><td class="labeltext">First Name</td><td class="textbox">',
        '#suffix'=>'</td></tr>',
);
$form['lastname']=array(
        '#title'=>t('Last Name'),
        '#type'=>'textfield',
                                     '#default_value' => $lastname,
    );
$form['gender']=array(
        '#title'=>t('Gender'),
        '#type'=>'radios',

                                   '#options' => array(t('male'), t('female')),
                                     '#default_value' => male,
    );
$form['status']=array(
        '#title'=>t('Status'),
        '#type'=>'radios',
                                     '#default_value' => active,
                                     '#options' => array(t('active'), t('inactive')),

    );

return confirm_form($form,t(''),
        isset($_GET['destination']) ? $_GET['destination'] : "doctor",
        t(''),
        t('Edit'),
        t('Cancel'));
}

function doctor_edit_confirm_submit($form, &$form_state)
{
if ($form_state['values']['confirm']) {
$doctor = $form_state['values']['_doctors'];
$firstname = $form_state['values']['firstname'];
    $lastname = $form_state['values']['lastname'];
    $gender1= $form_state['values']['gender'];
$gender = $gender1 ? t('female') : t('male');
    $status1 = $form_state['values']['status'];
$status = $status1 ? t('inactive') : t('active');

$query = "UPDATE {doctor} SET firstname = '$firstname', lastname= '$lastname', gender = '$gender', status = '$status' WHERE doctorid=$doctor->doctorid";
$rs = db_query($query);

}
drupal_goto("doctor");
}

Doctor Name	Gender	Status	Action
Mahesh Gajabar	male	inactive	Edit \| Delete
Anitha Patil	female	active	Edit \| Delete
Pavithra M	female	active	Edit \| Delete
Ravi Mandayam	male	active	Edit \| Delete