如何将数据插入数据库 [英] How do I insert data into database

问题描述

我是php的新手。我想从下拉列表中选择一个部门，然后将员工的姓名，年龄和部门插入到另一个表中。

i'm new to php. i want to select a department from dropdown selection, then insert staff's name,age and department into another table.

<div class="col">			
					<select onchange="document.myform.formVar.value=this.value">
					<?php 				
					$query = "SELECT * from mst_department "; 
					$result = mysqli_query($db, $query) or trigger_error( "Error!". mysqli_error($db));
					while($row = mysqli_fetch_array($result))	
					{
						echo"<option value='".$row[0]."'>".$row[1]."</option>";}?>
					</select>
					
					<form action="editor_staff.php" method="POST" name="myform">				
					<input type="hidden" name="new" value="1" />
					<input type="hidden" name="formVar" value="" />			
					<input type="text" name="name" required>	
					<input type="text" name="age" required>						
					<input type="submit" name="submit" value="save">					
					</form>	
</div>
<?php	 $db = mysqli_connect('localhost','root', '','multi_login');

if(isset($_POST['new']) && $_POST['new']==1)
{
$a =	$_POST['formVar'];
$b =	$_POST['name'];
$c =	$_POST['age'];
$insert= "INSERT into mst_employee (depart_id,name,age,total) VALUES ('$a', '$b', '$c', '')";
mysqli_query($db, $insert) or trigger_error( "Error!". mysqli_error($db));
header("location:editor_staff.php");			
}
 ?>	

我的尝试：



i认为问题发生在mysqli，我尝试插入数字，它正常运行，但如果我插入变量，它不起作用。

What I have tried:

i think the problem occur at mysqli , i tried insert number, it run as normal, but if i insert variable, it don't work.

推荐答案

query = SELECT * from mst_department;

query = "SELECT * from mst_department ";

result = mysqli_query（

result = mysqli_query(

db，

这篇关于如何将数据插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！