duannaxin9975 2014-02-17 11:33
浏览 28
已采纳

注意:未定义的索引错误[重复]

I'm getting this error:

Notice: Undefined index: prospectname in C:\wamp\www\var\SAS\insert.php on line 12

Here is the code

<form action="#" method="POST" class='form-horizontal form-bordered'>
    <div class="control-group">
        <label for="prospectname" class="control-label">Prospect Name</label>
        <div class="controls">
            <input type="text" name="prospectname" id="prospectname" placeholder="prospectname" class="input-xlarge">
        </div>
    </div>
    <div class="control-group">
        <label for="status" class="control-label">Status</label>
    </div>
</form>

sas.js

$(".registeradd").click(function () {

    var prospectname = $("#prospectname").val();
    var status = $("#status").val();
    var dataString = 'prospectname =' + prospectname + '&status=' + status;

    if (prospectname == '') {
        alert("Please Enter Some Text");
    } else {
        $("#flash").show();
        $("#flash").fadeIn(400).html;

        $.ajax({
            type: "POST",
            url: "insert.php",
            data: dataString,
            cache: false,
            success: function (html) {
                $("#display").after(html);
                $("#flash").hide();
            }
        });
    }
    return false;
});

Insert.php

<?php

$dbHost = 'localhost'; // usually localhost
$dbUsername = 'root';
$dbPassword = '';
$dbDatabase = 'test';

$db = mysql_connect($dbHost, $dbUsername, $dbPassword) or die ("Unable to connect to Database Server.");

mysql_select_db ($dbDatabase, $db) or die ("Could not select database.");

$prospectname =$_POST['prospectname'];
$status=$_POST['status'];

$sql_insert="insert into salesactivity(prospectname,status) values '$prospectname','$status')";

print $sql_insert;
mysql_query($sql_insert);

?>
</div>
  • 写回答

2条回答 默认 最新

  • dongza1708 2014-02-17 11:36
    关注

    Change your datastring

    var dataString = 'prospectname ='+ prospectname +'&status='+status;
    

    to a json object

    var dataString = { 'prospectname': prospectname, 'status': status};
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥50 永磁型步进电机PID算法
  • ¥15 sqlite 附加(attach database)加密数据库时,返回26是什么原因呢?
  • ¥88 找成都本地经验丰富懂小程序开发的技术大咖
  • ¥15 如何处理复杂数据表格的除法运算
  • ¥15 如何用stc8h1k08的片子做485数据透传的功能?(关键词-串口)
  • ¥15 有兄弟姐妹会用word插图功能制作类似citespace的图片吗?
  • ¥200 uniapp长期运行卡死问题解决
  • ¥15 latex怎么处理论文引理引用参考文献
  • ¥15 请教:如何用postman调用本地虚拟机区块链接上的合约?
  • ¥15 为什么使用javacv转封装rtsp为rtmp时出现如下问题:[h264 @ 000000004faf7500]no frame?