SQLite CRUD
Fayl:
php_tizim/test_bank.db
Qidir
CSV eksport
Jadval:
yasalgan_savol
10 ustun · 603 satr
Yangi yozuv
Sahifada:
Saralash:
—
id
kod
tartib
savol_id
savol_html
variantlar_json
togri_harf
papka_nomi
description_html
description_ustun
O'suvchi
Kamayuvchi
Qo'llash
Yozuvni tahrirlash
id
INTEGER · PK
kod
INTEGER
tartib
INTEGER
savol_id
INTEGER
savol_html
TEXT
<span style="font-size:10pt"><b>Choose the correct answer.</b></span><span style="font-size:10pt">Laziza</span><span style="font-size:10pt"> can come by </span><span style="font-size:10pt">tomorrow, . . . ?</span>
variantlar_json
TEXT
[{"harf":"A","html":"<span style=\"font-size:10pt\">can<\/span><span style=\"font-size:10pt\"> she <\/span>"},{"harf":"B","html":"<span style=\"font-size:10pt\">can’t<\/span><span style=\"font-size:10pt\"> she<\/span>"},{"harf":"C","html":"<span style=\"font-size:10pt\">could<\/span><span style=\"font-size:10pt\"> she<\/span>"},{"harf":"D","html":"<span style=\"font-size:10pt\">couldn’t<\/span><span style=\"font-size:10pt\"> she <\/span>"}]
togri_harf
TEXT
A
papka_nomi
TEXT
fizika.docx
description_html
TEXT
<span style="font-size:10pt">Did you know that much of your body is made up of water? If you didn’t have water to drink, you would die. Plants and animals must have water, too. Water doesn’t have a smell, and it doesn’t </span><span style="font-size:10pt">have a</span><span style="font-size:10pt"> taste. But we need it because it helps us to be strong. It helps plants to grow, too. We can find water in many forms. It is in clouds and rain. It is in ice and glaciers. It is in oceans and rivers and lakes. But there are many people on the earth, and some of them don’t have much water. It is good to save water. Turn off the tap water when you wash dishes or brush your teeth. Don’t leave the hose running. This way, everyone can enjoy a drink of water.</span>
description_ustun
INTEGER
Saqlash
Bekor qilish