Jaribu this one
<?php
/* Connection string which i assume */
if($conn === false)
{
exit("<pre>" . print_r(sqlsrv_errors(), true) . "</pre>");
}
if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'add-entry')
{
$your variable a= $_REQUEST['formvalue a'];
$your variable b= $_REQUEST['formvalue b'];
$your variable c= $_REQUEST['formvalue c'];
$sql = "INSERT INTO entries (a, b, c) VALUES (?, ?, ?)";
$stmt = sqlsrv_query($conn, $sql, array($your variablea, $your variableb, $your variablec));
if ($stmt === false)
{
echo "<p>An error has occured.</p>";
}
else
{
echo "<p>New entry created.</p>";
}
sqlsrv_free_stmt($stmt);
}
?>
<h2>title</h2>
<form action="" method="post">
<div>
<?php
$sql = "SELECT * FROM (database).(table)";
$stmt = sqlsrv_query($conn, $sql);
if ($stmt === false)
{
print_r(sqlsrv_errors());
}
?>
<label>Project:</label> <select name="project">
<?php
while($row = sqlsrv_fetch_array($stmt))
{
echo "<option value=\"$row[id]\">$row[name]</option>";
}
sqlsrv_free_stmt($stmt);
?>
</select>
</div>
<div><label>a:</label> <input type="text" name="a" /></div>
<div><label>b:</label> <input type="text" name="b" /></div>
<div><input type="submit" value="Save" /></div>
<input type="hidden" name="action" value="add-entry" />
</form>
<?php
sqlsrv_close($conn);
?>
</body>
</html>