Salam kenal..
Mau tanya nih seputar moodle.. gimana coding buat insert record di moodle?
ini coding yg aku punya
class simplehtml_form extends moodleform {
public function definition() {
global $CFG;
global $DB;
$mform = $this->_form; // Don't forget the underscore!
$rec=$DB->get_records_sql('SELECT * FROM kategori');
foreach($rec as $record)
{
$list[$record->idkategori] = $record->idkategori;
$list2[$record->idkategori] = $record->namakategori;
}
$kdbuku = $mform->addElement('text', 'kdbuku', 'Kode Buku');
$judul = $mform->addElement('text', 'judul', 'Judul');
$pengarang = $mform->addElement('text', 'pengarang', 'Pengarang');
$penerbit = $mform->addElement('text', 'penerbit', 'Penerbit');
$idkategori = $mform->addElement('select', 'idkategori', 'Kategori', $list);
$kategori = $mform->addElement('select', 'idkategori', 'Kategori', $list2);
$jumlah = $mform->addElement('text', 'jumlah', 'Jumlah');
$this->add_action_buttons();
}
//Custom validation should be added here
function validation($data, $files) {
return array();
}
}
//Instantiate simplehtml_form
$mform = new simplehtml_form();
//Form processing and displaying is done here
if ($mform->is_cancelled()) {
//Handle form cancel operation, if cancel button is present on form
$returnurl="$CFG->wwwroot/course/inputbuku.php";
redirect($returnurl);
} else if ($fromform = $mform->get_data()) {
//In this case you process validated data. $mform->get_data() returns data posted in form.
//$sql='insert into buku values';
$table = 'mdl_buku';
$dataobject = new StdClass;
$dataobject->kdbuku = $kdbuku;
$dataobject->judul = $judul;
$dataobject->pengarang = $pengarang;
$dataobject->penerbit = $penerbit;
$dataobject->idkategori = $idkategori;
$dataobject->jumlah = $jumlah;
$rec=$DB->insert_record($table, $dataobject);
} else {
// this branch is executed if the form is submitted but the data doesn't validate and the form should be redisplayed
// or on the first display of the form.
//Set default data (if any)
$mform->set_data($toform);
//displays the form
//$mform->display();
}
setelah di submit :
Table "mdl_buku" does not exist
Mohon bantuannya dari senior semua