除php,javascript jQuery,Ajax搭配使用,實現HTML數據新增,查詢,錄入數據,連接SQL server存儲數據,給出案例源碼
时间: 2024-05-01 22:16:29 浏览: 25
以下是一个简单的HTML表单,用于添加新的数据到SQL Server数据库中:
```html
<!DOCTYPE html>
<html>
<head>
<title>Add Data to SQL Server</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script>
$(document).ready(function(){
$("#submit").click(function(){
var name = $("#name").val();
var age = $("#age").val();
var gender = $("#gender").val();
var dataString = "name=" + name + "&age=" + age + "&gender=" + gender;
$.ajax({
type: "POST",
url: "add_data.php",
data: dataString,
cache: false,
success: function(result){
alert(result);
}
});
return false;
});
});
</script>
</head>
<body>
<h1>Add Data to SQL Server</h1>
<form>
<label>Name:</label>
<input type="text" id="name" name="name"><br><br>
<label>Age:</label>
<input type="text" id="age" name="age"><br><br>
<label>Gender:</label>
<select id="gender" name="gender">
<option value="Male">Male</option>
<option value="Female">Female</option>
</select><br><br>
<input type="submit" id="submit" value="Submit">
</form>
</body>
</html>
```
在上面的代码中,我们使用了jQuery和Ajax来处理表单提交。当用户点击提交按钮时,我们从表单中获取姓名、年龄和性别,并将它们作为数据字符串发送到服务器端的PHP脚本中。
以下是add_data.php脚本的代码,用于将数据插入到SQL Server数据库中:
```php
<?php
$serverName = "localhost";
$connectionInfo = array( "Database"=>"myDatabase", "UID"=>"myUsername", "PWD"=>"myPassword");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
$name = $_POST['name'];
$age = $_POST['age'];
$gender = $_POST['gender'];
$sql = "INSERT INTO myTable (name, age, gender) VALUES (?, ?, ?)";
$params = array($name, $age, $gender);
$stmt = sqlsrv_prepare($conn, $sql, $params);
if( !$stmt ) {
echo "Error in statement preparation.\n";
die( print_r( sqlsrv_errors(), true));
}
if( sqlsrv_execute($stmt) === false ) {
echo "Error in statement execution.\n";
die( print_r( sqlsrv_errors(), true));
}
echo "Data added successfully!";
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
} else {
echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
}
?>
```
在上面的代码中,我们首先建立了与SQL Server数据库的连接,然后获取从HTML表单中提交的数据,并将其插入到指定的数据库表中。最后,我们向客户端返回一条成功消息,表示数据已成功添加到数据库中。
在实际应用中,我们需要根据实际情况修改上述代码,并使用正确的数据库连接参数和表名。