html 类更改为 Attributes

Question

我正在尝试将 html 代码发送到数据库，然后在 index.php 中显示代码，这是我用来将 html 代码发送到 DB 的内容：

当我引用属性时，我收到 sql 语法错误

$result = "          <li>

                <a href=$Link class=external item-link item-content>

                  <div class=item-media><img src=$f_image class=lazy lazy-fade-in style=border-radius: 10px; width=42px height=42px></div>

                  <div class=item-inner>

                    <div class=item-title>

                      $Name <span class=test-bull>&bull;</span>

                      <div class=item-footer>$Info</div>

                    </div>

                    <div class=item-after></div>

                  </div>

                </a>

              </li>

              ";

$sql = "INSERT INTO table1 (test) VALUES ('$result')";

if ($conn->query($sql) === TRUE) {

    echo "New record created successfully";

}else {

    echo "Error: " . $sql . "<br>" . $conn->error;

}

这就是我用来在 index.php 中显示代码的内容：

<?php

      $sql = "SELECT test FROM table1";

       $result = $conn->query($sql);

 if ($result->num_rows > 0) {

    // output data of each row

     while($row = $result->fetch_assoc()) {

     echo $row ["test"];

 }

 } else {

    echo "0 results";

}

              ?>

现在你可以看到我的 html 代码中有不止一个类：

<a href=$Link class=external item-link item-content>

问题是当我从数据库中获取 html 代码并在 index.php 中显示它时，类被更改为这样的属性：

<li>

                <a href="test" class="external" item-link="" item-content="">

                  <div class="item-media"><img src="img/2ff4e.aa.png" class="lazy" lazy-fade-in="" style="border-radius:" 10px;="" width="42px" height="42px"></div>

                  <div class="item-inner">

                    <div class="item-title">

                      test <span class="test-bull">•</span>

                      <div class="item-footer">test</div>

                    </div>

                    <div class="item-after"></div>

                  </div>

                </a>

              </li>

这两个类 item-link 和 item-content 现在是 item-link="" 和 item-content=""

我做错了什么？我必须改变/做什么？

Answer 1

您需要添加引号。尝试这个：$result = '&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <li>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <a href="'.$Link.'" class="external item-link item-content">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="item-media"><img src="'.$f_image.'" class="lazy lazy-fade-in" style="border-radius: 10px; width=42px height=42px"></div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="item-inner">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="item-title">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '.$Name.' <span class="test-bull">&bull;</span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="item-footer">'.$Info.'</div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="item-after"></div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </a>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </li>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ';

Answer 2

您需要添加引号。尝试这个：$result = '&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <li>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <a href="'.$Link.'" class="external item-link item-content">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="item-media"><img src="'.$f_image.'" class="lazy lazy-fade-in" style="border-radius: 10px; width=42px height=42px"></div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="item-inner">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="item-title">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '.$Name.' <span class="test-bull">&bull;</span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="item-footer">'.$Info.'</div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <div class="item-after"></div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </a>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </li>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ';

Answer 3

$result = "This is double quotes, I need html class :) simple <div&nbsp;class='class_name_under_single_q'> Content </div>";$result = 'This is Single quotes, I need html class :) simple <div&nbsp;class="class_name_under_double_q"> Content </div>';<?php&nbsp; &nbsp;$result = "<a href=".$Link." class=".external item-link item-content.">";?>如果使用双引号，则在双引号下使用单引号。但是，如果您使用单引号，则在单引号下使用双引号。