Pulling a single MySQL value
Posted: Wed Nov 23, 2011 2:41 am
Quite often I need to pull just one specific value from a MySQL database so I wrote this function to do just that. I've been using it for a while and haven't had any problems with it at all. I was just wondering if there is anything wrong with it. Thanks to anyone who takes the time to examine my function and provide comments.
Code: Select all
<?php
include_once("sql_connect.php");
//Hermit TLs' my_get function v0.1
//This function pulls a single value from your MYSQL database
//
//Required Values
// $value : Column name of requested value
// $table : Table name of where column resides
// $where : ie. username=someuser
//
//Optional Values
// $error : Custom error to be displayed
// $override : Use this MYSQL statment to query (if this value is specified all other values will be ignored)
function my_get($value, $table, $where, $error = NULL, $override = NULL){
session_start();
if (!$where){
$where = $_SESSION['id'];
}
if(!$override){$query = "SELECT " . $value . " FROM " . $table . " WHERE " . $where;}
else{$query = $override;}
$getdata = mysql_query($query) or die ('
<table class="page">
<tr><td class="error">Error returned from my_get function.</td></tr>
<tr><td class="error">
Error: '.mysql_error() .
'</td></tr>
<tr><td class="error">'.
$query . '
</td></tr>
<tr><td class="error">
'.$error.'
</td></tr>
</table>
');
$results = mysql_fetch_array($getdata);
$got = $results[$value];
return ($got);
unset($value, $table, $where, $error, $override);
}
?>