主页 / user-351678

yaleksandr89's questions

Martin Hope
yaleksandr89
Asked: 2020-07-01 18:00:48 +0000 UTC
  • 1

我经常对文件和文件夹的访问权限感到困惑:(。如果您为用户授予文件夹的权限，那仍然很清楚（sudo chmod -R 777 /dir.../）。但是在这种情况下该怎么办：

安装 poedit 来本地化 WP 的主题，本地项目是/var/www/. 当我尝试通过 poedit 打开本地化文件时，我看到 在此处输入图像描述

权利/var/

在此处输入图像描述

权利/var/www/

在此处输入图像描述

安装了应用程序sudo snap install poedit。

告诉我，为了让 poedit 看到目录中的文件需要做什么/var/www/？我只是真的不想将文件从项目文件夹中/home/$USER来回拖动......

linux
Martin Hope
yaleksandr89
Asked: 2020-06-15 04:02:59 +0000 UTC
  • 0

我不知道如何在终端中更改配色方案。我使用 phpStorm+Material Theme UI(Oceanic)，我使用 git bash 作为控制台（我选择：在设置中C:\Program Files\Git\bin\bash.exe）。

我没有手动更改任何地方的颜色（一切都是默认的），结果我们在终端窗口中得到以下情况： 在此处输入图像描述

我不知道如何改变这个“vyrviglazny 背景”？我试图查看Editor - General - Selection background，颜色是默认的（正是控制台中显示的颜色）。

知道在哪里改变吗？

PS我真的不想使用Windows控制台，我习惯了git bash。

phpstorm
Martin Hope
yaleksandr89
Asked: 2020-06-10 17:27:58 +0000 UTC
  • 0

站点地图是根据以下原则在站点上生成的：/public/{название хоста}/sitemap.xml. 它没有放在 rootpublic中，因为管理面板可以选择允许您设置多站点，并且每个主机都需要自己的站点地图。

问题如下.htaccess：

<IfModule mod_rewrite.c>
    Options -MultiViews
    RewriteEngine On
    RewriteBase /

    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteRule ^(.*)$ index.php [QSA,L]
</IfModule>

<IfModule !mod_rewrite.c>
    <IfModule mod_alias.c>
        RedirectMatch 302 ^/$ /index.php/
    </IfModule>
</IfModule>

结果如下。例如，生成的站点地图site-1可在两个 URL 获得：

  1. http://example.com/site-1/sitemap.xml
  2. http://example.com/sitemap.xml

我发现这种行为是由于RewriteRule ^(.*)$ index.php [QSA,L]（如果您注释掉这条规则 2. 停止工作）。但由于不难猜测 - 它不能被删除:)

因此，是否可以调整.htaccess规则：RewriteRule ^(.*)$ index.php [QSA,L]不考虑扩展*.xml

这种设置没有太多经验（更准确地说，几乎没有:)），所以我决定寻求帮助。

.htaccess
Martin Hope
yaleksandr89
Asked: 2020-06-09 19:49:54 +0000 UTC
  • 0

如何正确编写正则表达式？你好。

请告诉我如何做一个常规的。http://РАНДОМНЫЙ-ДОМЕН/需要找到一个字符串РАНДОМНЫЙ-ДОМЕН（即名称和长度可以是任意的，也可以存在有效字符：-, _, .）并替换，例如用localhost.

我不知道如何选择//.../

UPD：我扔了这样的东西[a-z0-9_-]+(\.[a-z0-9_-]+)*\.[a-z]{2,5}，但有一个障碍。它处理http://localhost/不正确（这个选项也可以到达），我该如何解决？

php
Martin Hope
yaleksandr89
Asked: 2020-05-22 23:32:54 +0000 UTC
  • 0

告诉我如何为条件编写正则表达式： 有一个 url，如：http://example.com/news/news-name

需要切断http://example.com, 离开/news/news-name, 而 news-name 会根据新闻的名称而改变。

PS #1 仍然是一个小的愿望清单，虽然不是必需的。是否可以不“硬编码”网站的名称，而是用类似的东西代替 baseUrl = window.location.protocol + "//" + window.location.host;

可能吗？

PS#2new URL不能用，需要IE支持

javascript
Martin Hope
yaleksandr89
Asked: 2020-05-18 16:25:28 +0000 UTC
  • 1

在跟踪页面上下滚动时，我就是无法摆脱一个侧柱。简而言之，当一个块出现在页面范围内时。

*检查块是否出现在范围内的功能。

function is_shown() {
    /**
     * @var wt - windows scrollTop
     * @var wh - windows height
     * @var et - target element
     * @var eh - element height
     */
    var wt = parseFloat($(window).scrollTop().toFixed()),
        wh = parseFloat($(window).height().toFixed()),
        et = parseFloat(self.offset().top.toFixed()),
        eh = parseFloat(self.outerHeight().toFixed());
    return (wt + wh) - offsetTop >= et && (wt + wh - eh * 2) <= et + (wh - eh) - offsetBottom;
}

启动一个事件处理程序来跟踪页面的滚动方式：

function scrollTracking() {
    var lastScrollTop = 0;
    $(document).on('scroll.scrollTracking', function () {
        var currentScrollTop = $(this).scrollTop();
        if (currentScrollTop > lastScrollTop) {
            console.log('Прокрутка вниз');
            // здесь "магия" при прокрутке ВНИЗ
        } else {
            console.log('Прокрутка вверх');
            // здесь "магия" при прокрутке ВВЕРХ
        }
        lastScrollTop = currentScrollTop;
    });
}

is_shown()之间的交互作用scrollTracking()如下：

return $(document).on('scroll.isShow', function () {
    if (is_shown()) {
        if (blockShow === null || blockShow === false) {
            scrollTracking();
        }
        blockShow = true;
    } else {
        if (blockShow === null || blockShow === true) {
            $(document).off('scroll.scrollTracking');
        }
        blockShow = false;
    }
})

所有这些都有效，但只有一个门框。向下滚动页面时，一切正常，即当对象出现在范围内时，scrollTracking()，而当对象从范围内消失时，处理程序被移除$(document).off('scroll.scrollTracking')。

但是，如果您向上滚动页面，则向下滚动一次，然后向上滚动开始工作。

有点乱，本来想插个gif的，但是尺寸不合适，就想办法搞清楚在屏幕上工作的过程。

在此处输入图像描述

我知道里面的支票里面有问题scrollTracking()，但我不知道如何更改支票:(

如何纠正这种行为？

javascript
Martin Hope
yaleksandr89
Asked: 2020-05-18 02:17:02 +0000 UTC
  • 2

我不知道如何实现这样的功能：例如，页面上有 20 张图片

<div class="wrapper-img">
    <img src="img/1.jpg">
    <img src="img/2.jpg" style="display: none;">
    <img src="img/3.jpg" style="display: none;">
    ...
    <img src="img/20.jpg" style="display: none;">
</div>

如何通过滚动实现图像切换，即1-隐藏、2-显示等。我画了一个例子js：

$(document).ready(function () {
    $(document).on('scroll', function () {
        var stackImages = $('.wrapper-img').find('img');
            // stackImages.hide().eq($(this).index()).css("display", "block"); - срабатывает один раз, то есть скрывает картинку1, делает видимой картинку 2
        for (var i = 0; i < stackImages.length; i++){
            // ...
        }
    });
});

出现的问题： 1. 滚动时如何强制切换图片 2. 如何设置多长时间后切换

javascript
Martin Hope
yaleksandr89
Asked: 2020-05-17 22:27:47 +0000 UTC
  • 1

我想不通接下来的情况。

如果在理论上，如果页面上的元素，其外观需要被跟踪（滚动事件） - 这样做。问题是，当触发一个事件来监视范围内元素的外观时，会触发另一个（类似的滚动事件），该事件又负责检查页面滚动的方向（从上到下）。而且我无法以任何方式实现，因此在元素超出范围后，只有跟踪滚动方向的函数从事件处理程序中删除

代码：一个跟踪元素是否从范围内出现/消失的函数：

var self = $(this),
    blockShow = null,
    offsetTop = settings.offsetTop,
    offsetBottom = settings.offsetBottom;

/**
 * Функция определяет, находиться элемент в области видимости или нет.
 * Дополнительно (пользовательские отспупы):
 * scrollTop - отсутп сверх
 * offsetBottom - отступ снизу
 *
 * @returns {boolean|boolean}
 */
function is_shown() {
    /**
     * @var wt - windows scrollTop
     * @var wh - windows height
     * @var et - target element
     * @var eh - element height
     */
    var wt = parseFloat($(window).scrollTop().toFixed()),
        wh = parseFloat($(window).height().toFixed()),
        et = parseFloat(self.offset().top.toFixed()),
        eh = parseFloat(self.outerHeight().toFixed());
    return (wt + wh) - offsetTop >= et && (wt + wh - eh * 2) <= et + (wh - eh) - offsetBottom;
}

确定滚动方向的函数（当元素在范围内时）：

function scrollTracking() {
    var lastScrollTop = 0;
    $(document).on('scroll', function () {
        var currentScrollTop = $(this).scrollTop();
        if (currentScrollTop > lastScrollTop) {
            console.log('Прокрутка вниз');
        } else {
            console.log('Прокрутка вверх');
        }
        lastScrollTop = currentScrollTop;
    });
}

我结合了书面功能：

return $(document).on('scroll', function () {
    if (is_shown()) {
        if (blockShow === null || blockShow === false) {
            console.log('Блок ' + self.attr('class') + ' ПОЯВИЛСЯ');
            scrollTracking();
        }
        blockShow = true;
    } else {
        if (blockShow === null || blockShow === true) {
            console.log('Блок ' + self.attr('class') + ' СКРЫТ');
        }
        blockShow = false;
        //$(document).off('scroll', scrollTracking());
    }
})

实际上，会发生以下情况：当一个元素出现在作用域中时，会触发一个函数来确定滚动的方向。但是当元素超出范围时， scrollTracking(); 不会停止工作（并且应该）。

我故意将 $(document).off('scroll', scrollTracking()); 行注释掉，因为这是首先想到的 - 当元素从可见区域隐藏时 - 我删除了 scrollTracking()发挥作用，享受生活。

但实际上，不仅删除了跟踪滚动方式的函数，还删除了确定元素是否在范围内的函数。磨难的第二天 - 没有导致任何事情:(所以我只是给出一个提示。

我将不胜感激

javascript
Martin Hope
yaleksandr89
Asked: 2020-04-01 01:22:31 +0000 UTC
  • 0

有一些类别（类别迁移文件）

public function up():void
{
    Schema::create('blog_categories', static function (Blueprint $table) {
        $table->id();
        $table->bigInteger('parent_id')->unsigned()->default(1);

        $table->string('slug')->unique();
        $table->string('title');
        $table->text('description')->nullable();

        $table->timestamps();
        $table->softDeletes();
    });
}

其中有“基本” 在此处输入图像描述

所有这些类别都与帖子相关联（迁移后文件）

public function up(): void
{
    Schema::create('blog_posts', static function (Blueprint $table) {
        $table->id();
        $table->bigInteger('category_id')->unsigned();
        $table->bigInteger('user_id')->unsigned();

        $table->string('slug')->unique();
        $table->string('title');
        $table->text('excerpt')->nullable();

        $table->string('tdk_title')->nullable();
        $table->text('tdk_description')->nullable();
        $table->text('tdk_keywords')->nullable();

        $table->text('content_raw');
        $table->text('content_html');

        $table->integer('view_count')->default(0);
        $table->boolean('is_published')->default(false);
        $table->timestamp('published_at')->nullable();

        $table->timestamps();
        $table->softDeletes();

        $table->index('is_published');

        //FK
        $table->foreign('user_id')
            ->references('id')
            ->on('users')
            ->onDelete('cascade');
        $table->foreign('category_id')
            ->references('id')
            ->on('blog_categories')
            ->onDelete('cascade');
    });
}

需要解决两个任务：

  1. 防止删除根类别。这没有问题，在 destroy() 中检查 id，如果匹配则返回错误消息。
  2. 删除类别并将所有相关帖子移至根目录。在这里我停滞不前了，如何正确实现它？
laravel
Martin Hope
yaleksandr89
Asked: 2020-03-27 22:08:21 +0000 UTC
  • 0

我无法弄清楚日期格式的本地化。对于输出，当然，我使用 Carbon。所需的区域设置 ( 'locale' => 'ru') 在设置中设置。

我以格式输出日期\Carbon\Carbon::parse($post->published_at)->format('j F Y')，我得到： 在此处输入图像描述

谷歌找到了两个包

  1. 本地化碳- 已过时。
  2. jenssegers/date - 发布显示对 Laravel 7 的最小支持已经添加。但是当你尝试安装时，很多错误都失败了。
Problem 1
    - Conclusion: remove symfony/event-dispatcher-contracts v2.0.1
    - Conclusion: don't install symfony/event-dispatcher-contracts v2.0.1
    - symfony/translation 4.2.x-dev requires symfony/contracts ^1.1.1 -> satisfiable by symfony/contracts[v1.1.1, v1.1.2, v1.1.3, v1.1.4, v1.1.5, v1.1.6, v1.1.7, v1.1.8].
    - symfony/translation v4.2.10 requires symfony/contracts ^1.1.1 -> satisfiable by symfony/contracts[v1.1.1, v1.1.2, v1.1.3, v1.1.4, v1.1.5, v1.1.6, v1.1.7, v1.1.8].
    - symfony/translation v4.2.11 requires symfony/contracts ^1.1.1 -> satisfiable by symfony/contracts[v1.1.1, v1.1.2, v1.1.3, v1.1.4, v1.1.5, v1.1.6, v1.1.7, v1.1.8].
    - symfony/translation v4.2.12 requires symfony/contracts ^1.1.1 -> satisfiable by symfony/contracts[v1.1.1, v1.1.2, v1.1.3, v1.1.4, v1.1.5, v1.1.6, v1.1.7, v1.1.8].
    - symfony/translation v4.2.9 requires symfony/contracts ^1.1.1 -> satisfiable by symfony/contracts[v1.1.1, v1.1.2, v1.1.3, v1.1.4, v1.1.5, v1.1.6, v1.1.7, v1.1.8].
    - don't install symfony/contracts v1.1.1|don't install symfony/event-dispatcher-contracts v2.0.1
    - don't install symfony/contracts v1.1.2|don't install symfony/event-dispatcher-contracts v2.0.1
    - don't install symfony/contracts v1.1.3|don't install symfony/event-dispatcher-contracts v2.0.1
    - don't install symfony/contracts v1.1.4|don't install symfony/event-dispatcher-contracts v2.0.1
    - don't install symfony/contracts v1.1.5|don't install symfony/event-dispatcher-contracts v2.0.1
    - don't install symfony/contracts v1.1.6|don't install symfony/event-dispatcher-contracts v2.0.1
    - don't install symfony/contracts v1.1.7|don't install symfony/event-dispatcher-contracts v2.0.1
    - don't install symfony/contracts v1.1.8|don't install symfony/event-dispatcher-contracts v2.0.1
    - Installation request for symfony/event-dispatcher-contracts (locked at v2.0.1) -> satisfiable by symfony/event-dispatcher-contracts[v2.0.1].
    - Installation request for jenssegers/date ^3.5 -> satisfiable by jenssegers/date[v3.5.0].
    - Conclusion: don't install symfony/http-kernel v5.0.5|install symfony/translation 4.2.x-dev|install symfony/translation v4.2.10|install symfony/translation v4.2.11|install symfony/translation v4.2.12|install symfony/translation v4.2.9
    - Conclusion: remove symfony/http-kernel v5.0.5|install symfony/translation 4.2.x-dev|install symfony/translation v4.2.10|install symfony/translation v4.2.11|install symfony/translation v4.2.12|install symfony/translation v4.2.9
    - jenssegers/date v3.5.0 requires symfony/translation ^2.7|^3.0|^4.0 -> satisfiable by symfony/translation[2.7.x-dev, 2.8.x-dev, 3.0.x-dev, 3.1.x-dev, 3.2.x-dev, 3.3.x-dev, 3.4.x-dev, 4.0.x-dev, 4.1.x-dev, 4.2.x-dev, 4.3.x-dev, 4.4.x-dev, v2.7.0, v2.7.0-BETA1, v2.7.0-BETA2, v2.7.1, v2.7.10, v2.7.11, v2.7.12, v2.7.13, v2.7.14, v2.7.15, v2.7.16, v2.7.17, v2.7.18, v2.7.19, v2.7.2, v2.7.20, v2.7.21, v2.7.22, v2.7.23, v2.7.24, v2.7.25, v2.7.26, v2.7.27, v2.7.28, v2.7.29, v2.7.3, v2.7.30, v2.7.31, v2.7.32, v2.7.33, v2.7.34, v2.7.35, v2.7.36, v2.7.37, v2.7.38, v2.7.39, v2.7.4, v2.7.40, v2.7.41, v2.7.42, v2.7.43, v2.7.44, v2.7.45, v2.7.46, v2.7.47, v2.7.48, v2.7.49, v2.7.5, v2.7.50, v2.7.51, v2.7.6, v2.7.7, v2.7.8, v2.7.9, v2.8.0, v2.8.0-BETA1, v2.8.1, v2.8.10, v2.8.11, v2.8.12, v2.8.13, v2.8.14, v2.8.15, v2.8.16, v2.8.17, v2.8.18, v2.8.19, v2.8.2, v2.8.20, v2.8.21, v2.8.22, v2.8.23, v2.8.24, v2.8.25, v2.8.26, v2.8.27, v2.8.28, v2.8.29, v2.8.3, v2.8.30, v2.8.31, v2.8.32, v2.8.33, v2.8.34, v2.8.35, v2.8.36, v2.8.37, v2.8.38, v2.8.39, v2.8.4, v2.8.40, v2.8.41, v2.8.42, v2.8.43, v2.8.44, v2.8.45, v2.8.46, v2.8.47, v2.8.48, v2.8.49, v2.8.5, v2.8.50, v2.8.52, v2.8.6, v2.8.7, v2.8.8, v2.8.9, v3.0.0, v3.0.0-BETA1, v3.0.1, v3.0.2, v3.0.3, v3.0.4, v3.0.5, v3.0.6, v3.0.7, v3.0.8, v3.0.9, v3.1.0, v3.1.0-BETA1, v3.1.0-RC1, v3.1.1, v3.1.10, v3.1.2, v3.1.3, v3.1.4, v3.1.5, v3.1.6, v3.1.7, v3.1.8, v3.1.9, v3.2.0, v3.2.0-BETA1, v3.2.0-RC1, v3.2.0-RC2, v3.2.1, v3.2.10, v3.2.11, v3.2.12, v3.2.13, v3.2.14, v3.2.2, v3.2.3, v3.2.4, v3.2.5, v3.2.6, v3.2.7, v3.2.8, v3.2.9, v3.3.0, v3.3.0-BETA1, v3.3.0-RC1, v3.3.1, v3.3.10, v3.3.11, v3.3.12, v3.3.13, v3.3.14, v3.3.15, v3.3.16, v3.3.17, v3.3.18, v3.3.2, v3.3.3, v3.3.4, v3.3.5, v3.3.6, v3.3.7, v3.3.8, v3.3.9, v3.4.0, v3.4.0-BETA1, v3.4.0-BETA2, v3.4.0-BETA3, v3.4.0-BETA4, v3.4.0-RC1, v3.4.0-RC2, v3.4.1, v3.4.10, v3.4.11, v3.4.12, v3.4.13, v3.4.14, v3.4.15, v3.4.16, v3.4.17, v3.4.18, v3.4.19, v3.4.2, v3.4.20, v3.4.21, v3.4.22, v3.4.23, v3.4.24, v3.4.25, v3.4.26, v3.4.27, v3.4.28, v3.4.29, v3.4.3, v3.4.30, v3.4.31, v3.4.32, v3.4.33, v3.4.34, v3.4.35, v3.4.36, v3.4.37, v3.4.38, v3.4.4, v3.4.5, v3.4.6, v3.4.7, v3.4.8, v3.4.9, v4.0.0, v4.0.0-BETA1, v4.0.0-BETA2, v4.0.0-BETA3, v4.0.0-BETA4, v4.0.0-RC1, v4.0.0-RC2, v4.0.1, v4.0.10, v4.0.11, v4.0.12, v4.0.13, v4.0.14, v4.0.15, v4.0.2, v4.0.3, v4.0.4, v4.0.5, v4.0.6, v4.0.7, v4.0.8, v4.0.9, v4.1.0, v4.1.0-BETA1, v4.1.0-BETA2, v4.1.0-BETA3, v4.1.1, v4.1.10, v4.1.11, v4.1.12, v4.1.2, v4.1.3, v4.1.4, v4.1.5, v4.1.6, v4.1.7, v4.1.8, v4.1.9, v4.2.0, v4.2.0-BETA1, v4.2.0-BETA2, v4.2.0-RC1, v4.2.1, v4.2.10, v4.2.11, v4.2.12, v4.2.2, v4.2.3, v4.2.4, v4.2.5, v4.2.6, v4.2.7, v4.2.8, v4.2.9, v4.3.0, v4.3.0-BETA1, v4.3.0-BETA2, v4.3.0-RC1, v4.3.1, v4.3.10, v4.3.11, v4.3.2, v4.3.3, v4.3.4, v4.3.5, v4.3.6, v4.3.7, v4.3.8, v4.3.9, v4.4.0, v4.4.0-BETA1, v4.4.0-BETA2, v4.4.0-RC1, v4.4.1, v4.4.2, v4.4.3, v4.4.4, v4.4.5, v4.4.6].
    - symfony/translation 4.0.x-dev conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation 4.1.x-dev conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation 4.3.x-dev conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation 4.4.x-dev conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.0 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.0-BETA1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.0-BETA2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.0-BETA3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.0-BETA4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.0-RC1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.0-RC2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.10 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.11 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.12 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.13 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.14 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.15 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.5 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.6 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.7 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.8 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.0.9 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.0 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.0-BETA1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.0-BETA2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.0-BETA3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.10 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.11 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.12 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.5 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.6 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.7 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.8 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.1.9 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.2.0 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.2.0-BETA1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.2.0-BETA2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.2.0-RC1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.2.1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.2.2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.2.3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.2.4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.2.5 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.2.6 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.2.7 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.2.8 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.0 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.0-BETA1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.0-BETA2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.0-RC1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.10 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.11 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.5 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.6 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.7 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.8 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.3.9 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.4.0 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.4.0-BETA1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.4.0-BETA2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.4.0-RC1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.4.1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.4.2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.4.3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.4.4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.4.5 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v4.4.6 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation 3.4.x-dev conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.0 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.0-BETA1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.0-BETA2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.0-BETA3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.0-BETA4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.0-RC1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.0-RC2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.10 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.11 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.12 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.13 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.14 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.15 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.16 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.17 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.18 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.19 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.20 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.21 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.22 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.23 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.24 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.25 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.26 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.27 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.28 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.29 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.30 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.31 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.32 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.33 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.34 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.35 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.36 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.37 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.38 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.5 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.6 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.7 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.8 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.4.9 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation 2.7.x-dev conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation 2.8.x-dev conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation 3.0.x-dev conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation 3.1.x-dev conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation 3.2.x-dev conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation 3.3.x-dev conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.0 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.0-BETA1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.0-BETA2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.10 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.11 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.12 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.13 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.14 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.15 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.16 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.17 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.18 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.19 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.20 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.21 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.22 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.23 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.24 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.25 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.26 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.27 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.28 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.29 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.30 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.31 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.32 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.33 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.34 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.35 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.36 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.37 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.38 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.39 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.40 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.41 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.42 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.43 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.44 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.45 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.46 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.47 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.48 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.49 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.5 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.50 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.51 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.6 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.7 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v2.7.8 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.0.0 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.0.0-BETA1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.0.1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.0.2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.0.3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.0.4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.0.5 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.0.6 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.0.7 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.0.8 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.0.9 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.0 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.0-BETA1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.0-RC1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.10 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.5 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.6 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.7 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.8 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.1.9 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.0 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.0-BETA1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.0-RC1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.0-RC2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.10 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.11 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.12 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.13 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.14 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.5 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.6 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.7 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.8 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.2.9 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.0 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.0-BETA1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.0-RC1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.1 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.10 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.11 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.12 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.13 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.14 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.15 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.16 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.17 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.18 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.2 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.3 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.4 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.5 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.6 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.7 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.8 conflicts with symfony/http-kernel[v5.0.5].
    - symfony/translation v3.3.9 conflicts with symfony/http-kernel[v5.0.5].
    - Installation request for symfony/http-kernel (locked at v5.0.5) -> satisfiable by symfony/http-kernel[v5.0.5].

告诉我这个包的替代方案或更正确的本地化日期的方法。之前没遇到过这个问题，最近开始学习Laravel。

谢谢！

laravel
Martin Hope
yaleksandr89
Asked: 2020-03-25 08:08:52 +0000 UTC
  • 2

获取现有记录的数量（显示在面板上）

class DashboardController extends AdminController
{
    public function dashboard()
    {
        $params = [
            'categoriesCount' => BlogCategory::count(),
            'postsCount' => BlogPost::count(),
            //'bookmarksCount' => BlogBookmark::count(),
            'bookmarksCount' => DB::table('blog_bookmarks')->count(),
            'usersCount' => User::count(),
        ];
        return view('admin.dashboard')->with($params);
    }
}

我遇到了一个问题，当我发出请求时'bookmarksCount' => BlogBookmark::count()，我得到一个错误，因为表中没有字段'create_at'（'deleted_at'这是一个链接表，所以创建这些字段以及 id 字段没有意义）。

获取此表中使用的记录数bookmarksCount' => DB::table('blog_bookmarks')->count(),

这是多么“正确”，是否有一种方法可以让您“直接”使用 BlogBookmark 模型（缺少“created_at”、“deleted_at”字段）而不是通过 DB 门面获取记录数。

不久前开始研究这个框架，文档一直在我眼前。我不止一次地通过eloquent-model-conventions，但我仍然不知道我是否做对了？如果没有，那么如何正确地做到这一点。

我将衷心感谢您的帮助！

laravel
Martin Hope
yaleksandr89
Asked: 2020-10-09 01:21:27 +0000 UTC
  • 0

为了培训，我决定编写一个缩短链接的服务。我目前面临以下问题：

添加尚未在数据库中的链接时，行为不太正确。让我解释一下 - 在输入中我插入需要缩短的链接。我按下提交，就是这样:) 页面被重新加载，链接被缩短并添加到数据库中。

要查看生成的链接，您需要引发错误，即尝试再次缩短此链接。为了更直观的展示，上传到主机

目前，我对 3 个选项感兴趣，然后这个组件将适合我（我计划将来将它添加到另一个实现中）。

1.基于问题，我想实现从数据库加载ajax数据。 一个小插曲，我知道谁这样写：

foreach ($sth as $existLink) {
      echo '<h1>...</h1>';
      echo '<ul>';
      echo '<li>...</li>';
      echo '</ul>';
}

他们在赌注中燃烧 :)，但这是一个草案，现在我正在处理功能的实现，我将把“美”带到终点线。所以我会原谅你））

负责处理和缩短链接的文件：

<?php
include_once(__DIR__ . '/libraries/database.php');
$externalLink = $_POST['external_link'] ?? null;

function prepareExternalLink($link)
{
    $result = trim($link);
    $result = htmlspecialchars($result);
    return $result;
}

$preparedLink = prepareExternalLink($externalLink);
$sth = db_query("SELECT url, short_key FROM short WHERE url= '" . $preparedLink . "'");

if (empty($_POST['external_link'])) {
    echo 'Введите в поле ссылку, которую требуется сократь:';
} elseif (isset(db_query("SELECT url FROM short WHERE url= '" . $preparedLink . "'")->fetch()['url'])) {
// Должна подгружаться ajax    
foreach ($sth as $existLink) {
        echo '<h1>Такая ссылка уже есть в БД</h1>';
        echo '<ul>';
        echo '<li><strong>Внешняя ссылка</strong>: <a href="' . $existLink['url'] . '" target="_blank">' . $existLink['url'] . '</a></li>';
        echo '<li><strong>Сокращенная ссылка</strong>: <a href="//' . $_SERVER['HTTP_HOST'] . '/&' . $existLink['short_key'] . '" target="_blank">http://' . $_SERVER['HTTP_HOST'] . '/&' . $existLink['short_key'] . '</a></li>';
        echo '</ul>';
    }
} else {
    /*---- Генерация уникального id----*/
    $letters = 'qwertyuiopasdfghjklzxcvbnm1234567890';
    $count = strlen($letters);
    $intval = time();
    $result = '';
    for ($i = 0; $i < 4; $i++) {
        $last = $intval % $count;
        $intval = ($intval - $last) / $count;
        $result .= $letters[$last];
    }
    /*---- INSERT link in db---*/
    $sthInsert = db_query("INSERT INTO short (url,short_key) VALUE (:original_link, :short_key)", [
        'original_link' => $preparedLink,
        'short_key' => $result . $intval
    ]);

// Ajax – появляется информация о добавленной ссылке

}
?>

<form style="margin-top: 10px;" method="post">
    <input type="text" name="external_link">
    <input type="submit" name="submit">
</form>

我用谷歌搜索的所有内容都无法适应我的任务......也许有人知道你可以在哪里看到类似的例子。

数据库我不是经常碰到，但是这里我也需要通过ajax来做。原则上，我进行了查询（不是在本机 j 上，而是在 jquery - 表单验证上），但是这里的数据库和我有点迷失了。

  1. 关于重定向。生成的缩短链接如下所示：example.com/&8hde935。如何制作没有特殊字符的缩短链接（在我的例子中，一个＆符号），即example.com/8hde935。

.htaccess

DirectoryIndex index.php
Options -Indexes
Options +FollowSymLinks
php_flag register_globals off

RewriteEngine on
RewriteRule ^&(.*) /redirect.php?key=$1 [L]

重定向

<?php
include_once(__DIR__ . '/libraries/database.php');
$key = htmlspecialchars($_GET['key']) ?? null;
if (isset(db_query("SELECT url, short_key FROM short WHERE short_key= '" . $key . "'")->fetch()['url'])) {
    $sthSelectSingle = db_query("SELECT url, short_key FROM short WHERE short_key= '" . $key . "'");
    header('HTTP/1.1 301 Moved Permanently');
    header('Location:' . $sthSelectSingle->fetch(PDO::FETCH_OBJ)->url);
} else {
    exit('Ошибка при переадресации');
}

我知道是这种情况RewriteRule ^&(.*) /redirect.php?key=$1 [L]，但我无法重写规则:(。

  1. 计算链接的点击次数。这个问题仍然是理论上的，但由于我寻求帮助，他们可以定位（到目前为止，没有具体细节）。如何计算缩短链接的点击次数？有一个假设是通过 cookie，但我不确定，我以前没有遇到过。

目前我有 1 个表 3 个字段（id、url、short_key）。我将补充表格，将来我将制作一个管理面板，其中包含有关已保存链接的信息。

php