Question

1.1. Python function to connect to mysql server is:

1.2. Python function to access mysql tables is:

1.3. Python function to execute mysql queries is:

2.1. PHP function to connect to mysql server is:

2.2. PHP function to select mysql database is:

2.3. PHP function to execute mysql queries is:

Answer 1

Answer 1.1)

Python function to connect to mysql server. First we import mysql.connector and then uses connect() method with the required parameters to connect. See below:

import mysql.connector

connection = mysql.connector.connect(user='john', password='zxcv@4321', host='localhost', database='Student')

Answer 1.2)

To access the table from database in python we first create a cursor and then execute the query on the cursor to fetch the table. See below:

sql_query = "select * from Scores"

cursor = connection.cursor()

cursor.execute(sql_query)

records = cursor.fetchall()

Answer 1.3)

Python function to execute mysql queries is execute(sql_query).

sql_query = "select name from Scores"

cursor = connection.cursor()

cursor.execute(sql_query)

Answer 2.1)

PHP function to connect to mysql server is mysqli():

$server_name = "localhost";

$user_name = "kevin";

$password = "kevin@321";

$conn = new mysqli($server_name, $user_name, $password);

Answer 2.2)

PHP function to select mysql database is mysql_select_db(). See below:

mysql_select_db(databaseName, link_connection);