HTML button not sending SQL query to database

Question

I'm trying to send a SQL command from a HTML button to copy contents of one table into another table, then delete the those contents from the original table. My SQL works if I run through PHPMyAdmin, but not from the button click. How do I get the button to process the query?

<?php include("datagrid/dataconfig.php"); ?>
<form action="Daily-Activity-Log.php" method="POST">
    <button type="submit" style="float:right;" class="btn btn-outline-success" name="dgrefresh"  onclick="refresh()"><span class="glyphicon glyphicon-refresh"></span></button>
</form>

<?php
    $con = mysqli_connect("localhost", "root", "");

    //REFRESH
        if(isset($_POST['dgrefresh'])){
            $refreshquery = "INSERT INTO `activityarchive` SELECT * FROM `activity` WHERE ActivityCompleted='1';
                                DELETE FROM `activity` WHERE ActivityCompleted='1'";

                $query_run = mysqli_query($con, $refreshquery);
                /*DEBUG MODE*/
                if($query_run)
              {
                echo '<script> alert("Data Saved"); </script>';
                header('Location: Daily-Activity-Log.php');
              }
              else {
                echo '<script> alert("Data not Saved"); </script>';
              }
            }
     ?>

<!-- REFRESH Script -->
<script>
  function refresh(){
    location.reload();
  }
</script>

Thank you Dharman for the link. I used the mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); command and found out that it wasn't completely talking to the DB. Once I added that it worked as expected.

The name of your actual php script is Daily-Activity-Log.php, isn't it ? — LBS, Mar 26 '20 at 05:31
It only purpose is to update the datagrid when the SQL query is ran. — Zeddicus, Mar 26 '20 at 06:18
When you'll click on your *input* type submit, all the page will be refreshed. — LBS, Mar 26 '20 at 06:21
Thank you Dharman for the link. I used the mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); command and found out that it wasn't completely talking to the DB. Once I added that it worked as expected. — Zeddicus, Mar 29 '20 at 01:13

LBS · Answer 1 · 2020-03-26T06:02:19.060

0

Replace your <button type="submit"> by an <input type="submit">

and delete onclick="refresh()".

edited Mar 26 '20 at 06:02

answered Mar 26 '20 at 05:06

LBS

518
8
17

I replaced the button with input, with the same result. – Zeddicus Mar 26 '20 at 05:22

score 0 · Answer 2 · answered Mar 26 '20 at 05:08

0

Write two separate queries and execute them.

<?php
    $con = mysqli_connect("localhost", "root", "");
    //REFRESH
    if(isset($_POST['dgrefresh'])){
    $refreshquery = "INSERT INTO `activityarchive` SELECT * FROM `activity` WHERE ActivityCompleted='1';";
    $deleteData = "DELETE FROM `activity` WHERE ActivityCompleted='1'";

    $query_run = mysqli_query($con, $refreshquery);
    mysqli_query($con, $deleteData); //Execute delete query here
    /*DEBUG MODE*/
    if($query_run){
        echo '<script> alert("Data Saved"); </script>';
        header('Location: Daily-Activity-Log.php');
    }
    else{
        echo '<script> alert("Data not Saved"); </script>';
    }
}
?>

answered Mar 26 '20 at 05:08

Talk2Nit

1,115
3
22
38

I split the queries into two separate ones, still with the same result. – Zeddicus Mar 26 '20 at 05:22
What is the name of php file, you have written this code? – Talk2Nit Mar 26 '20 at 05:46
Daily-Activity-Log.php. Everything is written in the same page. – Zeddicus Mar 26 '20 at 05:59

score 0 · Answer 3 · edited Mar 26 '20 at 19:09

0

First, PHP is a backend language. To execute you script, you've to point the action form attrib to the same page.

E.g:

//index.php
<form action="index.php">
...

So when your browser (ok, i mean server side ) a post request, it will execute your mysql query.

edited Mar 26 '20 at 19:09

Dharman

30,962
25
85
135

answered Mar 26 '20 at 06:10

juliangorge

36
9

Everything is on Daily-Activity-Log.php, (form & php script). – Zeddicus Mar 26 '20 at 06:16

HTML button not sending SQL query to database

3 Answers3