Brandon: RAM is cheap, but not always expendable depending on what
you're doing.
Using count() on results from PDOStatement::fetchAll() is fine on small
result sets.
Keep in mind that this will certainly blow up on very large result sets,
especially depending on your memory_limit for php. Avoidi
On 9/10/2012 7:41 PM, Ethan Rosenberg, PhD wrote:
Dear list -
How do I add a new entry to /dev; eg, /dev/sdb?
Thanks,
Ethan Rosenberg
Ethan,
Sometimes google is great at answering this kind of stuff. Did you try
a search on your question. I did and found an answer in the fifth
result ret
On 9/11/2012 12:04 AM, Matt Pelmear wrote:
Ethan,
I am curious why you are using mysqli_stmt_bind_result() on a statement
that is an INSERT query? I don't use mysqli, but as I read the
documentation it seems to me that this method is intended to bind
results from a SELECT query into variables so
On 9/10/2012 8:06 PM, Ethan Rosenberg, PhD wrote:
Dear list -
Here is my code:
$sql3 = "select max(Indx) from Visit3";
$result7 = mysqli_query($cxn, $sql3);
$row7 = mysqli_fetch_array($result7, MYSQLI_BOTH);
$Indx = $row7[0];
$sql2 = "INS
On 9/10/2012 8:29 PM, Karl DeSaulniers wrote:
On Sep 10, 2012, at 7:06 PM, Ethan Rosenberg, PhD wrote:
Dear list -
Here is my code:
$sql3 = "select max(Indx) from Visit3";
$result7 = mysqli_query($cxn, $sql3);
$row7 = mysqli_fetch_array($result7, MYSQLI_BOTH);
Jim,
You likely have to install the mysqli package for your distribution.
Try a search for something like"ubuntu install php mysqli" or
"centos install php mysqli"
I can tell you for ubuntu you probably would need to do something like this:
sudo apt-get install php5-mysql
If you're in a h
Ethan,
I am curious why you are using mysqli_stmt_bind_result() on a statement
that is an INSERT query? I don't use mysqli, but as I read the
documentation it seems to me that this method is intended to bind
results from a SELECT query into variables so that you can simply call
mysqli_stmt_fe
Jim,
We have code that operates on tables that can be altered by users of the
application (effectively storing different types of user data for each
client). Some routines fetch results with PDO::FETCH_NUM as opposed to
PDO::FETCH_ASSOC (or others), particularly when returning large amounts
o
Ethan,
I think you should be a little more specific about what your end goal is.
-Matt
On 09/10/2012 07:41 PM, Ethan Rosenberg, PhD wrote:
Dear list -
How do I add a new entry to /dev; eg, /dev/sdb?
Thanks,
Ethan Rosenberg
--
PHP Database Mailing List (http://www.php.net/)
To unsubscri
On Sep 10, 2012, at 7:06 PM, Ethan Rosenberg, PhD wrote:
Dear list -
Here is my code:
$sql3 = "select max(Indx) from Visit3";
$result7 = mysqli_query($cxn, $sql3);
$row7 = mysqli_fetch_array($result7, MYSQLI_BOTH);
$Indx = $row7[0];
$sql2 = "INSE
Dear list -
Here is my code:
$sql3 = "select max(Indx) from Visit3";
$result7 = mysqli_query($cxn, $sql3);
$row7 = mysqli_fetch_array($result7, MYSQLI_BOTH);
$Indx = $row7[0];
$sql2 = "INSERT INTO Visit3(Indx, Site, MedRec, Notes,
Weight, BMI,
Dear list -
How do I add a new entry to /dev; eg, /dev/sdb?
Thanks,
Ethan Rosenberg
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On 9/10/2012 4:54 PM, Jim Giner wrote:
On 9/10/2012 11:10 AM, Lester Caine wrote:
Jim Giner wrote:
On 9/10/2012 10:49 AM, Bastien Koert wrote:
On Mon, Sep 10, 2012 at 9:48 AM, Jim Giner
wrote:
Reading up on the pdostatement class. Wondering what the intent
of the
columnCount function is.
On 9/10/2012 11:10 AM, Lester Caine wrote:
Jim Giner wrote:
On 9/10/2012 10:49 AM, Bastien Koert wrote:
On Mon, Sep 10, 2012 at 9:48 AM, Jim Giner
wrote:
Reading up on the pdostatement class. Wondering what the intent of the
columnCount function is. I mean, aren't the number of columns in a
Jim Giner wrote:
On 9/10/2012 10:49 AM, Bastien Koert wrote:
On Mon, Sep 10, 2012 at 9:48 AM, Jim Giner wrote:
Reading up on the pdostatement class. Wondering what the intent of the
columnCount function is. I mean, aren't the number of columns in a result
known when you write the query? Gra
Imagine if you are building a generic database framework, so you (dont
have, but) can generalize your queries functions and abstract some tables
info.
2012/9/10 Graham H.
> I think it's so that you could write functions as generically as possible.
> So you don't have to pass in the number of co
On 9/10/2012 10:53 AM, Graham H. wrote:
I think it's so that you could write functions as generically as possible.
So you don't have to pass in the number of columns or hard code in values
for number of columns, you can dynamically check the column count for each
result set that gets passed in. T
I think it's so that you could write functions as generically as possible.
So you don't have to pass in the number of columns or hard code in values
for number of columns, you can dynamically check the column count for each
result set that gets passed in. That's my guess.
On Mon, Sep 10, 2012 at 8
On 9/10/2012 10:49 AM, Bastien Koert wrote:
On Mon, Sep 10, 2012 at 9:48 AM, Jim Giner wrote:
Reading up on the pdostatement class. Wondering what the intent of the
columnCount function is. I mean, aren't the number of columns in a result
known when you write the query? Granted, you might ha
On Mon, Sep 10, 2012 at 9:48 AM, Jim Giner wrote:
> Reading up on the pdostatement class. Wondering what the intent of the
> columnCount function is. I mean, aren't the number of columns in a result
> known when you write the query? Granted, you might have some very complex
> query that you may
On 9/8/2012 2:02 PM, Jim Giner wrote:
I finally delved into learning how I was going to replace my MYSQL calls
with a different interface. Had to go with PDO since my hoster doesn't
support MYSQLI for my plan.
I've had some success with querying using pdo and prepared statements as
well. One t
Reading up on the pdostatement class. Wondering what the intent of the
columnCount function is. I mean, aren't the number of columns in a
result known when you write the query? Granted, you might have some
very complex query that you may not know the number, but for most
queries you will kno
22 matches
Mail list logo
