bobafart's questions

我已阅读文档并在 Google 上搜索过 - 找不到答案。我有一个视差引导幻灯片。在第一张幻灯片中，我试图让 3 个 div 列的高度和宽度相等，并排排列在一行中。代码如下。但是，渲染时，每列都堆叠在一起，因此基本上只有 1 列。请帮忙？

  <div style="--swiper-navigation-color: #fff; --swiper-pagination-color: #fff" class="swiper mySwiper">
    <div class="parallax-bg" style="
          background-image: url(https:// domain .com/assets/img/moonscape.jpg);
        " data-swiper-parallax="-23%"></div>
    <div class="swiper-wrapper">
      <div class="swiper-slide">
        <div class="title" data-swiper-parallax="-300">Slide 1</div>
        <div class="subtitle" data-swiper-parallax="-200">Subtitle</div>
        <div class="text" data-swiper-parallax="-100">
          <div class="container">
            <div class="row">
              <div class="col-sm-4">
                <p>
                  Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam
                  dictum mattis velit, sit amet faucibus felis iaculis nec. Nulla
                  laoreet justo vitae porttitor porttitor. Suspendisse in sem justo.
                  Integer laoreet magna nec elit suscipit, ac laoreet nibh euismod.
                  Aliquam hendrerit lorem at elit facilisis rutrum. Ut at
                  ullamcorper velit. Nulla ligula nisi, imperdiet ut lacinia nec,
                  tincidunt ut libero. Aenean feugiat non eros quis feugiat.
                </p>
              </div>
              <div class="col-sm-4">
                <p>
                  Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam
                  dictum mattis velit, sit amet faucibus felis iaculis nec. Nulla
                  laoreet justo vitae porttitor porttitor. Suspendisse in sem justo.
                  Integer laoreet magna nec elit suscipit, ac laoreet nibh euismod.
                  Aliquam hendrerit lorem at elit facilisis rutrum. Ut at
                  ullamcorper velit. Nulla ligula nisi, imperdiet ut lacinia nec,
                  tincidunt ut libero. Aenean feugiat non eros quis feugiat.
                </p>
              </div>
              <div class="col-sm-4">
                <p>
                  Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam
                  dictum mattis velit, sit amet faucibus felis iaculis nec. Nulla
                  laoreet justo vitae porttitor porttitor. Suspendisse in sem justo.
                  Integer laoreet magna nec elit suscipit, ac laoreet nibh euismod.
                  Aliquam hendrerit lorem at elit facilisis rutrum. Ut at
                  ullamcorper velit. Nulla ligula nisi, imperdiet ut lacinia nec,
                  tincidunt ut libero. Aenean feugiat non eros quis feugiat.
                </p>
              </div>
            </div>
          </div>                    
        </div>
      </div>
      <div class="swiper-slide">
        <div class="title" data-swiper-parallax="-300">Slide 2</div>
        <div class="subtitle" data-swiper-parallax="-200">Subtitle</div>
        <div class="text" data-swiper-parallax="-100">
          <p>
            Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam
            dictum mattis velit, sit amet faucibus felis iaculis nec. Nulla
            laoreet justo vitae porttitor porttitor. Suspendisse in sem justo.
            Integer laoreet magna nec elit suscipit, ac laoreet nibh euismod.
            Aliquam hendrerit lorem at elit facilisis rutrum. Ut at
            ullamcorper velit. Nulla ligula nisi, imperdiet ut lacinia nec,
            tincidunt ut libero. Aenean feugiat non eros quis feugiat.
          </p>
        </div>
      </div>
      <div class="swiper-slide">
        <div class="title" data-swiper-parallax="-300">Slide 3</div>
        <div class="subtitle" data-swiper-parallax="-200">Subtitle</div>
        <div class="text" data-swiper-parallax="-100">
          <p>
            Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam
            dictum mattis velit, sit amet faucibus felis iaculis nec. Nulla
            laoreet justo vitae porttitor porttitor. Suspendisse in sem justo.
            Integer laoreet magna nec elit suscipit, ac laoreet nibh euismod.
            Aliquam hendrerit lorem at elit facilisis rutrum. Ut at
            ullamcorper velit. Nulla ligula nisi, imperdiet ut lacinia nec,
            tincidunt ut libero. Aenean feugiat non eros quis feugiat.
          </p>
        </div>
      </div>
      <div class="swiper-slide">
        <div class="title" data-swiper-parallax="-300">Slide 4</div>
        <div class="subtitle" data-swiper-parallax="-200">Subtitle</div>
        <div class="text" data-swiper-parallax="-100">
          <p>
            Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aliquam
            dictum mattis velit, sit amet faucibus felis iaculis nec. Nulla
            laoreet justo vitae porttitor porttitor. Suspendisse in sem justo.
            Integer laoreet magna nec elit suscipit, ac laoreet nibh euismod.
            Aliquam hendrerit lorem at elit facilisis rutrum. Ut at
            ullamcorper velit. Nulla ligula nisi, imperdiet ut lacinia nec,
            tincidunt ut libero. Aenean feugiat non eros quis feugiat.
          </p>
        </div>
      </div>      
    </div>
    <div class="swiper-button-next"></div>
    <div class="swiper-button-prev"></div>
    <div class="swiper-pagination"></div>
  </div>

我以前使用过 Jquery UI 和工具提示，没有任何问题……这次由于某种原因，我无法让它们工作。我试图让工具提示仅在鼠标悬停在 1 个元素上时显示。<head> 是：

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
    <link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.14.1/themes/smoothness/jquery-ui.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.14.1/jquery-ui.min.js"></script>
    <script>
  $("#barracks").tooltip({disabled:true});
    $(document).click(function() {
        if($("#barracks").tooltip("option", "disabled")) {
            $("#barracks").tooltip("enable");
            $("#barracks").tooltip("open");
            $("#barracks").off("mouseleave focusout");
        } else {
            $("#barracks").tooltip("close");
            $("#barracks").tooltip("disable");
        }
    });
    </script>

在 < body > 中：

                <div class="col-lg-2 col-md-2 col-xs-2 thumb"> 
                    <img src="https://www. domain .com/adminp/occur/assets/img/soldier.jpg" id="barracks" class="img-thumbnail img-fluid rounded float-start max-width: 100%;" alt="infantry" title="Infantry">
                </div>
                <div class="col-lg-2 col-md-2 col-xs-2 thumb">
                    <img src="https://www. domain .com/adminp/occur/assets/img/gunner.jpg" id="barracks" class="img-thumbnail img-fluid rounded mx-auto d-block max-width: 100%;" alt="gunner" title="Gunner">                                 
                </div>
                <div class="col-lg-2 col-md-2 col-xs-2 thumb">
                    <img src="https://www. domain .com/adminp/occur/assets/img/pilot.jpg" id="barracks" class="img-thumbnail img-fluid rounded mx-auto d-block max-width: 100%;" alt="pilot" title="Pilot">                                 
                </div>                        
                <div class="col-lg-2 col-md-2 col-xs-2 thumb">
                    <img src="https://www. domain .com/adminp/occur/assets/img/astronaut.jpg" id="barracks" class="img-thumbnail img-fluid rounded float-end max-width: 100%;" alt="astronaut" title="Astronaut">    
                </div>

步兵工具提示可用，但其他 3 个不起作用。没有显示工具提示

我读过之前的问题和教程，但我不完全理解 mod_rewrite，所以我在这里发帖

Options +FollowSymLinks
RewriteEngine On

#Using THE_REQUEST for catching references and using them later on.
RewriteCond %{THE_REQUEST} \s/(content)/index\.php\?var=(.*?)\s [NC]
RewriteRule ^ /%1/featured/%2? [R=301,L]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(content)/featured/(.*?)/?$ $1/index.php?var=$2 [QSA,NC,L]

RewriteRule ^profile/([0-9]+)/ /profile.php?userid=$3 [NC, L] 

我想将 www.domain.com/profile.php?userid=2343 的 URL 重写为一个干净的 URL，即 www.domain.com/profile/2343/

我尝试了多种变化......上面描述的.htaccess 代码不起作用。

请帮忙？

尽管我尝试调试它，但我无法解决这个致命错误——问题是 mySQL Insert 语句

错误是：

致命错误：未捕获的 PDOException：SQLSTATE[23000]：完整性约束违规：1062 /home/path/public_html/signupvalidate.php:51 中键“uq_mobile”的重复条目“”堆栈跟踪：#0 /home/path/path/signupvalidate.php(51)：PDOStatement->execute(Array) #1 {main} 在 /home/path/path/signupvalidate.php 第 51 行中抛出

'uq_mobile' 是什么？这不是我的代码或 mySQL 数据库或表设置中的任何短语

插入语句为：

$stmtInsertProfile = $conn->prepare('INSERT INTO users_profile (userid, firstName, middleName, lastName, mobile, email, country, registeredAt, lastLogin, intro, userProfile)
                                    VALUES (:userid, :firstName, :middleName, :lastName, :mobile, :email, :country, :registeredAt, :lastLogin, :intro, :userProfile)');

$stmtInsertProfile->execute([
    // 'id' => '', // do not specific the auto increment primary key on insert commands 
    'userid' => $fetchedUserID,
    'firstName' => '',
    'middleName' => '',
    'lastName' => '',
    'mobile' => '',
    'email' => $fetchedUserEmail,
    'country' => '',
    'registeredAt' => '',
    'lastLogin' => '',
    'intro' => '',
    'userProfile' => ''
]);

我导出的表结构是：

CREATE TABLE `users_profile` (
  `id` bigint(20) NOT NULL,
  `userid` int(11) NOT NULL,
  `firstName` varchar(50) DEFAULT NULL,
  `middleName` varchar(50) DEFAULT NULL,
  `lastName` varchar(50) DEFAULT NULL,
  `mobile` varchar(15) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `userBio` text NOT NULL,
  `country` varchar(32) NOT NULL,
  `registeredAt` int(11) NOT NULL,
  `lastLogin` int(11) DEFAULT NULL,
  `intro` tinytext DEFAULT NULL,
  `userProfile` text DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

表中的主键是“id”，因此它未在 INSERT 命令中被引用。$fetchedUserEmail（有效的电子邮件字符串）和 $fetchedUserID（有效的整数）都是变量，当我在调试期间输出它们时，它们包含预期的值

我用谷歌搜索了这个并找不到答案。我来自 PHP。在 PHP 中，我会在笔记本电脑上的 IDE 中编写代码，将 .php 脚本上传到我的服务器 (VPS)，然后通过 Web 浏览器执行/运行该脚本。

我是Python新手。我写了下面的代码

print("Hello World") 

在一个名为 hello.py 的文件中。

如果我将文件上传到我的服务器并通过谷歌浏览器访问它，我会得到以下信息：

打印（“你好，世界！”）

Python 已安装，版本为 Python 3.x 在 PHP 世界中，我得出的结论是服务器没有解析 PHP 代码。hello.py 文件不在服务器上的 /bin/ 文件夹中，据我所知，我的 Python 安装没问题。

关于如何让文件通过浏览器运行有什么建议吗？谢谢