mysql插入变量

<?php
header("cache-control:no-cache,must-revalidate");  
header("Content-Type:text/html;charset=utf-8");  

set_time_limit(0);

try
{
    $dbName = "sqlsrv:Server=;Database=sjsb";
    $dbUser = "sa";
    $dbPassword = "ccflow";
    $db = new PDO($dbName, $dbUser, $dbPassword);
    if ($db)
    {
        echo "database connect succeed.<br />";
    }else{
        echo "database not connect succeed.<br />";
    }
}
catch (PDOException $e)
{
    $content = iconv("UTF-8","gbk",$e->getMessage());
    echo $content . "<br />";
}


$sql = "select  row_number() over(order by A.times desc) as  ID, B.Name as names, B.Tel,C.Name as dw,A.Longitude,A.Latitude,A.Times from  APP_Statistics   A join Port_Emp B on A.UserID=B.No   join  Port_Dept C on C.No = A.DpetID ";
$res = $db->query($sql); 


$i=0;
$con = mysql_connect("","root","root");
if (!$con){
  die('Could not connect: ' . mysql_error());
  }
  
 mysql_select_db("wgdz", $con);
 mysql_query("DELETE FROM pgm_cp_device");
 
foreach($res as $k=>$val){
      // foreach($val as $ks=>$x){
            $lon = $val['Longitude'];
$lon *= 20037508.34 / 180;
                $lon = round($lon, 6);                      
$lat = $val['Latitude'];

                $lat = log(tan((90 + $lat) * pi() / 360)) / (pi() / 180);
                $lat *= 20037508.34 / 180;
                $lat = round($lat, 7);
                $lonlat = 'POINT(' . $lon . ' ' . $lat . ')';
     $id =  $val['ID'];
$dw = $val['names'];
$names = $val['dw'];
$tel = $val['Tel'];
$times = $val['Times'];
// $names = $val['names'];
$rid = '648726';
$state = '1';
echo "<br/>";

$result=mysql_query("insertinto pgm_cp_device(id,uname,phone,rid,code,state,modifytime,lonlat) values(".$id.",'" . $dw . "','" . $tel . "','" . $rid . "','" . $names . "','" . $state . "','" . $times . "','" . $lonlat . "')");
             
     
}

$res = null;
$db = null;
mysql_close($con);
//$result = $sth->fetchAll(); 
//var_dump($result);

?>