CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

09 February, 2021

Updating two tables with an inner join

 Programing Coderfunda     February 09, 2021     php     No comments   

 I am having trouble updating it. I have two tables one is employees and other is attendance.

employees table has fields as (id, employee_id, firstname, lastname, address, email, salary, creacted_on) and attendance table has fields as (id, employee_id, date, time, description). Here is my code for editing.

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
<?php
       $query = "SELECT emp.employee_id, emp.firstname, emp.lastname, att.time, att.date, att.description from attendance AS att INNER JOIN employees AS emp where att.employee_id = emp.id";
       $query_run = mysqli_query($connection, $query);
 
       if (mysqli_num_rows($query_run) > 0) {
         while ($row = mysqli_fetch_assoc($query_run)) {
       ?>
           <tr>
             <td><?php echo date('M d, Y', strtotime($row['date'])); ?></td>
             <td><?php echo $row['employee_id']; ?></td>
             <td><?php echo $row['firstname'] . ' ' . $row['lastname']; ?></td>
             <td><?php echo date('h:i A', strtotime($row['time'])); ?></td>
             <td><?php echo ($row['description']) ?></td>
             <td>
               <form action="attendance_edit.php" method="post">
                 <input type="hidden" name="edit_id" value="<?php echo $row['id']; ?>">
                 <button type="submit" name="edit_btn" class='btn btn-success btn-sm edit btn-flat'><i class='fa fa-edit'></i> Edit</button>
               </form>
             </td>
             <td>
               <form action="attendance_code.php" method="post">
                 <input type="hidden" name="deleteattendance_id" value="<?php echo $row['id']; ?>">
                 <button onclick="return  confirm('do you want to delete Y/N')" type="submit" name="deleteattendance_btn" class='btn btn-danger btn-sm delete btn-flat'><i class='fa fa-trash'></i> Delete</button>
                 </form>
                 </td>
               </tr>
 
           <?php


page edit :
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
$connection = mysqli_connect("localhost", "root", "", "project08");
           if (isset($_POST['edit_btn'])) {
               $id = $_POST['edit_id'];
               $query = "SELECT * FROM attendance WHERE id= '$id'";
               $result = mysqli_query($connection, $query);
 
               while ($row = mysqli_fetch_assoc($result))
           ?>
 
               <form action="attendance_code.php" method="POST">
 
                   <input type="hidden" name="edit_id" value="<?php echo $row['id'] ?>">
 
                   <div class="form-group">
                       <label> Date </label>
                       <input type="date" name="edit_date" value="<?php echo date('M d, Y', strtotime($row['date'])); ?>" class="form-control datepicker" placeholder="Enter Date">
                   </div>
                   <div class="form-group">
                       <label>Time</label>
                       <input type="time" name="edit_time" value="<?php echo $row['time'] ?>" class="form-control timepicker" placeholder="Enter Time">
                   </div>
                   <div class="form-group">
                       <label>Description</label>
                       <input type="text" name="edit_description" value="<?php echo $row['description'] ?>" class="form-control" placeholder="Enter Description">
                   </div>
 
                   <a href="attendance.php" class="btn btn-danger"> CANCEL </a>
                   <button type="submit" name="update_btn" class="btn btn-primary"> Update </button>
 
               </form>
           <?php


?
 
Hello.

You may want to explain the problem a bit more. You mentioned you have a trouble updating the table for what it seems, however, that was it. It may be hard for somebody to help you - there could be many troubles.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
if (isset($_POST['update_btn'])) {
    $id = $_POST['edit_id'];
    $date = $_POST['edit_date'];
    $time = $_POST['edit_time'];
    $description = $_POST['edit_description'];
 
    $query = "UPDATE attendance att JOIN employees emp ON (att.employee_id = emp.employee_id) SET date = '$date', time = '$time', description = '$description' WHERE id = '$id'";
 
    $query_run = mysqli_query($connection, $query);
 
    if ($query_run) {
        $_SESSION['status'] = "Your data is Updated";
        $_SESSION['status_code'] = "success";
        header('Location: attendance.php');
    } else {
        $_SESSION['status'] = "Your data is NOT updated";
        $_SESSION['status_code'] = "error";
        header('Location: attendance.php');
    }
}
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to XShare to Facebook

Related Posts:

  • LaraCSV – Generate CSV files from your Eloquent modelsLaraCSV is a new package from Muhammad Usman that allows you to fluently generate CSV files from your Eloquent Models.Here is a code sample to show ho… Read More
  • Laravel Language Manager Laravel Langman, created by Mohamed Said, is a GUI for managing your JSON language files in a Laravel project.Langman is installed just like any… Read More
  • Laravel Sketchpad Sketchpad is a new project, by Dave Stewart, that is an innovative live-coding, development and admin environment for your existing Laravel site… Read More
  • Interactive Make CommandThe Interactive Make Command is a new package by Laracademy that allows you to get interactive questions after running php artisan make.On the pr… Read More
  • Interactive Make Command Doorman is a Laravel package that allows you to limit access to your Laravel applications by using invite codes.Once installed you can generate … Read More
Newer Post Older Post Home

0 comments:

Post a Comment

Thanks

Meta

Popular Posts

  • Sitaare Zameen Par Full Movie Review
     Here’s a  complete Vue.js tutorial for beginners to master level , structured in a progressive and simple way. It covers all essential topi...
  • Credit card validation in laravel
      Validation rules for credit card using laravel-validation-rules/credit-card package in laravel Install package laravel-validation-rules/cr...
  • C++ in Hindi Introduction
    C ++ का परिचय C ++ एक ऑब्जेक्ट ओरिएंटेड प्रोग्रामिंग लैंग्वेज है। C ++ को Bjarne Stroustrup द्वारा विकसित किया गया था। C ++ में आने से पह...
  • Write API Integrations in Laravel and PHP Projects with Saloon
    Write API Integrations in Laravel and PHP Projects with Saloon Saloon  is a Laravel/PHP package that allows you to write your API integratio...
  • iOS 17 Force Screen Rotation not working on iPAD only
    I have followed all the links on Google and StackOverFlow, unfortunately, I could not find any reliable solution Specifically for iPad devic...

Categories

  • Ajax (26)
  • Bootstrap (30)
  • DBMS (42)
  • HTML (12)
  • HTML5 (45)
  • JavaScript (10)
  • Jquery (34)
  • Jquery UI (2)
  • JqueryUI (32)
  • Laravel (1017)
  • Laravel Tutorials (23)
  • Laravel-Question (6)
  • Magento (9)
  • Magento 2 (95)
  • MariaDB (1)
  • MySql Tutorial (2)
  • PHP-Interview-Questions (3)
  • Php Question (13)
  • Python (36)
  • RDBMS (13)
  • SQL Tutorial (79)
  • Vue.js Tutorial (69)
  • Wordpress (150)
  • Wordpress Theme (3)
  • codeigniter (108)
  • oops (4)
  • php (853)

Social Media Links

  • Follow on Twitter
  • Like on Facebook
  • Subscribe on Youtube
  • Follow on Instagram

Pages

  • Home
  • Contact Us
  • Privacy Policy
  • About us

Blog Archive

  • July (4)
  • September (100)
  • August (50)
  • July (56)
  • June (46)
  • May (59)
  • April (50)
  • March (60)
  • February (42)
  • January (53)
  • December (58)
  • November (61)
  • October (39)
  • September (36)
  • August (36)
  • July (34)
  • June (34)
  • May (36)
  • April (29)
  • March (82)
  • February (1)
  • January (8)
  • December (14)
  • November (41)
  • October (13)
  • September (5)
  • August (48)
  • July (9)
  • June (6)
  • May (119)
  • April (259)
  • March (122)
  • February (368)
  • January (33)
  • October (2)
  • July (11)
  • June (29)
  • May (25)
  • April (168)
  • March (93)
  • February (60)
  • January (28)
  • December (195)
  • November (24)
  • October (40)
  • September (55)
  • August (6)
  • July (48)
  • May (2)
  • January (2)
  • July (6)
  • June (6)
  • February (17)
  • January (69)
  • December (122)
  • November (56)
  • October (92)
  • September (76)
  • August (6)

  • Sitaare Zameen Par Full Movie Review - 7/7/2025
  • Step-by-step Vue.js Tutorial Beginner to Master - 7/7/2025
  • Tailwindcss best practices for responsive design - 7/1/2025
  • Tailwind CSS Tutorial (Beginner to Master) - 7/1/2025
  • Failed to install 'cordova-plugin-firebase': CordovaError: Uh oh - 9/21/2024

Laravel News

  • Conditional Collection Skipping with Laravel's skipWhile Method - 7/14/2025

Copyright © 2025 CoderFunda | Powered by Blogger
Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda