C#, JAVA,PHP, Programming ,Source Code: Python MySQL Search

Python MySQL Search

How To Search a Specific Record In MySQL Database Table Using Python

import mysql.connector

connection = mysql.connector.connect(
                                     host='localhost', 
                                     user='root', password='', 
                                     port='3306', 
                                     database='test_py'
                                    )
c = connection.cursor()

def searchData(user_id):

    search_query = "SELECT * FROM `users_2` WHERE `id` = "+user_id
    c.execute(search_query)
    userdata = c.fetchone()
    print(userdata)


searchData("7")    