PHP MySQL 增、改、查

最新推荐文章于 2024-10-01 18:22:37 发布

澄续缘

最新推荐文章于 2024-10-01 18:22:37 发布

阅读量65

点赞数

分类专栏： MySQL 前端文章标签： php mysql android

本文链接：https://blog.csdn.net/weixuan_/article/details/132054070

版权

MySQL 同时被 2 个专栏收录

23 篇文章 0 订阅

订阅专栏

前端

23 篇文章 0 订阅

订阅专栏

文章介绍了使用PHP编写的三个函数，分别用于连接MySQL数据库执行查询（select_mysql_150）、插入数据（insert_mysql_150）和更新数据（update_mysql_150），并给出了在select.php、update.php和insert.php中的具体应用实例。

摘要由CSDN通过智能技术生成

db150.php

<?php
error_reporting(0);  // 关闭错误报告

//数据库连接参数
$db_ip="172.16.3.xxx";	//數據庫IP：
$db_port="3306";	//端口：
$db_name="xxx";	//數據庫名：
$db_user="xxx";	//用戶名：
$db_pwd="xxx";		//密碼：

// 查询数据
function select_mysql_150($db_ip, $db_port, $db_user, $db_pwd, $db_name, $sql_str){
	$conn=new mysqli($db_ip.":".$db_port, $db_user, $db_pwd, $db_name);
	if ($conn -> connect_error) {
	    printf("Connect failed: %s\n", $conn->connect_error);
		echo "172.16.3.xxx connect_fail";
	    exit();
	}
	$sql=$sql_str;
	$query = $conn->query($sql);
	$result="";
	while($row = $query->fetch_array()){
		$all_len++;
		$lie=count($row)/2;
		$result.="'";
		for($i=0; $i<$lie; $i++){
			$result.=$row[$i]."','";
		}
		if( strlen($result)>2 ){
			$result=substr($result, 0, strlen($result)-2);  //截取掉,'
		}
		$result.="<br />";
	}
	$result=substr($result, 0, strlen($result)-6);  //截取掉最后一个<br />
	$myres = 'len'.$all_len.'data'.$result;
	echo $myres;
	//释放结果集+关闭MySQL连接
	$query -> free_result();
	$conn -> close();
	return $myres;
}

// 插入数据
function insert_mysql_150($db_ip, $db_port, $db_user, $db_pwd, $db_name, $sql_str){
	// 创建连接
	$conn=new mysqli($db_ip.":".$db_port, $db_user, $db_pwd, $db_name);
	// 检测连接
	if ($conn->connect_error) {
	    // die("连接失败: " . $conn->connect_error);
		echo "172.16.3.xxx connect_fail";
		exit();
	} 
	 
	$sql = $sql_str;
	if ($conn->query($sql) === TRUE) {
	    echo "insert_success";
		$myres = "insert_success";
	} else {
	    echo "Error: " . $sql . "<br>" . $conn->error;
		$myres = "Error: " . $sql . "<br>" . $conn->error;
	}
	$conn->close();
	return $myres;
}

// 修改数据
function update_mysql_150($db_ip, $db_port, $db_user, $db_pwd, $db_name, $sql_str){
	// 创建连接
	$conn=new mysqli($db_ip.":".$db_port, $db_user, $db_pwd, $db_name);
	// 检测连接
	if ($conn->connect_error) {
	    // die("连接失败: " . $conn->connect_error);
		echo "172.16.3.xxx connect_fail";
		exit();
	} 
	 
	$sql = $sql_str;
	if ($conn->query($sql) === TRUE) {
	    echo "update_success";
		$myres = "update_success";
	} else {
	    echo "Error: " . $sql . "<br>" . $conn->error;
		$myres = "Error: " . $sql . "<br>" . $conn->error;
	}
	$conn->close();
	return $myres;
}


?>

select.php

<?php
header("content-type:text/html;charset=utf-8");         //设置编码
include "db150.php";
date_default_timezone_set('PRC');// 临时设置为中国时区

$combo_val=$_REQUEST["combo_val"];

//获取记录
$sql = "SELECT id,NAME,machine_type,stop_start_time,stop_minutes FROM oee_machine_tip 
WHERE combo=(SELECT combo_code FROM oee_stop_reason WHERE combo='$combo_val' LIMIT 1) AND emp_code='';"; 
select_mysql_150($db_ip, $db_port, $db_user, $db_pwd, $db_name, $sql);

?>

update.php

<?php
header("content-type:text/html;charset=utf-8");         //设置编码
include "db150.php";

$list_id=$_REQUEST["list_id"];
$sel_stop_type_val=$_REQUEST["sel_stop_type_val"];
$sel_stop_name_val=$_REQUEST["sel_stop_name_val"];
$man_val=$_REQUEST["man_val"];
$notes_val=$_REQUEST["notes_val"];

$sql = "UPDATE oee_machine_tip SET stop_type='$sel_stop_type_val', stop_name='$sel_stop_name_val', emp_code='$arr[1]', emp_name='$arr[2]', notes='$notes_val' 
	WHERE id='$list_id';	";
echo $list_id.' update stop_type ok res===  '.update_mysql_150($db_ip, $db_port, $db_user, $db_pwd, $db_name, $sql).'<br />';

?>

insert.php

<?php
header("content-type:text/html;charset=utf-8");         //设置编码
include "db150.php";

$physical_code_val=$_REQUEST["physical_code_val"];
$area_code_val=$_REQUEST["area_code_val"];
$asset_code_val=$_REQUEST["asset_code_val"];
$classify_code_val=$_REQUEST["classify_code_val"];
$machine_station_val=$_REQUEST["machine_station_val"];
$apply_code_val=$_REQUEST["apply_code_val"];
$my_department=$_REQUEST["my_department"];
$my_type=$_REQUEST["my_type"];

$sql = "INSERT INTO code_machine(department, combo, machine_type, machine_station, classify_code, physical_code, area_code, asset_code, apply_code, apply_name) 
VALUES('$my_department', (SELECT combo FROM machine WHERE department='$my_department' AND TYPE='$my_type' LIMIT 1), '$my_type', '$machine_station_val', '$classify_code_val', '$physical_code_val', '$area_code_val', REPLACE(REPLACE('$asset_code_val', CHAR(10), ''), CHAR(13), ''), '$apply_code_val', '$arr[2]');";
insert_mysql_150($db_ip, $db_port, $db_user, $db_pwd, $db_name, $sql);

?>