当前位置：文档之家 › PDO_BlankForm

PDO_BlankForm

  • 格式：pdf
  • 大小：383.13 KB
  • 文档页数：6

Member HSBC Group

Page 1/3 OPS089R11ETC-m (080514) FW The Hongkong and Shanghai Banking Corporation Limited (the "Bank")

*NOTICE RELATING TO THE PERSONAL DATA (PRIVACY) ORDINANCE (THE "ORDINANCE")

(a) From time to time, it is necessary for individuals to supply the Bank with data in connection with the opening or continuation of accounts and the establishment or continuation of banking facilities or provision of banking services or compliance with any laws, guidelines or requests issued by regulatory or other authorities.

(b) Failure to supply such data may result in the Bank being unable to open or continue accounts or establish or continue banking facilities or provide banking services.

(c) It is also the case that data are collected from (i) customers in the ordinary course of the continuation of the banking relationship (for example, when customers write cheques, deposit money or apply for credit), (ii) a person acting on behalf of the individual whose data are provided, and (iii) other sources (for example, information obtained from credit reference agencies). Data may also be generated or combined with other information available to the Bank or any member of the HSBC Group ("HSBC Group" means HSBC Holdings plc, its affiliates, subsidiaries, associated entities and any of their branches and offices (together or individually) and "member of the HSBC Group" has the same meaning).

(d) The purposes for which data may be used are as follows:

(i) considering applications for products and services and the daily operation of products, services and credit facilities provided to customers;

(ii) conducting credit checks (including without limitation upon an application for consumer credit (including mortgage loans) and upon periodic or special reviews of the credit which normally will take place one or more times each year);

(iii) creating and maintaining the Bank's credit and risk related models;

(iv) assisting other financial institutions to conduct credit checks and collect debts;

(v) ensuring ongoing credit worthiness of customers;

(vi) designing financial services or related products for customers' use;

(vii) marketing services, products and other subjects as described in (f) below;

(viii) determining the amount of indebtedness owed to or by customers;

(ix) collecting of amounts outstanding from customers and those providing security for customers' obligations;

(x) meeting obligations, requirements or arrangements, whether compulsory or voluntary, of the Bank or any of its branches or any member of the HSBC Group to comply with, or in connection with:

(1) any law, regulation, judgment, court order, voluntary code, sanctions regime, within or outside the Hong Kong Special Administrative Region ("Hong Kong") existing currently and in the future ("Laws");

(2) any guidelines, guidance or requests given or issued by any legal, regulatory, governmental, tax, law enforcement or other authorities, or self-regulatory or industry bodies or associations of financial services providers within or outside Hong Kong existing currently and in the future and any international guidance, internal policies or procedures;

(3) any present or future contractual or other commitment with local or foreign legal, regulatory, judicial, administrative, public or law enforcement body, or governmental, tax, revenue, monetary, securities or futures exchange, court, central bank or other authorities, or self-regulatory or industry bodies or associations of financial service providers or any of their agents with jurisdiction over all or any part of the HSBC Group (together the "Authorities" and each an "Authority") that is assumed by, imposed on or applicable to the Bank or any of its branches or any member of the HSBC Group; or

(4) any agreement or treaty between Authorities;

(xi) complying with any obligations, requirements, policies, procedures, measures or arrangements for sharing data and information within the HSBC Group and/or any other use of data and information in accordance with any programmes for compliance with sanctions or prevention or detection of money laundering, terrorist financing or other unlawful activities;

(xii) conducting any action to meet obligations of the Bank or any member of the HSBC Group to comply with Laws or international guidance or regulatory requests relating to or in connection with the detection, investigation and prevention of money laundering, terrorist financing, bribery, corruption, tax evasion, fraud, evasion of economic or trade sanctions and/or any acts or attempts to circumvent or violate any Laws relating to these matters;

合集下载

基于PDO的WEB数据库通用导入机制

基于PDO的WEB数据库通用导入机制

第１３卷第６期　重庆科技学院学报（自然科学版）　２０１１年１２月　

基于ＰＤＯ的ＷＥＢ数据库通用导入机制　

金悦奇　柏昌顺　史久旭　

（浙江国际海运职业技术学院，舟山３１６０２１）　

摘　要：为解决Ｅｘｃｅｌ等数据导人到任意类型的网站后台数据库的问题，在高职院校学生顶岗实习管理系统的设计　过程中开发了基于ＰＤＯ的数据访问方案．实现将客户端本地数据远程导人到任意类型的网站后台数据库的通用方　法。该方法适用于ＭｙＳＱＬ、ＳＱＬ　ＳＥＲＶＥＲ、Ｏｒａｃｌｅ等主流数据库。　关键词：ＰＤＯ；ＷＥＢ数据库：导人　中图分类号：ＴＰ３１１　文献标识码：Ａ　文章编号：１６７３—１９８０（２０１　１）０６—０ｌ８０—０３　

虽然目前主流数据库基本实现了ＳＱＬ标准化，　但在具体应用程序与数据库交互接口上仍有很大差　

异，通常一个应用程序的数据交互方案只适用于一　

种数据库。笔者在高职院校学生顶岗实习管理系统　的设计开发过程中，需要从大量的Ｅｘｃｅｌ工作表等　

数据源中将数据导人到网站后台数据库中．而且后　台数据库考虑到后续网站规模的升级。具体数据库　

类型也可能存在变化。所以需要设计一种通用方法　来解决从一种数据源如Ｅｘｃｅｌ导人到另一种任意数　

据库的问题。　

１　ＰＤＯ概述　

ＰＤＯ是ＰＨＰ　Ｄａｔａ　Ｏｂｊｅｅｔｓ的缩写．是ＰＨＰ编程　

中访问数据库的一个轻量级的、一致性的接口，它提　供了一个数据访问抽象层。ＰＤＯ各种主流数据库，　

都可以通过一致的函数执行查询和获取数据。ＰＤＯ　随ＰＨＰ５．１发行，在下一代的ＰＨＰ６中将默认使用　ＰＤＯ来操作数据库。其主要特点有ｌｌ　：　

编码一致性：ＰＤＯ提供了可用于各种数据库的　

统一接口，即通过ＰＤＯ编程实现的数据操作与数据　库类型无关。　灵活性：ＰＤＯ支持数据库切换。无需重新编译　

或重新配置。　

面向对象特性：ＰＤＯ可利用ＰＨＰ５的面对对象　

特性，获得更高效的数据通信能力。　高性能：ＰＤＯ采用Ｃ语言编写，与其他用ＰＨＰ　编写的解决方案相比性能更高。　

PHPPDO的扩展内容

PHPPDO的扩展内容

PHPPDO的扩展内容

PHP PDO的扩展内容

导语：PDO全称是PHP Data Object（PHP数据对象） ，是PHP连接数据库中的.一个扩展，目前得到普遍使用。下面是相关介绍，欢迎参考！

主要解决的问题是为不同的数据库提供一个统一的数据访问接口和操作层。为实现系统在跨数据库平台的开发及迁移等问题上提供了较好的解决方案。

PDO扩展中主要提供了类有：PDO、PDOStatement、PDOException和PDODrivers。今天简单学习使用了下PHP PDO，发现和原生态的PHP操作Mysql数据库非常类似，只是写法上稍有区别。

代码如下：

1

2 $db_user = "root";

3 $db_pwd = "123456";

4

5 try{

6 $pdo_conn = new PDO('mysql:host=localhost;

dbname=tourism_formal', $db_user, $db_pwd);

7 echo "mysql connect right";

8 $pdo_conn->exec("SET NAMES 'utf8'");

9 } catch(PDOException $ex){

10 echo $ex->getMessage();

11 exit();

12 }

13

14 $pdo_stmt = $pdo_conn->query('SELECT `name` FROM

`hotel`'); 15 while($row = $pdo_stmt->fetch()){

16 echo $row['name']."";

17 }

18

19 echo "-------------------";

php使用PDO方法详解

php使用PDO方法详解

php使⽤PDO⽅法详解

本⽂详细分析了php使⽤PDO⽅法。分享给⼤家供⼤家参考。具体分析如下：

PDO::exec:返回的是int类型,表⽰影响结果的条数.

复制代码 代码如下:PDOStatement::execute

返回的是boolean型,true表⽰执⾏成功,false表⽰执⾏失败,这两个通常出现在如下代码:

复制代码 代码如下:$rs0 = $pdo->exec($sql);

$pre = $pdo->prepare($sql);

$rs1 = $pre->execute();

⼀般情况下可以⽤$rs0的值判断SQL执⾏成功与否,如果其值为false表⽰SQL执⾏失败,0表⽰没有任何更改,⼤于0的值表⽰影响

了多少条记录.

但是$rs1只能返回SQL执⾏成功与否,如果需要获取影响的记录数需要使⽤$pre->rowCount();

我个⼈喜欢使⽤ MySQL,所以我的 extensions.ini 中有这⼆⾏.

复制代码 代码如下:extension=pdo.so

extension=pdo_mysql.so

接著在程式中,代码如下:

复制代码 代码如下:define('DB_NAME','test');

define('DB_USER','test');

define('DB_PASSWD','test');

define('DB_HOST','localhost');

define('DB_TYPE','mysql');

$dbh = new PDO(DB_TYPE.':host='.DB_HOST.';dbname='.DB_NAME, DB_USER, DB_PASSWD);

⽂中的使⽤常数设定是我个⼈的习惯,各位不⽤像我这么⿇烦,当像上⾯的操作,$dbh 本⾝就是代表了PDO的连线了,那要怎样使

⽤PDO呢？

第⼀种,懒⼈法 query,什么都不⽤想,像平常⼀样的使⽤ query 的函式,代码如下:

复制代码 代码如下:$sql = 'select * from test';

dw常用代码

dw常用代码

目 录

1.控制横向和纵向滚动条的显隐？ ........................................................................................ 1

12.添加到收藏夹和设为首页 .................................................................................................. 2

21.文字或图片弹出指定大小的窗口 ...................................................................................... 3

38.给表格做链接 ...................................................................................................................... 6

47.基本链接样式 ...................................................................................................................... 7

52、日期显示 ........................................................................................................................... 8

js表单验证控制代码大全 ............................................................................................................ 38