PHP/MySQL - Get Row Data

/ Published in: PHP
Save to your folder(s)

Use this function to pull all columns from a single database field.

You would call this function like:

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';"

Copy this code and paste it in your HTML
  1. function getrowdata($tablename,$rowid,$prefix){
  2. $field_query = mysql_query("SELECT * FROM ".$tablename." WHERE id = ".$rowid."");
  3. if(mysql_num_rows($field_query) > 0){
  4. //Get field data
  5. $field_array = mysql_fetch_array($field_query);
  6. foreach($field_array as $field_key=>$field_value){
  7. //Setup a global variable name for this data based on prefix
  8. global ${"{$prefix}$field_key"};
  9. ${"{$prefix}$field_key"} = stripslashes($field_value);
  10. }
  11. }
  12. }


Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.