<?php
if(isset($_POST['Add']))
{
$nameid = $_SESSION['userid'];
$namead = $_POST['name'];
$macad = $_POST['mac'];
$Connection = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if (!$Connection)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("simplecms900", $con);
if($Connection)
{
echo "Connected";
}
$quer="INSERT INTO data"."(ID, Name, Mac)"."VALUES ($nameid, $namead, $macad)";
$state = $Connection->prepare($quer);
$state->bind_param('i', $nameid);
$state->bind_param('s', $namead);
$state->bind_param('s', $macad);
$state->execute();
$state->store_result();
if (!mysql_query($quer,$Connection))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
echo $nameid;
}
?>
Your first two problems are mixing MySQL with mysqli and spelling mistakes.