Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
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');
SELECT * FROM tutorials_tbl;
<?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 * FROM 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);