Tag: php

Parse JSON data inside from occurrence of script tag using SimpleHtmlDom – PHP

json parsing php simple-html-dom web-scraping

I am using simple html dom to parse a link that contains two script tags with type=application/ld+json. The target website structure is like below, // tag that I want to parse

Error #1064 in creating function in MySQL

mysql php

friends. I am trying to create function in MySQL using this script: CREATE FUNCTION CurrentMemoDepartment(MID INT) RETURNS INT BEGIN DECLARE DeptID INT; SET DeptID = 0; SELECT TOP 1 TDeptID INTO …

Add Year to NOW()

database mysql php sql

I am trying to add a year to a date going into a SQL database from PHP. I have tried DATEADD(Year,1,NOW()) And various other forms but can’t seem to get it to add a year onto it in SQL. <?php …

WordPress | Loop different col-md

php wordpress

I know the wordpress loop is done like this:

Symfony 4 CollectionType Constraints – array of strings

forms json php symfony validation

I have a very simple array of strings being stored in a database and provided via an API. Using Symfony’s form types I’m adding validation for various bits of data. I’ve hit a wall with a …

Checking for an overlap and if values are already taken

php sql

I’m trying to write an SQL query that must check if an overlap between two hours exists and if certain values are already selected or not. For example, you have a record in a table and you need to …

Get Stripe Customer ID on WordPress / WooCommerce

php stripe-payments woocommerce wordpress

I’m building an e-commerce website which is linked to a mobile app. I would like to store the stripe customer id of a customer on WordPress after his purchase/subscription Is it possible? How? Answer This is possible by using the field : wp__stripe_customer_id