note 100999 deleted from function.mysql-query by thiago
| From: | thiago@php.net | Date: | Fri, 19 Nov 2010 12:04:22 +0000 |
| Subject: | note 100999 deleted from function.mysql-query by thiago | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-174182@lists.php.net to get a copy of this message | ||
Note Submitter: ricardo dot miguel at cleverti dot pt
----
<?php
public function mysqlRead ( $table = null , $what = null , $where = null , $equalsTo = null
, $orderBy = null , $type = null ) //@
{
$connect = self::mysqlConnect();
if ( $table !== null && $what !== null && $where !== null && $equalsTo !==
null )
{
if ( $orderBy !== null && $type !== null )
{
$query = "SELECT $what FROM $table WHERE $where = \"$equalsTo\" ORDER BY $orderBy
$type";
}
else
{
$query = "SELECT $what FROM $table WHERE $where = \"$equalsTo\"";
}
$query = mysql_query ( $query , $connect );
$row = mysql_num_rows ( $query );
if ( $row )
{
$i = 0;
while ( $result[] = mysql_fetch_array ( $query ) )
{
$i++;
}
unset ( $result[count($result)-1] ); //Fixes the last "ghost" index
return $result;
}
else
{
return false;
}
return $result;
}
else if ( $table !== null && $what !== null && $where !== null &&
$equalsTo == null )
{
if ( is_array ( $where ) )
{
$container = "";
$contar = count ( $where ) -1;
$i = 0;
foreach ( $where as $key => $val )
{
if ( $i != $contar )
{
$container .= $key . " = \"" . $val . "\" AND ";
}
else
{
$container .= $key . " = \"" . $val . "\"";
}
$i++;
}
}
else
{
return false;
}
if ( $orderBy !== null && $type !== null )
{
$query = "SELECT $what FROM $table WHERE $container ORDER BY $orderBy $type";
}
else
{
$query = "SELECT $what FROM $table WHERE $container";
}
$query = mysql_query ( $query , $connect );
$row = mysql_num_rows ( $query );
if ( $row )
{
$i = 0;
while ( $result[] = mysql_fetch_array ( $query ) )
{
$i++;
}
unset ( $result[count($result)-1] ); //Fixes the last "ghost" index
return $result;
}
else
{
return false;
}
return $result;
}
else if ( $table !== null && $what !== null )
{
if ( $orderBy !== null && $type !== null )
{
$query = "SELECT $what FROM $table ORDER BY $orderBy $type";
}
else
{
$query = "SELECT $what FROM $table";
}
$query = mysql_query ( $query , $connect );
$row = mysql_num_rows ( $query );
if ( $row )
{
$i = 0;
while ( $result[] = mysql_fetch_array ( $query ) )
{
$i++;
}
unset ( $result[count($result)-1] ); //Fixes the last "ghost" index
return $result;
}
else
{
return false;
}
}
else
{
return false;
}
self::mysqlClose ( $connect );
}
?>