php封装一个class类，实现mysql数据库的增删改查怎么 *** 做？_sql

class sqlHelper{\x0d\x0apublic $conn \x0d\x0apublic $dbname="数据库名称" \x0d\x0apublic $username="数据库用户名" \x0d\x0apublic $password="数据库密码" \x0d\x0apublic $host="localhost" \x0d\x0a//连接数据库\x0d\x0apublic function __construct(){\x0d\x0a$this->conn=mysql_connect($this->host,$this->username,$this->password) \x0d\x0aif(!$this->conn){\x0d\x0adie("连接失败".mysql_error()) \x0d\x0a}\x0d\x0amysql_select_db($this->dbname,$this->conn) \x0d\x0a}\x0d\x0a//执行查询语句\x0d\x0apublic function execute_dql($sql){ \x0d\x0a$res=mysql_query($sql,$this->conn) \x0d\x0areturn $res \x0d\x0a}\x0d\x0a//执行增填改语句\x0d\x0apublic function execute_dml($sql){\x0d\x0a$b=mysql_query($sql,$this->conn) \x0d\x0aif(!$b){\x0d\x0areturn 3 \x0d\x0a}else{\x0d\x0aif(mysql_affected_rows($this->conn)){ \x0d\x0areturn 1//表示OK\x0d\x0a}else{\x0d\x0areturn 2//表示没有行收到影响 \x0d\x0a}\x0d\x0a}\x0d\x0a}\x0d\x0a}

<?php

$con = mysql_connect("localhost:3306","root","")

if (!$con) {

die('Could not connect: ' . mysql_error())

}

mysql_select_db("test", $con)

$result = mysql_query("SELECT * FROM user")

echo "<table border='1'>

<tr>

<th>Username</th>

<th>Password</th>

</tr>"

while($row = mysql_fetch_array($result)) {

echo "<tr>"

echo "<td>" . $row['username'] . "</td>"

echo "<td>" . $row['password'] . "</td>"

echo "</tr>"

}

echo "</table>"

mysql_close($con)

从服务器中获取用户所有信息（SQL SELECT语句）并以表格形式出现

<?php

$con = mysql_connect("localhost","root","")

if (!$con) {

die('Could not connect: ' . mysql_error())

}

mysql_select_db("test", $con)

mysql_query("DELETE FROM user WHERE username = '$_POST[username]'")

mysql_close($con)

删除该用户所有信息delete.php

<?php

$con = mysql_connect("localhost:3306","root","")

if (!$con) {

die('Could not connect: ' . mysql_error())

}

mysql_select_db("test", $con)

$sql = "INSERT INTO user (username,password)

VALUES

('$_POST[username]','$_POST[password]')"

if (!mysql_query($sql,$con)) {

die('Error: ' . mysql_error())

}

echo "1 record added"

mysql_close($con)

注册一个新用户insert.php

<?php

$con = mysql_connect("localhost","root","")

if (!$con) {

die('Could not connect: ' . mysql_error())

}

mysql_select_db("test", $con)

mysql_query("UPDATE user SET password = '$_POST[password]' WHERE username = '$_POST[username]'")

mysql_close($con)

修改一个用户密码update.php

<html>

<head>

</head>

<body>

<br />

<h1>Insert:</h1>

username:<input type="name" name="username"/>

<br />

password:<input type="password" name="password"/>

</form>

<h1>Delete</h1>

username:<input type="name" name="username" />

<br />

Are you sure?<input type="submit" value="sure" />

</form>

<h1>Update</h1>

username:<input type="name" name="username"/>

<br />

You want to change your password into:<input type="password" name="password"/>

</form>

</body>

</html>

以上三个功能的提交源Operate.html

欢迎分享，转载请注明来源：内存溢出

原文地址: http://outofmemory.cn/sjk/9679834.html

php封装一个class类，实现mysql数据库的增删改查怎么 *** 做？

发表评论

评论列表（0条）