Hi! Could we please enable some services and cookies to improve your experience and our website?

PHPize Online / SQLize Online  /  SQLtest Online

A A A
Login    Share code      Blog   FAQ

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Copy Format Clear
-- CREATE DATABASE accounts; -- USE accounts; CREATE TABLE verified_accounts ( ID int NOT NULL, account_username varchar(255) NOT NULL, account_password varchar(255) NOT NULL, PRIMARY KEY (ID) ); CREATE TABLE pending_accounts ( ID int NOT NULL AUTO_INCREMENT, account_username varchar(255) NOT NULL, account_password varchar(255) NOT NULL, PRIMARY KEY (ID) ); ALTER TABLE pending_accounts AUTO_INCREMENT=1000; SHOW DATABASES; INSERT INTO pending_accounts (account_username,account_password) VALUES ("doge","yfuy7ug"); INSERT INTO pending_accounts (account_username,account_password) VALUES ("admin","87654321testingpassword");

Stuck with a problem? Got Error? Ask AI support!

Copy Clear
Copy Format Clear
<?php $result = array(); $query = mysqli_query($mysqli,"SELECT * FROM pending_accounts;"); if (mysqli_num_rows($query) > 0) { while($row = mysqli_fetch_assoc($query)) { array_push($result,array($row["ID"],$row["account_username"],$row["account_password"])); } } echo print_r($result); ?>
Copy Clear