起风网1.先声明一个数据库连接的类ConnDb，将数据库连接参数设置为成员属性，连接动作设置为成员方法；
<?php
class ConnDb{
private $host;
private $username;
private $password;
private $dbname;
private $charset;
function __construct($host,$username,$password,$dbname,$charset=’utf-8′){
$this->host=$host;
$this->username=$username;
$this->password=$password;
$this->dbname=$dbname;
$this->charset=$charset;
}
public function getConnId(){
@$connId=mysql_connect($this->host,$this->username,$this->password);
@mysql_select_db($this->dbname,$connId);
@mysql_query(‘set names’.$this->charset);
return $connId;
}
}
?>
2.创建一个表单，使用POST提交；若提交成功，则包含上述的类文件，并判断是否连接数据库成功！
<html>
<head>
<title>连接数据库</title>
</head>
<body>
<table align=’center’ width=’500′ border=’1′>
<caption><h1>建立与mysql服务器的连接</h1></caption>
<form action=’table.php’ method=’post’>
<tr>
<td>服务器地址：</td>
<td><input type=’text’ name=’host’ size=’20’ value=”<?php if($_POST[‘sub1’]) {echo $_POST[‘host’];} ?>”></td>
</tr>
<tr>
<td>用户名：</td>
<td><input type=’text’ name=’username’ size=’20’ value=”<?php if($_POST[‘sub1’]) {echo $_POST[‘username’]; }?>”></td>
</tr>
<tr>
<td>密码：</td>
<td><input type=’password’ name=’password’ size=’20’ value=”<?php if($_POST[‘sub1’]) {echo $_POST[‘password’];} ?>”></td>
</tr>
<tr>
<td>数据库：</td>
<td><input type=’text’ name=’dbname’ size=’20’ value=”<?php if($_POST[‘sub1’]) {echo $_POST[‘dbname’];} ?>”></td>
</tr>
<tr>
<td>字符编码：</td>
<td><input type=’text’ name=’charset’ size=’20’ value=”<?php if($_POST[‘sub1’]) {echo $_POST[‘charset’];} ?>”></td>
</tr>
<tr>
<td align=’right’><input type=’submit’ name=’sub1′ value=’连接’></td>
<td align=’left’><input type=’reset’ name=’sub2′ value=’重置’></td>
</tr>
<tr>
<td colspan=’2′>
<?php
if(isset($_POST[‘sub1’])){
include “connect.class.php”;
$obj=new ConnDb($_POST[‘host’],$_POST[‘username’],$_POST[‘password’],$_POST[‘dbname’],$_POST[‘charset’]);
echo (!$obj->getConnId())?”数据库连接成功！”:”数据库连接失败！”;
}
?>
</td>
</tr>
</form>
</table>
</body>
</html>
原文链接：https://blog.csdn.net/living_ren/article/details/75110035
本站声明:网站内容来源于网络,如有侵权,请联系我们,我们将及时处理。
评论前必须登录！
立即登录