时间戳

首页 > 解决方案 > 将带有图像的数据插入数据库

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

问题描述

我想将数据和图像都插入到我的 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");

?>

标签： phphtml

解决方案

你正在做 php 服务器站点提交，所以你需要在你的 html 中添加表单标签。然后必须在表单标签中提及动作和方法。您可以点击以下链接。

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

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

推荐阅读