将带有图像的数据插入数据库

Question

我想将数据和图像都插入到我的sql数据库中，但如果我填写表格并输入，则不会插入记录，也不会显示错误消息，请帮助

<!--fourth container starts here-->
<div class="urine_test_lue">
<!--fourth urinalysis-->
<div class="urine_test_label">
<label class="label">sg:</label>
</div>
<div class="urine_test_lue-main">
<div class="urine_test_lue-sub">
<div>
<abel class="label">1.000</abel> 
</div>
<div>
<input type="radio" name="urine" value="sg 1.000">
</div>
</div>

<div class="urine_sub">
<div>
<label class="label">1.005</label> 
</div>
<div>
<input type="radio" name="urine" value="sg 1.005">
</div>
</div>
<div class="urine_test_lue-sub">
<div>
<label class="label">1.010</label> 
</div>
<div>
<input type="radio" name="urine"value="sg 1.010">
</div>
</div>

<div class="urine_sub">
<div>
<label class="label">1.015</label> 
</div>
<div>
<input type="radio" name="urine" value="sg 1.015">
</div>
</div>
<div class="urine_test_lue-sub">
<div>
<label class="label">1.020</label> 
</div>
<div>
<input type="radio" name="urine" value="sg 1.020">
</div>
</div>

<div class="urine_sub">
<div>
<label class="label">1.025</label> 
</div>
<div>
<input type="radio" name="urine" value="sg 1.025">
</div>
</div>
<div class="urine_test_lue-sub">
<div>
<label class="label">1.030</label> 
</div>
<div>
<input type="radio" name="urine" value="sg 1.030">
</div>
</div>
</div>
</div>
</div>
</div>
<!-- image upload -->
<div class="system__container">
<label  class="form_label" for="name">select image files </label>
<input type="text" class="form_input" id="name" name="tittle" placeholder="enter image tittle" required>
<input type="file" name="image">
</div>
</div>
<div class="personal__data--tittle">
<h3 class="u-margin-bottom-small u-margin-top-small">
completed by
</h3>
</div>
<div class="form_group">
<label for="name2" class="form_label">Name</label>
<input type="text" class="form_input" id="name" placeholder="Name" name="personnel_name" required>

<label for="designation" class="form_label">Designation</label>

<input type="text" class="form_input" id="designation" placeholder="designation" name="designation" required>
</div>
<div>
<label for="sign" class="form_label">Signature</label>

<input type="text" class="form_input" id="sign" placeholder="signature" name="signature" required>
</div>
<div class="button_container">
<input type="submit" name="insert" value="enter record" class="submit_btn">
</div>

这是我的php代码

<?php
//database connection
$db = mysqli_select_db($con,'nesthet');
if(isset($_POST['insert']))
{   
//personal data
$name = $_POST['name'];
$gender = $_POST['gender'];
$date = $_POST['date'];
$reg_nurse = $_POST['reg_nurse'];
$current_complain = $_POST['current_complain'];
// vital
$blood_pressure = $_POST['bp'];
$temp = $_POST['temp'];
$pr = $_POST['pr'];
$rr = $_POST['rr'];
$sat_02 = $_POST['02_sat'];
// examination
$illness = $_POST['illness'];
$opt = $_POST['optional'];
$optional = implode (',',$opt);
$jaundice = $_POST['jaundice'];
$edema = $_POST['edema'];
// human system
$respiratory = $_POST['respiratory_system'];
$cardiovascular = $_POST['cardiovascular_system'];
$nervous = $_POST['internal_nervous_system'];
$gastro = $_POST['gastro_intestinal_system'];
$differential = $_POST['differential_diagnosis'];
$final = $_POST['final_diagnosis'];
$treatment = $_POST['treatment'];
$health_education = $_POST['health_education'];
//routine lab test
$rbs = $_POST['rbs'];
$fbs = $_POST['fbs'];
$hb = $_POST['hb'];
$blood_group = $_POST['b_group'];
$rdt = $_POST['rdt'];
$wbc = $_POST['wbc'];
//urinalysis
$urine = $_POST['urine'];
// image upload codes
$tittle = $_POST['tittle'];
$img = $_FILES['image']['name'];
// complete by
$personnel_name = $_POST['personnel_name'];
$designation = $_POST['designation'];
$signature = $_POST['signature'];
//sql insert query
$insert_query = ("INSERT into tbl_nursing_assessment (name , gender , date , reg_nurse , current_complain , bp , temp , pr , rr , 02_sat , illness , optional , jaundice , edema , respiratory_system , cardiovascular_system , internal_nervous_system , gastro_intestinal_system , differential_diagnosis , final_diagnosis , treatment , health_education , rbs , fbs , hb , b_group , rdt , wbc , urine , tittle , image , personnel_name , designation , signature)
VALUES ('$name' , '$gender' , '$date' , '$reg_nurse' , '$current_complain' , '$blood_pressure ' , '$temp ' , '$pr' , '$rr' , '$sat_02' , '$illness' , '$optional' , '$jaundice' , '$edema' , '$respiratory' , '$cardiovascular' , '$nervous' , '$gastro' , '$differential' , '$final' , '$treatment' , '$health_education ' , '$rbs' , '$fbs' , '$hb' , '$blood_group' , '$rdt' , '$wbc' , '$urine' , '$tittle' , '$img' , '$personnel_name' , '$designation' , '$signature')");
//run sql insert query
if(mysqli_query($con,$insert_query))
{
echo "<script> alert ('Record inserted Successfully') </script>";
}
else
{
echo "<script> alert ('Record Failed to inserted please try again') </script>";
}
}
//move_uploaded_file($_FILES['image']['tmp_name'], "uploaded_files/$img");
?>

Answer 1

您正在进行php服务器站点提交，因此需要在html中添加表单标记。然后必须在表单标签中提及动作和方法。您可以关注以下链接。

表格提交参考号：https://www.w3schools.com/tags/att_form_method.asp

文件上传参考：https://www.w3schools.com/php/php_file_upload.asp