benanamen

Yeah, the question smells. OP tell us what the real problem is you are trying to solve instead of asking about your attempted solution to solving it.

I would suggest you take some time to get down on SOLID principles. Here are a couple links. (I didn't read these pages. There may be better links) https://medium.com/prod-io/solid-principles-takeaways-ec0825a07247 https://www.hashbangcode.com/article/solid-principles-php

There is much that could be said about this code, but to keep on point, you need to use Dependency Injection and pass an instance of the helper class to your user class just like you did with the PDO connection. * The duplicate query should be one of the first clues of a problem with this class. This pretty much explains what I see here so the current state of the code makes sense for now. You should eventually end up with quite a bit of refactoring when you get it dialed in.

What have you tried besides posting this on every coding forum?

The first problem is that you are using variables in your query. You need to use Prepared Statements. You have not shown us where $check1_res comes from.

Your right. It "doesn't work".

Truncate the table. It will also delete all the data. TRUNCATE TABLE table_name; TRUNCATE TABLE table_name;

Allow me to direct you to the PHP Manual. It gives you an exact example of what you are asking. https://www.php.net/manual/en/function.error-log.php

In HTML5, the "action" is not necessary at all when submitting to the same page. You can simple do like so... <form method="post">

The one thing that hasn't been mentioned is WHY would YOU want to do this in the first place?

The last part could use some cleanup. if (mysqli_num_rows($result)) { return $result; } return false;

OP, What is the point of adding another layer (Javascript) just to get a random value? Why not just generate in Php? And rather than tell us about your attempted solution to the real problem, how about tell us what the real problem is.

All of this... $category = $_POST['category']; $item_type = $_POST['item_type']; $item_size = $_POST['item_size']; $product_name = $_POST['product_name']; $item_qty = $_POST['item_qty']; $price = $_POST['price']; $total_price = $_POST['total_price']; $item_price = $_POST['item_price'];

Get rid of the variables for nothing. You already have the POST values, just use them.

The option is in Webmin=>Webmin Users