PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Copy Clear
Copy Format Clear
<?php $mysqli->query("create table test (i int)"); $mysqli->query("insert into test values(1)"); var_dump($mysqli->query("select * from test")->fetch_assoc()); $mysqli->options(MYSQLI_OPT_INT_AND_FLOAT_NATIVE, 1); var_dump($mysqli->query("select * from test")->fetch_assoc()); $db->query("update test set i=2"); $pattern = '~Rows matched: (?<matched>\d+) Changed: (?<changed>\d+) Warnings: (?<warnings>\d+)~'; preg_match($pattern, $db->info, $info); $info = array_filter($matches, "is_string", ARRAY_FILTER_USE_KEY); var_dump($info);
Show:  
Copy Clear