Showing posts with label Access method of MySql used in PHP. Show all posts
Showing posts with label Access method of MySql used in PHP. Show all posts

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);

}
?>

How to solve mysql ERROR 1118 (42000) Row size too large

  I had this issue with MYSQL 5.7 . The following worked althoug...