Browse Moodle Solutions

I have 2-3 different column names that I want to look up in the entire database and list out all tables which have those columns. Is there any easy script?

I have a table: table votes ( id, user, email, address, primary key(id), ); How can I make the columns **user, e...

How do you set a default value for a MySQL Datetime column? In SQL Server it's `getdate()`. What is the equivalant for MySQL? I'm using MySQL 5.x if...

I am trying to select data from a MySQL table, but I get one of the following error messages: > mysql_fetch_array() expects parameter 1 to be resource, bo...

Per [the MySQL docs][1], there are four TEXT types: 1. TINYTEXT 2. TEXT 3. MEDIUMTEXT 4. LONGTEXT What is the maximum length that I can store in a...

While executing an `INSERT` statement with many rows, I want to skip duplicate entries that would otherwise cause failure. After some research, my options appea...

I have a table with a varchar column, and I would like to find all the records that have duplicate values in this column. What is the best query I can use to fi...

I've got a messages table in MySQL which records messages between users. Apart from the typical ids and message types (all integer types) I need to save the...

I have a table of player performance: ``` CREATE TABLE TopTen ( id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, home INT UNSIGNED NOT NULL, `datetime`D...

I'm currently a student at a University and I'm using Moodle everyday. I would like to access some information that is available to me (For example, in...

We have tried to insert form elements via quiz actvity in moodle but when it is much complicated to handle when we display on the front end. Please refer th...

tl;dr; trying to get a course module instance via a course module through mysql or the official moodle api. My solution in the end seems rather scrappy though,...

I want to create an API request in Postman that creates a category in Moodle. The following are the steps which I did in Moodle : 1. Enabled Web service 2...

I am using moodle 3.4 Version. My moodle is not showing Site administrator in "Add a Block".Due to which i am not able to add "Site administrato...

I am a beginner in Moodle and I wrote an algorithm in python to learn users profiles. The aim is to create a plugin that provides adaptive functionalities in th...

I want to get user role from user id. I am using loop in my code where i want to show all user except admin. i used below code but its not working. $co...

I want to know how joins are applied for **$table= set_sql();** method. I'm trying to render a table without using the conventional **html_ta...

Hi there i'm beginner in using **moodle** i want my custom website which is on ASP.net can anyone guide me that how can i add **SSO** feature for my website...

For one of my projects I need to manage some of the attributes of our Moodle, including (but probably not limited to) Creating/Updating users and managing enrol...

I want so connect an external website with a moodle-system. I've already set up the webService and created a token to get access. I've followed http:...