Moodle in English: insert data to database manually by phpmyadmin

insert data to database manually by phpmyadmin

by aiai himori - Tuesday, September 30, 2008, 7:39 PM

hello ,,

I makeing a elearning project .

I have any problems about my database.

How can I insert data to my database by phpmyadmin for make new course, quiz, user to show the page.

Once, I try to insert data to database but it's not show to the page.

Re: insert data to database manually by phpmyadmin

by Anthony Borrow - Tuesday, September 30, 2008, 10:52 PM

Aiai - When I first got started with Moodle, I did a fair amount of database manipulation and since that is my background I am still occasionally tempted to monkey with the database directly; however, I find myself increasingly hesitant to do so as I realize that it is too easy to forget to do something or to make mistakes. So I would not recommend directly adding things to the database. That being said, you may want to take a look at the mdl_course_modules table and see if adding records there for your newly created quiz will help. You will need to know the quiz module id (from mdl_modules) and the instance id from mdl_quiz and the section id from mdl_course_sections. As you see, it gets a little complex and then you may also end up dealing with mdl_role_assignments and perhaps other things that I may have overlooked. I hope this is helpful. Peace - Anthony

Average of ratings: -

Re: insert data to database manually by phpmyadmin

by aiai himori - Thursday, October 2, 2008, 2:26 PM

Anthony

ahh thank you for your help. i use moodle to be my senior project and this problems it's require of my teacher.

she'd like to add quizz, question, cours at database to show the page in moodle..

it's hard for me,,and this's important ,too

Average of ratings: -

Re: insert data to database manually by phpmyadmin

by Panji Aria - Thursday, June 20, 2013, 12:35 PM

Hi Anthony....I have the same problems with moodle database

i need to add the data manually using phpmyadmin

i need to add mdl_forum but it's not show to the page

i have no problems to add and show new course and quiz.

I found the relationship between mdl_course, mdl_forum, mdl_forum_discuss and mdl_forum_post.

but, the data not show...am i missing something ?

forgot to fill in the tables that have relationships with mdl_forum ?

I use Moodle 2.0

THX !

Average of ratings: -

Database

insert data to database manually by phpmyadmin