PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
-- Hint: use Ctrl+Enter for SQL autocomplete CREATE TABLE users (`id` INTEGER, `name` VARCHAR(5), `value` VARCHAR(3), `user_id` INTEGER ); INSERT INTO users (`id`, `name`, `value`, `user_id`) VALUES ('1', 'foo', '40', '10'), ('2', 'bar', '15', '10'), ('3', 'baz', '390', '10'), ('4', 'quux', 'ENG', '10'), ('5', 'waldo', '1', '10'), ('6', 'foo', '20', '13'), ('7', 'bar', '15', '13'), ('8', 'waldo', '1', '13'), ('9', 'baz', '0', '13'), ('10', 'quux', 'ENG', '13'), ('11', 'baz', '420', '15'), ('12', 'waldo', '1', '15'), ('13', 'bar', '1', '15'), ('14', 'foo', '5', '15'), ('15', 'quux', 'ENG', '15'), ('16', 'waldo', '1', '16'), ('17', 'quux', 'ENG', '16'), ('18', 'foo', '5', '16'), ('19', 'baz', '0', '16'), ('20', 'bar', '15', '16');
Copy Clear
Copy Format Clear
<?php $result = mysqli_query($mysqli, "SELECT * FROM users"); $usersArray=[]; esult); function tableArrayPushData($result){ $tableArray = []; while ($row = $result->fetch_assoc()) { $str = ''; foreach ($row as $value) { $str = $str.$value.'|'; } $newStr = rtrim($str, "| "); array_push($tableArray,$newStr); } return $tableArray; } $usersArra = tableArrayPushData($r print_r($usersArray); for ($i=0; $i<count($usersArray); $i++){//array is always empty at this point echo "Ok"; echo "<br>"; }
Show:  
Copy Clear