如何执行javascript确认框内的代码 [英] How to execute the code inside javascript confirm box

问题描述

我有一个 JavaScript 确认框，我有一些 MySQL 插入查询代码要在某些条件下执行.这是我的代码的样子:

I have a JavaScript confirm box and i have some MySQL insert query code to be executed at some condition. This is how my code look like:

<?php
$id = $_POST['id'];
$name= $_POST['name'];
$query = mysql_query("select * from table where id='$id'");
$count    =   mysql_num_rows($query );

if($count!=0)
{
?>
   <script type="text/javascript">  
        if (confirm("This seems to be Duplicate. Do you want to continue ?") == true)
        {
            //Execute/Insert into table as how it is given below
        }
        else
        {
            //Dont execute/insert into table but close the window
        }
     </script>
<?php
}
else
{
    $queryinsert = mysql_query("INSERT INTO table(id,name) VALUES('$id','$name')");
}
?>

推荐答案

你不能在 javascript 中执行 MySQL 或 PHP 命令，你可以做的是制作一个可以被 Ajax 调用的 PHP 函数.最好的方法是使用 jQuery 或 重定向在 URL 中使用 PHP 函数的页面.

You can't execute MySQL or PHP command inside javascript, what you can do instead is to make a PHP function that you can call by Ajax. The best way is by using jQuery or by redirecting the page with your PHP function in URL.

<script type="text/javascript">  
    if (confirm("This seems to be Duplicate. Do you want to continue ?"))
    {
        $.ajax({
            url: 'your_path_to_php_function.php',
            type: 'POST', // Or any HTTP method you like
            data: {data: 'any_external_data'}
        })
        .done(function( data ) {
            // do_something()
        });
    }
    else
    {
        window.location = 'your_url?yourspecialtag=true'
    }
 </script>

这篇关于如何执行javascript确认框内的代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！