On Jan 7, 2013, at 6:00 PM, Ethan Rosenberg, PhD wrote:
Dear list -
I have a program [*pseudo code*]:
if(!isset($_REQUEST["welcome_already_seen"]))
{
initialize variables
}
$errors_array = array();
if($_REQUEST["welcome_already_seen"]== "alrea
On Jan 6, 2013, at 9:09 PM, tamouse mailing lists wrote:
On Sun, Jan 6, 2013 at 2:14 PM, Karl DeSaulniers
wrote:
Unfortunately, I am still working on an old G4 Powerbook trying to
finish a
website of mine.
Adobe GoLive was the program I imprinted on and it stuck. Sadly it
has gone
away
On Sun, Jan 6, 2013 at 6:32 PM, Jim Giner wrote:
> On 1/6/2013 7:17 PM, Ethan Rosenberg, PhD wrote:
>>
>> The problem was in this piece of code:
>>
>> require '/var/www/pass.inc';
>> $db = "Store";
>> $cxn = mysqli_connect($host,$user,$password,$db);
>> if ( !$c
On Sun, Jan 6, 2013 at 2:14 PM, Karl DeSaulniers wrote:
> Unfortunately, I am still working on an old G4 Powerbook trying to finish a
> website of mine.
> Adobe GoLive was the program I imprinted on and it stuck. Sadly it has gone
> away now
> and Dreamweaver is the replacement. I am not fond of D
Permissions?
-Original Message-
From: Ethan Rosenberg, PhD [mailto:erosenb...@hygeiabiomedical.com]
Sent: Sunday, January 06, 2013 8:18 PM
To: PHP Database List
Subject: [PHP-DB] Programs not Running - SOLVED
Dear List -
Thanks to all for your help.
The problem was in this piece of cod
On Jan 6, 2013, at 4:55 AM, tamouse mailing lists wrote:
On Sun, Jan 6, 2013 at 1:21 AM, Karl DeSaulniers
wrote:
I likey.. :)
Thanks!
Best,
Karl
On Jan 5, 2013, at 10:05 PM, Bastien wrote:
Get net beans. It's free and a great IDE with debuggers and other
stuff
Bastien Koert
netbea
On Sun, Jan 6, 2013 at 1:21 AM, Karl DeSaulniers wrote:
> I likey.. :)
>
> Thanks!
>
> Best,
> Karl
>
>
> On Jan 5, 2013, at 10:05 PM, Bastien wrote:
>
>> Get net beans. It's free and a great IDE with debuggers and other stuff
>>
>> Bastien Koert
netbeans is pretty awesome; I haven't used it for
I likey.. :)
Thanks!
Best,
Karl
On Jan 5, 2013, at 10:05 PM, Bastien wrote:
Get net beans. It's free and a great IDE with debuggers and other
stuff
Bastien Koert
On 2013-01-05, at 7:14 PM, Karl DeSaulniers
wrote:
On Jan 5, 2013, at 8:52 AM, tamouse mailing lists wrote:
On Sat, Ja
On Jan 5, 2013, at 8:52 AM, tamouse mailing lists wrote:
On Sat, Jan 5, 2013 at 12:48 AM, Karl DeSaulniers > wrote:
On Jan 4, 2013, at 8:00 PM, tamouse mailing lists wrote:
On Fri, Jan 4, 2013 at 6:09 PM, Matt Pelmear
wrote:
On 01/04/2013 01:40 PM, tamouse mailing lists wrote:
One should be
On Sat, Jan 5, 2013 at 12:48 AM, Karl DeSaulniers wrote:
> On Jan 4, 2013, at 8:00 PM, tamouse mailing lists wrote:
>> On Fri, Jan 4, 2013 at 6:09 PM, Matt Pelmear wrote:
>>> On 01/04/2013 01:40 PM, tamouse mailing lists wrote:
One should be able to solve parsing problems without resorting t
On Jan 4, 2013, at 8:00 PM, tamouse mailing lists wrote:
On Fri, Jan 4, 2013 at 6:09 PM, Matt Pelmear
wrote:
On 01/04/2013 01:40 PM, tamouse mailing lists wrote:
One should be able to solve parsing problems without resorting to
using a
web server. Every time I save a php file, I have my
On 01/04/2013 06:00 PM, tamouse mailing lists wrote:
On Fri, Jan 4, 2013 at 6:09 PM, Matt Pelmear wrote:
On 01/04/2013 01:40 PM, tamouse mailing lists wrote:
One should be able to solve parsing problems without resorting to using a
web server. Every time I save a php file, I have my editor set
On Fri, Jan 4, 2013 at 6:09 PM, Matt Pelmear wrote:
> On 01/04/2013 01:40 PM, tamouse mailing lists wrote:
>>
>> One should be able to solve parsing problems without resorting to using a
>> web server. Every time I save a php file, I have my editor set to run it
>> through php -l. Saves lots of an
On 01/04/2013 01:40 PM, tamouse mailing lists wrote:
One should be able to solve parsing problems without resorting to
using a web server. Every time I save a php file, I have my editor set
to run it through php -l. Saves lots of angst when I get to the web
testing stage.
This is a good idea
On Fri, Jan 4, 2013 at 12:37 AM, Matt Pelmear wrote:
> In my experience, the problem you are experiencing is caused by one of two
> issues:
>
> 1) A major parsing problem (sometimes no error is displayed-- you just get
> no output.)
One should be able to solve parsing problems without resorting t
Is the failing one a .php file?
jg
On Jan 3, 2013, at 11:54 PM, "Ethan Rosenberg, PhD"
wrote:
>
> On 01/03/2013 10:14 PM, Matt Pelmear wrote:
>>
>> In addition to Jim's comments,
>>
>> Have you checked to see whether the permissions on all files are appropriate
>> on the environment wher
On 01/03/2013 08:54 PM, Ethan Rosenberg, PhD wrote:
=
I can't answer because I do not understand. gives
the correct output.
Ethan - whatever do you mean the phpinfo gives the correct output? Do
you mean that you compared every line and found them to match EXCEPT
where you
Ethan,
I'm not sure this conversation is appropriate for this mailing list.
This question has probably been answered 1000 times on the general php list.
In my experience, the problem you are experiencing is caused by one of
two issues:
1) A major parsing problem (sometimes no error is dis
In addition to Jim's comments,
Have you checked to see whether the permissions on all files are
appropriate on the environment where this doesn't work?
Are you running this in a web environment or CLI? If web, are you 100%
sure the web server configuration is correct?
-Matt
On 01/03/2013 04:
On Wed, Jan 2, 2013 at 12:50 AM, Ethan Rosenberg, PhD <
erosenb...@hygeiabiomedical.com> wrote:
> Dear List -
>
> I am using the following command:
>
> mysqldump -u root -p Store > StoreBkup.sql;
>
> to backup the database called Store.
>
> Mysql insists on giving a syntax error.
>
> Advice and h
On Dec 31, 2012, at 3:36 AM, Ashley Sheridan wrote:
Karl DeSaulniers wrote:
Hello Everyone,
Hope all are well. Quick and hopefully painless question.
Is there any examples on how to build a discount system
into your shopping cart out there that anyone knows of?
I am using MySQL and PHP. I
On Mon, Dec 3, 2012 at 3:34 PM, Jim Giner wrote:
> On 12/3/2012 2:30 PM, Ethan Rosenberg, PhD wrote:
>> $stmt = mysqli_stmt_init($cxn);
>> mysqli_stmt_prepare( $stmt, $sql12 );
>>
>> The search fails.
So, you got us down to where you prepare the sql statement in
On Tue, Nov 27, 2012 at 5:31 PM, Ethan Rosenberg, PhD
wrote:
> Dear list -
>
> Maybe this fell thru the cracks, so here it is again.
>
> Is there a way to have a button in the tray that will minimize all the
> windows and show the desktop?
Well, it's neither a PHP nor database question, s
You have a valid point there Matt.
Not dead set. Table it is.
Thanks guys.
Best,
Karl
On Nov 27, 2012, at 12:30 AM, Matt Pelmear wrote:
BLOB and TEXT are basically the same thing, except that BLOB can be
used for storing binary data (like an image).
You would only need one additional tabl
BLOB and TEXT are basically the same thing, except that BLOB can be used
for storing binary data (like an image).
You would only need one additional table to do what I was describing,
but if you're dead-set on using a comma separated list then TEXT or
LONGTEXT is probably what you want, depend
On Nov 26, 2012, at 9:22 PM, tamouse mailing lists wrote:
On Mon, Nov 26, 2012 at 8:10 PM, Karl DeSaulniers > wrote:
On Nov 26, 2012, at 8:01 PM, Karl DeSaulniers wrote:
On Nov 26, 2012, at 7:29 PM, Bastien wrote:
Bastien Koert
On 2012-11-26, at 7:43 PM, Karl DeSaulniers
wrote:
H
On Mon, Nov 26, 2012 at 8:10 PM, Karl DeSaulniers wrote:
>
> On Nov 26, 2012, at 8:01 PM, Karl DeSaulniers wrote:
>
>>
>> On Nov 26, 2012, at 7:29 PM, Bastien wrote:
>>
>>>
>>>
>>> Bastien Koert
>>>
>>> On 2012-11-26, at 7:43 PM, Karl DeSaulniers wrote:
>>>
Hello all,
Quick question.
>>
Karl,
Typically I would do this as multiple rows rather than comma-separated
data in one field. If you go this route, you may consider adding an
unsigned int primary key (with auto increment) on the discounts table so
you consume less storage space and can do joins more quickly.
`discounts`:
On Mon, Nov 26, 2012 at 7:28 PM, Ethan Rosenberg, PhD
wrote:
> Dear List -
>
> Here is some code:
>
> $sql13 = "SELECT * FROM Intake3 WHERE MedRec = ?";
> $stmt = mysqli_stmt_init($cxn);
> mysqli_stmt_prepare( $stmt, $sql13 );
> $_SESSION['stmt'] = $
Unsuscribe me please.
Thanks
El 26/11/12 23:01, Karl DeSaulniers escribió:
On Nov 26, 2012, at 7:29 PM, Bastien wrote:
Bastien Koert
On 2012-11-26, at 7:43 PM, Karl DeSaulniers
wrote:
Hello all,
Quick question.
What is the best way to store a comma separated list of discount
codes in
On Nov 26, 2012, at 8:01 PM, Karl DeSaulniers wrote:
On Nov 26, 2012, at 7:29 PM, Bastien wrote:
Bastien Koert
On 2012-11-26, at 7:43 PM, Karl DeSaulniers
wrote:
Hello all,
Quick question.
What is the best way to store a comma separated list of discount
codes in a InnoDB?
Text, va
On Nov 26, 2012, at 7:29 PM, Bastien wrote:
Bastien Koert
On 2012-11-26, at 7:43 PM, Karl DeSaulniers
wrote:
Hello all,
Quick question.
What is the best way to store a comma separated list of discount
codes in a InnoDB?
Text, varchar, blob, ? I want to be able to store discount codes
Bastien Koert
On 2012-11-26, at 7:43 PM, Karl DeSaulniers wrote:
> Hello all,
> Quick question.
> What is the best way to store a comma separated list of discount codes in a
> InnoDB?
> Text, varchar, blob, ? I want to be able to store discount codes offered to
> users in their profile, in t
> -Original Message-
> From: Karl DeSaulniers [mailto:k...@designdrumm.com]
> Sent: 26 November 2012 08:48
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] Re: Formatting
>
> Ethan,
> is this valid PHP? What is the ampersand for? What is it doing? Just
> curi
Ethan,
is this valid PHP? What is the ampersand for? What is it doing? Just
curious.
$args[] = &$_POST[$k]; // Note the addition of the ampersand here
Karl
On Nov 26, 2012, at 12:14 AM, Matt Pelmear wrote:
FYI, this really is not the appropriate mailing list for these types
of questions.
FYI, this really is not the appropriate mailing list for these types of
questions.
Are you positive they are empty lines? i.e., are they in the html code
of the page, or only appear as empty space in the rendered page?
If they are just in the rendered page, in addition to losing the
"" in th
On 11/25/2012 5:39 PM, Ethan Rosenberg, PhD wrote:
List -
Any more ideas.
=
Keep on debugging
jg
Jim -
I've been at this for a few weeks, and am stuck.
Thanks for all your help.
Ethan
+
On Nov 25, 2012, at 1:59 PM, "Ethan Rosenberg, PhD"
wrote:
On 11/25/2012 12:56 PM, Jim Gi
On Nov 25, 2012, at 6:25 PM, tamouse mailing lists wrote:
On Sun, Nov 25, 2012 at 4:40 PM, Karl DeSaulniers > wrote:
Your also using a combination of and . I am thinking that
you have
columns and that they lay next to each other.
Lose the and just use
Hmm, well, no, it looks like the tab
On Sun, Nov 25, 2012 at 4:40 PM, Karl DeSaulniers wrote:
> Your also using a combination of and . I am thinking that you have
> columns and that they lay next to each other.
> Lose the and just use
Hmm, well, no, it looks like the table header columns are in fact just
table header columns, and
On Nov 25, 2012, at 11:56 AM, Jim Giner wrote:
On 11/25/2012 12:46 PM, Ethan Rosenberg, PhD wrote:
Dear list -
When I run the following code, the results are preceded by at least
one
screen full of blank lines. I am showing you a large code block
since I
do not know where the error is:
List -
Any more ideas.
=
Keep on debugging
jg
Jim -
I've been at this for a few weeks, and am stuck.
Thanks for all your help.
Ethan
+
On Nov 25, 2012, at 1:59 PM, "Ethan Rosenberg, PhD"
wrote:
On 11/25/2012 12:56 PM, Jim Giner wrote:
On 11/25/2012 12:46 PM, Ethan Rosenbe
On Wed, Oct 24, 2012 at 7:20 PM, Christopher Jones
wrote:
>
>
> On 10/24/2012 05:02 PM, Ethan Rosenberg, PhD wrote:
>>
>> Dear list -
>>
>> A. Is anyone aware of a debugger that:
>>
>> 1] will step thru the code,
>> 2] will stop at a point that input is requested [eg, form] and allow
>> input?
>>
On 10/24/2012 05:02 PM, Ethan Rosenberg, PhD wrote:
Dear list -
A. Is anyone aware of a debugger that:
1] will step thru the code,
2] will stop at a point that input is requested [eg, form] and allow input?
B. Aptana gives the following message:
'Launching Firefox' internal server has
Do you have xdebug installed?
- "The cold winds are rising"
On Oct 24, 2012 7:02 PM, "Ethan Rosenberg, PhD" <
erosenb...@hygeiabiomedical.com> wrote:
> Dear list -
>
> A. Is anyone aware of a debugger that:
>
> 1] will step thru the code,
> 2] will stop at a point that input is requested [eg, for
On Wed, Oct 17, 2012 at 10:53 PM, Bastien Koert wrote:
> Hi All,
>
> Below is a situation I ran into recently. To me, the decision made
> shows how to not solve a problem but merely compound the issue.
>
> Scenario: There is an app currently running on a highly loaded 4.11
> MySQL db. Customers ar
On Tue, Oct 16, 2012 at 9:53 PM, Ethan Rosenberg, PhD
wrote:
>
>
>
> with an empty action= attribute simply calls the same URL as given. I
> use this all the time for testing and for localhost one-page apps, but is a
> Very Bad Idea ™ for a real on-the-internet application.
>
>
> Thank
On Mon, Oct 15, 2012 at 11:14 AM, Jim Giner
wrote:
> On 10/14/2012 5:57 PM, Ethan Rosenberg, PhD wrote:
>>
>> Dear List -
>>
>> Thank you ever so much for all your help.
>>
>> I apologize in advance for dumping all this code on you. I cannot
>> get any debugger to work for me [see my separate ema
On Oct 14, 2012, at 4:57 PM, Ethan Rosenberg, PhD wrote:
Dear List -
Thank you ever so much for all your help.
I apologize in advance for dumping all this code on you. I cannot
get any debugger to work for me [see my separate email on
debuggers]. I placed numerous echo and print_r state
On Sun, Oct 14, 2012 at 11:57 PM, Ethan Rosenberg, PhD
wrote:
> Dear List -
>
> Thank you ever so much for all your help.
>
> I apologize in advance for dumping all this code on you. I cannot get any
> debugger to work for me [see my separate email on debuggers]. I placed
> numerous echo and pri
Bastien Koert
On 2012-10-14, at 5:57 PM, "Ethan Rosenberg, PhD"
wrote:
> Dear list.
>
> I am running Debian 6 (sid) and Firefox 15.0
>
> I have three debuggers:
>
> Firebug - I have never been able to make it step thru the code.
>
> Aptana - "Aptana Firefox extension launching...please wa
$stmt = mysqli_stmt_prepare( $cxn, $sql12 );// line 507
//Warning: mysqli_stmt_prepare() expects parameter 1 to be mysqli_stmt, object
given in /var/www/x5.php on line 507
$cxn is not a mysqli_stmt. Are you perhaps passing the mysqli database
resource instead of the statement?
See this
Ethan,
Please accept my apologies for the minor errors in the untested code I
previously provided for your edification.
Consider the following tested code:
CREATE TABLE test (id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, data
INT UNSIGNED);
INSERT INTO test (data) VALUES (123),(124),(1
Hi,
Many thanks for your quick answer.
I tried what you suggest by modifying the phpMyAdmin code and it works
great !
Thank you very much !
Le 27/09/2012 17:55, Niel Archer a écrit :
Hi
You could try using mysqli_options(), but I do not know if that supports
this setting yet. The PHP docum
Hi
>
> You could try using mysqli_options(), but I do not know if that supports
> this setting yet. The PHP documentation does not mention it, and I am
> unable to test it myself at the moment.
Just occured to me, even if the setting is not directly supported yet, you
can create a separate config
> Hi everyone,
>
> I need to use the mysql_clear_password plugin.
> I'm using the CentOS php 5.3.3 and manually recompiled the mysql &
> mysqli extensions with the Oracle MySQL 5.5 libraries.
>
> According to the MySQL documentation (
> http://dev.mysql.com/doc/refman/5.5/en/cleartext-authentic
On Wed, Sep 26, 2012 at 10:41 AM, Dr Vijay Kumar
wrote:
> In filling a form, error messages should come in a new widow while
> retaining the form filled on the screen. Coding in php is required.
>
> --
PHP can't do anything 'onscreen'. If you want to do anything onscreen,
you need to use javascr
On 9/26/2012 9:35 AM, Jimi Thompson wrote:
So tell the error message to open in a target="_blank"
On Wed, Sep 26, 2012 at 3:41 AM, Dr Vijay Kumar <
vaibhavinformat...@gmail.com> wrote:
In filling a form, error messages should come in a new widow while
retaining the form filled on the screen.
So tell the error message to open in a target="_blank"
On Wed, Sep 26, 2012 at 3:41 AM, Dr Vijay Kumar <
vaibhavinformat...@gmail.com> wrote:
> In filling a form, error messages should come in a new widow while
> retaining the form filled on the screen. Coding in php is required.
>
> --
>
>
> D
On Wed, Sep 26, 2012 at 1:18 AM, Dr Vijay Kumar
wrote:
> I wish to send a SMS to a mobile no. thru PHP/HTML. Any suggestions Please?
Try an email -> SMS gateway?
http://en.wikipedia.org/wiki/List_of_SMS_gateways
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://w
> What's with all the people suddenly wanting to unsubscribe? Did they
> suddenly become experts - no longer needing the community for support? Or did
> they suddenly discover they had actually enlisted for the influx of emails
> they were getting and wanted to stop them? Sure seems odd
On Friday, September 21, 2012 10:07:56 AM Jim Giner wrote:
> What's with all the people suddenly wanting to unsubscribe? Did they
> suddenly become experts - no longer needing the community for support?
> Or did they suddenly discover they had actually enlisted for the influx
> of emails they were
Some of them may not end up being PHP + DB programmers? Or joined
under mistaken expectations? Or thought it might be a good idea at the
time and ended up doing something else? Lots of possible reasons.
Given the inability of the folk to figure out *how* to unsubscribe,
I'd suspect rather limited u
Ethan,
I believe the root of your problem is that you are passing $bind3 as a
string to mysqli_stmt_bind_param() where the function was expecting
multiple arguments.
Let's say $binder = array( 'one', 'two', 'three' ); // I'll call this
$arguments in my example below
and $typer = array( 's',
On Thu, Sep 20, 2012 at 9:29 PM, Alan Vickers wrote:
> Please remove me, too. Thanks!
Please follow the unsubscription instructions as posted all over,
included in the foot of every single list message, and as I posted
twice in this thread yesterday.
--
Network Infrastructure Manager
http:
I feel the same, I'm happy to receive all this emails as sometimes I'm able to
help them and I learn new things
Jey
--
-Original Message-
From: Rikin Parekh
Date: Fri, 21 Sep 2012 14:14:03
To:
Cc:
Subject: Re: [PHP-DB] Why the sudden dis-interest?
I am
I am happy with this community. I get a lot of new things to learn daily.
On Fri, Sep 21, 2012 at 10:07 AM, Jim Giner wrote:
> What's with all the people suddenly wanting to unsubscribe? Did they
> suddenly become experts - no longer needing the community for support? Or
> did they suddenly disc
Please remove me, too. Thanks!
On Thu, Sep 20, 2012 at 8:43 AM, Daniel Brown wrote:
> On Wed, Sep 19, 2012 at 6:43 PM, Graham H. wrote:
> > Hi,
> >
> > I tried unsubscribing from the list, but I was unsuccessful, I believe
> > because when I subscribed I cleverly added +php to the end of my ema
On Thu, Sep 20, 2012 at 3:37 AM, wrote:
>
> Me too (whe...@eircom.ie)
>
>
>
>
> ***
> The information contained in this e-mail and any files transmitted
> with it is confidential and may be subject to legal professional
> privilege. It i
On Thu, Sep 20, 2012 at 11:51 AM, Valentin Nedkov wrote:
> Hello,
>
> please, unsubscribe me too.
Sure.
It seems no one knows the unsubscription instructions. So, for all others:
From your subscribed email address, send a blank message to
php-db-unsubscr...@lists.php.net.
On Wed, Sep 19, 2012 at 6:43 PM, Graham H. wrote:
> Hi,
>
> I tried unsubscribing from the list, but I was unsuccessful, I believe
> because when I subscribed I cleverly added +php to the end of my email
> address (for Gmail filtering).
>
> Could I be removed please? Thanks.
No problem, I'll
We are getting closer. But I'll give some image to better ilustrate:
http://177.71.185.219/stable/anexos/505b18fc713f8imagem.png
this is my table in Flex, the fields are in portuguese so 'ignore' it.
2012/9/19 Matt Pelmear
> Bruno,
>
> This schema layout seems a little odd to me. Maybe I'm
Me too
Sent from my iPad
On Sep 19, 2012, at 9:18 PM, "Michel BUYSE" wrote:
> Unsubscribe me too m...@marvol.be
>
> -Oorspronkelijk bericht-
> Van: Paul Clark [mailto:p...@leckytech.com]
> Verzonden: donderdag 20 september 2012 7:13
> Aan: php-db@lists.p
Unsubscribe me too m...@marvol.be
-Oorspronkelijk bericht-
Van: Paul Clark [mailto:p...@leckytech.com]
Verzonden: donderdag 20 september 2012 7:13
Aan: php-db@lists.php.net
Onderwerp: Re: [PHP-DB] Unsubscribe me please
Unsubscribe me too leckyt...@gmail.com
On 19 September 2012 23:43
Unsubscribe me too leckyt...@gmail.com
On 19 September 2012 23:43, Graham H. wrote:
> Hi,
>
> I tried unsubscribing from the list, but I was unsuccessful, I believe
> because when I subscribed I cleverly added +php to the end of my email
> address (for Gmail filtering).
>
> Could I be removed pl
Bruno,
This schema layout seems a little odd to me. Maybe I'm just
misunderstanding the use.
Correct me if I'm wrong here:
Each row in the "bill" table is a customer? (or some other lookup value
for which you're generating the data grid?)
I assume the 15 fields from your original message are
Sorry for the lack of explanation.
Again:
I have to model a bill table.
The bill have 20 fields.
But for each field we have: *registered* value, *billed *value and* total
value.*
So i've created an *bill* table with *20 *fields (representing the bill
fields, like: consumption, demand, etc ), a
I'm a little confused here.
You have a 15x3x3 set of data to display in a 3 column, 15 row datagrid?
Are you displaying a single value in each cell of the datagrid, or all 3
values for the cell?
How many variables are needed to uniquely select a piece of data from
that 3-dimensional space?
Ca
Ethan,
9 times out of 10 your answer is in the error statement.
Warning: mysqli_stmt_bind_result(): Number of bind variables doesn't
match number of fields in prepared statement.
GL,
Best,
Karl
On Sep 13, 2012, at 7:09 PM, Ethan Rosenberg, PhD wrote:
Dear List -
Here is another problem
On 9/13/2012 9:15 PM, Ethan Rosenberg, PhD wrote:
Dear list -
Thanks to all. It now works!
The problem, as you correctly noted, was the erroneous inclusion of the
bind-results statement. Removed that and it worked!!
Thanks again!
Ethan
Methinks Ethan is thanking the group for assistance o
Dear list -
Thanks to all. It now works!
The problem, as you correctly noted, was the erroneous inclusion of the
bind-results statement. Removed that and it worked!!
Thanks again!
Ethan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.ph
Does the list of the SELECT fields not have to match the variables you are
binding? E.g. if you do not include MedRec in your SELECT then you have no
MedRec data to bind from your $sql11 variable to the $MedRec varable and
then nothing to print there... or what? Am I just fabulating? :).
Cheers,
On Tue, Sep 11, 2012 at 3:37 AM, Aaron Wood - Slurpy Studios
wrote:
> Hello,
>
> I have been trying to unsubscribe from this list, but it doesn't seem to be
> stopping - could you look into it for me and take me off the list?
I've removed you from php-db@lists.php.net manually just now,
Aaron
On Mon, Sep 10, 2012 at 11:27 PM, Jim Giner
wrote:
> 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
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/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: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
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
Michael Stowe wrote:
How are you using the number? Probably the easiest way is to utilize
PDOStatement::FetchAll() and then do a count() on that result set.
There are two things to bear in mind here. Often you are only displaying a
subset of records - ten per page perhaps - and so a count of
401 - 500 of 23728 matches
Mail list logo