te')); return $arr; } /* 遍历用户所有主题 * @param $uid 用户ID * @param int $page 页数 * @param int $pagesize 每页记录条数 * @param bool $desc 排序方式 TRUE降序 FALSE升序 * @param string $key 返回的数组用那一列的值作为 key * @param array $col 查询哪些列 */ function thread_tid_find_by_uid($uid, $page = 1, $pagesize = 1000, $desc = TRUE, $key = 'tid', $col = array()) { if (empty($uid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('uid' => $uid), array('tid' => $orderby), $page, $pagesize, $key, $col); return $arr; } // 遍历栏目下tid 支持数组 $fid = array(1,2,3) function thread_tid_find_by_fid($fid, $page = 1, $pagesize = 1000, $desc = TRUE) { if (empty($fid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('fid' => $fid), array('tid' => $orderby), $page, $pagesize, 'tid', array('tid', 'verify_date')); return $arr; } function thread_tid_delete($tid) { if (empty($tid)) return FALSE; $r = thread_tid__delete(array('tid' => $tid)); return $r; } function thread_tid_count() { $n = thread_tid__count(); return $n; } // 统计用户主题数 大数量下严谨使用非主键统计 function thread_uid_count($uid) { $n = thread_tid__count(array('uid' => $uid)); return $n; } // 统计栏目主题数 大数量下严谨使用非主键统计 function thread_fid_count($fid) { $n = thread_tid__count(array('fid' => $fid)); return $n; } ?>translation - Handling Multilingual Data in Laravel 10 and Vue.js 3 - Stack Overflow

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

    最新消息：雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客
    你的位置： 首页>programmer>translation - Handling Multilingual Data in Laravel 10 and Vue.js 3 - Stack Overflow

    translation - Handling Multilingual Data in Laravel 10 and Vue.js 3 - Stack Overflow

    programmeradmin3浏览0评论

    I'm an entry-level developer working on an e-commerce project using Laravel 10 and Vue.js 3. I've already set up i18n for translations in Vue.js, but now I'm struggling with structuring my database to support multilingual product data.

    The website admin should be able to add products in two languages. I'm wondering if there's a recommended approach, library, or best practice to make this process simpler.

    Should I store translations in separate tables, use JSON columns, or is there a package that helps with this? Any guidance would be greatly appreciated!

    Thanks in advance!

    So far, I’ve considered two possible approaches:

    Using a JSON column in the database to store translations for product names, descriptions, etc. This seems simple but might make querying and filtering data more complicated. Creating a separate translations table with columns like product_id, language, name, and description. This approach seems more structured but adds complexity to queries and relationships. I expected to find a Laravel package that simplifies multilingual database handling, but I haven't found one that fits my case well. I'm looking for guidance on the best approach to balance performance, maintainability, and ease of use.

    与本文相关的文章

    发布评论

    评论列表(0)

    1. 暂无评论