inserting information and image in php and mysql

by

This would combine the two inserts into one action. But I would advise against storing the images in the db. Store the path relative to your site of the image instead.

<?php
require 'db.php';
$message="";
$Error="";
if(isset($_POST['Attendee_id'])  && 
    isset($_POST['RFID_number']) &&
    isset($_POST['Attendee_Name']) &&
    isset($_POST['CourseOrDepartment']) &&
    isset($_POST['Status']) &&
    isset($_FILES['Image']['tmp_name']) &&
    $_SERVER['REQUEST_METHOD']=='POST') {

    $Attendee_id = $_POST['Attendee_id'];
    $RFID_number = $_POST['RFID_number'];
    $Attendee_Name = $_POST['Attendee_Name'];
    $CourseOrDepartment = $_POST['CourseOrDepartment'];
    $Status = $_POST['Status'];
    $image = $_FILES['Image']['tmp_name'];
    $img = file_get_contents($image);
    $sql="INSERT INTO tbl_listofregister(
        Attendee_id,
        RFID_number,
        Attendee_Name,
        CourseOrDepartment,
        Status,
        image)
    VALUES(:Attendee_id, 
        :RFID_number,
        :Attendee_Name,
        :CourseOrDepartment,
        :Status,
        :Image)";
    $statement = $connection->prepare($sql);
    if($statement->execute(
            [':Attendee_id' => $Attendee_id, 
            ':RFID_number' => $RFID_number,
            ':Attendee_Name' => $Attendee_Name,
            ':CourseOrDepartment' => $CourseOrDepartment,
            ':Status' => $Status,
            ':Image' => $img]
        )) {
        $message="DATA INSERTED SUCCESSFULLY";
    } else {
        $Error = "ID SHOULD BE UNIQUE";
    }
}
?>

More Related Contents:

  1. Save the data into a database and return another value from database using PHP
  2. Can I mix MySQL APIs in PHP?
  3. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  4. How to change mysql to mysqli?
  5. How to prevent duplicate usernames when people register?
  6. Best way to INSERT many values in mysqli?
  7. How to use mysqli prepared statements?
  8. MySQLi prepared statements error reporting [duplicate]
  9. Why is mysqli giving a “Commands out of sync” error?
  10. mysqli last insert id
  11. mysqli: can it prepare multiple queries in one statement?
  12. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  13. How to call a MySQL stored procedure from within PHP code?
  14. MySQLi count(*) always returns 1
  15. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  16. Using Mysqli bind_param with date and time columns?
  17. Using MySQLi from another class in PHP
  18. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  19. PHP PDO and MySQLi [duplicate]
  20. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  21. Can I blindly replace all mysql_ functions with mysqli_?
  22. php password_verify() hash and pass won’t match
  23. Get number of rows matched by UPDATE query with PHP mysqli
  24. How to use mysqli_query() in PHP?
  25. PHP to MySQL SSL Connections
  26. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  27. Using Prepared Statement, how I return the id of the inserted row?
  28. Which is fastest in PHP- MySQL or MySQLi?
  29. When should I close a database connection in PHP?
  30. MySqli Commands out of sync; you can’t run this command now [duplicate]

Leave a Comment