$uniqueattendance = new stdclass;
$uniqueattendance->id = $anabsentee->number;
$uniqueattendance->field1 = 'some data';
$uniqueattendance->field2 = 'something else';
if (update_record('mytable', $uniqueattendance)) {
/// Success!
} else {
/// Fail!
}if ($uniqueattendance = get_record('mytable', 'id', $anabsentee->number)) {
$uniqueattendance->field1 = 'new data';
update_record('mytable', $uniqueattendance);
}Hi all,
I have tried all these...but nothing works....
Kindly help me out to update a particular record of the user table...
Thanks in advance...
global $DB; $uniquelevel = new stdclass;
$lcSelectedid = $_GET['stuid'];
$unilevel = intVal($_POST['level_select']);
if ($uniquelevel =$DB->get_record('{user}', 'id', $lcSelectedid ))
{ $uniquelevel->level = $unilevel;
$DB->update_record('mdl_user',$uniquelevel);
}
2.
$data = new stdClass;
$lcSelectedValue = intVal($_POST['level_select']);
$lid=$_GET['stuid'];
$data->level = $lcSelectedValue;
//$ulevel=$DB->update_record_sql('UPDATE mdl_user SET level = $lcSelectedValue WHERE id=?',$lid);
$res = $this->datalib->update_record('mdl_user', $data);
3.$record = new object();
$record->level = $lcSelectedValue;
if($record->id == $lid)
{ echo $id = $DB->insert_record('mdl_user', $record); }
echo "Level Updated Successfully!!!";
4.
$record = new stdClass();
$record->id=$stuval->id;
$ulevel=$DB->update_record(mdl_user, $record, $bulk=false);
5.$ulevel=$DB->update_record('UPDATE {user} SET level = $lcSelectedValue WHERE id=?',array($stuval->id));
The passing and getting of the value from other part of the code is successful..I have checked that...but cant update the record....
Please help me at the earliest...
Thanks,
Sathya
Hi Davo Smith,
Thanks for your reply....
It worked well with the following code....
global $DB;
$uniquelevel = new stdclass;
$lcSelectedid = $_GET['stuid'];
$levl = intVal($_POST['level_select']);
$sql=$DB->get_record_sql("Update {user} set level=$levl where id= $lcSelectedid");
Now im going to try to update multiple values from multiple selection box to a field in table.
Thanks,
Sathya.
I think you need to have another look at the code, it might work, but is wide open to a number of security flaws that Moodle tries its best to protect you from, try this instead:
global $DB;
$upduser = new stdClass();
$upduser->id = required_param('stuid', PARAM_INT);
$upduser->level = required_param('level_select', PARAM_INT);
$DB->update_record('user', $uniquelevel);
Even better would be to add a check, just before the last line, that the student exists:
if ($DB->record_exists('user', array('id' => $upduser->id))) {
You should never be calling 'get_record_sql' to update the database ('execute' can be used in the rare occassions where there really is no alternative). Even if you are going to use 'get_record_sql' for some purpose (i.e. to get records, not update them), then remember to use the following syntax:
$result = $DB->get_record_sql("SELECT * FROM {user} WHERE level = ?", array($userid));
As this format will clean all the paramaters for you (although in this example, you would actually use '$DB->get_record('user', array('id' => $userid));')
Hi Dave,
I think there are two typoos in your example;
1) $uniquelevel is never defined. I assume this should be $upduser;
$DB->update_record('user', $upduser);
2) You use $userid as level, so this line should be;
$result = $DB->get_record_sql("SELECT * FROM {user} WHERE level = ?", array($upduser->level));
BTW personally I prefer named parameters;
$result = $DB->get_record_sql("SELECT * FROM {user} WHERE level = :level", array('level'=>$upduser->level));
Anne.
Note to other readers; the way to handle DB has changed since 2.x, so the top of this thread my no longer apply.
oops... sorry, but I hope the basic idea behind it still stands
Hi Dave & Anne,
Thank You for your reply....
Reply is more understandable and make to learn better...Thanks again...
<code> global $DB;
$upduser = new stdClass();
$lcSelectedid = $_GET['stuid'];
$levls = $_POST['level_select'];
$upduser->id = required_param('lcSelectedid', PARAM_INT);
$upduser->level = required_param('levls', PARAM_INT);
if ($DB->record_exists('user', array('id' => $upduser->id))) {
$DB->update_record('user', $upduser);
} </code>
Here im passing the value stuid & level_select from one file to other,so i have altered the code like this,here it is not taking lcSelectedid value....
"A required parameter (lcSelectedid) was missing"
And now im trying to insert multiple values into the table....when only the first value is inserted....Is there an option for it?
<codeglobal $DB;
$upduser = new stdClass();
$lcSelectedid = $_GET['stuid'];
$levls = $_POST['level_select'];
foreach($levls as $levl)
{
$upduser->teacherid = required_param("lcSelectedid", PARAM_INT);
$upduser->level = required_param('levls', PARAM_INT);
if ($DB->record_exists('teacher_level', array('teacherid' => $upduser->teacherid)))
{
//Delete Query should be written later once this works fine here
}
else{
$DB->insert_record('teacher_level', $upduser);
}
"A required parameter (lcSelectedid) was missing"--Its not taking the value passed....
Thanks in advance.....
Sathya
global $DB;
$upduser = new stdClass();
$lcSelectedid = $_GET['stuid'];
$lcSelectedid = required_param('studid', PARAM_INT);
$levls = $_POST['level_select'];
$levls = required_param('level_select', PARAM_INT);
$upduser->id = $lcSelectedid;
$upduser->level = $levls;
if ($DB->record_exists('user', array('id' => $upduser->id))) {
$DB->update_record('user', $upduser);
}
Although, there is really no reason to get the data via required_param and then copy it into another variable, the code I originally suggested would work just as well:
$upduser->id = required_param('studid', PARAM_INT);
