$id
=
$_GET
[
'id'
]
?
?
'Пусто'
;
$connect
=
new
PDO
(
'mysql:dbname=codeby;host=localhost'
,
'root'
,
''
)
;
$sql
=
"SELECT username, password FROM античат _sql WHERE id = :id"
;
$sth
=
$connect
-
>
prepare
(
$sql
,
[
PDO
:
:
ATTR_CURSOR
=
>
PDO
:
:
CURSOR_FWDONLY
]
)
;
$sth
-
>
execute
(
[
':id'
=
>
$id
]
)
;
while
(
$row
=
$sth
-
>
fetch
(
)
)
{
echo
'Username: '
.
$row
[
'username'
]
.
'
'
;
echo
'Password: '
.
$row
[
'password'
]
;
}
}

$id
=
$_GET
[
'id'
]
?
?
'Пусто'
;
$connect
=
new
mysqli
(
'localhost'
,
'root'
,
''
,
'codeby'
)
;
$query
=
"SELECT username, password FROM античат _sql WHERE id = ?"
;
$sth
=
$mysqli
-
>
stmt_init
(
)
;
if
(
$sth
-
>
prepare
(
$query
)
)
{
$sth
-
>
bind_param
(
"i"
,
$id
)
;
$sth
-
>
execute
(
)
;
$result
=
$sth
-
>
get_result
(
)
;
while
(
$row
=
$result
-
>
fetch_array
(
MYSQLI_NUM
)
)
{
echo
'Username: '
.
$row
[
'username'
]
.
'
'
;
echo
'Password: '
.
$row
[
'password'
]
;
}
}