<ol
class
=
"dp-xml"
>
<li
class
=
"alt"
><span><span><?php </span></span></li>
<li
class
=
""
><span>
require_once
(
"DB.php"
); </span></li>
<li
class
=
"alt"
><span> </span></li>
<li
class
=
""
><span>
function
get_user(
$name
) </span></li>
<li
class
=
"alt"
><span>{ </span></li>
<li
class
=
""
>
<span>$</span><span
class
=
"attribute"
><font color=
"#ff0000"
>dsn</font></span><span> = </span><span
class
=
"attribute-value"
><font color=
"#0000ff"
>
'mysql://root:password@localhost/bad_multi1'
</font></span><span>; </span>
</li>
<li
class
=
"alt"
>
<span>$</span><span
class
=
"attribute"
><font color=
"#ff0000"
>db</font></span><span> =& DB::Connect(
$dsn
,
array
() ); </span>
</li>
<li
class
=
""
><span>
if
(PEAR::isError(
$db
)) {
die
(
$db
->getMessage()); } </span></li>
<li
class
=
"alt"
><span> </span></li>
<li
class
=
""
>
<span>$</span><span
class
=
"attribute"
><font color=
"#ff0000"
>res</font></span><span> =
$db
->query(
"SELECT id FROM users WHERE </span><span class="
attribute
"><font color="
#ff0000
">login</font></span><span>=?"
,
array
(
$name
) ); </span>
</li>
<li
class
=
"alt"
>
<span>$</span><span
class
=
"attribute"
><font color=
"#ff0000"
>uid</font></span><span> = </span><span
class
=
"attribute-value"
><font color=
"#0000ff"
>null</font></span><span>; </span>
</li>
<li
class
=
""
>
<span>
while
(
$res
->fetchInto(
$row
) ) { $</span><span
class
=
"attribute"
><font color=
"#ff0000"
>uid</font></span><span> =
$row
[0]; } </span>
</li>
<li
class
=
"alt"
><span> </span></li>
<li
class
=
""
><span>
return
$uid
; </span></li>
<li
class
=
"alt"
><span>} </span></li>
<li
class
=
""
><span> </span></li>
<li
class
=
"alt"
><span>
function
get_files(
$name
) </span></li>
<li
class
=
""
><span>{ </span></li>
<li
class
=
"alt"
>
<span>$</span><span
class
=
"attribute"
><font color=
"#ff0000"
>uid</font></span><span> = </span><span
class
=
"attribute-value"
><font color=
"#0000ff"
>get_user</font></span><span>(
$name
); </span>
</li>
<li
class
=
""
><span> </span></li>
<li
class
=
"alt"
>
<span>$</span><span
class
=
"attribute"
><font color=
"#ff0000"
>rows</font></span><span> = </span><span
class
=
"attribute-value"
><font color=
"#0000ff"
>
array
</font></span><span>(); </span>
</li>
<li
class
=
""
><span> </span></li>
<li
class
=
"alt"
>
<span>$</span><span
class
=
"attribute"
><font color=
"#ff0000"
>dsn</font></span><span> = </span><span
class
=
"attribute-value"
><font color=
"#0000ff"
>
'mysql://root:password@localhost/bad_multi2'
</font></span><span>; </span>
</li>
<li
class
=
""
>
<span>$</span><span
class
=
"attribute"
><font color=
"#ff0000"
>db</font></span><span> =& DB::Connect(
$dsn
,
array
() ); </span>
</li>
<li
class
=
"alt"
><span>
if
(PEAR::isError(
$db
)) {
die
(
$db
->getMessage()); } </span></li>
<li
class
=
""
><span> </span></li>
<li
class
=
"alt"
>
<span>$</span><span
class
=
"attribute"
><font color=
"#ff0000"
>res</font></span><span> =
$db
->query(
"SELECT * FROM files WHERE </span><span class="
attribute
"><font color="
#ff0000
">user_id</font></span><span>=?"
,
array
(
$uid
) ); </span>
</li>
<li
class
=
""
><span>
while
(
$res
->fetchInto(
$row
) ) {
$rows
[] =
$row
; } </span></li>
<li
class
=
"alt"
><span>
return
$rows
; </span></li>
<li
class
=
""
><span>} </span></li>
<li
class
=
"alt"
><span> </span></li>
<li
class
=
""
>
<span>$</span><span
class
=
"attribute"
><font color=
"#ff0000"
>files</font></span><span> = </span><span
class
=
"attribute-value"
><font color=
"#0000ff"
>get_files</font></span><span>(
'jack'
); </span>
</li>
<li
class
=
"alt"
><span> </span></li>
<li
class
=
""
><span>var_dump(
$files
); </span></li>
<li
class
=
"alt"
><span>?> </span></li>
</ol>