Thursday, April 9, 2009

Access method of MySql used in PHP

<?php
/* do a MySQL query */
function do_query ($query, $db_link) {

$result = @mysql_query($query, $db_link);
if (!
$result) {
fatal_error("A database query error has occurred!");
} else {
return(
$result);
}

}

/* get single result value */
function query2result ($query, $db_link) {

$result = do_query($query, $db_link);
$row = @mysql_result($result, 0);
return(
$row);

}

/* get result in numeric array */
function query2array ($query, $db_link) {

$result = do_query($query, $db_link);
$row = @mysql_fetch_row($result);
return(
$row);

}

/* get result in associative array */
function query2hash ($query, $db_link) {

$result = do_query($query, $db_link);
$row = @mysql_fetch_array($result);
return(
$row);

}

/* get row of result */
function result2row ($result) {

$row = @mysql_fetch_row($result);
return(
$row);

}

/* get row of result in hash */
function result2hash ($result) {

$row = @mysql_fetch_array($result);
return(
$row);

}

/* find number of rows in query result */
function number_rows ($result) {

$number_rows = @mysql_num_rows($result);
return(
$number_rows);

}

/* put rows from a column into an array */
function column2array ($query, $db_link) {

$result = do_query($query, $db_link);
while (
$row = @mysql_fetch_array($result)) {
$array[] = $row[0];
}
return(
$array);

}
?>

security header validate

  HTTP Security Headers Check Tool - Security Headers Response (serpworx.com)