cnx = mysql.connector.connect(host='xxxx', user='xxxx',password='xxxx', database='xxxx')
cursor = cnx.cursor()
add_employee="insert into carobject (AreaName, Username, UnitName, Longitude, Latitude, Icon, Status, TimeUploadm) VALUES (%s,%s,%s,%s,%s,%s,%s,%s)"

#print len(j)
for i in xrange(0,len(j)):
	cursor.execute(add_employee,(str(j[i]["areaname"]),str(j[i]["user_name"]),str(j[i]["unitname"]),str(j[i]["user_name"]),str(j[i]["longitude"]),str(j[i]["latitude"]),str(j[i]["icon"]),str(j[i]["status"]),Timeupload))
	cnx.commit()