易截截图软件、单文件、免安装、纯绿色、仅160KB

PHP连接Oracle并分页访问

使用的是ADODB库,需要有OCI8库.
<?php

//require("adodb5/adodb-exceptions.inc.php");
require("adodb5/adodb.inc.php");
$conn = NewADOConnection("oci8");
$conn->Connect($url, $user, $password, $service_name);
$rs;
try {
$rs = $conn->Execute("SELECT * from (SELECT rownum r,ima_file.* from ima_file) s WHERE s.r >= 9000 AND s.r <= 10000");
} catch(exception $e) {
print_r($e);
}

$i = 0;
echo "<table border=1><caption>IMA_FILE</caption><thead><td>计数</td><td>行数</td><td>料件号</td><td>品名</td><td>规格</td></thead>";
foreach($rs as $row) {
echo "<tr><td>" . ++$i . "</td><td>$row[0]</td><td>{$row[1]}</td><td>{$row[2]}</td><td>{$row[3]}</td></tr>";
}
echo "</table>";
?>


相关文档:

Oracle 10G 数据库文件目录结构

Oracle 10G 数据库文件目录结构 
在Oracle Database 10g中,Oracle的目录结构是由Oracle_Base及其子目录Oracle_Home、admin、flash_recovery_area和oradata目录构成的。为方便讨论,用Oracle_Base代表Oracle目录树的根,用Oracle_Home表示根目录下的主目录。
1.Oracle_Base目录
Oracle_Base代表Oracle目录树的根。 ......

PHP 批量删除数据的方法

 HTML代码
<form action="" method="post">
<input name="ID_Dele[]" type="checkbox" id="ID_Dele[]" value="1"/>
<input name="ID_Dele[]" type="checkbox" id="ID_Dele[]" value="2"/>
<input name="ID_Dele[]" type="checkbox" id="ID_Dele[]" value="3"/>
<input name="ID_D ......

php 访问控制

 <?php
// An array of allowed users and their passwords
$users = array(
'harryf' => 'secret',
'tom' => 'mypwd'
);
// If there's no Authentication header, exit
if (!isset($_SERVER['PHP_AUTH_USER'])) {
header('HTTP/1.1 401 Unauthorized');
header('WWW-Authenticate: Basic real ......

PHP框架CodeIgniter的数据库操作整理


1.
$query = $this->db->query('SELECT name, title, email from my_table');
foreach ($query->result() as $row)
{
    echo $row->title;
    echo $row->name;
    echo $row->email;
}
2.
foreach ($query->result_array() as $row)
{ ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号