Hi
I have wrote a module for despalying my database table data into html format table. I have delete and edit button infront of every button. delete function is working fine. Code is as below
<?phpwhen i put hardcoded value infront of doctorid like doctorid=2 then its getting edited after i click on edit button but when i paasing it using varible and clicking edit button then its showing following error where firstname ->anitha,lastname->abc are the values i enetering in form while editing.
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");
}
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 query: UPDATE doctor SET firstname = 'anitha', lastname= 'abc', gender = 'female', status = 'inactive' WHERE doctorid= in D:\FR-Server\Apache2\htdocs\fr\sites\all\Modules\doctor\doctor.module on line 157.
my html table on drupal screen
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
edit form :
First Name:
Last Name:
Gender:
male
female
Status:
active
inactive
Please help me how i can pass that doctorid and also help me for getting default values in form when i click edit button in table.MAHESH GAJABAR
Software Developer
FrontalRain Technologies,Bengaluru