Connecting MySQL database in flask

 import MySQLdb

from flask import Flask, render_template, request
from flask_mysqldb import MySQL

app = Flask(__name__)

db = MySQLdb.connect(host="localhost", user="root", passwd="", db="testdb")
cur = db.cursor()
name = "drago"
owner = "rahul"
species = "lizard"
sql = 'INSERT INTO pet (name, owner, species) VALUES (%s, %s, %s)'
cur.execute(sql, (name, owner, species))
db.commit()

#fetchone()
#executeOne()
#fetchmany()

Comments

Post a Comment

Popular posts from this blog

maintext/ react

4)  react React makes it painless to create interactive UIs. Design simple views for each state in your application, and React will efficiently update and render just the right components when your data changes. 4.1) Component-Based Build encapsulated components that manage their own state, then compose them to make complex UIs. Since component logic is written in JavaScript instead of templates, you can easily pass rich data through your app and keep state out of the DOM. 4.2) Learn Once, Write Anywhere We don’t make assumptions about the rest of your technology stack, so you can develop new features in React without rewriting existing code. React can also render on the server using Node and power mobile apps using  React Native . 4.3) A Simple Component React components implement a  render()  method that takes input data and returns what to display. This example uses an XML-like syntax called JSX. Input data that is passed into the component can be a...
Read more

CSS-position property

  position:static; Element cannot be move from their position, that is element get fixed   position:relative; It helps move an element with respect to its original position. position:fixed: It moves the element with respect to the browser windows. The position of the element remains fixed even if we scroll the web page. The next element present after the position element takes the place of the element leaving no gap. position:absolute; It moves the element with respect to the nearest positioned ancestor element. Next element will take the gap. z-index; It is used to position an element along the z axis. It works only positioned on elements.
Read more

How to create Scroll Bar | CSS

HTML/PUG        h1  creating scrollBar       .clsScroll            p  Lorem ipsum dolor, sit amet consectetur adipisicing elit. Sapiente,                 eos quae nam sed dolore aliquam, corrupti iure quo eaque eius ipsam sit.               Lorem ipsum dolor sit amet consectetur adipisicing elit. Laborum sunt                  totam adipisci ipsam fuga exercitationem at odio autem corrupti eos,                   illum fugit accusantium quisquam perspiciatis ...
Read more