mysql> describe freq;
+-----------+-----------+------+-----+-----------------------------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-----------+------+-----+-------------------+---------------+
| id | int(11) | NO | PRI | NULL | auto_increment|
| fnfreq | float | YES | | NULL | |
| fnrawfreq | float | YES | | NULL | |
| ts | timestamp | NO | MUL | CURRENT_TIMESTAMP | |
| fnvolts | float | YES | | NULL | |
+-----------+-----------+------+-----+-------------------+---------------+
5 rows in set (0.00 sec)

import serial
import urllib2
from apscheduler.schedulers.background import BackgroundScheduler
cfreq = "0.0"
rfreq = 0.0
cvolts = "0.0"
rvolts = 0.0

def tick():
global rfreq
print (rfreq)
contents = urllib2.urlopen("http://10.100.1.51/freqlog/freq.php?v=" + str(rfreq) + "&volts=" + str(rvolts)).read()
print (contents)

scheduler = BackgroundScheduler()
scheduler.add_job(tick, 'interval', seconds=2)
scheduler.start()

ser = serial.Serial('/dev/ttyACM0',115200,timeout=5)
print (ser.name)
while(1):
line = ser.readline()
print (line)
ll = line.split(" ")
if (len(ll) > 4):
cfreq = ll[4]
rfreq = 0.1 * float(cfreq)
cvolts = ll[5]
rvolts = float(cvolts)

<?php
error_reporting(E_ALL);
include_once "ez_sql_core.php";
include_once "ez_sql_mysqli.php";
$db = new ezSQL_mysqli("root","something_or_other","mainsfreq","localhost");
parse_str($_SERVER['QUERY_STRING']);
$s = "insert into freq (fnfreq, fnrawfreq,fnvolts) values (".$v.",".$v.",".$volts.")";
$db->query($s);

?>