Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

1
failing to execute dinamic query
Post Body

I am trying to fetch data from a database in Moodle with a dinamic query but I tell me that there is an error in the reading of the database:

$parts = $_POST['make']; $arr = explode(':', $parts);

$sql = "SELECT mdl_block_report_bbb_meeting.id, mdl_block_report_bbb_meeting.name, mdl_block_report_bbb_meeting.create_time, mdl_block_report_bbb_meeting.end_time, mdl_block_report_bbb_user_events.id as ueid, mdl_block_report_bbb_user_events.name as uename, mdl_block_report_bbb_user_events.join_time, mdl_block_report_bbb_user_events.left_time FROM mdl_block_report_bbb_meeting JOIN mdl_block_report_bbb_user_events ON mdl_block_report_bbb_meeting.id = mdl_block_report_bbb_user_events.meeting_id WHERE uename LIKE '%$arr%'";

$result = $DB->get_records_sql($sql);

What am I doing wrong?

Author
Account Strength
80%
Account Age
6 years
Verified Email
Yes
Verified Flair
No
Total Karma
251
Link Karma
97
Comment Karma
154
Profile updated: 11 hours ago
Posts updated: 4 months ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
3 years ago