benanamen

You will need a session id and a WHERE clause in your query.

For starters, you don't need to check if the session has been started. Just set it and be done with it. You also need to kill the script after a header redirect and don't create variables for nothing.

The first thing you do is issue a redirect and kill the script. How do you expect it to do anything after that?

OP, I would really suggest you actually learn how to code instead of using a WYSIWYG. The output is absolutely horrendous.

Op was given the answer on another forum

What should be suggested is that you stop using dangerous obsolete mysql code that has been completely removed from PHP and was warned about for well over ten years and to stop running a php version that is hundreds of releases behind and reached end of life long ago. Toss that code in the trash. Every bit of it is bad. You need to use PDO with Prepared Statements. This tutorial will get you going. https://phpdelusions.net/pdo

OP, you were handed a complete properly coded example on the other forum by a gracious expert. Why are you still messing around with this bad code?

It means you posted this in multiple forums and someone already took the time in another forum to answer you so we are not going to waste more experts time answering something that has already been answered.

OP was given answer in another forum.

Money is not an int.

Exposing your PC to the entire world is a really bad idea. The various wamps are intended for Development, not Production.

What guarantee do you have that it was actually submitted by the users form and the users date picker? There are several ways to make a Post Request without using the users form. Bottom line, it is user supplied data and you well understand to NEVER trust user supplied data. The one case where you can safely get away with a variable in the query is if the date (or whatever) comes directly from the code, but then then that isn't user supplied data is it? But why do it? Consistency is always a good thing. No you didn't. Read the manual and see what you did wrong.

The OP created the column as datetime and is trying to insert a text string. $date_col = "test";//

If you just leave a closing php tag hanging around of course it will break. Why would you remove proper code?

What is the code from blog-approval.php? The tester is not displaying the error you posted. It is displaying a 1 as it should. If you echo'ed the line in your tester you would see a hash. Also, phpinfo() does not require echo.