1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
<?php
use Registry;
define("LIMIT", 50); // number of random records to make
function lorem_md() {
// create curl resource
$ch = curl_init();
// set url
curl_setopt($ch, CURLOPT_URL, "https://jaspervdj.be/lorem-markdownum/markdown.txt");
//return the transfer as a string
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
// $output contains the output string
$output = curl_exec($ch);
$title = substr($output, 2, strpos( $output, "\n" )-1);
$body = trim(substr($output, strpos( $output, "\n" )+1));
$intro = str_replace("\n", " ", (substr($body, 3, strpos( $body, "\n" )-2) . $title));
// close curl resource to free up system resources
curl_close($ch);
return [
'title' => $title,
'intro' => $intro,
'body' => $body
];
}
$rand_content = lorem_md();
for ($i=0; $i < LIMIT ; $i++) {
$rand_content = lorem_md();
$id = Registry::use('database')->query(
"INSERT INTO lesson (title, course_id, intro, `body`, `status`)
VALUES (:title, :courseid, :intro, :body, :status)",
[
':title' => $rand_content['title'],
':courseid' => rand(3,11),
':intro' => $rand_content['intro'],
':body' => $rand_content['body'],
'status' => rand(0,1)
]
)->lastInsertID();
Registry::use('database')->runQuery(
"INSERT INTO lesson_privilege (lesson_id, privilege_id)
VALUES (:lesson_id, :privilege_id)",
[
':lesson_id' => $id,
':privilege_id' => rand(1,2)
]
);
}
?>
done!
|
