i'm new php , mysql. have created form accepts inputs user , want inputs inserted mysql using stored procedure.
hurray got this, form data inserting mysql using stored procedure.
dbconn.php
<?php // set connection variables. $host = "localhost"; $user = "root"; $pwd = "root"; $db = "eservice"; // connect mysql server $mysqli = new mysqli($host,$user,$pwd,$db); /* check if error occured */ if (mysqli_connect_errno()) { echo "failed connect mysql : " . mysqli_connect_error(); exit; } ?> add.php
<?php // if form submitted. if($_post) { // connect db. include 'dbconn.php'; // retrieve data form. $srn = $_post['srn']; $client = $_post['client']; $type = $_post['type']; $fy = $_post['fy']; $category = $_post['category']; $sd = $_post['sd']; $fd = $_post['fd']; $assignto = $_post['assignto']; $edoc = $_post['edoc']; $current = date('m/d/y'); $date = strtotime("+".$edoc." days", strtotime($current)); $ecd = date("y/m/d", $date); $reviewed = $_post['reviewed']; $path = $_post['path']; // stored procedure code if(!$mysqli->query("drop procedure if exists addproc") || !$mysqli->query("create procedure addproc (in client varchar(50), in type varchar(30), in fy int, in category varchar(30), in sd varchar(80), in fd varchar(80), in assignto varchar(50), in edoc date, in reviewed varchar(40), in upload varchar(100)) begin insert main(client, type, fy, category, sd, fd, assignto, edoc, reviewed, upload) values(client, type, fy, category, sd, fd, assignto, edoc, reviewed, upload); end; ")) { echo "stored procedure creation failed : (" .$mysqli->errno .") " .$mysqli->error; } if(!$mysqli->query("call addproc('$client','$type','$fy','$category','$sd','$fd','$assignto','$ecd','$reviewed','$path')")) { echo "call failed : (" .$mysqli->errno .")" .$mysqli->error; } else { ?> <script language="javascript"> alert("task created successfully" + "\n\n" + " <?php echo "service request number : " .$srn ?>"); top.location.href = "home.php"; // page redirection. </script> <?php } if(!$res = $mysqli->query("select * main")) { echo "select failed : (" .$mysqli->errno .")" .$mysqli->error; } } ?>
$query = "insert main(client, type, fy, category, sd, fd, assignto, edoc, reviewed, upload) values('$client', '$type', '$fy', '$category', '$sd', '$fd', '$assignto', '$edoc', '$reviewed', '$upload')"; if(mysqli_query($mysqli,$query)) & others.
Comments
Post a Comment