MySQL接続 PHP

<?php

//DB接続
$dbcon = mysql_connect('localhost', 'ID', 'PASSWORD');
if (!$dbcon) {
die('connect error'.mysql_error());
}

//DB選択
$db_selected = mysql_select_db('DBNAME', $dbcon);
if (!$db_selected){
die('use db error'.mysql_error());
}

//キャラセット

mysql_query('SET NAMES sjis');

//クエリ実行

$strSQL = "SELECT * FROM tbl_test";

$result = mysql_query($strSQL);

if (!$result) {
die('query error'.mysql_error());
}

//DB切断

$dbclose = mysql_close($dbcon );

if ($dbclose ){
print('close ok');
}