FUDforum: comp.lang.php » ODBC Connection

Home » Imported messages » comp.lang.php » ODBC Connection

Show: Today's Messages :: Polls :: Message Navigator

Re: ODBC Connection [message #172759 is a reply to message #172746]

Mon, 28 February 2011 07:47

P E Schoen
Messages: 86
Registered: January 2011

Karma:

Member

"sheldonlg" wrote in message
news:ikedis$8ou$1(at)news(dot)eternal-september(dot)org...

> Go to:
> www.php.net
> and look at
> odbc_fetch_array, odbc_fetch_row, odbc_result

With SQLite, you can use a qualifier to fetch the array as either numeric,
or associative, or both:
http://php.net/manual/en/function.mysql-fetch-array.php

array mysql_fetch_array ( resource $result [, int $result_type =
MYSQL_BOTH ] )

This may be helpful as well:
http://www.phpro.org/tutorials/Introduction-to-PHP-PDO.html

I had problems using associative arrays when, for instance, I wanted to
fetch a series of rows which might be

$db->exec("INSERT INTO tEmail (id,name,email) VALUES (
'$ID', '$Name', '$Email' )");

For some reason I was unable to use the associative indexes in a "for" loop
such as

for( $i = name; $i <= email; $i++)

but this was OK:

$line = 0;
while ($row = $qres->fetcharray(SQLITE3_BOTH)) {
for ($i = 0; $i < 2; $i++) {
$arr[$line][$i] = $row[$i];
}
$name = $arr[$line][1]; // should also be OK to use
$arr[$line][name];
$email = $arr[$line][2];
$line++;
}

I didn't spend much time with it. Since it worked with numeric indexes, I
was OK with that, but associative would have been clearer.

Paul

Report message to a moderator

[Message index]

		ODBC Connection By: bruceaj on Sun, 27 February 2011 17:57
		Re: ODBC Connection By: Luuk on Sun, 27 February 2011 18:07
		Re: ODBC Connection By: bruceaj on Sun, 27 February 2011 18:24
		Re: ODBC Connection By: Jerry Stuckle on Sun, 27 February 2011 18:54
		Re: ODBC Connection By: bruceaj on Sun, 27 February 2011 20:46
		Re: ODBC Connection By: Jerry Stuckle on Sun, 27 February 2011 20:55
		Re: ODBC Connection By: spambait on Sun, 27 February 2011 21:02
		Re: ODBC Connection By: bruceaj on Sun, 27 February 2011 21:10
		Re: ODBC Connection By: Luuk on Sun, 27 February 2011 19:04
		Re: ODBC Connection By: richard on Sun, 27 February 2011 18:36
		Re: ODBC Connection By: bruceaj on Sun, 27 February 2011 18:49
		Re: ODBC Connection By: richard on Sun, 27 February 2011 19:19
		Re: ODBC Connection By: Jerry Stuckle on Sun, 27 February 2011 19:51
		Re: ODBC Connection By: richard on Sun, 27 February 2011 20:06
		Re: ODBC Connection By: sheldonlg on Sun, 27 February 2011 20:52
		Re: ODBC Connection By: P E Schoen on Mon, 28 February 2011 07:47
		Re: ODBC Connection By: Jerry Stuckle on Mon, 28 February 2011 11:40
		Re: ODBC Connection By: P E Schoen on Mon, 28 February 2011 18:48

Previous Topic:	static vs global variable
Next Topic:	SOCIAL NETWORK FOR PHP PLATFORM..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 18:57:18 GMT 2024

Total time taken to generate the page: 0.05600 seconds