Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db = new PDO('mysql:host=localhost;
- dbname=moodle;
- charset=utf8',
- 'namapengguna',
- 'katalaluanpengguna');
- $db->exec('TRUNCATE TABLE keusahawanan');
- echo 'Truncate table finished...';
- $senarainomatrik = $db->exec('INSERT INTO
- keusahawanan(matrik,userid)
- SELECT username,id
- from mdl_user
- where id in (SELECT
- userid FROM
- `mdl_feedback_completed`
- WHERE `feedback`=19
- and timemodified > 1363326999)');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement