dongze8698
2016-06-24 12:53
浏览 101

将表单值从PHP文件传递到另一个PHP文件

I make a pop-up form like this, in home.php :

<script src="js/submit.js"></script>

.........
.........
.........

<div id="abc">
<!-- Popup Div Starts Here -->

<div id="popupContact">
<!-- Form -->

<form action="#" id="form" method="post" name="form">

    <input id="month" name="month" placeholder="MONTH" type="text">
    <a href="javascript:%20check_empty()" id="submit">ADD</a>

</form>

</div>
<!-- Popup Div Ends Here -->
</div>

I fill the form. When I click 'ADD' button, it runs javascript function. The code in submit.js :

function check_empty() {
    if (document.getElementById('month').value == ""){
        alert("Fill column!");
    } else {
        document.getElementById('form').submit();   
        $.get("application/insertdata.php");
        return false;
    }
}

//Function To Display Popup
function div_show() {
document.getElementById('abc').style.display = "block";
}

//Function to Hide Popup
function div_hide(){
document.getElementById('abc').style.display = "none";
}

I want to run query in insertdata.php as below. It needs the value from 'month'.

<?php 
require("phpsqlajax_dbinfo.php");

$conn = mysqli_connect('localhost', $username, $password, $database);

if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
} 

$data = isset($_POST['month']);
$monthstring = mysqli_real_escape_string($conn, $data);

$sql = "INSERT INTO `databasea`.`tablea` (`MONTH`, `TEST`) VALUES ('". $monthstring ."', 'xxx');";

mysqli_query($conn, $sql);
mysqli_close($conn);
?>

The query run successfully, and row is added in my table. 'TEST' column is added with 'xxx'. But in 'MONTH' column, it generates no value, just empty.

So, how to get the 'month' value? Thank you.

图片转代码服务由CSDN问答提供 功能建议

我在 home.php 中制作一个这样的弹出窗体:

 &lt; script src =“js / submit.js”&gt;&lt; / script&gt; 
 
 ......... 
 ....  ..... 
 ......... 
 
&lt; div id =“abc”&gt; 
&lt;! -  Popup Div从这里开始 - &gt; 
 
&lt; div id  =“popupContact”&gt; 
&lt;! - 表格 - &gt; 
 
&lt; form action =“#”id =“form”method =“post”name =“form”&gt; 
 
&lt;  ; input id =“month”name =“month”placeholder =“MONTH”type =“text”&gt; 
&lt; a href =“javascript:%20check_empty()”id =“submit”&gt; ADD&lt; / a&gt;  ; 
 
&lt; / form&gt; 
 
&lt; / div&gt; 
&lt;! -  Popup Div在此结束 - &gt; 
&lt; / div&gt; 
   
 \  n 

我填写表格。 当我点击“添加”按钮时,它会运行javascript功能。 submit.js 中的代码:

  function check_empty(){
 if(document.getElementById('month')。value ==“  “){
 alert(”填充栏!“); 
} else {
 document.getElementById('form')。submit();  
 $ .get(“application / insertdata.php”); 
返回false; 
} 
} 
 
 //功能显示Popup 
function div_show(){
document.getElementById('abc'  ).style.display =“block”; 
} 
 
 //隐藏弹出功能
功能div_hide(){
document.getElementById('abc')。style.display =“none”; 
}  
   
 
 

我想在 insertdata.php 中运行查询,如下所示。 它需要'月'的值。

 &lt;?php 
require(“phpsqlajax_dbinfo.php”); 
 
 $ conn = mysqli_connect('localhost',  $ username,$ password,$ database); 
 
if(!$ conn){
 die(“Connection failed:”。mysqli_connect_error()); 
} 
 
 $ data = isset($ _ POST [  'month']); 
 $ monthstring = mysqli_real_escape_string($ conn,$ data); 
 
 $ sql =“INSERT INTO`databasea``tablea`(`MONTH`,`TEST`)VALUES('”  。$ monthstring。“','xxx');”; 
 
mysqli_query($ conn,$ sql); 
mysqli_close($ conn); 
?&gt; 
   
  
 

查询成功运行,并在我的表中添加了行。 “TEST”列添加了“xxx”。 但是在“MONTH”列中,它不会生成任何值,只会为空。

那么,如何获得'月'值? 谢谢。

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

3条回答 默认 最新

  • doucandiao9180 2016-06-24 13:14
    已采纳

    Since you're using JavaScript/jQuery there is no real need for inline code in your HTML, so let's start there by removing the inline JavaScript:

    <script src="js/submit.js"></script>
    
    .........
    .........
    .........
    
    <form action="#" id="form" method="post" name="form">
    
    <input id="month" name="month" placeholder="MONTH" type="text">
    <a href="#" id="submit">ADD</a>
    
    </form>
    

    Much cleaner, no? You weren't passing any data in your function call which may have caused problems for you down the line.

    Now a simpler setup in your JavaScript/jQuery in which we'll capture the click event and pass the data via $.post:

    $('#submit').click(function(event) {
        event.preventDefault(); // prevent the default click action
        var month = $('#month').val();
        if('' == month) {
            alert('fill the column!');
        } else {
            $.post("application/insertdata.php", {month: month}); // notice how the data is passed
        }
    });
    

    So far, so good, the code is much tighter and more readable and it actually posts the data from the form to the AJAX call.

    Finally the PHP, testing to see if the variable month is set properly:

    <?php 
        require("phpsqlajax_dbinfo.php");
    
        $conn = mysqli_connect('localhost', $username, $password, $database);
    
        if (!$conn) {
            die("Connection failed: " . mysqli_connect_error());
        } 
    
        if(isset($_POST['month'])) {
            $data = $_POST['month'];
            $monthstring = mysqli_real_escape_string($conn, $data);
            $sql = "INSERT INTO `databasea`.`tablea` (`MONTH`, `TEST`) VALUES ('". $monthstring ."', 'xxx');";
            mysqli_query($conn, $sql);
        }
    
        mysqli_close($conn);
    ?>
    

    NOTE: I am concerned that you might have more than one of these forms on your page and you may be duplicating ID's which will not work and the duplicate ID's will need to be removed. If this is the case the jQuery code I've written needs to be changed. Here is one way to do that:

    $('a').click(function(event) {
        event.preventDefault(); // prevent the default click action
        var month = $(this).prev('input').val(); // get the input next to the link
        if('' == month) {
            alert('fill the column!');
        } else {
            $.post("application/insertdata.php", {month: month}); 
        }
    });
    

    As I stated in comments Little Bobby says your script is at risk for SQL Injection Attacks. Learn about prepared statements for MySQLi. Even escaping the string is not safe! Changing to prepared statements will make your code cleaner and safer.

    已采纳该答案
    打赏 评论
  • dongqiuge5435 2016-06-24 12:57

    Hi use $data = $_POST['month'];

    isset will return true or false not value of month

    打赏 评论
  • dousuitang5239 2016-06-24 12:57

    Replace

    $data = isset($_POST['month']);
    

    by

    if(isset($_POST['month'])) {
       $data=$_POST['month'];
    }
    
    打赏 评论

相关推荐 更多相似问题