Installing  mySQL connector to  connect python 

with php myAdmin in Raspberry Pi .

To run mySQL with python we need to establish connection between mySQL and python in Raspberry pi. We already install mysql with php myadmin .
(if phpmyadmin is not install in your raspberrypi then visit  : https://aiworldofjuhi.blogspot.com/2019/02/how-to-install-mysql-on-raspberry-pi-3b.html ).

now, go to command prompt or terminal in raspberry pi and install bellow library.

Step 1 : $sudo apt-get update
Step 2 : $sudo apt-get upgrade
Step 3 : $sudo apt-get -y install python-mysql.connector

After installing python-mysql.connector python is ready to work with mysql. here, An example of inserting data in php myadmin using python-mysql.coonector.

Way: 1

import mysql.connector
mydb=mysql.connector.connect(host='localhost',user='raspberry',passwd='juhi',database='chanchala')
print ("working")
mycursor=mydb.cursor()
#mycursor.execute("CREATE TABLE pixs(line INTEGER(2), xcor INTEGER(5), ycor
INTEGER(5))")
sqlFormula="INSERT INTO pixs(line,xcor,ycor) VALUES(1,2,3)"
#pixs1=[(1,2,3),(5,4,7),(8,9,6)]
mycursor.execute(sqlFormula)
mydb.commit()

Way: 2

import mysql.connector
mydb=mysql.connector.connect(host='localhost',
user='hiren',passwd='hiren',database='chanchala')
print ("working")
mycursor=mydb.cursor()
#mycursor.execute("CREATE TABLE pixs(line INTEGER(2), xcor INTEGER(5), ycor
INTEGER(5))")
sqlFormula="INSERT INTO pixs(line,xcor,ycor) VALUES(%s,%s,%s)"
pixs1=[(1,2,3),(5,4,7),(8,9,5)]
mycursor.executemany(sqlFormula ,pixs1)
mydb.commit()



This picture shows how a table is created and store data one by one through python-mysql.connector.
Next blog start with computer vision system and some real time  image processing programming. 

Comments

Post a Comment

Popular posts from this blog

Image
Survey  on AI self-driving cars around the world What’s the future of personal transportation? Well, you’ll likely be spending a lot less time behind the wheel, for one. The rise of self-driving cars means that some scenes out of science-fiction flicks (movie: Total Recall  or  I, Robot ) are now reality—and even more will be available soon. What is self-drive car? Self-driving vehicles are cars or trucks in which human drivers are never required to take control to safely operate the vehicle. Also known as autonomous or “driverless” cars, they combine sensors and software to control, navigate, and drive the vehicle. An autonomous car is a vehicle that is capable of sensing its environment and navigating without human input. Autonomous cars combine a variety of techniques to perceive their surroundings, including radar, laser light, GPS, odometry, and computer vision. In August 1961, Popular Science r...
Read more

Voice Recognition Using web camera and Google API - Raspberry pi 3B (python)

Voice Recognition Using web camera and Google API - Raspberry pi 3B (python).   I am trying to find a Speech recognition library similar to PySpeech that will work on a Raspberry Pi 3. Google API is best for speech recognition because google api use hidden markov model for recognition. there are steps given below for voice recognition  Required  module: 1. Raspberry pi model 3 B 2. Logitech  Web camera 3. Rasbian os installed SD card Hidden markov Model:  - Hidden markov model is used to convert speech into text and recognized it. - In HMM, speech signal is divided into 10-millisecond fragment. - Every fragment converted into power spectrum. - Then each power spectrum converted into frequency domain. - In last each frequency domain fragment converted into vector. this each vector compare    with google speech API vector. - Dimension of these vector usually small, sometime 10. More accurate system may have   ...
Read more