Helpful SQL Select User Function

you dont have to thank me, but here you go.
http://codepad.org/5MaSEeFS

it should look a bit confusing, but its better in notepadd++.

pretty much, if your making a website, this makes getting user data from a database real easy. it can be just the user who is logged in, or multiple users that has left comments on a profile or something. there are examples in the url. but since theres no database, its only examples inside the php code and you cant actually see it in action. it pretty much works like this:

$USER = THAT_FUNCTION();

echo $USER['id'];
echo $USER['username'];
echo $USER['bio'];
echo $USER['last_login'];
echo $USER['age'];
echo $USER['anything'];

pretty much, whatever you want, will be in that $USER variable. the function automatically checks all the field names inside your database, and puts those field names and values together. it makes everything easy. so should you use it? i dont know. in my opinion, this would make your website be doing alot more work. maybe even make it slower. however, it just makes everything, so much easier and cleaner.

At least you used PDO XD

its really helpful though. another example can be this:


$U = THAT_FUNCTION();
//U = everything

if( $U['messages'] ){
//if U msgs has a value

$MS = explode( ',', $U['messages'] );
//make it an array

$PM = THAT_FUNCTION('msgs', 'id', $MS[0]);
//get the first array (the msg id)

if( !$PM['read'] ){
//if its 'read' is 0 or whatever

echo "You have unread messages";
//tell the user, they have unread whatever

}

}


note this is only a example. and this is assuming, the messages in the user database looks like this "14,36,47" and each of those numbers, are the message ID in a messages database. which is why the example explode()'d them. and then used the function to check the message in the database. im bad at explaining, but if you look at the example, it should make sense.

The distinguished Hybrilynx spake:

its really helpful though. another example can be this:


$U = THAT_FUNCTION();
//U = everything

if( $U['messages'] ){
//if U msgs has a value

$MS = explode( ',', $U['messages'] );
//make it an array

$PM = THAT_FUNCTION('msgs', 'id', $MS[0]);
//get the first array (the msg id)

if( !$PM['read'] ){
//if its 'read' is 0 or whatever

echo "You have unread messages";
//tell the user, they have unread whatever

}

}


note this is only a example. and this is assuming, the messages in the user database looks like this "14,36,47" and each of those numbers, are the message ID in a messages database. which is why the example explode()'d them. and then used the function to check the message in the database. im bad at explaining, but if you look at the example, it should make sense.

Yeah I don't think anyone will use this because most of these people use stupid wapka and the others like me most likely already have something like this but it's nice to see someone who knows what they're talking about