php 对 mysql数据库的增,删,该,查
来源:互联网 发布:手机淘宝取消退款流程 编辑:程序博客网 时间:2024/06/07 12:55
$dbhost="localhost";
$dbuser ="admin";
$dbpass ="";
$dbname = "lch";
$conn = mysql_connect($dbhost,$dbuser,$dbpass,$dbname);
if($conn)
{
echo "connect";
}else
{
echo "11111";
}
mysql_select_db($dbname,$conn);
$sql = "insert into ";
$sql .="user(tripal_id,company_id,username,email,name,credit,parent_id,password,settle_password,lognum,last_login,new_fan_num,remember_me_num,
$select = "select * from user ";
$result = mysql_query($select) or die('select data failed cause: '.mysql_error());
print_r(mysql_fetch_array($result));
$update = "update user set email = '2@QQ.com' where id =3";
echo $update;
mysql_query($update) or die('update data failed cause: '.mysql_error());
$delete = "delete from user where id = 1";
mysql_query($delete) or die('delete data failed cause: '.mysql_error());
$dbuser ="admin";
$dbpass ="";
$dbname = "lch";
$conn = mysql_connect($dbhost,$dbuser,$dbpass,$dbname);
if($conn)
{
echo "connect";
}else
{
echo "11111";
}
mysql_select_db($dbname,$conn);
$sql = "insert into ";
$sql .="user(tripal_id,company_id,username,email,name,credit,parent_id,password,settle_password,lognum,last_login,new_fan_num,remember_me_num,
is_admin,is_bb,is_bc)";
$sql .="values('1','1','name3','1@qq.com','ling','23','0',null,null,'1','2012-10-18 16:25:39','1','1','1','1','1')";
mysql_query($sql) or die('insert data failed cause: '.mysql_error());$select = "select * from user ";
$result = mysql_query($select) or die('select data failed cause: '.mysql_error());
print_r(mysql_fetch_array($result));
$update = "update user set email = '2@QQ.com' where id =3";
echo $update;
mysql_query($update) or die('update data failed cause: '.mysql_error());
$delete = "delete from user where id = 1";
mysql_query($delete) or die('delete data failed cause: '.mysql_error());
- php 对 mysql数据库的增,删,该,查
- PHP 中对MySql 数据库的增删改查
- php对mysql的增删改查
- 对mysql数据库的增删改查
- Unity3D通过PHP对MySQL执行增、删、改、查
- ios开发-数据库网络之用php对mysql的增删改查(6)
- java链接mysql以及对数据库的增,删,改,查
- Go丨语言对MySQL数据库的增、删、改、查操作
- mysql数据库的增、删、改、查(二)---查
- 《PHP操作数据库mysql的类 完成增、删、改、查操作》
- PHP对mysql数据库的插入记录
- 使用PHP调用Mysql数据库函数封装,对数据库进行增删改查
- cmd窗口下对mysql数据库的增删改查
- Java实现对mysql数据库的增删查改
- Springboot 之 JPA对Mysql数据库的增删改查
- maven+hibernate实现对MySql数据库的增删改查
- 关于数据库的连接,以及对数据增删该查的操作的封装
- 对ACCESS数据库增,删,查,改的源码(zz)
- Maven入门学习
- opencv 中SVM + PCA 人脸识别
- 解决android导入多个第三方jar包后项目代码混淆的问题
- Select模型学习
- Common Tasks :Virtual Machine Guest Operations
- php 对 mysql数据库的增,删,该,查
- C++的替代者
- 创建计算字段 汇总数据 分组数据
- Common Tasks :Powering Off or Suspending a Virtual Machine
- 第八周最后任务—我爱你!!!
- Common Tasks :Importing a Legacy Virtual Machine
- C++的营养——swap手法
- fusionchart的简单封装
- 一个程序员的悲剧 - 前言