Arduino yun Joomla SQL communications.

Official Hardware Classic Yún
10

Use python script to communication mysql:

Install python-mysql

opkg update
opkg install python-mysql

nano mysql.py

#!/usr/bin/python
# -*- coding: utf-8 -*-

import _mysql
import sys

try:
    	con = _mysql.connect('192.168.0.20', 'root', 'password', 'books')
    	#con.query("SELECT VERSION()")
    	#result = con.use_result()
    	#print "MySQL version: %s" %  result.fetch_row()[0]
	con.query("INSERT INTO authors (id,name,email) VALUES(3,'python','python@yahoo.com')")
    
except _mysql.Error, e:
  
    	print "Error %d: %s" % (e.args[0], e.args[1])
    	sys.exit(1)

finally:
    
    	if con:
        		con.close()