php - 试图从 mysql 获取数据但导致找不到

Question

已经尝试了几个小时将数据从 mysql 获取到我的网站，但我无法弄清楚我做错了什么......

注意：未定义的索引：第 17 行 C:\xampp\htdocs\website\products.php 中的 subcatid

<?php
    $url=$_SERVER['REQUEST_SCHEME']."://".$_SERVER['HTTP_HOST']."/eshopmgk/";

    require_once("connection.php");
    $sql1="select * from prointa where id=".$_GET['catid'];

    mysqli_query($con,'set names "utf8"');

    $recordset=mysqli_query($con,$sql1);    

    $sqla="select * from proionta
            inner join subcatigories on proionta.subcatigories_id=subcatigories.subcatigories_id 
            where subcatigories.subcatigories_alias like  '".$_GET['subcatid']."'";
    $recordsetcannon=mysqli_query($con,$sqla);
?>

.

<div class="col100  products-home-items">
                <?php while($recordcannon=mysqli_fetch_assoc($recordsetcannon)){?>
                    <div class="col25 products-home-item">
                        <div class="col100 items-img">
                            <img width="55%" src="<?=$url?><?=$recordcannon['photos']?>" />
                        </div>
                        <div class="col100 items-title">
                            <a href="#">
                                <p>Φακός</p>
                            </a>
                        </div>
                        <div class="col100 items-category">
                            <a href="<?=$url?>/<?=$_GET['catid']?>/<?=$_GET['subcatid']?>/<?=$recordcannon['proionta_alias']?>"><h3><?=$recordcannon['proionta_name']?></h3></a>                            
                        </div>
                        <div class="col100">                            
                            <div class="col100">
                                <p class="items-price text-center"><?=$recordcannon['proionta_timi']?>&euro;</p>
                            </div>

标签： phpmysqlindexingundefined