连接数据库:使用面向对象的方法;1.造一个Mysqli对象,造连接对象2.准备一条sql语句3.执行SQL语句,如果是查询语句。成功返回结果及对象4.从结果集
<?= mysqli("localhost","root","12345678","heiheihei" = "select * from student" = ->query((
= ->
(?>
最后的返回值是一个集对象,为了方便清晰的看到结果 我们用到了fetch_all(),fetch_row(); fetch_object();
//造连接对象$db = new MySQLi("localhost","root","12345678","heiheihei");//准备SQL语句$sql = "insert into cou values('3-111','嘿嘿','803')"; //执行SQL语句$r = $db ->query($sql);if($r)//如果$r是ture{ echo "执行成功";
}else { echo "执行失败";
}
<?PHP//造连接对象$db = new MySQLi("localhost","root","12345678","heiheihei");//准备SQL语句$sql = "update cou set cname='哈哈' where tno='803'"; //执行SQL语句$r = $db ->query($sql);if($r)
{ echo "执行成功";
}else { echo "执行失败";
}?>
<?php//造连接对象$db = new MySQLi("localhost","root","12345678","heiheihei");//准备SQL语句$sql = "delete from cou where tno='803'"; //执行SQL语句$r = $db ->query($sql);if($r)
{ echo "执行成功";
}else { echo "执行失败";
}?>
--结束END--
本文标题: php连接mysql数据库
本文链接: https://www.lsjlt.com/news/43016.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-19
2024-04-19
2024-04-19
2024-04-19
2024-04-19
2024-04-19
2024-04-19
2024-04-19
2024-04-19
2024-04-19
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0