object(mysqli_result)#2 (5) {
["current_field"]=>
int(0)
["field_count"]=>
int(6)
["lengths"]=>
NULL
["num_rows"]=>
int(65)
["type"]=>
int(0)
}
array(6) {
["id"]=>
string(1) "1"
["username"]=>
string(2) "as"
["password"]=>
string(4) "asdf"
["email"]=>
string(4) "asdf"
["class"]=>
string(9) "Sophomore"
["reg_date"]=>
string(19) "2019-11-22 03:46:49"
}
id: 1 - Name:
array(6) {
["id"]=>
string(1) "2"
["username"]=>
string(4) "asdf"
["password"]=>
string(4) "asdf"
["email"]=>
string(13) "asdfasdfgadfh"
["class"]=>
string(9) "Sophomore"
["reg_date"]=>
string(19) "2019-11-22 03:46:56"
}
id: 2 - Name:
array(6) {
["id"]=>
string(1) "3"
["username"]=>
string(4) "John"
["password"]=>
string(3) "123"
["email"]=>
string(13) "abc@email.com"
["class"]=>
string(6) "Junior"
["reg_date"]=>
string(19) "2019-11-22 16:54:21"
}
id: 3 - Name:
array(6) {
["id"]=>
string(1) "4"
["username"]=>
string(4) "John"
["password"]=>
string(3) "123"
["email"]=>
string(14) "abce@email.com"
["class"]=>
string(9) "Sophomore"
["reg_date"]=>
string(19) "2019-11-22 16:54:31"
}
id: 4 - Name:
array(6) {
["id"]=>
string(1) "5"
["username"]=>
string(4) "Mary"
["password"]=>
string(10) "IAmSecure!"
["email"]=>
string(14) "blah@email.com"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-11-22 16:54:45"
}
id: 5 - Name:
array(6) {
["id"]=>
string(1) "6"
["username"]=>
string(8) "Old Mary"
["password"]=>
string(25) "afda357864q5ndafo98__!asd"
["email"]=>
string(11) "no you dont"
["class"]=>
string(6) "Senior"
["reg_date"]=>
string(19) "2019-11-22 16:55:04"
}
id: 6 - Name:
array(6) {
["id"]=>
string(1) "7"
["username"]=>
string(4) "John"
["password"]=>
string(10) "maybesafer"
["email"]=>
string(9) "1234@5678"
["class"]=>
string(6) "Junior"
["reg_date"]=>
string(19) "2019-11-22 16:55:18"
}
id: 7 - Name:
array(6) {
["id"]=>
string(1) "8"
["username"]=>
string(4) "Mary"
["password"]=>
string(8) "password"
["email"]=>
string(4) "yeet"
["class"]=>
string(6) "Junior"
["reg_date"]=>
string(19) "2019-11-22 16:55:27"
}
id: 8 - Name:
array(6) {
["id"]=>
string(2) "10"
["username"]=>
string(4) "ryan"
["password"]=>
string(12) "bad password"
["email"]=>
string(14) "ryan@email.com"
["class"]=>
string(9) "Sophomore"
["reg_date"]=>
string(19) "2019-11-22 18:29:48"
}
id: 10 - Name:
array(6) {
["id"]=>
string(2) "19"
["username"]=>
string(7) "demoing"
["password"]=>
string(9) "databases"
["email"]=>
string(9) "with@ajax"
["class"]=>
string(6) "Junior"
["reg_date"]=>
string(19) "2019-11-25 18:07:33"
}
id: 19 - Name:
array(6) {
["id"]=>
string(2) "20"
["username"]=>
string(0) ""
["password"]=>
string(0) ""
["email"]=>
string(0) ""
["class"]=>
string(0) ""
["reg_date"]=>
string(19) "2019-11-25 18:08:47"
}
id: 20 - Name:
array(6) {
["id"]=>
string(2) "21"
["username"]=>
string(3) "asd"
["password"]=>
string(3) "asd"
["email"]=>
string(3) "asf"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-11-25 18:10:05"
}
id: 21 - Name:
array(6) {
["id"]=>
string(2) "22"
["username"]=>
string(3) "asd"
["password"]=>
string(3) "asd"
["email"]=>
string(3) "asf"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-11-25 18:10:15"
}
id: 22 - Name:
array(6) {
["id"]=>
string(2) "23"
["username"]=>
string(4) "yyyy"
["password"]=>
string(4) "mmmm"
["email"]=>
string(8) "eeeeeeee"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-02 00:12:34"
}
id: 23 - Name:
array(6) {
["id"]=>
string(2) "24"
["username"]=>
string(3) "nnn"
["password"]=>
string(0) ""
["email"]=>
string(7) "nnnnnnn"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-02 00:27:29"
}
id: 24 - Name:
array(6) {
["id"]=>
string(2) "25"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:38:42"
}
id: 25 - Name:
array(6) {
["id"]=>
string(2) "26"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:39:51"
}
id: 26 - Name:
array(6) {
["id"]=>
string(2) "27"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:39:51"
}
id: 27 - Name:
array(6) {
["id"]=>
string(2) "28"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:39:52"
}
id: 28 - Name:
array(6) {
["id"]=>
string(2) "29"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(31) "a) AND 6716=5926 AND (7832=7832"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:39:57"
}
id: 29 - Name:
array(6) {
["id"]=>
string(2) "30"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(31) "a) AND 7686=7686 AND (2625=2625"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:39:57"
}
id: 30 - Name:
array(6) {
["id"]=>
string(2) "31"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(15) "a AND 1252=5403"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:39:58"
}
id: 31 - Name:
array(6) {
["id"]=>
string(2) "32"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(15) "a AND 7686=7686"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:39:58"
}
id: 32 - Name:
array(6) {
["id"]=>
string(2) "33"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(22) "a AND 9539=5486-- hQXx"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:39:58"
}
id: 33 - Name:
array(6) {
["id"]=>
string(2) "34"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(22) "a AND 7686=7686-- iKpL"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:39:58"
}
id: 34 - Name:
array(6) {
["id"]=>
string(2) "35"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:00"
}
id: 35 - Name:
array(6) {
["id"]=>
string(2) "36"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:01"
}
id: 36 - Name:
array(6) {
["id"]=>
string(2) "37"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:01"
}
id: 37 - Name:
array(6) {
["id"]=>
string(2) "38"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:01"
}
id: 38 - Name:
array(6) {
["id"]=>
string(2) "39"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:01"
}
id: 39 - Name:
array(6) {
["id"]=>
string(2) "40"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:01"
}
id: 40 - Name:
array(6) {
["id"]=>
string(2) "41"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:02"
}
id: 41 - Name:
array(6) {
["id"]=>
string(2) "42"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:02"
}
id: 42 - Name:
array(6) {
["id"]=>
string(2) "43"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(1) "a"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:02"
}
id: 43 - Name:
array(6) {
["id"]=>
string(2) "44"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(30) "a) AND SLEEP(5) AND (1713=1713"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:03"
}
id: 44 - Name:
array(6) {
["id"]=>
string(2) "45"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(14) "a AND SLEEP(5)"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:03"
}
id: 45 - Name:
array(6) {
["id"]=>
string(2) "46"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(21) "a AND SLEEP(5)-- yxCh"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:03"
}
id: 46 - Name:
array(6) {
["id"]=>
string(2) "47"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(20) "a) ORDER BY 1-- etSy"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:08"
}
id: 47 - Name:
array(6) {
["id"]=>
string(2) "48"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(23) "a) ORDER BY 3451-- QovU"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:08"
}
id: 48 - Name:
array(6) {
["id"]=>
string(2) "49"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(31) "a) UNION ALL SELECT NULL-- POmo"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:08"
}
id: 49 - Name:
array(6) {
["id"]=>
string(2) "50"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(36) "a) UNION ALL SELECT NULL,NULL-- KwDi"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:08"
}
id: 50 - Name:
array(6) {
["id"]=>
string(2) "51"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(41) "a) UNION ALL SELECT NULL,NULL,NULL-- bgWI"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:08"
}
id: 51 - Name:
array(6) {
["id"]=>
string(2) "52"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(46) "a) UNION ALL SELECT NULL,NULL,NULL,NULL-- TRiM"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:08"
}
id: 52 - Name:
array(6) {
["id"]=>
string(2) "53"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(19) "a ORDER BY 1-- rvEn"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:10"
}
id: 53 - Name:
array(6) {
["id"]=>
string(2) "54"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(22) "a ORDER BY 1736-- xqTx"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:10"
}
id: 54 - Name:
array(6) {
["id"]=>
string(2) "55"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(30) "a UNION ALL SELECT NULL-- SFGX"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:10"
}
id: 55 - Name:
array(6) {
["id"]=>
string(2) "56"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(35) "a UNION ALL SELECT NULL,NULL-- FpDE"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:10"
}
id: 56 - Name:
array(6) {
["id"]=>
string(2) "57"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(40) "a UNION ALL SELECT NULL,NULL,NULL-- qeQq"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:10"
}
id: 57 - Name:
array(6) {
["id"]=>
string(2) "58"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(45) "a UNION ALL SELECT NULL,NULL,NULL,NULL-- WmHl"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:11"
}
id: 58 - Name:
array(6) {
["id"]=>
string(2) "59"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(50) "a UNION ALL SELECT NULL,NULL,NULL,NULL,NULL-- iMur"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:11"
}
id: 59 - Name:
array(6) {
["id"]=>
string(2) "60"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(19) "a ORDER BY 1-- eObQ"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:12"
}
id: 60 - Name:
array(6) {
["id"]=>
string(2) "61"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(22) "a ORDER BY 5570-- HxNW"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:12"
}
id: 61 - Name:
array(6) {
["id"]=>
string(2) "62"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(30) "a UNION ALL SELECT NULL-- WCSL"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:12"
}
id: 62 - Name:
array(6) {
["id"]=>
string(2) "63"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(35) "a UNION ALL SELECT NULL,NULL-- HUSe"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:13"
}
id: 63 - Name:
array(6) {
["id"]=>
string(2) "64"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(40) "a UNION ALL SELECT NULL,NULL,NULL-- fCxn"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:13"
}
id: 64 - Name:
array(6) {
["id"]=>
string(2) "65"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(45) "a UNION ALL SELECT NULL,NULL,NULL,NULL-- sWSZ"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:13"
}
id: 65 - Name:
array(6) {
["id"]=>
string(2) "66"
["username"]=>
string(1) "a"
["password"]=>
string(1) "a"
["email"]=>
string(50) "a UNION ALL SELECT NULL,NULL,NULL,NULL,NULL-- uTWH"
["class"]=>
string(8) "Freshman"
["reg_date"]=>
string(19) "2019-12-04 12:40:13"
}
id: 66 - Name:
array(6) {
["id"]=>
string(2) "67"
["username"]=>
string(5) "admin"
["password"]=>
string(4) "pass"
["email"]=>
string(5) "email"
["class"]=>
string(6) "Junior"
["reg_date"]=>
string(19) "2019-12-04 12:41:36"
}
id: 67 - Name:
array(6) {
["id"]=>
string(2) "68"
["username"]=>
string(5) "admin"
["password"]=>
string(4) "pass"
["email"]=>
string(5) "email"
["class"]=>
string(6) "Junior"
["reg_date"]=>
string(19) "2019-12-04 12:42:08"
}
id: 68 - Name:
array(6) {
["id"]=>
string(2) "69"
["username"]=>
string(5) "admin"
["password"]=>
string(4) "pass"
["email"]=>
string(10) ""version()"
["class"]=>
string(6) "Junior"
["reg_date"]=>
string(19) "2019-12-04 12:44:30"
}
id: 69 - Name:
array(6) {
["id"]=>
string(2) "70"
["username"]=>
string(5) "admin"
["password"]=>
string(4) "pass"
["email"]=>
string(18) "(select version())"
["class"]=>
string(6) "Junior"
["reg_date"]=>
string(19) "2019-12-04 12:46:06"
}
id: 70 - Name:
array(6) {
["id"]=>
string(2) "71"
["username"]=>
string(0) ""
["password"]=>
string(0) ""
["email"]=>
string(0) ""
["class"]=>
string(5) "No Op"
["reg_date"]=>
string(19) "2019-12-12 03:44:27"
}
id: 71 - Name:
array(6) {
["id"]=>
string(2) "72"
["username"]=>
string(3) "rrr"
["password"]=>
string(7) "rrrrrrr"
["email"]=>
string(6) "rrrrrr"
["class"]=>
string(9) "Sophomore"
["reg_date"]=>
string(19) "2019-12-12 03:44:37"
}
id: 72 - Name:
array(6) {
["id"]=>
string(2) "73"
["username"]=>
string(8) "fgfhfhfh"
["password"]=>
string(6) "eegdzs"
["email"]=>
string(6) "sgssgs"
["class"]=>
string(6) "Junior"
["reg_date"]=>
string(19) "2019-12-12 03:44:52"
}
id: 73 - Name:
array(6) {
["id"]=>
string(2) "74"
["username"]=>
string(0) ""
["password"]=>
string(0) ""
["email"]=>
string(0) ""
["class"]=>
string(5) "No Op"
["reg_date"]=>
string(19) "2020-11-02 00:06:41"
}
id: 74 - Name:
id: 3 - Name: John Email: abc@email.com
id: 4 - Name: John Email: abce@email.com
id: 7 - Name: John Email: 1234@5678
SELECT id, email FROM Sample_Data WHERE username='Mary'
id: 5 - Name: Email: blah@email.com
id: 8 - Name: Email: yeet