<?php
function checkUser( $id ) {
# Are we using a valid ID?
if( ctype_digit( $id ) === false ) {
# No, we're not, lets return an error message / code / secret nazi encryption string.
return 'badid';
}
# Ok we're using a valid id (we didn't catch in the if)
# Lets run a query to find our guys. note how we didn't have to do anything to id as we checked it
# for a type (a digit), so if it's not the type we want it'll never get here and if it does, it's clean anyway.
$query = mysql_query( 'SELECT * FROM `users` WHERE `id` = \'' . $id . '\'' );
# Count the rows returned, did we get any?
if( mysql_num_rows( $query ) === 0 ) {
# No, we didn't, lets return an error message / code / bill bailey musical performance
return 'nouser';
}
# Loop through the results (the proper way)
while( false !== ( $fetch = mysql_fetch_assoc( $query ) ) ) {
# Add the information to the end of the array, and then continue.
$buildArray[] = array(
'username' => $fetch[ 'username' ],
'email' => $fetch[ 'email' ],
'name' => $fetch[ 'name' ],
'gender' => $fetch[ 'gender' ]
);
}
# We've done it (what?), return the array and lets get out of here.
return $buildArray;
}
# Setup a heredoc to contain our HTML.
$templateNoPost = <<<HTML
<form method="post" action="">
Enter a user id to search for:<br />
<input type="text" name="id" />
<input type="submit" name="submit" value="Do it" />
</form>
HTML;
# And a heredoc to contain our processed form HTML.
$templatePost = <<<HTML
<table>
<tr>
<td>Name</td>
<td>Username</td>
<td>Email</td>
<td>Gender</td>
</tr>
{html}
</table>
HTML;
# Do we have an id? (you could put an id checker here, but I decided not to. why? z.)
if( empty( $_POST[ 'id' ] ) === false ) {
# We have no id, lets just send out the form and get on with it.
echo $templateNoPost;
} else {
# Require the MySQL connection file (do magic here) only once.
require_once( 'mysql.php' );
# Run the checkUser function, get any information that we need from it.
$users = checkUser( $id );
# Did it come back as an array?
if( !is_array( $users ) ) {
# No, it didn't, lets handle it.
# Is our id bad?
if( $users === 'badid' ) {
# Yes, set the status variable for later
$htmlStatus = 'Bad user id';
}
# No, but is it a bad user?
elseif( $users === 'nouser' ) {
# Yes, set the status variable for later
$htmlStatus = 'No user in the database with that id.';
}
} else {
# It did, lets loop and build!
# Count the amount of keys (amount of users, basically) in the array
$count = count( $users );
# Shut PHP strict errors up (not setting a variable before adding to it)
$buildHtml = '';
# Loop through the amount defined in $count
for( $i = 0; $i < $count; $i++ ) {
# Add the HTML to the variable using .=
$buildHtml .= '
<tr>
<td>' . $users[ $i ][ 'name' ] /* Pull out the username of the "$i"th array (decided by the loop we're on) */ . '</td>
<td>' . $users[ $i ][ 'username' ] . '</td>
<td>' . $users[ $i ][ 'email' ] . '</td>
<td>' . $users[ $i ][ 'gender' ] . '</td>
</tr>
';
}
# Replace "{html}" with the HTML variable we just build using "$buildHtml .="
$templatePost = str_ireplace( '{html}', $buildHtml, $templatePost );
# And send it out in the wild
echo $templatePost;
}
}
?>
that covers arrays, queries, looping of different types, data manipulation, data handling and form processing
eat me.