Hi! Could we please enable some services and cookies to improve your experience and our website?

PHPize Online / SQLize Online  /  SQLtest Online

A A A
Login    Share code      Blog   FAQ

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Copy Format Clear
CREATE TABLE A ( DATA VARCHAR(10) NOT NULL ); INSERT INTO A ( DATA ) VALUES ('a'); INSERT INTO A ( DATA ) VALUES ('b'); SELECT * FROM A;

Stuck with a problem? Got Error? Ask AI support!

Copy Clear
Copy Format Clear
<?php use Carbon\Carbon; $query = "SELECT DATA FROM A;"; // get DB version using PDO $stmt = $pdo->prepare($query); $stmt->execute(); $row = $stmt->fetch(PDO::FETCH_ASSOC); $data = json_decode('{"uid":"1","custName":"ALI BIN AHMAD","identificationType":"N","identificationID":"010101010101","tin":"IG123456789","sst":"A12-3456-78901234","eInvoiceCustomerType":"N","addressLine1":" 123.Main Street","addressLine2":"Apartment #4B, Block C","addressLine3":"10-1, Jalan Bukit Bintang","addressLine4":"Lot 5, Section 8, Phase 2","addressCity":"Ipoh","addressPostal":"43500","addressState":"6","addressCountry":"MYS"}'); // ? addressLine1 if (!preg_match("/^[A-Za-z0-9\s\-\#\.\,\/\(\)\°\'\"&`‘’]{3,}(?:,\s?[A-Za-z0-9\s\-\#\.\,\/\(\)\°\'\"&`‘’]+)*$/u", $data->addressLine1)) { echo 'address line 1'; }
Copy Clear