一介資男 nczz

openssh latest

Build, install, and run the latest OpenSSH Server as a systemd service.

openssh latest
- About
- Prepare /opt
apt install

Simple WordPress Bulk Insert

A very simple function to perform bulk SQL inserts, since WPDB doesn't provide one directly. The aim is for simplicity - both in the function itself, and in using it - rather than being a massive beast which covers all possible incorrect usage scenarios. Provide it with clean, consistent data, and it should hopefully be able to do what you want without issue.

Notes:

Provide a table name and an array of associative arrays of rows to insert
Column names are pulled from the first row of data automatically
Make sure you provide the same fields in each row (there's no protection for this)
Data types (for WPDB placeholders) are auto-detected for each individual value (using is_numeric())
There is no protection for exceeding maximum query size (i.e. MySQL's max_allowed_packet); you could pre-batch into smaller "safe" chunks if you need to handle this case - or just find a better way to insert such a large amount of data

psql: FATAL: Peer authentication failed for user “postgres” (or any user)

The connection failed because by default psql connects over UNIX sockets using peer authentication, that requires the current UNIX user to have the same user name as psql. So you will have to create the UNIX user postgres and then login as postgres or use sudo -u postgres psql database-name for accessing the database (and psql should not ask for a password).

If you cannot or do not want to create the UNIX user, like if you just want to connect to your database for ad hoc queries, forcing a socket connection using psql --host=localhost --dbname=database-name --username=postgres (as pointed out by @meyerson answer) will solve your immediate problem.

But if you intend to force password authentication over Unix sockets instead of the peer method, try changing the following pg_hba.conf* line:

from

	<?php
	/**
	* Get Instagram media on WordPress using the current Instagram (Facebook) API
	*
	* @param $token // Info on how to retrieve the token: https://www.gsarigiannidis.gr/instagram-feed-api-after-june-2020/
	* @param $user // User ID can be found using the Facebook debug tool: https://developers.facebook.com/tools/debug/accesstoken/
	* @param int $limit // Add a limit to prevent excessive calls.
	* @param string $fields // More options here: https://developers.facebook.com/docs/instagram-basic-display-api/reference/media
	* @param array $restrict // Available options: IMAGE, VIDEO, CAROUSEL_ALBUM
	*

	<?php
	/**
	* 使用方式：在頁面中建立 "退貨政策" 後，從 [自訂] 中選取退貨政策的頁面，便會出現在結帳頁中。
	* 在 WooCommerce 結帳頁顯示內容。
	*/
	if ( ! function_exists( 'hyc_refund' ) ) {
	function hyc_refund() {
	$pid = get_theme_mod( 'hyc_refund_policy' );
	if ( $pid ) {
	?>

-<?php
-add_action( 'wfacp_internal_css', function () {
-	?>
-    <script>
-        window.addEventListener('load', function () {
-            (function ($) {
-                $('form.checkout').off('keydown', '.address-field input.input-text, .update_totals_on_change input.input-text');
-            })(jQuery);
-        });
-    </script>

	<IfModule mod_rewrite.c>

	RewriteCond %{REQUEST_FILENAME} !-f
	RewriteCond %{REQUEST_FILENAME} !-d
	RewriteRule ^wp-content/uploads/(.*)$ http://www.example.com/wp-content/uploads/$1 [R=302,L,NC]

	</IfModule>

	# BEGIN WordPress
	# ----- WP generated code


	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<title>My FB Reactions Page</title>
	<style>
	html {
	box-sizing: border-box;
	width: 100%;

	<?php
	/**
	* Gravity Wiz // Gravity Forms // Advanced Conditional Logic
	*
	* PLEASE NOTE: This snippet is a proof-of-concept. It is not supported and we have no plans to improve it.
	*
	* Allows multiple groups of conditional logic per field.
	*
	* @version 0.1
	* @author David Smith <[email protected]>

	<?php
	$challenge = $_REQUEST['hub_challenge'];
	$verify_token = $_REQUEST['hub_verify_token'];

	// Set this Verify Token Value on your Facebook App
	if ($verify_token === 'testtoken') {
	echo $challenge;
	}

	$input = json_decode(file_get_contents('php://input'), true);