*************

SQL code: Upload Copy Format Clear

CREATE TABLE fb_modules ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(124) NOT NULL, remarks VARCHAR(125) NOT NULL, config JSON, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); INSERT INTO fb_modules (name, remarks, config) VALUES ("Registration Form Builder", "This builder is to manage reg form buildesr", '{}'); CREATE TABLE fb_fields ( id INT AUTO_INCREMENT PRIMARY KEY, fb_modules_id INT, name VARCHAR(125) NOT NULL, status BOOLEAN DEFAULT FALSE, type VARCHAR(125) NOT NULL, -- set this as enum <<< better. label VARCHAR(125) NOT NULL, is_mandatory BOOLEAN DEFAULT FALSE, config JSON, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, FOREIGN KEY (fb_modules_id) REFERENCES fb_modules(id) );

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php use Carbon\Carbon; $now = Carbon::now()->format('d/m/Y'); // Output current date and PHP version printf("Today is %s\nCurrent PHP version: %s \n\n", $now, phpversion()); $query = "SELECT VERSION() AS version"; if (isset($pdo)) { // Get DB version using PDO $stmt = $pdo->prepare($query); $stmt->execute(); $row = $stmt->fetch(PDO::FETCH_ASSOC); printf('DB version (PDO): %s ' . PHP_EOL, $row['version']); } else { echo "PDO is not initialized properly."; } if (isset($mysqli)) { $result = $mysqli->query($query); $version = $result->fetch_object(); printf('DB version (mysqli): %s ' . PHP_EOL, $version->version); } else { echo "MySQLi connection is not initialized properly."; } echo "\n-------------------------------\n"; echo "Check for Supported Modules.."; echo "\n-------------------------------\n"; $query = "SELECT * FROM fb_modules;"; $result = $db::select($query); print_r($result); echo "\n-------------------------------\n"; echo ">>>>>>>>> Inserting new custom_field"; echo "\n-------------------------------\n"; $fb_modules_id = 1; $name = "Parents Name"; $status = true; $label = "Enter parents name"; $is_mandatory = true; $type = "input_text"; $config = json_encode(["min_char" => 2, "max_char"=> 50, "placeholder"=> "Enter blacblac", "default_val"=> "James Bond"]); $query = "INSERT INTO fb_fields (fb_modules_id, name, status, label, is_mandatory, type, config) VALUES (:fb_modules_id, :name, :status, :label, :is_mandatory, :type, :config)"; $stmt = $pdo->prepare($query); $stmt->execute(compact('fb_modules_id', 'name', 'status', 'label', 'is_mandatory', 'type', 'config')); echo "\n-------------------------------\n"; echo "View all Custom fields"; echo "\n-------------------------------\n"; $query = "SELECT * FROM fb_fields;"; $result = $db::select($query); print_r($result);

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online