频道导航

• ▸ PHP
• ▸ Java
• ▸ Java SE
• ▸ Python
• ▸ C#
• ▸ C&C++
• ▸ Ruby
• ▸ VB
• ▸ asp.Net
• ▸ Go
• ▸ Perl
• ▸ netty
• ▸ Django
• ▸ Delphi
• ▸ Jsp
• ▸ .NET Core
• ▸ Spring
• ▸ Flask
• ▸ Springboot
• ▸ SpringMVC
• ▸ Lua
• ▸ Laravel
• ▸ Mybatis
• ▸ Asp
• ▸ Groovy
• ▸ ThinkPHP
• ▸ Yii
• ▸ swoole
• ▸ HTML
• ▸ HTML5
• ▸ JavaScript
• ▸ CSS
• ▸ jQuery
• ▸ Bootstrap
• ▸ Angularjs
• ▸ TypeScript
• ▸ Vue
• ▸ Dojo
• ▸ Json
• ▸ Electron
• ▸ Node.js
• ▸ extjs
• ▸ Express
• ▸ XML
• ▸ ES6
• ▸ Ajax
• ▸ Flash
• ▸ Unity
• ▸ React
• ▸ Flex
• ▸ Ant Design
• ▸ Web前端
• ▸ 微信小程序
• ▸ 微信公众号
• ▸ iOS
• ▸ Android
• ▸ Swift
• ▸ Hybrid
• ▸ Cocos2d-x
• ▸ Flutter
• ▸ Xcode
• ▸ Silverlight
• ▸ cocoa
• ▸ Cordova

• 前端之家
• PHP
• php操作mysql数据库的基本类代码

<div class="codebody" id="code82744">
<?PHP
$dbhost='localhost';
$dbuser='root';
$dbpass='123456';
$dbname='products';
$connect=MysqL_connect($dbhost,$dbuser,$dbpass);
if(!$connect) exit('数据库连接失败！');
MysqL_select_db($dbname,$connect);
MysqL_query('set names utf8');
//查询
$sql="SELECT * FROM category";
$result=MysqL_query($sql);
while($row=MysqL_fetch_array($result)){
echo $row['id'];
}
//插入
$sql="INSERT INTO category (id,name) VALUES (NULL,'".$name."')";
$result=MysqL_query($sql);
if(MysqL_affected_rows()){
echo '插入成功，插入ID为：',MysqL_insert_id();
}else{
echo '插入失败：',MysqL_error();
}
//修改
$sql="UPDATE category SET name='".$name."' WHERE id='".$id."'";
$result=MysqL_query($sql);
if(MysqL_affected_rows()){
echo '修改成功！';
}
//删除
$sql="DELETE FROM category WHERE id='".$id."'";
$result=MysqL_query($sql);
if(MysqL_affected_rows()){
echo '删除成功！';
}
//关闭连接
MysqL_close($connect);
?>