Python version of PHP mysql_fetch_array

Question

I have a PHP sheet that I am trying to translate into Python. One of the functions is mysql_fetch_array. Does anyone know of a Python equivalent? As you can see, most of my code has already been translated. The exception is line 41, which is still PHP.

#send

import MySQLdb
servername = "localhost"
username = "username"
password = "password"
dbname = "some_database"
import time
today = time.strftime("%d-%m-%Y")
now = time.strftime("%H:%M:%S")

#use Django for this
field = request.GET['field']
value = request.GET['value']

conn = MySQLdb.connect(host="localhost",user="username",passwd="password",db=)
if not conn:
    print 'Could not connect: mysql_error'# . mysql_error();
#below may need editing
con_result = conn.select("some_database")
if not con_result:
    print 'Could not connect to specific database: '# . mysql_error();
datenow = today + ' ' + now
hvalue = value

sql = "INSERT INTO `DataTable`(`logdata`, `field`, `value`) VALUES (\"datenow\",\"field\",value)"
result = sql.fetchall()
if not result:
    print 'Invalid query'
print "THE DATA HAS BEEN SENT!"
conn.close()

#get
fieldToGet = request.GET['field']
sql = "SELECT * FROM `DataTable` WHERE `field` = \"fieldToGet\""
result = sql.fetchall()
if not result:
    print 'Invalid query'
print "THE DATA HAS BEEN RECEIVED!!"

while(row == mysql_fetch_array($result, MYSQL_ASSOC))

How are you connecting to MySQL? What have you investigated? Show some code, and some effort. — miken32
– miken32, Commented May 23, 2016 at 23:21

Pedro Lobito · Accepted Answer · 2016-05-23 23:34:29Z

1

The php equivalent of mysql_fetch_array in python is fetchall(), i.e.:

import MySQLdb as mdb
con = mdb.connect('localhost', 'user', 'pass', 'db');
with con:
    cur = con.cursor()
    cur.execute("SELECT * FROM `DataTable` WHERE `field` = '"+fieldToGet+"'")
    rows = cur.fetchall()
    for row in rows:
        email = row[0]
        password = row[1]

answered May 23, 2016 at 23:34

Pedro Lobito

99.8k36 gold badges274 silver badges278 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python version of PHP mysql_fetch_array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related