插入语句php与mysql中的错误 [英] error in insert statement php with mysql

问题描述

哪里有错误？



此消息显示插入时出错，再次尝试

where is the error ?

this message appear " error while inserting , TRY AGAIN"

<?php
error_reporting(0);
	
	if(isset($_POST['save_mul']))
	{		
		
			$inst_name = $_POST["inst_name"];
			$inst_directorate = $_POST["directorate"];
			$inst_administration = $_POST["administration"];
			$inst_type = $_POST["type"];
			$inst_classification = $_POST["classification"];
			$full_address = $_POST["full_address"];
			$country = $_POST["country"];
			$city = $_POST["city"];
			$satate = $_POST["satate"];
			$postal_code = $_POST["postal_code"];
			$telephone = $_POST["telephone"];
			$principal = $_POST["principal"];
			$control_chairman = $_POST["control_chairman"];
			$email = $_POST["email"];
			$website = $_POST["website"];
			$inst_logo = '01';
			$sql="INSERT INTO inst_basic_info('inst_name','inst_directorate','inst_administration','inst_type','inst_classification','full_address',
			'country','city','satate','postal_code','telephone','principal','control_chairman','email','website') VALUES('".$inst_name."',
			'".$inst_directorate."','".$inst_administration."','".$inst_type."','".$inst_classification."','".$full_address."',
			'".$country."','".$city."','".$satate."','".$postal_code."','".$telephone."','".$principal."','".$control_chairman."',
			'".$email."','".$website."')";
			$sql = $dbc->query($sql);	
		if($sql)
		{
			?>
			<script>
			alert('<?php echo $total." records was inserted !!!"; ?>');
			window.location.href='../admin/index.php?pth=modules/institution&page=inst_classification';
			</script>
			<?php
		}
		else
		{
			?>
			<script>
			alert('error while inserting , TRY AGAIN');
			window.location.href='../admin/index.php?pth=modules/institution&page=inst_add';			
			</script>
			<?php
		}
		
	}
	
	?>

推荐答案

_POST [' save_mul']））
{

_POST['save_mul'])) {

inst_name =

inst_name =

_POST [ inst_name];

_POST["inst_name"];

这篇关于插入语句php与mysql中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！