CODEWITHSUNDEEP
javascriptphp
user1950349
user1950349

Reputation: 5146

How to mix php inside javascript?

I have a php code as shown below in which there is an if condition.

php:

if(mysqli_num_rows($result1) > 0){   // Line X
    while($row = mysqli_fetch_array($result1)){
        if($row['open'] == "true") {
                if(!isset($_SESSION['admin'])) {
                    $message = "user " . $row['user_name'] . " is currently editing the form. Want to take over ?";  // Line B
                    echo "<script type='text/javascript'>if(confirm('$message')) {   } else {  };</script>";   // Line A                        
                    }
            break;
        }
    }
}

I was able to integrate $message at Line B.

I am wondering what changes I should do at Line A so that I can integrate the following code in the curly braces of the if(confirm('$message') block:

$username = $_SESSION['user_name'];
$open="true";
$write="1";
$stmt=$connect->prepare("UPDATE trace_users SET write=0 WHERE write=1"); // revoke write access of all users
$stmt=$connect->prepare("UPDATE trace_users SET open=?, write=? WHERE user_name=?");
$stmt->bind_param('sss', $open, $write, $username);
$stmt->execute();

Upvotes: -1

Views: 643

Answers (2)

Not A Robot
Not A Robot

Reputation: 2684

It is a good practice if you avoid mixing two different languages together.

When mixing these two the complexity of your code increases.

Since you need the answer here you go

echo "<script type='text/javascript'>if(confirm(" . $message . ")) {   } else { };</script>";

Inside echo's double/single quotes(" / ') everything is considered as a string, so to access your PHP variable you need to use the concatenation method to use that PHP variable.

if(confirm(" . $message . "))

UPDATE

You need to follow the same steps, as described above. You need to use the string concatenations.

But that will be very complex and as well as very difficult to make debugging.

You can use a better approach using XHR request or you can design the PHP code in a better way to use it with your JavaScript code.

Upvotes: 0

UberRose
UberRose

Reputation: 86

Unfortunately user1950349, this is a bit more complex than it may seem because your idea is closer to how a desktop app would where there is a message loop which allows the code to respond to user input. But with a webpage generated by php and sent over the internet, we do not have a message loop to work with. Thus, we have figure out a way to get the server and the user's computer to message back and forth without any additional webpage loads.

This is where AJAX would come into play; however, an explanation of how to use that for your use case would depend on how you implement AJAX. For instance, you might use jQuery or some other javascript library.

Upvotes: 1

Related Questions