Hello. I'm doing a website in php and I'm using DB2.
PHP Code:
class connectPDO{
private $database,$user,$password,$hostname,$port;
function __construct() {
$this->database = 'db';
$this->user = 'user';
$this->password = 'pass';
$this->hostname = 'localhost';
$this->port = 50000;
}
public function connect() {
try{
$conn_string='ibm:DRIVER={IBM*DB2*ODBC*DRIVER};HOSTNAME='.$this->hostname.';PORT='.$this->port.';DATABASE='.$this->database.';PROTOCOL=TCPIP;UID='.$this->user.';PWD='.$this->password;
$pdo=new PDO($conn_string);
return $pdo;
}catch(PDOException $err){
print ("Error:".$err->getMessage());
}
}
}
PHP Code:
$ObPdo = new connectPDO();
$pdo = $ObPdo->connect();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql='CALL infoForm(:str)';
$stmt = $pdo->prepare($sql);
$str='name';
$stmt->bindParam(':str', $str, PDO::PARAM_STR);
$stmt->execute();
if( $stmt ){
$result=$stmt->fetchAll(PDO::FETCH_COLUMN);
$tab=count($result);
$newstring='<select name="'.$str.'">';
for($i=0; $i<$tab ; $i++) {
$newstring.='<option value="'.$i.'">'.$tab[$i].'</option>';
}
$newstring.='</select>';
return $newstring;
This query return bad string because I'm using /// content="text/html; charset=iso-8859-2" /// so how to change connecting/query (some examples) with base db2.
To connecting with MySql I using
PHP Code:
mysql_query("set character_set_connection = latin2");
dBforums
>
codepage iso-8859-2 DB2 -> php
05-11-09, 15:15
Linear Mode
