[PHP-DB] Re: Prepared Statements - Search

2012-12-03 Thread Jim Giner
On 12/3/2012 2:30 PM, Ethan Rosenberg, PhD wrote: Dear List - I am trying to use prepared statements with the following code: $allowed_fields = array ('Cust_Num' = 'i', 'Fname' = 's', 'Lname' = 's', 'Street' = 's','City'= 's', 'State' = 's', 'Zip' =

[PHP-DB] Re: Prepared Statements - Search

2012-12-03 Thread Jim Giner
On 12/3/2012 2:30 PM, Ethan Rosenberg, PhD wrote: Dear List - I am trying to use prepared statements with the following code: $allowed_fields = array ('Cust_Num' = 'i', 'Fname' = 's', 'Lname' = 's', 'Street' = 's','City'= 's', 'State' = 's', 'Zip' =

Re: [PHP-DB] Re: Prepared Statements - Search

2012-12-03 Thread tamouse mailing lists
On Mon, Dec 3, 2012 at 3:34 PM, Jim Giner jim.gi...@albanyhandball.com 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

[PHP-DB] Re: Prepared Statements - Select - Bind Parameters w/ correction

2012-09-27 Thread Jim Giner
On 9/27/2012 12:40 PM, Ethan Rosenberg, PhD wrote: Dear list - SEE CORRECTION IN $_POST VARIABLE BELOW. Thanks to all for your help. I hope [??] that this question will solve all the remaining problems. So that we are on the same page, here is what was previously stated.

Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-03 Thread tamouse mailing lists
On Sun, Sep 2, 2012 at 10:24 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: mysqli_stmt_bind_result(): Number of bind variables doesn't match number of fields in prepared statement What exactly is unclear about that? -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-03 Thread Jim Giner
On 9/3/2012 2:44 AM, tamouse mailing lists wrote: On Sun, Sep 2, 2012 at 10:24 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: mysqli_stmt_bind_result(): Number of bind variables doesn't match number of fields in prepared statement What exactly is unclear about that? Actually

Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-03 Thread tamouse mailing lists
On Mon, Sep 3, 2012 at 7:45 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 9/3/2012 2:44 AM, tamouse mailing lists wrote: On Sun, Sep 2, 2012 at 10:24 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: mysqli_stmt_bind_result(): Number of bind variables doesn't match number

Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-02 Thread Jim Giner
So do u have the revised code to show us? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-02 Thread tamouse mailing lists
if($stmt = mysqli_stmt_prepare($stmt, INSERT INTO Intake3 (Site, MedRec, Fname, Lname, Phone, Height, Sex, Hx, Bday, Age) VALUES(?,?,?,?,?,?,?,?,?,?)!=0) Let me break this into smaller chunks: if ($a = $b != 0) Precedence rules show that comparisons (!= in this case) come before assignment

[PHP-DB] Re: Prepared Statements

2011-02-11 Thread David Robley
Ron Piggott wrote: I am just starting to use Prepared Statements and am in a learning curve. I am working on the code below. It is for a directory. This is to select the listing for updating. How do I tell if there are more than 1 search result? Am I correctly retrieving the

[PHP-DB] Re: Prepared Statements and mySQL

2010-12-27 Thread David Robley
Ron Piggott wrote: I am trying to implement Prepared Statements on my web site and this is the first time I have ever used this. #1) I received the error ?class mysql not defined?. That is a reference #to the first line of code (below) where the database connection is #established.

[PHP-DB] Re: Prepared statements via mssql extension

2004-06-28 Thread Hans Lellelid
Gerard Samuel wrote: Is it possible? Just checking... It's not unless you use stored procedures. It'd be nice ... :) Stored procedures via mssql_init(), mssql_bind() and mssql_execute() work quite well, though. Read the user comments in the manual as they will help you get over some common