Query:
$query
Page:".$_SERVER['PHP_SELF']."
Referer:".$_SERVER['HTTP_REFERER']);
$key = mysql_insert_id($myConn);
mysql_close($myConn);
return $key;
}
/**
* Gets only result (RAW)
*
* @param string $query SQL query
* @return result
*/
function get_result($query){
$conn = get_connection();
$result = mysql_query($query) or die(mysql_error()." while executing
Query:
$query
Page:".$_SERVER['PHP_SELF']."
Referer:".$_SERVER['HTTP_REFERER']);
mysql_close($conn);
return $result;
}
/**
* Gets the next record
*
* @param result $result
* @return array
*/
function sql_next($result){
return mysql_fetch_array($result, MYSQL_ASSOC);
}
function get_row($query){
return sql_next(get_result($query));
}
/**
* Returns 2D array with multi values
*
* @param string $query SQL query
* @return array 2D associative array
*/
function get_result_array2D($query){
$result = get_result($query);
$rows = array();
$count=0;
while($row=sql_next($result)){
$rows[$count]=$row;
$count++;
}
return $rows;
}
?>