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 reported on the Aeromobile 35B, an air-cushion vehicle (ACV) that was inven
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    dimension 32 or more. - This vectors are
Read more
Image
Real Time Face Detection using Haar Cascade Algorithm and cloning detected face. Haar  Cascade is a machine learning object detection algorithm used to identify objects in an image or video and based on the concept of  ​ ​  features proposed by Paul Viola and Michael Jones in their paper "Rapid Object Detection using a Boosted Cascade of Simple Features" in 2001. It is a machine learning based approach where a cascade function is trained from a lot of positive and negative images.   It is then used to detect objects in other images. The algorithm has four stages: Haar  Feature Selection Creating    Integral Images Adaboost  Training Cascading Classifiers OpenCV comes with a trainer as well as detector. If you want to train your own classifier for any object like car, planes etc. you can use OpenCV to create one. Its full details are given here:  Cascade Classifier Training . Here we will deal with detection. OpenCV already contains many pre-tra
Read more