php mysql 连接 数据库选择 显示所有表
这里主要是讲关于在php中数据库连接与数据库选择以及显示当前数据库所有表三个实用函数,有需要的朋友可以看看。
$phps教程ql_user = "root"; $phpsql_password = "root"; $phpsql_loc = ""; $phpsql_db = ""; function phpsql_connect($location, $username, $password){ global $phpsql_loc, $phpsql_user, $phpsql_password; if($phpsql_user != $username || $phpsql_password != $password) phpsql_error("cannot access to phpsql!(wrong username/wrong password)"); define(phpsql_loc, $location); $phpsql_loc = $location; } function phpsql_select_db($db){ global $phpsql_db; define(phpsql_db, $db); $phpsql_db = $db; } function phpsql_list_table(){ global $phpsql_loc, $phpsql_db; $i = 0; if(!($handle = @opendir($phpsql_loc."/".$phpsql_db))) return 0; while(($file = readdir($handle)) !== false){ if($file != "." && $file != "..") { $table[$i ++] = $file; } } return $table; }
文章地址:http://www.phprm.com/database/36372.html
转载随意^^请带上本文地址!