PHP——连接数据库

PHP作为客户端连接MySQL服务器只需要三步:
(1)连接MYSQL服务器
     $conn = mysqli_connect($host,$uname,$upwd,$dbname,$port);
(2)执行SQL语句
     $sql = "INSERT/DELETE/UPDATE/SELECT ..."; //此处的SQL语句内部无需添加分号
     mysqli_query($conn,$sql);
(3)处理执行结果
     mysqli_affected_rows($conn); //获取影响的行数
     mysqli_fetch_row($result); //从结果集中读取一行
(4)(可以省略)关闭数据库连接

     mysqli_close($conn);


<?php

	$conn = mysqli_connect('localhost','root','123456','database1',3306);
	$sql = "DELETE FROM emp WHERE eid=1000";
	$result = mysqli_query($conn,$sql);

	if($result){
		echo "删除成功";
	}else{
		echo "删除失败";
	}
?>
<?php
	$did = 60;
	$dname = 'fanhua';
	$loc = 'Bei Jing';
	echo $did;
	$conn = mysqli_connect('localhost','root','','tedu',3306);
	//$sql = "INSERT INTO dept(did,dname,loc) VALUES(50,'feixing','New York')"; //可执行
	$sql = "INSERT INTO dept(did,dname,loc) VALUES('$did','$dname','$loc')";//记得加引号

	$result = mysqli_query($conn,$sql);

	if($result){
		echo "操作成功";
	}else{
		echo "操作失败";
	}
?>

--------------------------------------

<?php
	$did = $_REQUEST['did'];
	$dname = $_REQUEST['dname'];
	$loc = $_REQUEST['loc'];
	echo $did;
	$conn = mysqli_connect('localhost','root','','tedu',3306);
	//$sql = "INSERT INTO dept(did,dname,loc) VALUES(50,'feixing','New York')"; //可执行
	$sql = "INSERT INTO dept(did,dname,loc) VALUES('$did','$dname','$loc')";//记得加引号

	$result = mysqli_query($conn,$sql);

	if($result){
		echo "操作成功";
	}else{
		echo "操作失败";
	}
?>

-------------------------

建立公共文件

<?php
    //init.php
	$conn = mysqli_connect('127.0.0.1','root','','database1',3306);
	mysqli_query($conn,"SET NAMES UTF8");
?>

包含这个文件

<?php
	
	require('init.php');

	@$n = $_REQUEST['uname'] or die('uname required');
	@$p = $_REQUEST['upwd'] or die('upwd required');

	$sql = "INSERT INTO xz_user VALUES(NULL,'$n','$p')";
	$result = mysqli_query($conn,$sql);

	if($result){
		echo "操作成功";
	}else{
		echo "操作失败";
	}


?>




评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值