我想把上面读取数据库的部分内容封装成一个函数,在别的文件中调用,读取出返回的内容可,这个要怎么写呢?
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "cs";
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
echo "连接成功<br>";
}
catch(PDOException $e)
{
echo $e->getMessage();
}$conn->query("set character set 'utf8'");
$stmt = $conn->prepare("SELECT * FROM login where uname=? and upass=?"); $uname='张三';
$upass='123456';
$stmt->execute(array($uname,$upass));
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
echo "用户名:".$row['uname']."<br />";
echo "密码:".$row['upass']."<br />";
echo "日期:".$row['lrdate']."<br /><br />";
}
echo $stmt->rowCount().'条<br>';
$conn = null; ?>
function connect($servername, $username, $password, $dbname){
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
echo "连接成功<br>";
return $conn;
}
catch(PDOException $e)
{
echo $e->getMessage();
}
}function query($conn, $uname, $upass){
$conn->query("set character set 'utf8'");
$stmt = $conn->prepare("SELECT * FROM login where uname=? and upass=?");
$stmt->execute(array($uname,$upass));
while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
echo "用户名:".$row['uname']."<br />";
echo "密码:".$row['upass']."<br />";
echo "日期:".$row['lrdate']."<br /><br />";
}
echo $stmt->rowCount().'条<br>';
}$servername = "localhost";
$username = "root";
$password = "";
$dbname = "cs";$conn = connect($servername, $username, $password, $dbname);
$uname='张三';
$upass='123456';
query($conn, $uname, $upass);
$conn = null;