duan47676379 2017-07-20 05:52
浏览 18

未定义的索引'查询'

I am getting the notice in PHP code like this. Notice: Undefined index: query on line 2.

Here is my code.

// gets value sent over search form

$min_length = 1;
// you can set minimum length of the query if you want

if(strlen($query) >= $min_length){ // if query length is more or equal minimum length then

    $query = htmlspecialchars($query); 
    // changes characters used in html to their equivalents, for example: < to &gt;

    $query = mysqli_real_escape_string($con,$query);
    // makes sure nobody uses SQL injection

    $raw_results = mysqli_query($con,"SELECT * FROM dashboard
        WHERE (`company_name` LIKE '%".$query."%')OR (`total_device` LIKE '%".$query."%')OR
        (`working_device` LIKE '%".$query."%')") or die(mysql_error());

    // * means that it selects all fields, you can also write: `id`, `company_name`, `total_device`,`working_device`
    // articles is the name of our table

    // '%$query%' is what we're looking for, % means anything, for example if $query is Hello
    // it will match "hello", "Hello man", "gogohello", if you want exact match use `title`='$query'
    // or if you want to match just full word so "gogohello" is out use '% $query %' ...OR ... '$query %' ... OR ... '% $query'

    if(mysqli_num_rows($raw_results) > 0){ // if one or more rows are returned do following

 while($results = mysqli_fetch_array($raw_results)){ ?>
<div class="wrap">

Working Devices
Total Devices


Any help please..

  • 写回答

1条回答 默认 最新

  • dsfgds4215 2017-07-20 06:05
    关注

    Thanks to everyone. The problem resolved with this.

    $query = isset($_POST['query'])? $_POST['query'] : "";

    评论

报告相同问题?

悬赏问题

  • ¥15 BP神经网络控制倒立摆
  • ¥20 要这个数学建模编程的代码 并且能完整允许出来结果 完整的过程和数据的结果
  • ¥15 html5+css和javascript有人可以帮吗?图片要怎么插入代码里面啊
  • ¥30 Unity接入微信SDK 无法开启摄像头
  • ¥20 有偿 写代码 要用特定的软件anaconda 里的jvpyter 用python3写
  • ¥20 cad图纸,chx-3六轴码垛机器人
  • ¥15 移动摄像头专网需要解vlan
  • ¥20 access多表提取相同字段数据并合并
  • ¥20 基于MSP430f5529的MPU6050驱动,求出欧拉角
  • ¥20 Java-Oj-桌布的计算