Lightbox Info Board : SQLの窓


<?

$conf_client_charset = "shift_jis";
$conf_common_path1 = "http://homepage2.nifty.com/lightbox/gensjis/";
$conf_common_path2 = "http://homepage2.nifty.com/lightbox/gen/";

// 1:MySQL, 2:SQLServer, 3:PostgreSQL
// 4:MDB(COM), 5:Oracle(COM/ADO), 6:Oracle(COM/OO4O)
$conf_db_type = 1;

$conf_db_host	= "localhost";
$conf_db_db	= "lightbox";
$conf_db_user	= "root"; 
$conf_db_pass	= ""; 

?>

Database : shift_jis
ソース : EUC-JP


<?

$conf_client_charset = "euc-jp";
$conf_common_path1 = "http://homepage2.nifty.com/lightbox/geneuc/";
$conf_common_path2 = "http://homepage2.nifty.com/lightbox/gen/";

// 1:MySQL, 2:SQLServer, 3:PostgreSQL
// 4:MDB(COM), 5:Oracle(COM/ADO), 6:Oracle(COM/OO4O)
$conf_db_type = 1;

$conf_db_host	= "localhost";
$conf_db_db	= "lightbox";
$conf_db_user	= "root"; 
$conf_db_pass	= ""; 

// DB class による強制変換
$conf_db_charset = 'SJIS';

?>

Database : EUC-JP
ソース : shift_jis


<?

$conf_client_charset = "shift_jis";
$conf_common_path1 = "http://homepage2.nifty.com/lightbox/gensjis/";
$conf_common_path2 = "http://homepage2.nifty.com/lightbox/gen/";

// 1:MySQL, 2:SQLServer, 3:PostgreSQL
// 4:MDB(COM), 5:Oracle(COM/ADO), 6:Oracle(COM/OO4O)
$conf_db_type = 1;

$conf_db_host	= "localhost";
$conf_db_db	= "lightbox";
$conf_db_user	= "root"; 
$conf_db_pass	= ""; 

// DB class による強制変換
$conf_db_charset = 'EUC-JP';

?>

MySQL 4.1 以降

Database : shift_jis
ソース : shift_jis


<?

$conf_client_charset = "shift_jis";
$conf_common_path1 = "http://homepage2.nifty.com/lightbox/gensjis/";
$conf_common_path2 = "http://homepage2.nifty.com/lightbox/gen/";

// 1:MySQL, 2:SQLServer, 3:PostgreSQL
// 4:MDB(COM), 5:Oracle(COM/ADO), 6:Oracle(COM/OO4O)
$conf_db_type = 1;

$conf_db_host	= "localhost";
$conf_db_db	= "lightbox";
$conf_db_user	= "root"; 
$conf_db_pass	= ""; 

// もし問題が出る場合は実行しておく
$conf_db_connect_action = "set names 'sjis'";

?>

Database : shift_jis
ソース : EUC-JP


<?

$conf_client_charset = "euc-jp";
$conf_common_path1 = "http://homepage2.nifty.com/lightbox/geneuc/";
$conf_common_path2 = "http://homepage2.nifty.com/lightbox/gen/";

// 1:MySQL, 2:SQLServer, 3:PostgreSQL
// 4:MDB(COM), 5:Oracle(COM/ADO), 6:Oracle(COM/OO4O)
$conf_db_type = 1;

$conf_db_host	= "localhost";
$conf_db_db	= "lightbox";
$conf_db_user	= "root"; 
$conf_db_pass	= ""; 

// MySQL による自動変換
$conf_db_connect_action = "set names 'ujis'";

?>

Database : EUC-JP
ソース : shift_jis


<?

$conf_client_charset = "shift_jis";
$conf_common_path1 = "http://homepage2.nifty.com/lightbox/gensjis/";
$conf_common_path2 = "http://homepage2.nifty.com/lightbox/gen/";

// 1:MySQL, 2:SQLServer, 3:PostgreSQL
// 4:MDB(COM), 5:Oracle(COM/ADO), 6:Oracle(COM/OO4O)
$conf_db_type = 1;

$conf_db_host	= "localhost";
$conf_db_db	= "lightbox";
$conf_db_user	= "root"; 
$conf_db_pass	= ""; 

// MySQL による自動変換
$conf_db_connect_action = "set names 'sjis'";

?>

SQLServer ( MSDE )　2000、2005 with php_mssql.dll

マシンID では接続できない環境もあるようです。
その場合は、IPアドレス\\インスタンス名で設定します

Database : shift_jis
ソース : shift_jis


<?

$conf_client_charset = "shift_jis";
$conf_common_path1 = "http://homepage2.nifty.com/lightbox/gensjis/";
$conf_common_path2 = "http://homepage2.nifty.com/lightbox/gen/";

// 1:MySQL, 2:SQLServer, 3:PostgreSQL
// 4:MDB(COM), 5:Oracle(COM/ADO), 6:Oracle(COM/OO4O)
$conf_db_type = 2;

$conf_db_host	= "night\\SQLEXPRESS";
$conf_db_db	= "lightbox";
$conf_db_user	= "sa"; 
$conf_db_pass	= "passwordpassword"; 

?>

Database : shift_jis
ソース : EUC-JP


<?

$conf_client_charset = "euc-jp";
$conf_common_path1 = "http://homepage2.nifty.com/lightbox/geneuc/";
$conf_common_path2 = "http://homepage2.nifty.com/lightbox/gen/";

// 1:MySQL, 2:SQLServer, 3:PostgreSQL
// 4:MDB(COM), 5:Oracle(COM/ADO), 6:Oracle(COM/OO4O)
$conf_db_type = 2;

$conf_db_host	= "night\\SQLEXPRESS";
$conf_db_db	= "lightbox";
$conf_db_user	= "sa"; 
$conf_db_pass	= "passwordpassword"; 

// DB class による強制変換
$conf_db_charset = 'SJIS';

?>