exam.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Exception in Tkinter callback\n",
      "Traceback (most recent call last):\n",
      "  File \"D:\\Anaconda\\lib\\tkinter\\__init__.py\", line 1702, in __call__\n",
      "    return self.func(*args)\n",
      "  File \"<ipython-input-34-462fb0de92a2>\", line 262, in display\n",
      "    li.pop(x)\n",
      "IndexError: pop index out of range\n",
      "Exception in Tkinter callback\n",
      "Traceback (most recent call last):\n",
      "  File \"D:\\Anaconda\\lib\\tkinter\\__init__.py\", line 1702, in __call__\n",
      "    return self.func(*args)\n",
      "  File \"<ipython-input-34-462fb0de92a2>\", line 262, in display\n",
      "    li.pop(x)\n",
      "IndexError: pop index out of range\n"
     ]
    }
   ],
   "source": [
    "import tkinter as tk\n",
    "from tkinter import *\n",
    "import random\n",
    "import sqlite3 \n",
    "import time\n",
    "\n",
    "def loginPage(logdata):\n",
    "    sup.destroy()\n",
    "    global login\n",
    "    login = Tk()\n",
    "    \n",
    "    user_name = StringVar()\n",
    "    password = StringVar()\n",
    "    \n",
    "    login_canvas = Canvas(login,width=720,height=440,bg=\"#101357\")\n",
    "    login_canvas.pack()\n",
    "\n",
    "    login_frame = Frame(login_canvas,bg=\"white\")\n",
    "    login_frame.place(relwidth=0.8,relheight=0.8,relx=0.1,rely=0.1)\n",
    "\n",
    "    heading = Label(login_frame,text=\"Quiz App Login\",fg=\"black\",bg=\"white\")\n",
    "    heading.config(font=('calibri 40'))\n",
    "    heading.place(relx=0.2,rely=0.1)\n",
    "\n",
    "    #USER NAME\n",
    "    ulabel = Label(login_frame,text=\"Username\",fg='black',bg='white')\n",
    "    ulabel.place(relx=0.21,rely=0.4)\n",
    "    uname = Entry(login_frame,bg='#d3d3d3',fg='white',textvariable = user_name)\n",
    "    uname.config(width=42)\n",
    "    uname.place(relx=0.31,rely=0.4)\n",
    "\n",
    "    #PASSWORD\n",
    "    plabel = Label(login_frame,text=\"Password\",fg='black',bg='white')\n",
    "    plabel.place(relx=0.215,rely=0.5)\n",
    "    pas = Entry(login_frame,bg='#d3d3d3',fg='white',textvariable = password)\n",
    "    pas.config(width=42)\n",
    "    pas.place(relx=0.31,rely=0.5)\n",
    "\n",
    "    def check():\n",
    "        for a,b,c,d in logdata:\n",
    "            if b == uname.get() and c == pas.get():\n",
    "                menu()\n",
    "                break\n",
    "        else:\n",
    "            error = Label(login_frame,text=\"Wrong Username or Password!\",fg='black',bg='white')\n",
    "            error.place(relx=0.37,rely=0.7)\n",
    "    \n",
    "    #LOGIN BUTTON\n",
    "    log = Button(login_frame,text='Login',padx=5,pady=5,width=5,command=check)\n",
    "    log.configure(width = 15,height=1, activebackground = \"#33B5E5\", relief = FLAT)\n",
    "    log.place(relx=0.4,rely=0.6)\n",
    "    \n",
    "    \n",
    "    login.mainloop()\n",
    "\n",
    "def signUpPage():\n",
    "    root.destroy()\n",
    "    global sup\n",
    "    sup = Tk()\n",
    "    \n",
    "    fname = StringVar()\n",
    "    uname = StringVar()\n",
    "    passW = StringVar()\n",
    "    country = StringVar()\n",
    "    \n",
    "    \n",
    "    sup_canvas = Canvas(sup,width=720,height=440,bg=\"#101357\")\n",
    "    sup_canvas.pack()\n",
    "\n",
    "    sup_frame = Frame(sup_canvas,bg=\"white\")\n",
    "    sup_frame.place(relwidth=0.8,relheight=0.8,relx=0.1,rely=0.1)\n",
    "\n",
    "    heading = Label(sup_frame,text=\"Quiz App SignUp\",fg=\"black\",bg=\"white\")\n",
    "    heading.config(font=('calibri 40'))\n",
    "    heading.place(relx=0.2,rely=0.1)\n",
    "\n",
    "    #full name\n",
    "    flabel = Label(sup_frame,text=\"Full Name\",fg='black',bg='white')\n",
    "    flabel.place(relx=0.21,rely=0.4)\n",
    "    fname = Entry(sup_frame,bg='#d3d3d3',fg='white',textvariable = fname)\n",
    "    fname.config(width=42)\n",
    "    fname.place(relx=0.31,rely=0.4)\n",
    "\n",
    "    #username\n",
    "    ulabel = Label(sup_frame,text=\"Username\",fg='black',bg='white')\n",
    "    ulabel.place(relx=0.21,rely=0.5)\n",
    "    user = Entry(sup_frame,bg='#d3d3d3',fg='white',textvariable = uname)\n",
    "    user.config(width=42)\n",
    "    user.place(relx=0.31,rely=0.5)\n",
    "    \n",
    "    \n",
    "    #password\n",
    "    plabel = Label(sup_frame,text=\"Password\",fg='black',bg='white')\n",
    "    plabel.place(relx=0.215,rely=0.6)\n",
    "    pas = Entry(sup_frame,bg='#d3d3d3',fg='white',textvariable = passW)\n",
    "    pas.config(width=42)\n",
    "    pas.place(relx=0.31,rely=0.6)\n",
    "    \n",
    "    \n",
    "    \n",
    "    #country\n",
    "    clabel = Label(sup_frame,text=\"Country\",fg='black',bg='white')\n",
    "    clabel.place(relx=0.215,rely=0.7)\n",
    "    c = Entry(sup_frame,bg='#d3d3d3',fg='white',textvariable = country)\n",
    "    c.config(width=42)\n",
    "    c.place(relx=0.31,rely=0.7)\n",
    "    def addUserToDataBase():\n",
    "        \n",
    "        fullname = fname.get()\n",
    "        username = user.get()\n",
    "        password = pas.get()\n",
    "        country = c.get()\n",
    "        \n",
    "        conn = sqlite3.connect('quiz.db')\n",
    "        create = conn.cursor()\n",
    "        create.execute('CREATE TABLE IF NOT EXISTS userSignUp(FULLNAME text, USERNAME text,PASSWORD text,COUNTRY text)')\n",
    "        create.execute(\"INSERT INTO userSignUp VALUES (?,?,?,?)\",(fullname,username,password,country)) \n",
    "        conn.commit()\n",
    "        create.execute('SELECT * FROM userSignUp')\n",
    "        z=create.fetchall()\n",
    "        print(z)\n",
    "#        L2.config(text=\"Username is \"+z[0][0]+\"\\nPassword is \"+z[-1][1])\n",
    "        conn.close()\n",
    "        loginPage(z)\n",
    "    def gotoLogin():\n",
    "        conn = sqlite3.connect('quiz.db')\n",
    "        create = conn.cursor()\n",
    "        conn.commit()\n",
    "        create.execute('SELECT * FROM userSignUp')\n",
    "        z=create.fetchall()\n",
    "        loginPage(z)\n",
    "    #signup BUTTON\n",
    "    sp = Button(sup_frame,text='SignUp',padx=5,pady=5,width=5,command = addUserToDataBase)\n",
    "    sp.configure(width = 15,height=1, activebackground = \"#33B5E5\", relief = FLAT)\n",
    "    sp.place(relx=0.4,rely=0.8)\n",
    "\n",
    "    log = Button(sup_frame,text='Already have a Account?',padx=5,pady=5,width=5,command = gotoLogin,bg=\"white\")\n",
    "    log.configure(width = 16,height=1, activebackground = \"#33B5E5\", relief = FLAT)\n",
    "    log.place(relx=0.4,rely=0.9)\n",
    "\n",
    "    sup.mainloop()\n",
    "\n",
    "def menu():\n",
    "    #login.destroy()\n",
    "    global menu \n",
    "    menu = Tk()\n",
    "    \n",
    "    \n",
    "    menu_canvas = Canvas(menu,width=720,height=440,bg=\"#101357\")\n",
    "    menu_canvas.pack()\n",
    "\n",
    "    menu_frame = Frame(menu_canvas,bg=\"white\")\n",
    "    menu_frame.place(relwidth=0.8,relheight=0.8,relx=0.1,rely=0.1)\n",
    "\n",
    "    \n",
    "    \n",
    "    wel = Label(menu_canvas,text=' W E L C O M E  T O  Q U I Z  S T A T I O N ',fg=\"white\",bg=\"#101357\") \n",
    "    wel.config(font=('Broadway 22'))\n",
    "    wel.place(relx=0.1,rely=0.02)\n",
    "    \n",
    "    \n",
    "    level = Label(menu_frame,text='Select your Difficulty Level !!',bg=\"white\",font=\"calibri 18\")\n",
    "    level.place(relx=0.25,rely=0.3)\n",
    "    \n",
    "    \n",
    "    var = IntVar()\n",
    "    easy = Radiobutton(menu_frame,text='Easy',bg=\"white\",font=\"calibri 16\",value=1,variable = var)\n",
    "    easy.place(relx=0.25,rely=0.4)\n",
    "    \n",
    "    medium = Radiobutton(menu_frame,text='Medium',bg=\"white\",font=\"calibri 16\",value=2,variable = var)\n",
    "    medium.place(relx=0.25,rely=0.5)\n",
    "    \n",
    "    hard = Radiobutton(menu_frame,text='Hard',bg=\"white\",font=\"calibri 16\",value=3,variable = var)\n",
    "    hard.place(relx=0.25,rely=0.6)\n",
    "    \n",
    "    \n",
    "    menu.mainloop()\n",
    "def easy():\n",
    "    \n",
    "    global e\n",
    "    e = Tk()\n",
    "    \n",
    "    easy_canvas = Canvas(e,width=720,height=440,bg=\"#101357\")\n",
    "    easy_canvas.pack()\n",
    "\n",
    "    easy_frame = Frame(easy_canvas,bg=\"white\")\n",
    "    easy_frame.place(relwidth=0.8,relheight=0.8,relx=0.1,rely=0.1)\n",
    "\n",
    "    \n",
    "    easyQ = [\n",
    "                 [\n",
    "                     \"What will be the output of the following Python code? \\nl=[1, 0, 2, 0, 'hello', '', []] \\nlist(filter(bool, l))\",\n",
    "                     \"[1, 0, 2, ‘hello’, '', []]\",\n",
    "                     \"Error\",\n",
    "                     \"[1, 2, ‘hello’]\",\n",
    "                     \"[1, 0, 2, 0, ‘hello’, '', []]\" \n",
    "                 ] ,\n",
    "                 [\n",
    "                     \"What will be the output of the following Python expression if the value of x is 34? \\nprint(“%f”%x)\" ,\n",
    "                    \"34.00\",\n",
    "                    \"34.000000\",\n",
    "                    \"34.0000\",\n",
    "                    \"34.00000000\"\n",
    "                 ],\n",
    "                [\n",
    "                    \"What will be the value of X in the following Python expression? \\nX = 2+9*((3*12)-8)/10\" ,\n",
    "                    \"30.8\",\n",
    "                    \"27.2\",\n",
    "                    \"28.4\",\n",
    "                    \"30.0\"\n",
    "                ],\n",
    "                [\n",
    "                    \"Which of these in not a core data type?\" ,\n",
    "                    \"Tuples\",\n",
    "                    \"Dictionary\",\n",
    "                    \"Lists\",\n",
    "                    \"Class\"\n",
    "                ],\n",
    "                [\n",
    "                    \"Which of the following represents the bitwise XOR operator?\" ,\n",
    "                    \"&\",\n",
    "                    \"!\",\n",
    "                    \"^\",\n",
    "                    \"|\"\n",
    "                ]\n",
    "            ]\n",
    "    li = [0,1,2,3,4]\n",
    "    x = random.choice(li)\n",
    "        \n",
    "    ques = Label(easy_frame,text =easyQ[x][0],font=\"calibri 12\",bg=\"white\")\n",
    "    ques.place(relx=0.5,rely=0.2,anchor=CENTER)\n",
    "\n",
    "    var = StringVar()\n",
    "    a = Radiobutton(easy_frame,text=easyQ[x][1],font=\"calibri 10\",value=1,variable = var,bg=\"white\")\n",
    "    a.place(relx=0.5,rely=0.42,anchor=CENTER)\n",
    "\n",
    "    b = Radiobutton(easy_frame,text=easyQ[x][2],font=\"calibri 10\",value=2,variable = var,bg=\"white\")\n",
    "    b.place(relx=0.5,rely=0.52,anchor=CENTER)\n",
    "\n",
    "    c = Radiobutton(easy_frame,text=easyQ[x][3],font=\"calibri 10\",value=3,variable = var,bg=\"white\")\n",
    "    c.place(relx=0.5,rely=0.62,anchor=CENTER) \n",
    "\n",
    "    d = Radiobutton(easy_frame,text=easyQ[x][4],font=\"calibri 10\",value=4,variable = var,bg=\"white\")\n",
    "    d.place(relx=0.5,rely=0.72,anchor=CENTER) \n",
    "\n",
    "    def display():\n",
    "        x = random.choice(li)\n",
    "        \n",
    "        if (len(li)==0):\n",
    "            return\n",
    "       \n",
    "        ques.configure(text =easyQ[x][0])\n",
    "        \n",
    "        a.configure(text=easyQ[x][1])\n",
    "      \n",
    "        b.configure(text=easyQ[x][2])\n",
    "      \n",
    "        c.configure(text=easyQ[x][3])\n",
    "      \n",
    "        d.configure(text=easyQ[x][4])\n",
    "        \n",
    "        li.pop(x)  \n",
    "        \n",
    "        \n",
    "    display()\n",
    "    nextQuestion = Button(easy_frame,command=display,text=\"Next\")\n",
    "    nextQuestion.place(relx=0.5,rely=0.82,anchor=CENTER)\n",
    "    \n",
    "    timer = Label(e)\n",
    "    timer.place(relx=0.8,rely=0.82,anchor=CENTER)\n",
    "    try:\n",
    "        def countDown():\n",
    "            for k in range(10, 0, -1):\n",
    "                timer.configure(text=k)\n",
    "                easy_frame.update()\n",
    "                time.sleep(1)\n",
    "            timer.configure(text=\"Times up!\")\n",
    "            return (-1)\n",
    "    except:\n",
    "          pass\n",
    "    x = countDown()\n",
    "    if x == -1:\n",
    "        pass\n",
    "        #print(\"jaa na\")\n",
    "    e.mainloop()\n",
    "#def medium():\n",
    "#def difficult():\n",
    "def start():\n",
    "    global root \n",
    "    root = Tk()\n",
    "    canvas = Canvas(root,width = 720,height = 440, bg = 'yellow')\n",
    "    canvas.grid(column = 0 , row = 1)\n",
    "    img = PhotoImage(file=\"output-onlinepngtools.png\")\n",
    "    canvas.create_image(50,10,image=img,anchor=NW)\n",
    "\n",
    "    button = Button(root, text='Start',command = signUpPage) \n",
    "    button.configure(width = 102,height=2, activebackground = \"#33B5E5\", relief = RAISED)\n",
    "    button.grid(column = 0 , row = 2)\n",
    "\n",
    "    root.mainloop()\n",
    "    \n",
    "if __name__=='__main__':\n",
    "    easy()\n",
    "    #signUpPage()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('Vishal Singh', 'Vishal023', 'Vishal123', 'India'), ('Aditya Aggarwal', 'Adi786', '123456', 'India'), ('Jinendra Sahu', 'Jinu', '789456', 'India'), ('', '', '', ''), ('', '', '', ''), ('', '', '', '')]\n"
     ]
    }
   ],
   "source": [
    "conn = sqlite3.connect('quiz.db')\n",
    "create = conn.cursor()\n",
    "create.execute('SELECT * FROM userSignUp')\n",
    "z=create.fetchall()\n",
    "print(z)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}