PHP oracle 数据修改
时间: 2023-10-06 11:09:10 浏览: 37
要修改 Oracle 数据库中的数据,可以使用以下步骤:
1. 连接到数据库:
```php
$conn = oci_connect('username', 'password', 'hostname/servicename');
```
2. 编写 SQL 更新语句:
```php
$sql = "UPDATE table_name SET column1=value1, column2=value2 WHERE condition";
```
3. 准备语句:
```php
$stmt = oci_parse($conn, $sql);
```
4. 绑定参数(如果有):
```php
oci_bind_by_name($stmt, ':param1', $param1);
```
5. 执行语句:
```php
oci_execute($stmt);
```
6. 关闭连接:
```php
oci_close($conn);
```
完整的示例代码:
```php
$conn = oci_connect('username', 'password', 'hostname/servicename');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$sql = "UPDATE employees SET salary=5000 WHERE department='Sales'";
$stmt = oci_parse($conn, $sql);
oci_execute($stmt);
oci_close($conn);
```
这个例子将更新"employees"表中"department"为"Sales"的行的"salary"列为5000。