Home  • Programming • PHP

Insert record with PHP Prepared Statement

question-create-a-mysql-stored
<?php
//create connection object
if(isset($_POST["btnSubmit"])){	
	$emp_id=$_POST["txtEmp"];	
	$revenue=$_POST["txtRevenue"];
		
	$db=new mysqli("localhost","root","","test");
	$stm=$db->stmt_init();
	$stm->prepare("insert into sales(employee_id,revenue,trans_on)values(?,?,now())");
	
	
	$stm->bind_param("sd",$emp_id,$revenue);//sd mean consecutive input as string and double datatype
	if($stm->execute()){
	 echo "Successfully Saved";
	}
	
	/*
	$emp_id='100';
	$revenue=400.00;
	$stm->bind_param("sd",$emp_id,$revenue);
	$stm->execute();
	
	$emp_id='101';
	$revenue=200.00;
	$stm->bind_param("sd",$emp_id,$revenue);
	$stm->execute();
	
	$emp_id='101';
	$revenue=300.00;
	$stm->bind_param("sd",$emp_id,$revenue);
	$stm->execute();*/
	
	$stm->close();
	$db->close();
}
?>
<form action="#" method="post">
<div>
Emp ID<br/><input type="text" name="txtEmp" />
</div>
<div>
Revenue<br/><input type="text" name="txtRevenue" />
</div>
<div>
<input type="submit" name="btnSubmit" value="Submit" />
</div>
</form>
Note:Four binding parameter datatype are: i - All Integer types d - The Double and Float types b - The BLOB types s - All other types (including string)

Comments 0


Share

Copyright © 2024. Powered by Intellect Software Ltd