PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tutorials_tbl ( tutorial_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) ); INSERT INTO tutorials_tbl (LastName) VALUES ('nippa'); INSERT INTO tutorials_tbl (LastName) VALUES ('dilshan');
Copy Clear
Copy Format Clear
<?php use Carbon\Carbon; $now = Carbon::now()->format('d/m/Y'); printf("Today is %s\nCurrent PHP version: %s \n\n", $now, phpversion()); $id = 'nippa'; $query = "SELECT * tutorials_tbl where LastName = '$id'"; // 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']); // Run query using mysqli $result = $mysqli->query($query); if (mysqli_num_rows($result) > 0) { // login successful echo "login success"; } else { echo "login fail"; } // var_dump($result); // $version = $result->fetch_object(); // printf('DB version (mysqli): %s ' . PHP_EOL, $version->version); // // Select using Laravel // $version = $db::select($db::raw("SELECT VERSION() as version;")); // printf('DB version (Laravel Query Builder): %s ' . PHP_EOL, $version[0]->version);
Show:  
Copy Clear