How to insert delete_time

Question

1.00/5 (1 vote)

See more:

delete_time column name in delete_user table i want when user delete and move in delete_user from login_user with datetime in insert into select statement

What I have tried:

<?php
	include '../../config/database.php';
	$id=$_POST['user_id'];
		date_default_timezone_set("Asia/kathmandu");
    $delete_time = date("Y-m-d H:i:s");
    $query = mysqli_query($cn,"INSERT INTO  delete_user (`user_id`,`name`,`email_id`,`phone`,`user_type`,`delete_time`) SELECT `user_id`,`name`,`email_id`,`phone`,`user_type`, FROM `login_user`
    WHERE user_id=$id");
	if(!$query) { die(mysqli_error()); }

	$sql1 = "DELETE FROM `login_user` WHERE user_id=$id";
	if (mysqli_query($cn, $sql1)) {
		echo json_encode(array("statusCode"=>200));
	}
	
	
?>

Posted 22-Dec-20 5:10am

Member 13751016

Updated 4-Jan-21 5:30am

Add a Solution

Comments

[no name] 24-Dec-20 12:20pm

Aren't INSERT and SELECT separate statements? Wouldn't you "select" first?

Member 13751016 25-Dec-20 0:34am

then how ? please help!!

Richard Deeming 6-Jan-21 10:08am

Your code is vulnerable to SQL Injection[^]. NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.

PHP: SQL Injection - Manual[^]

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2021-01-04T05:30:00

Include complete details(Error message, etc.,) always in your question.

After looking at code, found that your query is wrong.

Remove the comma(,) before FROM keyword.

Quote:
$query = mysqli_query($cn,"INSERT INTO delete_user (`user_id`,`name`,`email_id`,`phone`,`user_type`,`delete_time`) SELECT `user_id`,`name`,`email_id`,`phone`,`user_type`, FROM `login_user`

But you need to give matching number of values in query. INSERT statement has 6 columns & SELECT statement has only 5 values(columns). It should be matching(I think you missed the 6th column before FROM keyword). So update your query.