PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table test (id int, name char(255)); show tables; insert into test (id, name) VALUES (1, 'tewst'), (2 , 'test'), (3, 'oo'),( 4, '22'), (5, 'pp'); select * from test;
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()); $rows = ['test' => 1, 'toto' => 2, 'dump' => 3]; $test = implode(',', array_keys($rows)); $query = "SELECT * from test where name in(".$test.');'; // 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); $version = $result->fetch_object(); printf('DB version (mysqli): %s ' . PHP_EOL, $version->version);
Show:  
Copy Clear