如何使用PHP将数据插入到oracle数据库中 [英] How to insert data into oracle database using PHP
本文介绍了如何使用PHP将数据插入到oracle数据库中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨...
$ b $我试图使用php将数据插入到oracle数据库中,但是没有插入到数据库中。
它也没有显示任何错误。
当我点击提交按钮时,表格变成空白。
请帮帮我们。
我尝试过:
表格元素。
hi...
i am trying to insert data into oracle database using php but its not getting inserted into the database.
its not showing any error too.
When i click on submit button the form gets blank.
please help guys.
What I have tried:
form element.
<form action="rbi_data_entry_insert.php" method="POST">
<fieldset class="rbi_circular"><br/>
<label for="Compliance Ref NO" hidden="">Compliance Referance Number</label>
<input type="textbox" placeholder="Enter Compliance Referance Number" name="Compliance Ref NO" value="REF/" id="Compliance Ref NO" hidden=""><br/><br/>
<label for="CS Circular Ref number">CS Circular Ref number</label>
<input type="textbox" placeholder="Enter CS Circular Ref number" name="CS Circular Ref number" id="CS Circular Ref number" required=""><br/><br/>
<label for="RBI Ref Number">RBI Referance Number</label>
<input type="textbox" placeholder="RBI Ref Number" name="RBI Ref Number" id="RBI Ref Number" required=""><br/><br/>
<label for="Entry Date">Entry Date</label>
<input type="date" name="Entry Date" required=""><br/><br/>
<label for="Subject">Subject</label>
<input type="textbox" placeholder="Enter Subject" name="Subject" id="Subject" required=""><br/><br/>
<label for="Department Name">Department Name</label>
<select name="Department Name" required="">
<option value="Department Name">Department Name</option>
<option value="AFMD">ACCOUNTS AND FUND MANAGEMENT DEPARTMENT</option>
<option value="ABG">AGRICULTURAL BANKING GROUP</option>
<option value="BIAC">BIAC</option>
<option value="CS">CHAIRMANS SECRETARIATE</option>
<option value="CCBG">COMMERCIAL AND CORPORATE BANKING GROUP</option>
<option value="CBG">COMMERCIAL BANKING GROUP</option>
<option value="COMCL">COMMPLIANCE DEPARTMENT</option>
<option value="CIG">CORPORATE AND INSTITUTIONAL GROUP</option>
<option value="CRAUD">CREDIT AUDIT</option>
<option value="CMG">CREDIT MONITORING GROUP</option>
<option value="FCD">FINANCE AND CONTROL DEPARTMENT</option>
<option value="HRD">HUMAN RESOURCE DEPARTMENT</option>
<option value="ISG">INFORMATION SECURITY GROUP</option>
<option value="IAD">INSPECTION AND AUDIT DEPARTMENT</option>
<option value="IBG">INTERNATIONAL BANKING GROUP</option>
<option value="IRC">INVESTORS RELATIONS CELL</option>
<option value="KYC/AML">KYC/AML CELL</option>
<option value="LEGAL">LEGAL DEPARTMENT</option>
<option value="MIS">MANAGEMENT INFORMATION SYSTEM CELL</option>
<option value="OD">OPERATIONS DEPARTMENT</option>
<option value="PBG">PERSONAL BANKING GROUP</option>
<option value="PRCCC">PR AND CORPORATE COMMUNICATIONS CELL</option>
<option value="RMCD">RISK MANAGEMENT AND COMPLIANCE DEPARTMENT</option>
<option value="RMD">RISK MANAGEMENT DEPARTMENT</option>
<option value="SHARES">SHARES</option>
<option value="STY">STATIONERY SECTION</option>
<option value="SAMD">STRESSED ASSETS MANAGEMENT DEPARTMENT</option>
<option value="TAX CELL">TAX CELL</option>
<option value="TECHNOLOGY DEPARTMENT">TECHNOLOGY DEPARTMENT</option>
<option value="TFMD">TREASURY AND FUNDS MANAGEMENT DEPARTMENT</option>
<option value="TD">TREASURY DEPARTMENT</option>
</select><br/><br/>
<label for="RBI Due Date">RBI Due Date</label>
<input type="date" name="RBI Due Date" required=""><br/><br/>
<label for="RBI End Date">RBI End Date</label>
<input type="date" name="RBI End Date" required=""><br/><br/>
<label for="Action to be taken">Action to be taken</label>
<textarea name="Action to be taken" ROWS="5" COLS="50" id="Action to be taken" required=""> </textarea><br/><br/>
<label for="Attachment">Attachment Required</label>
Yes <input type="radio" id="chk" name="Attachment" value="Yes" checked="checked" required="">
No <input type="radio" name="Attachment" value="No" required=""><br/><br/>
<label for="Upload" id="upload">Upload your Attachment:</label>
<form id="upload_form" method="POST" enctype="multipart/form-data">
<input type="file" id="file" name="file">
<button type="upload" id="btn" value="Upload" name="upload" onclick="">Upload</button>
</form>
<br><br>
<center>
<input type="submit" name="submit" value="SUBMIT"/>
<input type="reset" name="reset" value="RESET" onclick="reload()"><br/><br/>
</center>
</fieldset>
</form>
后端服务器端编码。
back end server side coding.
<?php
if (isset($_POST['submit']))
{
include 'includes/db_connection.php';
if (!$conn)
{
$e = oci_error();
//For oci_connect errors pass to handle
echo "Database connection failed. <br>";
echo htmlentities($e['message']);
}
else
{
//Getting user provided database
$cs_ref_no = $_POST['CS Circular Ref number'];
$rbi_ref_no = $_POST['RBI Ref Number'];
$entry_date = $_POST['Entry Date'];
$sub = $_POST['Subject'];
$dept_name = $_POST['Department Name'];
$rbi_due_date = $_POST['RBI Due Date'];
$rbi_end_date = $_POST['RBI End Date'];
$action = $_POST['Action to be taken'];
$attach = $_POST['Attachment'];
/* //checking for error handlers
if (empty($cs_ref_no) || empty($rbi_ref_no) || empty($entry_date) || empty($sub) || empty($dept_name) || empty($rbi_due_date) || empty($rbi_end_date) || empty($action) || empty($attach))
{
header('location: data_entry.php?fields=empty');
exit();
}
else
{
*/
//preparing sql statement to insert data into the database
/* $sql = 'insert into rbi_data_entry (COMP_REF_NO,CS_REF_NUMBER,RBI_REF_NUMBER,ENTRY_DATE,SUBJECT,DEPARTMENT_NAME,RBI_DUE_DATE, RBI_END_DATE,ACTION_TO_BE_TAKEN,ATTACHMENT) values(data_entry_insert.nextval, :cs, :rbi, :entry, ":sub", ":dept", :rbi_due, :rbi_end, ":action", ":attach")';
*/ //To avoid sql injection we have to check the data for any malecious content in the user provided information
$compile = oci_parse($conn, 'insert into rbi_data_entry (COMP_REF_NO,CS_REF_NUMBER,RBI_REF_NUMBER,ENTRY_DATE,SUBJECT,DEPARTMENT_NAME,RBI_DUE_DATE, RBI_END_DATE,ACTION_TO_BE_TAKEN,ATTACHMENT)'. 'values(data_entry_insert.nextval, :cs, :rbi, :entry, :sub, :dept, :rbi_due, :rbi_end, :action, :attach)');
//providing the actual value to the placholder's after checking the user provided data
oci_bind_by_name($compile, ":cs", $cs_ref_no);
oci_bind_by_name($compile, ":rbi", $rbi_ref_no);
oci_bind_by_name($compile, ":entry", $entry_date);
oci_bind_by_name($compile, ":sub", $sub);
oci_bind_by_name($compile, ":dept", $dept_name);
oci_bind_by_name($compile, ":rbi_due", $rbi_due_date);
oci_bind_by_name($compile, ":rbi_end", $rbi_end_date);
oci_bind_by_name($compile, ":action", $action);
oci_bind_by_name($compile, ":attach", $attach);
//executing the statement
$result = oci_execute($compile, OCI_DEFAULT);
//Checking weather the data has been inserted or not
$row = oci_fetch_array($compile);
if($result > 0)
{
echo '<h1 align="center" color="#008000">DATA INSERTED SUCCESSFULLY</h1>';
oci_commit($conn);
oci_free_statement($compile);
oci_close($conn);
header('location: data_entry.php');
exit();
}
else
{
echo '<h1 align="center" color="red">Something went wrong please try again</h1>';
oci_rollback($conn);
oci_free_statement($compile);
oci_close($conn);
header('location: data_entry.php');
exit();
}
}
}
else
{
header('location: data_entry.php');
exit();
}
?>
推荐答案
_POST ['submit']))
{
包括'includes / db_connection.php';
if(!
_POST['submit'])) { include 'includes/db_connection.php'; if (!
conn)
{
conn) {
e = oci_error();
//对于oci_connect错误传递给处理
echo数据库连接失败。< br>;
echo htmlentities(
e = oci_error(); //For oci_connect errors pass to handle echo "Database connection failed. <br>"; echo htmlentities(
这篇关于如何使用PHP将数据插入到oracle数据库中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文