Cannot retrive all items from database

k0rnonthek0b · December 10, 2007

Hey I am working on a PHP calendar here, and I am pretty new to this all but so far everything works except when I try to retrieve my data from my database it only shows the most recent entry instead of listing ALL of the current items in the database. I hope that makes sense. Thank you, here is my code:

<?php
include '_prepend.php';
if (!empty($_POST))
{
	if (!empty($_POST['event_title']))
	{
		$unixT1 = strtotime($_POST['event_month_1'] . ' '.$_POST['event_day_1'] . ' ' . $_POST['event_year_1'] . ' ' . $_POST['event_hour_1']);
		//echo $unixT1.'<br />';

		$unixT2 = strtotime($_POST['event_month_2'] . ' '.$_POST['event_day_2'] . ' ' . $_POST['event_year_2'] . ' ' . $_POST['event_hour_2']);
		//echo $unixT2.'<br />';

		$_POST['event_timestamp_1'] = $unixT1;
		$_POST['event_timestamp_2'] = $unixT2;

		insertData("activities", $_POST);
		//redirect to kill the post

	}
}

$activities = SQLquery("SELECT * FROM activities");
$activities = $activities['data'];


?>

<html>
<head>
<title>Personal Calendar</title>

<link href="../CSS/css.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#ffffff">
<?php include '_header.php' ?>

<h1>Add An Event</h1>
<form action="" method="post">
  <table width="75%">
    <tr> 
      <td width="23%"><div align="right"> 
          <label>Event Title: </label>
          <label></label>
        </div></td>
      <td width="77%"><input type="text" name="event_title" value="" size="40" maxlength="255"></td>
    </tr>
    <tr> 
      <td><div align="right"> 
          <label>Event Description:</label>
          <br>
        </div></td>
      <td><textarea name="event_desc" rows="10" cols="43"></textarea></td>
    </tr>
    <tr> 
      <td><div align="right">Date Begins:</div></td>
      <td><select name="event_month_1" size="1">
          <option value="" selected> </option>
          <option value="January">January</option>
          <option value="February">February</option>
          <option value="March">March</option>
          <option value="April">April</option>
          <option value="May">May</option>
          <option value="June">June</option>
          <option value="July">July</option>
          <option value="August">August</option>
          <option value="September">September</option>
          <option value="October">October</option>
          <option value="November">November</option>
          <option value="December">December</option>
        </select>
        - 
        <select name="event_day_1" size="1">
          <option value="" selected> </option>
          <option value="1">1</option>
          <option value="2">2</option>
          <option value="3">3</option>
          <option value="4">4</option>
          <option value="5">5</option>
          <option value="6">6</option>
          <option value="7">7</option>
          <option value="8">8</option>
          <option value="9">9</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
          <option value="23">24</option>
          <option value="25">25</option>
          <option value="26">26</option>
          <option value="27">27</option>
          <option value="28">28</option>
          <option value="29">29</option>
          <option value="30">30</option>
          <option value="31">31</option>
        </select>
        - 
        <select name="event_year_1" size="1">
          <option value="" selected> </option>
          <option value="2007">2007</option>
          <option value="2008">2008</option>
          <option value="2009">2009</option>
          <option value="2010">2010</option>
        </select> </td>
    </tr>
    <tr> 
      <td><div align="right">Hour Begins: </div></td>
      <td><select name="event_hour_1" size="1">
          <option value="" selected> </option>
          <option value="12:00am">12:00 am</option>
          <option value="12:30am">12:30 am</option>
          <option value="1:00am">1:00 am</option>
          <option value="1:30am">1:30 am</option>
          <option value="2:00am">2:00 am</option>
          <option value="2:30am">2:30 am</option>
          <option value="3:00am">3:00 am</option>
          <option value="3:30am">3:30 am</option>
          <option value="4:00am">4:00 am</option>
          <option value="4:30am">4:30 am</option>
          <option value="5:00am">5:00 am</option>
          <option value="5:30am">5:30 am</option>
          <option value="6:00am">6:00 am</option>
          <option value="6:30am">6:30 am</option>
          <option value="7:00am">7:00 am</option>
          <option value="7:30am">7:30 am</option>
          <option value="8:00am">8:00 am</option>
          <option value="8:30am">8:30 am</option>
          <option value="9:00am">9:00 am</option>
          <option value="9:30am">9:30 am</option>
          <option value="10:00am">10:00 am</option>
          <option value="10:30am">10:30 am</option>
          <option value="11:00am">11:00 am</option>
          <option value="11:30am">11:30 am</option>
          <option value="12:00pm">12:00 pm</option>
          <option value="12:30pm">12:30 pm</option>
          <option value="1:00pm">1:00 pm</option>
          <option value="1:30pm">1:30 pm</option>
          <option value="2:00pm">2:00 pm</option>
          <option value="2:30pm">2:30 pm</option>
          <option value="3:00pm">3:00 pm</option>
          <option value="3:30pm">3:30 pm</option>
          <option value="4:00pm">4:00 pm</option>
          <option value="4:30pm">4:30 pm</option>
          <option value="5:00pm">5:00 pm</option>
          <option value="5:30pm">5:30 pm</option>
          <option value="6:00pm">6:00 pm</option>
          <option value="6:30pm">6:30 pm</option>
          <option value="7:00pm">7:00 pm</option>
          <option value="7:30pm">7:30 pm</option>
          <option value="8:00pm">8:00 pm</option>
          <option value="8:30pm">8:30 pm</option>
          <option value="9:00pm">9:00 pm</option>
          <option value="9:30pm">9:30 pm</option>
          <option value="10:00pm">10:00 pm</option>
          <option value="10:30pm">10:30 pm</option>
          <option value="11:00pm">11:00 pm</option>
          <option value="11:30pm">11:30 pm</option>
        </select></td>
    </tr>
    <tr> 
      <td><div align="right">Date Ends:</div></td>
      <td><select name="event_month_2" size="1">
          <option value="" selected> </option>
          <option value="January">January</option>
          <option value="February">February</option>
          <option value="March">March</option>
          <option value="April">April</option>
          <option value="May">May</option>
          <option value="June">June</option>
          <option value="July">July</option>
          <option value="August">August</option>
          <option value="September">September</option>
          <option value="October">October</option>
          <option value="November">November</option>
          <option value="December">December</option>
        </select>
        - 
        <select name="event_day_2" size="1">
          <option value="" selected> </option>
          <option value="1">1</option>
          <option value="2">2</option>
          <option value="3">3</option>
          <option value="4">4</option>
          <option value="5">5</option>
          <option value="6">6</option>
          <option value="7">7</option>
          <option value="8">8</option>
          <option value="9">9</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
          <option value="23">24</option>
          <option value="25">25</option>
          <option value="26">26</option>
          <option value="27">27</option>
          <option value="28">28</option>
          <option value="29">29</option>
          <option value="30">30</option>
          <option value="31">31</option>
        </select>
        - 
        <select name="event_year_2" size="1">
          <option value="" selected> </option>
          <option value="2007">2007</option>
          <option value="2008">2008</option>
          <option value="2009">2009</option>
          <option value="2010">2010</option>
        </select></td>
    </tr>
    <tr> 
      <td><div align="right">Hour Ends:</div></td>
      <td><select name="event_hour_2" size="1">
          <option value="" selected> </option>
          <option value="12:00am">12:00 am</option>
          <option value="12:30am">12:30 am</option>
          <option value="1:00am">1:00 am</option>
          <option value="1:30am">1:30 am</option>
          <option value="2:00am">2:00 am</option>
          <option value="2:30am">2:30 am</option>
          <option value="3:00am">3:00 am</option>
          <option value="3:30am">3:30 am</option>
          <option value="4:00am">4:00 am</option>
          <option value="4:30am">4:30 am</option>
          <option value="5:00am">5:00 am</option>
          <option value="5:30am">5:30 am</option>
          <option value="6:00am">6:00 am</option>
          <option value="6:30am">6:30 am</option>
          <option value="7:00am">7:00 am</option>
          <option value="7:30am">7:30 am</option>
          <option value="8:00am">8:00 am</option>
          <option value="8:30am">8:30 am</option>
          <option value="9:00am">9:00 am</option>
          <option value="9:30am">9:30 am</option>
          <option value="10:00am">10:00 am</option>
          <option value="10:30am">10:30 am</option>
          <option value="11:00am">11:00 am</option>
          <option value="11:30am">11:30 am</option>
          <option value="12:00pm">12:00 pm</option>
          <option value="12:30pm">12:30 pm</option>
          <option value="1:00pm">1:00 pm</option>
          <option value="1:30pm">1:30 pm</option>
          <option value="2:00pm">2:00 pm</option>
          <option value="2:30pm">2:30 pm</option>
          <option value="3:00pm">3:00 pm</option>
          <option value="3:30pm">3:30 pm</option>
          <option value="4:00pm">4:00 pm</option>
          <option value="4:30pm">4:30 pm</option>
          <option value="5:00pm">5:00 pm</option>
          <option value="5:30pm">5:30 pm</option>
          <option value="6:00pm">6:00 pm</option>
          <option value="6:30pm">6:30 pm</option>
          <option value="7:00pm">7:00 pm</option>
          <option value="7:30pm">7:30 pm</option>
          <option value="8:00pm">8:00 pm</option>
          <option value="8:30pm">8:30 pm</option>
          <option value="9:00pm">9:00 pm</option>
          <option value="9:30pm">9:30 pm</option>
          <option value="10:00pm">10:00 pm</option>
          <option value="10:30pm">10:30 pm</option>
          <option value="11:00pm">11:00 pm</option>
          <option value="11:30pm">11:30 pm</option>
        </select></td>
    </tr>
    <tr> 
      <td>
<div align="right"> </div></td>
      <td><input type="submit" name="submit" value="submit"></td>
    </tr>
  </table>
</form>

	<h2>Current Events</h2>
<table width="40%" border="0">
  <tr> 
    <td width="47%" rowspan="4"><table>
        <tr> 
          <th width="192"><div align="right">Title:</div></th>
        </tr>
        <tr> 
          <th><div align="right">Description:</div></th>
        </tr>
        <tr> 
          <th><div align="right">Start:</div></th>
        </tr>
        <?php 
foreach ($activities as $activity)
    {
         date("F j, Y, g:i a", $activity['event_timestamp_1']);

	 '<option value="'.$activity['id'].'">'.$activity['event_title'].'</option>';

         "\n";
    }
{
         date("F j, Y, g:i a", $activity['event_timestamp_2']);

	 '<option value="'.$activity['id'].'">'.$activity['event_title'].'</option>';

         "\n";
    }
    
?>
        <?php
$result = sqlQuery('SELECT * FROM activities');
$activities = $result['data'];
foreach ($activities as $activity)

	?>
        <tr> 
          <th><div align="right">End:</div></th>
        </tr>
        <?php include '_footer.php'?>
      </table> </td>
    <td width="53%"> 
      <?= $activity['event_title'] ?>
    </td>
  </tr>
  <tr> 
    <td> 
      <?= $activity['event_desc'] ?>
    </td>
  </tr>
  <tr> 
    <td> 
      <?= date("F j, Y, g:i a", $activity['event_timestamp_1']); ?>
    </td>
  </tr>
  <tr> 
    <td> 
      <?= date("F j, Y, g:i a", $activity['event_timestamp_2']); ?>
    </td>
  </tr>
</table>
</body>
</html>

trq · December 10, 2007

What does your sqlQuery function look like?

k0rnonthek0b · December 10, 2007

CREATE TABLE `activities` (

`event_ID` int(11) unsigned NOT NULL auto_increment,

`event_title` varchar(255) NOT NULL default '',

`event_desc` text,

`event_timestamp_1` int(50) NOT NULL default '0',

`event_timestamp_2` int(50) NOT NULL default '0',

PRIMARY KEY (`event_ID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;

pocobueno1388 · December 10, 2007

CREATE TABLE `activities` (

`event_ID` int(11) unsigned NOT NULL auto_increment,

`event_title` varchar(255) NOT NULL default '',

`event_desc` text,

`event_timestamp_1` int(50) NOT NULL default '0',

`event_timestamp_2` int(50) NOT NULL default '0',

PRIMARY KEY (`event_ID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;

No yoru sqlQuery function, not your table structure. You use it in your code like this

SQLquery("SELECT * FROM activities");

We need to see what that function looks like.

k0rnonthek0b · December 10, 2007

<?php

$result = sqlQuery('SELECT * FROM activities ORDER BY event_timestamp_1 DESC');

$activities = $result['data'];

foreach ($activities as $activity)

?>

pocobueno1388 · December 10, 2007

<?php

$result = sqlQuery('SELECT * FROM activities ORDER BY event_timestamp_1 DESC');

$activities = $result['data'];

foreach ($activities as $activity)

?>

Still not the function...

The function is probably defined in _prepend.php.

k0rnonthek0b · December 10, 2007

I'm sorry I am usually not this daft, but when it comes to programming I am in need of help. I have a file that I was working on in class called sqlfunctions.1.6.php this is being called upon in the file i posted above, is that what you are talking about?

pocobueno1388 · December 10, 2007

If thats where the function is defined, then yes.

k0rnonthek0b · December 10, 2007

Ok, I'm sorry. I have never touched this file. This is something my teacher had given us in class to work off of.

<?php

# 1.3: modified the way the SQLValue function escapes new lines

# 1.4: removed SQLInsertString function; modified SQLUpdateString, insertData & replaceData

# functions to escape any field names

# 1.5: cache some db result in static variable; allow multiple keys in updateData

# 1.6: removed mysql dependency

function duplicateCheck( $new, $existingData )

{

if( empty($existingData) )

return false;

foreach( $existingData as $temp =>$compare )

{

$id = "";

if( empty($id) && strstr( key($compare), "id" ) )

{

$id = $compare[key($compare)];

}

$duplicate = true;

foreach( $new as $key => $value )

{

if( isset($compare[$key]) && $compare[$key] != $value )

{

$duplicate = false;

break;

}

if( $duplicate )

{

if(!empty($id) )

$duplicate = $id;

return $duplicate;

}

return false;

}

function SQLValue( $string, $keepZero = false )

{

if( trim($string) == "" && !$keepZero )

$value = "NULL";

else

{

# The function addslashes is a "fake" for calling the proper

# escaping function of the db driver. This will need to be

# replaced at some point (perhaps when sqlquery is updated

# provide an escaping mechanism)

$value = "'".addslashes($string)."'";

$value = str_replace("\\\\","\\",$value);

}

return $value;

}

function SQLValues( $data )

{

if( is_array($data) )

{

foreach( $data as $key => $value )

$data[$key] = SQLValue( $value );

}

else

$data = SQLValue( $data );

return $data;

}

function SQLUpdateString( $array )

{

if( is_array($array) )

{

$string = "";

foreach( $array as $key => $value )

$string .= "`$key` = ".SQLValue( $value ).", ";

return rtrim($string,", ");

}

# loops through an associative array and returns a list of fields that

# are valid for a particular table

function SQLTableData( $table, $data )

{

$columns = tableColumns($table);

$array = array();

if( !empty($data) && is_array($data) )

{

foreach( $data as $key => $value )

{

if( in_array($key,$columns) )

$array[$key] = $value;

}

if( !empty($array) )

return $array;

}

return false;

}

function tableColumns($tableName)

{

static $schema = array();

if(empty($schema[$tableName]))

{

$columns = sqlquery("SHOW COLUMNS FROM ".$tableName);

if( !empty($columns['data']) )

{

$column_array = array();

foreach( $columns['data'] as $column )

{

array_push($column_array, $column['Field']);

}

$schema[$tableName] = $column_array;

}

else

{

$column_array = $schema[$tableName];

}

if( !empty($column_array) )

return $column_array;

return false;

}

function getEnumValues( $table, $field )

{

static $schema = array();

if(empty($schema[$table.'::'.$field]))

{

$select = sqlquery("

DESCRIBE ".$table." ".$field."

");

$enum = explode(",",trim(strstr($select['data'][0]['Type'],"("),")("));

foreach( $enum as $key => $value )

{

$enum[$key] = trim($value,"'");

}

$schema[$table.'::'.$field] = $enum;

}

else

{

$enum = $schema[$table.'::'.$field];

}

return $enum;

}

function relevantDataArray( $table, $array )

{

$tableFields = tableColumns($table);

if( !empty($tableFields) && !empty($array) )

{

foreach( $array as $key => $value )

{

if( in_array($key, $tableFields) )

$data[$key] = $value;

}

return $data;

}

return false;

}

function insertData( $table, $data, $showQuery=false )

{

if( $data = relevantDataArray( $table, $data ) )

{

$insert = sqlquery( "

INSERT INTO ".$table."

(`". implode( "`,`",array_keys($data) ) ."`)

VALUES(". implode( ",", SQLValues($data) ) .")

");

if( $showQuery )

echo "<pre>", print_r($insert), "</pre>";

if( isset($insert['insertID']) )

return $insert['insertID'];

else if( isset($insert['rowsAffected']) && $insert['rowsAffected'] == 1 )

return true;

}

return false;

}

function replaceData( $table, $data, $showQuery=false )

{

if( $data = relevantDataArray( $table, $data ) )

{

$insert = sqlquery( "

REPLACE INTO ".$table."

(`". implode( "`,`",array_keys($data) ) ."`)

VALUES(". implode( ",", SQLValues($data) ) .")

");

if( $showQuery )

echo "<pre>", print_r($insert), "</pre>";

if( isset($insert['insertID']) )

return $insert['insertID'];

else if( isset($insert['rowsAffected']) && $insert['rowsAffected'] == 1 )

return true;

}

return false;

}

function updateData( $table, $data, $key, $showQuery= false )

{

$id = array();

if(is_array($key))

{

foreach($key as $k)

{

$id[] = "`$k` = ".SQLValue($data[$k]);

unset($data[$k]);

}

else

{

$id[] = "`$key` = ".SQLValue($data[$key]);

unset($data[$key]);

}

if( $data = relevantDataArray( $table, $data ) )

{

$update = sqlquery("

UPDATE $table

SET ".SQLUpdateString( $data )."

WHERE ".implode(' AND ', $id)."

");

if( $showQuery )

echo "<pre>", print_r($update), "</pre>";

if( !empty($update['rowsAffected']))

return $update['rowsAffected'];

else if( empty($update['errors']) )

return true;

}

return false;

}

?>

pocobueno1388 · December 10, 2007

Nope...not in there either.

it would look like this

<?php

function sqlQuery(){
  //code in between
}

?>

k0rnonthek0b · December 10, 2007

Ok, after doing a sitewide search I found it (i think/hope) in another one of those files my teacher gave us. (this is obviously a beginners class)

<?php

if(function_exists('mysql_connect') || function_exists('mysqli_connect'))
{

define('FETCH_ASSOC', 0);
define('FETCH_NUM', 1);
define('FETCH_BOTH', 2);

global $dbConfigDefault;
$dbConfigDefault = array(
'dbType'	=>	"mysql"
,	'hostname'	=>	"localhost"
,	'username'	=>	""
,	'password'	=>	""
,	'database'	=>	""
,	'mysqli'	=>	function_exists('mysqli_connect')
,	'fetch-mode'	=> FETCH_ASSOC
,	'verbose'	=>	true
,	'privacy'	=>	true
,	'schema'	=>	false
,	'result-only'	=>	false
,	'store-result'	=>	true
);

if( !function_exists( "mtime" ) )
{
function mtime()
{
	list($usec, $sec) = explode(" ", microtime());
	return ((float)$usec + (float)$sec);
}
}

function SQLQuery( $query, $param = false )
{
static $dbStates;

if(!isset($dbStates))
{
	$dbStates = array();
}

if(!is_array($param))
{
	$param = array($param);
}

global $dbConfigDefault; global $dbConfig;
$config = array_merge($dbConfigDefault, $dbConfig);
foreach($config as $key => $ignored)
{
	if(isset($param[$key]))
	{
		$config[$key] = $param[$key];
	}
	elseif(array_search($key, $param) !== false)
	{
		$config[$key] = true;
	}
	elseif(array_search('no-'.$key, $param) !== false)
	{
		$config[$key] = false;
	}
}

if($config['dbType'] != 'mysql')
{
	return false;
}

$query = trim($query);
$return = array();

if(!empty($config['verbose']))
{
	$t_start = mtime();
	$return['query'] = $query;
	$return['dbType'] = 'mysql';
	$return['status'] = false;
	$return['connection'] = false;
	$return['database'] = false;
	$return['schema'] = false;

	if(!$config['privacy'])
	{
		$return['connectionInfo'] = $config;
	}
}

$dbConnect = implode('|', array(
	$config['hostname'], $config['username'], $config['password']
));

if( empty($dbStates[$dbConnect]['connection']) )
{
	# We need to connect!
	if(!empty($config['mysqli']))
	{
		$try =& new mysqli( $config['hostname'], $config['username'], $config['password'], $config['database'] );
		if(mysqli_connect_errno())
		{
			$return['error'] = mysqli_connect_error();
		}
		else
		{
			$dbStates[$dbConnect] = array();
			$dbStates[$dbConnect]['connection'] =& $try;
			$dbStates[$dbConnect]['database'] = $config['database'];
		}
	}
	else
	{
		$try = @mysql_connect( $config['hostname'], $config['username'], $config['password'] );
		if($try)
		{
			$dbStates[$dbConnect] = array();
			$dbStates[$dbConnect]['connection'] = $try;
			$dbStates[$dbConnect]['database'] = '';
		}
		else
		{
			$return['error'] = mysql_error();
		}
	}
	if(!empty($return['error']))
	{
		if(!empty($config['verbose']))
		{
			$t_stop = mtime();
			$return['time'] = array( 'start' => $t_start, 'stop' => $t_stop, 'elapsed' => $t_stop - $t_start );
		}
		return $return;
	}
}
$db =& $dbStates[$dbConnect]['connection'];

if($config['verbose'])
{
	$return['connection'] =& $db;
}

if(!empty($config['database']) && $config['database'] != $dbStates[$dbConnect]['database'])
{
	if(!empty($config['mysqli']))
	{
		if(!$db->select_db($config['database']))
		{
			$return['error'] = $db->error;
		}
	}
	else
	{
		if(!@mysql_select_db( $config['database'], $db ))
		{
			$return['error'] = mysql_error($db);
		}
	}
	if(!empty($return['error']))
	{
		if($config['verbose'])
		{
			$return['connection'] = false;
			$t_stop = mtime();
			$return['time'] = array( 'start' => $t_start, 'stop' => $t_stop, 'elapsed' => $t_stop - $t_start );
		}
		return $return;
	}
}

if(!empty($config['verbose']))
{
	$return['database'] = true;
	$q_start = mtime();
}

if(!empty($config['mysqli']))
{
	$q = @$db->real_query($query);
}
else
{
	$q = @mysql_unbuffered_query($query, $db);
}

if($config['verbose'])
{
	$q_stop = mtime();
	$return['rtime'] = array( 'start' => $q_start, 'stop' => $q_stop, 'elapsed' => $q_stop - $q_start );
}

if($q === false)
{
	if(!empty($config['mysqli']))
	{
		$return['error'] = $db->error;
	}
	else
	{
		$return['error'] = mysql_error($db);
	}
	if($config['verbose'])
	{
		$return['connection'] = false;
		$t_stop = mtime();
		$return['time'] = array( 'start' => $t_start, 'stop' => $t_stop, 'elapsed' => $t_stop - $t_start );
	}
	return $return;
}

if($config['verbose'])
{
	$return['status'] = true;
}

list($queryType, $ignored) = preg_split('/[\s]+/', $query, 2);
$queryType = strtolower($queryType);

switch($queryType)
{
	case 'select':
	case 'show':
	case 'describe':
	case 'explain':
		if($config['verbose'])
		{
			$return['queryType'] = 'select';
		}

		if(!empty($config['mysqli']))
		{
			$rs = @$db->use_result();
		}
		else
		{
			$rs = $q;
		}

		if(!$config['store-result'])
		{
			$return['data'] = $rs;
		}
		elseif(!empty($config['mysqli']))
		{
			if($config['fetch-mode'] == FETCH_NUM)
				$m = MYSQLI_NUM;
			elseif($config['fetch-mode'] == FETCH_BOTH)
				$m = MYSQLI_BOTH;
			else
				$m = MYSQLI_ASSOC;

			$r = array();
			while($row = @$rs->fetch_array($m))
				$r[] = $row;

			if($config['verbose'] && $config['schema'])
			{
				$f = array(); $s = array();
				while($field = $rs->fetch_field())
				{
					$f[$rs->current_field] = $field->name;
					$s[$rs->current_field] = $field;
				}
			}

			$rs->close();
		}
		else
		{
			if($config['fetch-mode'] == FETCH_NUM)
				$m = MYSQL_NUM;
			elseif($config['fetch-mode'] == FETCH_BOTH)
				$m = MYSQL_BOTH;
			else 
				$m = MYSQL_ASSOC;

			$r = array();
			while($row = mysql_fetch_array($rs, $m))
				$r[] = $row;

			if($config['verbose'] && $config['schema'])
			{
				$f = array(); $s = array();
				for($i = 0; $i < mysql_num_fields($rs); $i++)
				{
					$f[$i] = mysql_field_name($rs, $i);
					if($config['schema'])
						$s[$i] = mysql_fetch_field($rs, $i);
				}
			}
		}

		if(empty($return['data']))
		{
			$return['data'] = $r;

			if($config['verbose'])
			{
				if($config['schema'])
				{
					$return['allKeys'] = $f;
					$return['assocCols'] = sizeof($f);
					$return['schema'] = $s;
				}
				$return['rows'] = sizeof($return['data']);
			}
		}
	break;

	case 'insert':
	case 'replace':
		if($config['verbose'])
		{
			$return['queryType'] = 'insert';
		}
		if(!empty($config['mysqli']))
		{
			$return['insertID'] = $db->insert_id;
			$return['rowsAffected'] = $db->affected_rows;
		}
		else
		{
			$return['insertID'] = mysql_insert_id($db);
			$return['rowsAffected'] = mysql_affected_rows($db);
		}
	break;

	case 'update':
	case 'delete':
		if($config['verbose'])
		{
			$return['queryType'] = $queryType;
		}
		if(!empty($config['mysqli']))
		{
			$return['rowsAffected'] = $db->affected_rows;
		}
		else
		{
			$return['rowsAffected'] = mysql_affected_rows($db);
		}
	break;
}

if(!empty($config['mysqli']) && !$config['store-result'])
{
	mysql_free_result($q);
}

if($config['verbose'])
{
	$t_stop = mtime();
	$return['time'] = array( 'start' => $t_start, 'stop' => $t_stop, 'elapsed' => $t_stop - $t_start );
}

if($config['result-only'] && isset($return['data']))
{
	return $return['data'];
}
else
{
	return $return;
}
}

}
else
{

function SQLQuery( $query, $param = false )
{
return false;
}

}

?>

EDITED BY thorpe. Notice how everyone else on this board has there code within [ code ][/ code ] tags? It makes for much easier reading.

Sign In

Cannot retrive all items from database

Recommended Posts

k0rnonthek0b

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

k0rnonthek0b

Link to comment

Share on other sites

pocobueno1388

Link to comment

Share on other sites

k0rnonthek0b

Link to comment

Share on other sites

pocobueno1388

Link to comment

Share on other sites

k0rnonthek0b

Link to comment

Share on other sites

pocobueno1388

Link to comment

Share on other sites

k0rnonthek0b

Link to comment

Share on other sites

pocobueno1388

Link to comment

Share on other sites

k0rnonthek0b

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information