Truncate table mysql php providing error

Question

I am receiving this error "Parse error: syntax error, unexpected 'TABLE' (T_STRING)" when trying to truncate a table before more data is entered.

    <?php
      $servername = "localhost";
      $username = "root";
      $password = "";
      $dbname = "members";

      // Create connection
      $conn = mysqli_connect($servername, $username, $password, $dbname);
      // Check connection
      if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
      }

      TRUNCATE TABLE users;

      {
        header ("Location: order.php");
        exit;
      }

       mysqli_close($conn);
     ?>

Write your query inside [mysqli_query](http://php.net/manual/en/mysqli.query.php) — Saty, Jul 19 '16 at 07:45

score 4 · Answer 1 · answered Jul 19 '16 at 07:46

You can't just put MySQL queries in plain text in PHP. Write it as a string inside mysqli_query() along with your current open connection as shown below:

mysqli_query($conn, "TRUNCATE TABLE `users`");

Your entire code should be:

<?php
    $servername = "localhost";
    $username = "root";
    $password = "";
    $dbname = "members";

    // Create connection
    $conn = mysqli_connect($servername, $username, $password, $dbname);

    // Check connection
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }
    else {
        mysqli_query($conn, "TRUNCATE TABLE `users`");
        header ("Location: order.php");
        exit;
    }

   mysqli_close($conn);
 ?>

thanks a heap, worked perfectly! – Sam Hoinville Jul 19 '16 at 07:56 — Sam Hoinville, Jul 19 '16 at 07:56

Truncate table mysql php providing error

1 Answers1