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条)

报告相同问题?

悬赏问题

  • ¥15 Matlab在app上输入带有矩阵形式的初始条件发生错误
  • ¥15 CST仿真别人的模型结果仿真结果S参数完全不对
  • ¥15 误删注册表文件致win10无法开启
  • ¥15 请问在阿里云服务器中怎么利用数据库制作网站
  • ¥60 ESP32怎么烧录自启动程序
  • ¥50 html2canvas超出滚动条不显示
  • ¥15 java业务性能问题求解(sql,业务设计相关)
  • ¥15 52810 尾椎c三个a 写蓝牙地址
  • ¥15 elmos524.33 eeprom的读写问题
  • ¥15 用ADS设计一款的射频功率放大器