php - How to properly send HTML Link tag to database as entry? -

i have a multifile upload script converts uploaded files zip. works flawlessly.only problem have uploading data database. tried , databse still doesn't of data. 2 things: 1: want send file path within html link tag displayed link on page loading , 2: rest of data submitted on form. great. here code:

<?php  set_time_limit(0); // make sure php doesnt end script after 30 seconds ini_set('memory_limit','128m'); ini_set( 'upload_max_filesize', '100m' ); ini_set( 'post_max_size', '100m' );    $project = $_post['project']; $assignto = $_post['assignto']; $asdate = $_post['asdate'];  $chdate = $_post['chdate']; $ddate = $_post['ddate'];  $timestamp = time();  if (isset ($_post['submit']))  {      $filesarray= $_files["files"];   ($num=0; $num<count($filesarray["name"]);$num++)  {      $filename = $filesarray["name"][$num];      $tempname= $filesarray["tmp_name"][$num];       move_uploaded_file($tempname,"tmp/".$filename);  }      $archivename= $timestamp.".zip";      $filesarraynames= $_files["files"]["name"];        $zipsdir= scandir ("uploads/");      $error = false;      foreach($zipsdir $zipdirfile)      {          if($zipdirfile == $archivename)          {              $error= true ;              break;          }      }          if ($error== false)         {             $tmpdir = scandir ("tmp/");             $zip = new ziparchive;             $zip->open("uploads/".$archivename, ziparchive::create);                ($num =0; $num<count($filesarray["name"]);$num++)             {             $filename = $filesarray["name"][$num];             foreach($tmpdir $tmpdirfile)             {                     if($tmpdirfile == $filename)                     {                     $zip->addfile("tmp/".$filename);                     echo " adding: ".$filename."<br/>";                      }             }         }         $zip->close();          ($num=0; $num<count($filesarray["name"]);$num++)         {          $filename = $filesarray["name"][$num];             foreach($tmpdir $tmpdirfile)             {                     if($tmpdirfile == $filename)                     {                      unlink("tmp/".$filename);                     } }             }         }         else          {                                    echo "name exists";     }  }  $filepath= "<a href='"'http://www.amadastage.com/uploads/ '"'.$archivename.'"'>files</a>';   mysql_connect("webcontrolcenter.com","dude","usa") or die ('error:' .mysql_error()); //database connection     mysql_select_db("mediamanagement");  mysqli_query("insert demo (name, id_continent, lastvisit,cdate,ddate,email) values ('project', 'assignto','asdate','chdate','ddate')"); 

like nvanesch said use mysqli creating connection.
have put variable values quotes:

try this:

$sql = "insert demo (`name`, `id_continent`, `lastvisit`, `cdate`, `ddate`, `email`)         values ('".$project."', '".$assignto."','".$asdate."','".$chdate."','".$ddate."')"; mysqli_query($sql);