wordpress商品信息整理并通过Django管理 前言{callout color="#f0ad4e"}通过上一篇文章： wordpress直接通过数据库导出文章标题、分类信息到xls表格 ，将数据导入到excel表格中了。在处理的过程中发现仍然不是很方便，一是数据量有点大，每次打开更新需要的的时间有点久。另外无法统计分析。于是想把它输入到自己的数据库中，方便处理查看查询。{/callout}Django添加新模块resource{message type="success" content="models.py 建立数据库模型"/}from django.db import models #状态 U = 0 Y = 1 N = 2 STATUS_CHOICE = { U: '未处理', Y: '可用', N: '不可用', } # Create your models here. class Resource(models.Model): ''' 任务模型类 ''' id = models.AutoField(primary_key=True) rid = models.CharField(max_length=16, verbose_name='编号', default='0') rtitle = models.CharField(max_length=256, verbose_name='标题') rcontent = models.TextField(max_length=2048*8, verbose_name='说明') rparent1 = models.CharField(max_length=128, verbose_name='一级分类', default='0') rparent2 = models.CharField(max_length=128, verbose_name='二级分类', default='1') rurl = models.CharField(max_length=256, verbose_name='下载链接', default='0') rpwd = models.CharField(max_length=256, verbose_name='解压密码', default='0') status_choices = ((k, v) for k,v in STATUS_CHOICE.items()) rstatus = models.SmallIntegerField(default='0', choices=status_choices, verbose_name='状态') # admin显示订单的id def __str__(self): return self.rtitle class Meta: db_table = 'code_resource' verbose_name = '源码资源' verbose_name_plural = '源码资源'{message type="success" content="更新数据库"/}# 修改项目settings.py,添加模块 INSTALLED_APPS = [ ... 'resource', ... ], # 更新 python3 manage.py makemigrations python3 manage.py migrate{message type="success" content="查看建库语句"/}show create table code_resource;待处理资源wordpress数据库操作{message type="success" content="创建code_resource表"/}CREATE TABLE `code_resource` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rid` varchar(16) COLLATE utf8_bin NOT NULL, `rtitle` varchar(256) COLLATE utf8_bin NOT NULL, `rcontent` longtext COLLATE utf8_bin NOT NULL, `rparent1` varchar(128) COLLATE utf8_bin NOT NULL, `rparent2` varchar(128) COLLATE utf8_bin NOT NULL, `rurl` varchar(256) COLLATE utf8_bin NOT NULL, `rpwd` varchar(256) COLLATE utf8_bin NOT NULL, `rstatus` smallint(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=60031 DEFAULT CHARSET=utf8 COLLATE=utf8_bin隐藏内容，请前往内页查看详情{message type="success" content="数据迁移处理"/}# 导出 mysqldump -uroot -pxxxx -h 127.0.0.1 yonp code_resource > code_resource.sql # 导入 mysql -uroot -pxxxx taskmonitor < code_resource.sql数据展示{message type="success" content="修改Django项目resource模块的admin.py文件"/}隐藏内容，请前往内页查看详情{card-default label="效果" width="90%"}{/card-default}FAQdjango 数据库更新抱错后，重新执行# 确保存在文件 resource/migrations/__init__.py # 登录数据库,清理resource模块记录 select * from django_migrations;

wordpress直接通过数据库导出文章标题、分类信息到xls表格 前言{callout color="#f0ad4e"}收集了一个基于wordpress的资源站数据库，在整理数据的过程中，想将文章标题等导入到excel的表格中方便查看。下面是导出过程。{/callout}表名相关字段说明wp_termsterm_id, name标签,分类,链接wp_postspost_title,post_content,post_status,post_type文章表wp_linkslink_id,link_url,link_name友链表wp_term_taxonomyterm_taxonomy_id,term_id,parent,taxonomy分类信息wp_term_relationshipsobject_id,term_taxonomy_id,term_order关联表导出语句select a.post_title, (select name from wp_terms where term_id = b.parent) as parent1, c.name as parent2 into outfile '/tmp/yuanma4.csv' CHARACTER SET utf8 FIELDS TERMINATED BY '|' from wp_term_taxonomy b join wp_terms c on b.term_id = c.term_id join wp_term_relationships d on b.term_taxonomy_id = d.term_taxonomy_id join wp_posts a on a.ID = d.object_id where b.taxonomy = 'category' and b.parent != 0;csv转xls# 数据处理 vim打开文件，替换特殊符号"," %s /,/，/g cat yuanma4.csv | awk -F'|' '{print $1","$2","$3}' > yuanma.csv{message type="success" content="csv转换为xls，可以通过mac的numbers进行。"/}{card-default label="数据内容" width="75%"}{/card-default}带下载链接的升级版本导出数据select a.ID, a.post_title, (select name from wp_terms where term_id = b.parent) as parent1, c.name as parent2, e.meta_value into outfile '/tmp/yuanma5.csv' CHARACTER SET utf8 FIELDS TERMINATED BY '|' from wp_term_taxonomy b join wp_terms c on b.term_id = c.term_id join wp_term_relationships d on b.term_taxonomy_id = d.term_taxonomy_id join wp_posts a on a.ID = d.object_id join wp_postmeta e on a.ID = e.post_id where b.taxonomy = 'category' and e.meta_key = '_riplus_down_info' and b.parent != 0;数据处理cat yuanma5.csv | awk -F'[|"]' '{print $1","$2","$3","$4","$12","$16}'

RiPro-V2主题虚拟资源商城部署与使用 前言{callout color="#f0ad4e"}一直想做一个虚拟资源商城，最近选择了 RiPro-V2主题 ，RiPro-V2主题是看到第一眼就非常喜欢。具体就不介绍了，可以自己看官网介绍。花了一段时间终于部署好了，特此记录部署过程。{/callout}{card-default label="商城首页" width="85%"}{/card-default}部署{message type="success" content="首先部署lnmp环境,然后下载最新的wordpress版本，最后上传RiPro-V2主题并配置。"/}lnmp架构部署参考 基于docker部署wordpress外贸电商平台RiPro-V2主题{callout color="#f0ad4e"}RiPro-V2主题采用会员制,获取后不限域名，不限时间。还是比较良心的。 购买链接 {/callout}{message type="success" content="获取后直接上传到 wp-content/themes/ 目录下，通过后台启用就可以了。"/}主题配置{callout color="#f0ad4e"}可以参考官方的配置文档: 主题介绍 · RiPro-V2主题文档 · 看云 {/callout}伪静态和固定链接{message type="success" content="nginx.conf 配置"/}server { listen 82; server_name 0.0.0.0; root /www/web/wordpress/; server_tokens off; include none.conf; index index.php index.html index.htm; access_log /www/web_logs/store_access.log wwwlogs; error_log /www/web_logs/store_error.log notice; client_max_body_size 50m; location ~ \.php$ { fastcgi_pass php:9000; fastcgi_index index.php; include fcgi.conf; fastcgi_buffers 8 4K; fastcgi_buffer_size 4K; } location ~* \.(eot|ttf|woff|woff2|svg)$ { add_header Access-Control-Allow-Origin *; add_header Access-Control-Allow-Headers X-Requested-With; add_header Access-Control-Allow-Methods GET,POST,OPTIONS; } rewrite /wp-admin$ $scheme://$host$uri/ permanent; location ~ .*\.(gif|jpg|jpeg|png|bmp|swf)$ { expires 30d; } location ~ .*\.(js|css)?$ { expires 12h; } }{message type="success" content="后台设置: 设置->固定链接->自定义结构"/}{card-default label="固定链接" width="75%"}{/card-default}FAQPHP启用swoole.so扩展# 手动安装 docker exec -it myblog_php_1 bash apt-get update apt-get install build-essential pecl install swoole # 主题官方资源 cd /usr/local/lib/php/extensions/no-debug-non-zts-20190902/ wget https://business.swoole.com/static/loader2.2.0/swoole_loader74.so # 修改php.ini配置 extension=swoole.so重定向次数过多{message type="error" content="访问后台，提示重定向次数过多。"/}# 因为本站架构为前端 nginx 启用https 代理后端 http 模式 # 后台将网站所有链接改为 https # 修改 wp-config.php,新增配置 $_SERVER['HTTPS'] = 'on'; define('FORCE_SSL_LOGIN', true); define('FORCE_SSL_ADMIN', true);普通用户登录抱错{callout color="#f0ad4e"}普通用户通过wordpress默认后台登录抱错，页面空白。{/callout}{message type="success" content="解决办法：除admin外,全部通过商城前端登录页面进入"/}管理后台添加跳转个人中心菜单{callout color="#f0ad4e"}管理员登录后台后，没办法直接调转到主题的用户中心{/callout}/* * 编辑文件:wp-content/themes/ripro-v2/functions.php * 添加一个简单的菜单 * 自行修改 'title' 和 'href' 的值 */ function custom_adminbar_menu( $meta = TRUE ) { global $wp_admin_bar; if ( !is_user_logged_in() ) { return; } if ( !is_super_admin() || !is_admin_bar_showing() ) { return; } $wp_admin_bar->add_menu( array( 'id' => 'custom_menu', 'title' => __( '个人中心' ), 'href' => '/user', )); } add_action( 'admin_bar_menu', 'custom_adminbar_menu', 50 ); /* add_action # 后面的数字表示位置： 10 = 在 Logo 的前面 15 = 在 logo 和 网站名之间 25 = 在网站名后面 100 = 在菜单的最后面 */{card-default label="效果" width="75%"}{/card-default}

使用wordpress快速建设企业官网 {card-default label="企业官网" width="90%"}{/card-default}前言{callout color="#f0ad4e"}企业官网是企业在网上展示的窗口，如何利用wordpress快速部署一个企业展示官网{/callout}部署{card-describe title="准备资源"} 一台vps主机 可以采用腾讯云香港节点（不用备案），建议配置：2核4G内存50G硬盘5M带宽 vps购买链接 如果企业在国内不做外贸的话，建议还是用国内节点。备案一两周也就可以了。访问速度会更快，客户体验比较好。一个域名 准备一个域名，解析到vps公网地址{/card-describe}系统初始化参考文章： docker和docker-compose一键安装脚本部署wordpress参考文章: 基于docker部署wordpress外贸电商平台安装主题免费主题{callout color="#f0ad4e"}wordpress安装完成后,通过后台登录,选择“外观”->“主题”->“添加新主题”，搜索框输入关键字，然后选择喜欢的主题安装即可。{/callout}{card-default label="后台搜索，并安装主题" width="70%"}{/card-default}付费主题{callout color="#f0ad4e"}免费的主题制作的已经非常漂亮了，但是大部分是国外的。可能不是符合国人的使用习惯。可以去网络上一些wordpress主题站点搜索，发现中意的wordpress主题后，获取zip包。然后上传安装即可。我自己使用的mxtheme02的主题（头部图片），就是比较贵，500元对于草根站长来说，算是一笔巨款了。mxtheme02官网 {/callout}{card-default label="主题安装" width="75%"}{/card-default}FAQ访问报错no input file specifide{card-describe title="解决办法"}检查项目目录下的隐藏文件,如.user.ini,有则去掉。{/card-describe}

基于docker部署WooCommerce外贸电商平台 前言WooCommerce 是一个基于 WordPress 的可定制的开源电子商务平台。WordPress是使用PHP语言开发的内容管理系统,又叫做Content Management System（CMS）,全球使用的人最多，是免费开源的建站系统。WordPress有许多第三方开发的免费模板，安装方式简单易用。{card-describe title="优点"}功能强大、扩展性强，插件众多，易于扩充功能，基本上一个完整网站该有的功能，通过其第三方插件都能实现所有功能；seo对搜索引擎友好，收录也快，排名靠前；适合DIY。主题多，各色各样，应有尽有！导入导出方便强大的社区支持{/card-describe}{card-default label="wordpress外贸站" width="90%"} {/card-default}部署准备资源一台vps主机{alert type="success"}可以采用腾讯云香港节点（不用备案），建议配置：2核4G内存50G硬盘5M带宽 购买链接{/alert}一个域名{alert type="success"}准备一个域名，并解析到vps公网地址{/alert}系统初始化{card-describe title="所做工作"}包括设置yum源安装基础软件包修改系统限制优化history命令记录内核优化安全设置时区同步登录欢迎语设置安装docker和docker-compose{/card-describe}参考文章 docker和docker-compose一键安装脚本 部署wordpress获取源码获取wordpress最新源码: 最新版下载地址基于docker的lnmp项目配置文件：隐藏内容，请前往内页查看详情解压并更改目录权限tar xvf latest.tar.gz -C /opt/lnmp/app/ cd /opt/lnmp/app/ && mv wordpress wp #更改目录权限 useradd -u 1010 www-data -s /usr/sbin/nologin chown -R www-data /opt/lnmp/app/wp/nginx配置cp support/web.conf.example services/nginx/conf/conf.d/wp.conf{card-describe title="wp.conf"}server { listen 80; server_name www.wpshop.com; #改成自己的域名 root /www/web/wp/; #项目目录,在app目录下 server_tokens off; include none.conf; index index.php index.html index.htm; access_log /www/web_logs/access.log wwwlogs; error_log /www/web_logs/error.log notice; location ~ \.php$ { fastcgi_pass php:9000; fastcgi_index index.php; include fcgi.conf; } location ~ .*\.(gif|jpg|jpeg|png|bmp|swf)$ { expires 30d; } location ~ .*\.(js|css)?$ { expires 12h; } }{/card-describe}启动服务cd /opt/lnmp/ && docker-compose up -d创建数据库并授权#登录 mysql -uroot -pmariadb@123 -h 127.0.0.1{card-describe title="执行sql"}CREATE DATABASE `wp` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; create user 'wpuser'@'%' IDENTIFIED BY 'wpuser123'; grant all privileges on wp.* to 'wpuser'@'%'; flush privileges;{/card-describe}通过web安装配置域名解析，然后通过浏览器访问，按照提示安装{card-default label="安装页面" width="75%"} {/card-default}{card-default label="配置数据库" width="75%"} {/card-default}{card-default label="完成" width="75%"} {/card-default}配置安装主题可以通过搜索关键字搜索相关主题并安装{card-default label="主题" width="80%"}{/card-default}修改主题{message type="success" content="外观->主题->自定义"/}插件多语言插件{message type="success" content="Translate WordPress with GTranslate"/}{card-default label="配置" width="75%"}{/card-default}多币种插件{message type="success" content="Currency Switcher for WooCommerce"/}{card-default label="效果" width="75%"}{/card-default}{message type="success" content="免费版支持两种币种"/}二开第三方支付插件WooCommerce对接第三方支付插件开发WooCommerce对接第三方支付插件开发(二)WooCommerce对接第三方支付插件开发(三)FAQ无法创建配置文件,安装失败{card-describe title="解决办法"}检查目录权限{/card-describe}域名迁移{message type="success" content="wpe.superxshop.com -> global.kingmarkshop.com"/}#登录数据库 UPDATE wp_options SET option_value = replace( option_value, 'http://wpe.superxshop.com', 'http://global.kingmarkshop.com' ) WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET post_content = replace( post_content, 'http://wpe.superxshop.com', 'http://global.kingmarkshop.com' ) ; UPDATE wp_posts SET guid = replace( guid, 'http://wpe.superxshop.com', 'http://global.kingmarkshop.com' ) ;

centos7安装配置wordpress博客系统 {card-default label="wordpress" width="75%"}{/card-default}前言{card-default label="LAMP架构的介绍" width="100"}LAMP是 linux Apache MySQL PHP的简写，即把Apache MySQL PHP 安装在linux系统上，组成一个环境来运行PHP网站。这里的Apache是httpd服务。这些可以安装在一个机器上，也可以安装在多台机器上，但是httpd和PHP安装在一台机器上（php作为httpd的一个模块存在的。 他们两者必须要在一起，才能实现效果）{/card-default}安装配置apache+php服务{card-default label="视频1" width="80%"}{bilibili bvid="BV1jA411u75e" page="wordpress博客配置"/}{/card-default}apache和php安装命令yum install httpd httpd-devel yum -y install epel-release yum -y install https://rpms.remirepo.net/enterprise/remi-release-7.rpm yum -y install yum-utils yum-config-manager --enable remi-php74 yum -y install php php-cli php-fpm php-mysqlnd php-zip php-devel php-gd php-mcrypt php-mbstring php-curl php-xml php-pear php-bcmath php-json php-redisphp配置优化{card-describe title="php-fpm.conf"}[global] pid = /var/run/php-fpm/php-fpm.pid error_log = /opt/servicelogs/php-fpm/error.log daemonize = yes include=/etc/php-fpm.d/*.conf{/card-describe}{card-describe title="php-fpm.d/www.conf"}[www] listen = /var/run/php-fpm/php-fpm.sock ;listen = 127.0.0.1:9000 listen.allowed_clients = 127.0.0.1 listen.owner = nginx listen.group = nginx listen.mode = 0660 listen.backlog = 16384 user = nginx group = nginx pm = static pm.max_children = 20 pm.start_servers = 10 pm.min_spare_servers = 10 pm.max_spare_servers = 35 pm.max_requests = 10000 request_terminate_timeout = 180 request_slowlog_timeout = 30 slowlog = /opt/servicelogs/php-fpm/www-slow.log ;access.log = /opt/servicelogs/php-fpm/access.$pool.log ;access.format = "%R - %u %t \"%m %r%Q%q\" %s %f %{seconds}d %{megabytes}M %{user}C%%" ping.path = /php5fpm-ping pm.status_path = /php5fpm-status{/card-describe}{card-describe title="php.ini"}[PHP] engine = On short_open_tag = Off precision = 14 output_buffering = 4096 zlib.output_compression = Off implicit_flush = Off unserialize_callback_func = serialize_precision = 17 disable_functions = disable_classes = zend.enable_gc = On expose_php = On max_execution_time = 30 max_input_time = 60 memory_limit = 128M error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT display_errors = Off display_startup_errors = Off log_errors = On log_errors_max_len = 1024 ignore_repeated_errors = Off ignore_repeated_source = Off report_memleaks = On track_errors = Off html_errors = On variables_order = "GPCS" request_order = "GP" register_argc_argv = Off auto_globals_jit = On post_max_size = 256M auto_prepend_file = auto_append_file = default_mimetype = "text/html" default_charset = "UTF-8" doc_root = user_dir = enable_dl = Off file_uploads = On upload_max_filesize = 2M max_file_uploads = 20 allow_url_fopen = On allow_url_include = Off default_socket_timeout = 60 [CLI Server] cli_server.color = On [Date] [filter] [iconv] [intl] [sqlite] [sqlite3] [Pcre] pcre.jit=0 [Pdo] [Pdo_mysql] pdo_mysql.cache_size = 2000 pdo_mysql.default_socket= [Phar] [mail function] sendmail_path = /usr/sbin/sendmail -t -i mail.add_x_header = On [SQL] sql.safe_mode = Off [ODBC] odbc.allow_persistent = On odbc.check_persistent = On odbc.max_persistent = -1 odbc.max_links = -1 odbc.defaultlrl = 4096 odbc.defaultbinmode = 1 [Interbase] ibase.allow_persistent = 1 ibase.max_persistent = -1 ibase.max_links = -1 ibase.timestampformat = "%Y-%m-%d %H:%M:%S" ibase.dateformat = "%Y-%m-%d" ibase.timeformat = "%H:%M:%S" [MySQLi] mysqli.max_persistent = -1 mysqli.allow_persistent = On mysqli.max_links = -1 mysqli.cache_size = 2000 mysqli.default_port = 3306 mysqli.default_socket = mysqli.default_host = mysqli.default_user = mysqli.default_pw = mysqli.reconnect = Off [mysqlnd] mysqlnd.collect_statistics = On mysqlnd.collect_memory_statistics = Off [PostgreSQL] pgsql.allow_persistent = On pgsql.auto_reset_persistent = Off pgsql.max_persistent = -1 pgsql.max_links = -1 pgsql.ignore_notice = 0 pgsql.log_notice = 0 [bcmath] bcmath.scale = 0 [browscap] [Session] session.save_handler = files session.use_strict_mode = 0 session.use_cookies = 1 session.use_only_cookies = 1 session.name = PHPSESSID session.auto_start = 0 session.cookie_lifetime = 0 session.cookie_path = / session.cookie_domain = session.cookie_httponly = session.serialize_handler = php session.gc_probability = 1 session.gc_divisor = 1000 session.gc_maxlifetime = 1440 session.referer_check = session.cache_limiter = nocache session.cache_expire = 180 session.use_trans_sid = 0 session.hash_function = 0 session.hash_bits_per_character = 5 url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=fakeentry" [Assertion] zend.assertions = -1 [mbstring] [gd] [exif] [Tidy] tidy.clean_output = Off [soap] soap.wsdl_cache_enabled=1 soap.wsdl_cache_dir="/tmp" soap.wsdl_cache_ttl=86400 soap.wsdl_cache_limit = 5 [sysvshm] [ldap] ldap.max_links = -1 [mcrypt] [dba] [curl] [openssl] [opcache] opcache.enable=1 opcache.memory_consumption=128 opcache.interned_strings_buffer=8 opcache.max_accelerated_files=4000 opcache.revalidate_freq=60 opcache.fast_shutdown=1 opcache.validate_timestamps=0 opcache.file_cache=/tmp{/card-describe}php安装后测试php -v php --modules整体功能测试echo '<?php phpinfo(); ?>' > index.php通过浏览器访问出现下图界面，即php安装正常{card-default label="php测试" width="50%"}{/card-default}安装配置mysql数据库服务{card-default label="视频2" width="80%"}{bilibili bvid="BV1C54y1p7eY" page="wordpress博客配置"/}{/card-default}清除默认的maradbyum list installed | grep mariadb yum -y remove mariadb-libs.x86_64安装依赖包yum install -y perl.x86_64 libaio.x86_64 net-tools.x86_64 perl-Compress-Raw-Bzip2 perl-Compress-Raw-Zlib perl-DBI perl-IO-Compress perl-Net-Daemon perl-PlRPC下载mysql安装包,并安装wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.6/MySQL-client-5.6.51-1.el7.x86_64.rpm wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.6/MySQL-server-5.6.51-1.el7.x86_64.rpm wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.6/MySQL-devel-5.6.51-1.el7.x86_64.rpm yum localinstall MySQL-*配置 mysqlvim /etc/my.cnf配置内容隐藏内容，请前往内页查看详情创建目录，修改目录权限mkdir -p /data/mysql/ /data/logs/ /data/logs/mysql/ chown -R mysql:mysql /data/logs/mysql/数据库初始化mysql_install_db --user=mysql --datadir=/data/mysql systemctl start mysql /usr/bin/mysqladmin -u root password -S /data/mysql/mysql.sock查看mysql服务状态systemctl status mysql安装完成安装配置wordpress博客{card-default label="视频3" width="80%"}{bilibili bvid="BV19t4y1q77A" page="wordpress博客配置"/}{/card-default}下载安装包wget https://wordpress.org/wordpress-5.6.tar.gz wget https://wp101.net/wordpress-5.6.tar.gz解压tar xvf wordpress-5.6.tar.gz sudo mv wordpress /var/www/html/mywordpress/更改代码目录权限chown -R apache:apache /var/www/html/mywordpress/修改配置文件httpd服务的配置vim /etc/httpd/conf/httpd.conf配置内容隐藏内容，请前往内页查看详情重启httpd服务，使配置生效systemctl restart httpd建库授权CREATE DATABASE `wpdb` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin; create user 'wpuser'@'localhost' IDENTIFIED BY 'wpuser123'; grant all privileges on wpdb.* to 'wpuser'@'localhost'; flush privileges;绑定域名到指定IPecho '192.168.88.2 www.mywordpress.com' >> /etc/hosts通过浏览器访问,并配置博客http://www.mywordpress.com/FAQ关闭自动更新//wp-config.php define('AUTOMATIC_UPDATER_DISABLED',true);