Posted By

kilrizzy on 06/02/09

Tagged

Versions (?)

Last Edited at 06/02/09 12:57pm

Statistics

Viewed 854 times

Favorited by 1 user(s)

Related snippets

PHP/MySQL - Get Row Data

/ Published in: PHP

Use this function to pull all columns from a single database field.
getrowdata(tablename,rowid,prefix);

You would call this function like:
getrowdata("users",$_SESSION['user'],"user_");

The prefix is the prefix you want for the array names, so if I have a field in my "users" table called "username", the example above would output the variable "$user_username = 'data';"

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

function getrowdata($tablename,$rowid,$prefix){
	$field_query = mysql_query("SELECT * FROM ".$tablename." WHERE id = ".$rowid."");
	if(mysql_num_rows($field_query) > 0){
		//Get field data
		$field_array = mysql_fetch_array($field_query);
		foreach($field_array as $field_key=>$field_value){
			//Setup a global variable name for this data based on prefix
			global ${"{$prefix}$field_key"};
			${"{$prefix}$field_key"} = stripslashes($field_value);
		}
	}	
}