【PHP】php连接mysql

最新推荐文章于 2023-03-09 23:42:00 发布

FAIRY哦

最新推荐文章于 2023-03-09 23:42:00 发布

阅读量328

点赞数 1

分类专栏： PHP 文章标签： PHP

本文链接：https://blog.csdn.net/renjingjingya0429/article/details/80260722

版权

PHP 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

<?php
class db{
//$res = mysqli_connect('localhost','root','root','bbb');
//public $connect='连接成功';
//public $sql="select user.user_name,user.pass,U_information.phonenumber,U_information.address from user inner join U_information";
//public function connect($res,$sql,$connect){
public function connect($res){
if($res){
//$res = mysqli_connect('localhost','root','root','bbb');
$sql="select user.user_name,user.pass,U_information.phonenumber,U_information.address from user inner join U_information";
$connect='连接成功';
echo $connect;
$bb=mysqli_query($res,$sql);
$arr=mysqli_fetch_assoc($bb);

echo '表中的字段信息为:';
echo '<hr/>';
var_dump($arr);
echo '<hr/>';
echo '该表各个字段的的详细信息为:';
while($arr=mysqli_fetch_assoc($bb)){
echo '<hr/>';
var_dump($arr);
}
}
else{
echo '连接失败，请重试！';
}
}
}
$obj=new db;
$res = mysqli_connect('localhost','root','root','bbb');
//$sql="select user.user_name,user.pass,U_information.phonenumber,U_information.address from user inner join U_information";
//$connect='连接成功';
//$obj->connect($res,$sql,$connect);

$obj->connect($res);

附上截图：