How to use the boolean value in PHP for comparing

Question

0.00/5 (No votes)

See more:

I am new to php and javascript.In my project I can click the delete button.before deleting the record show the alert message and if i click ok record will be delete.But In
My case Alert message is showing in javascript fine.But once alert message shown if click cancel button also record will be deleting.How to solve this problem please help me on this.Thanks in Advance.

What I have tried:

JavaScript

 function ConfirmDelete()
{
  var x = confirm("Are you sure you want to delete?");
  if (x==true)
  {
      return true;
  }
  else
    return false;
}

PHP

if(isset($_POST['Delete']))
		{
	            $sql="UPDATE `organization`
			    SET bbnk_delstatus='Y'
				WHERE bbnk_Id='$select_id'";
			if(mysqli_query($conn,$sql))
			{
				$status= "Record Deleted successfully";
			}
			else
			{
				$status= "connection failed".mysqli_error($conn);
			
			}
				
		}

Posted 28-Jun-17 19:09pm

Member 13153537

Updated 29-Jun-17 7:54am

Patrice T

v3

Add a Solution

2 solutions

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)

W∴ Balboos, *GHB* · Answer 1 · 2017-06-29T07:09:00

Solution 1

Unfortunately, you've not shown any sort of connection between your ConfirmDelete() function and your delete statement. First, you should never get to the statement if you do not select 'YES'.

So I'll guess: you're running the ConfirmDelete() function but your actual delete is occurring with ever checking it. You need to rearrange your logic in that function so that the deletion is called if YES is selected, or else it's not called at all.

There's no connection (magical or otherwise) between confirm() unless you make one!

Posted 29-Jun-17 7:09am

W∴ Balboos, GHB

Comments

Member 13153537 29-Jun-17 13:33pm

How to do that please any help.Thanks in Advance.

W∴ Balboos, GHB 29-Jun-17 13:48pm

Check Here: https://www.w3schools.com/jsref/met_win_confirm.asp

Look where the example says: txt = "You pressed OK!";
You would replace that with whatever code you use to access your database. If you do that you should only run that code if YES is clicked.

Patrice T · Answer 2 · 2017-06-29T07:54:00

Looks like you need to learn and practice programming.
Advice: follow tutorials and practice.
Your code is overcomplicated

JavaScript

function ConfirmDelete()
{
  var x = confirm("Are you sure you want to delete?");
  if (x==true)
  {
    return true;
  }
  else
    return false;
}

can be simplified to

JavaScript

function ConfirmDelete()
{
  var x = confirm("Are you sure you want to delete?");
  return x;
}

and even to

JavaScript

function ConfirmDelete()
{
  return confirm("Are you sure you want to delete?");
}