Dear List -
I posted part of this question on the general list. I am posting
here just in case this list did not see the post. This should NOT be
taken as any type of negative reference to the general list, the
members of which have furnished me excellent help.
Question:
What books would
Dear List -
Thanks for your help.
Using PHP, how do I create a database, add tables to it, then add and
extract data from the tables.? Sample code please.
Please be aware that I am a newbie.
Ethan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Dear list -
Thanks for all your help.
I have a tab delimited file which I wish to import into a data
base. In MySQL I can use the LOAD DATA command. As far as I know,
that command cannot be used in PHP as a mysqli_query. As I
understand, I have to parse the file and use the INSERT
At 02:54 PM 10/24/2010, Jason Pruim wrote:
On Oct 24, 2010, at 2:46 PM, Ethan Rosenberg wrote:
Dear list -
Thanks for all your help.
I have a tab delimited file which I wish to import into a data
base. In MySQL I can use the LOAD DATA command. As far as I know,
that command cannot be used
');
foreach ($data AS $row) {
$row = explode(\n, trim($row));
var_dump($row);
}
And there you go.
Cheers.
On 24 October 2010 16:46, Ethan Rosenberg eth...@earthlink.net wrote:
Dear list -
Thanks for all your help.
I have a tab delimited file which I wish to import into a data base. Â
Dear List -
Thanks for all your excellent help.
I am setting up a database for medical research, which will be
conducted at various sites. The sites will be identified by a letter
{A,B,C }. The medical record number [primary key] will start at
1001 and increment by one(1) for each
Dear List -
Is anybody aware of any books on PROCEDURAL PHP programming, NOT OO.
Thanks.
Ethan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
At 10:10 AM 10/27/2010, Richard Quadling wrote:
On 27 October 2010 14:11, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thanks for all your excellent help.
I am setting up a database for medical research, which will be conducted at
various sites. Â The sites will be identified
At 03:40 AM 10/28/2010, Max E.K wrote:
From: Ethan Rosenberg eth...@earthlink.net
To: rquadl...@googlemail.com, Ethan Rosenberg eth...@earthlink.net
Cc: php-db-lists.php.net php-db@lists.php.net
Sent: Thursday, October 28, 2010 4:55:34 AM GMT
+01:00 Amsterdam / Berlin / Bern / Rome / Stockholm
At 01:17 PM 10/28/2010, Bastien Koert wrote:
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net wrote:
At 03:40 AM 10/28/2010, Max E.K wrote:
From: Ethan Rosenberg eth...@earthlink.net
To: rquadl...@googlemail.com, Ethan Rosenberg eth...@earthlink.net
Cc: php-db
Dear List -
I cannot figure this one out:
mysql $st=1000;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '$st=1000' at line 1
Ethan
MySQL 5.1 PHP 5 Linux [Debian (sid)]
--
PHP
At 05:13 PM 10/28/2010, Andrés G. Montañez wrote:
mysql SET @st=100;
mysql SELECT @st;
+--+
| @st |
+--+
| 100 |
+--+
Cheers.
On 28 October 2010 19:10, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
I cannot figure this one out:
mysql $st=1000;
ERROR 1064 (42000
Dear List -
I am afraid that I am missing something in a major way.
mysql printf(%b %d %f %s\n, 123, 123, 123, test);
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'printf(%b %d %f
Dear List -
Thank you for all your help. Here is another one.
I have a file [/home/ethan/PHP/RecNum] which consists of the number
1005. It also has been 1005. No matter how I do it, it is only
recognized as 1.
Here is the code. In this case, the file is 1005.
$fptr1 =
be passed by reference.
so you should expect an array. print_r it to see what is inside.
art
On 2 November 2010 03:34, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thank you for all your help. Here is another one.
I have a file [/home/ethan/PHP/RecNum] which consists
Dear list -
Thank you for all your excellent help.
I wish to search a table. In this case, I have five(5) columns:
site, Record, BMI, Weight and Height.
I wish to be able to search on one or more of the columns. If I use
a query like:
$ste = $_POST['site'];
$req = $_POST['Record'];
$wgt =
Dear List -
How do I close the browser window, with a script [shell or Perl],
after I exit PHP?
Thanks.
Ethan
MySQL 5.1 PHP 5 Linux [Debian (sid)]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Dear List -
Thanks for all your help.
How do I reset auto_increment so that the primary key will start from
1. The primary key is now 2421. I have deleted all the data in the
table and started over, and the primary key just increments from its
previous value. Setting auto_increment=0 does
At 12:38 PM 12/14/2010, Daniel Brown wrote:
On Tue, Dec 14, 2010 at 12:34, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thanks for all your help.
How do I reset auto_increment so that the primary key will start from 1.
The primary key is now 2421. I have deleted all the data
Dear List -
I am sending this again since it does not seem to have posted.
Ethan
+++
Dear List -
Thank you with your excellent help in the past. Here is another puzzler
I am trying to write a program that can have two(2) independent forms
in one PHP file. When I run the code below
Dear List -
Thanks to all for your EXCELLENT comments. I definitly agree that
goto is a command to be avoided at all costs. In this case, I could
not figure out how to acheive the desired result without the
goto. So being a newbie, I humbly request that you show [and at
the same time
Dear List -
Thank you for all your help in the past.
Here is another one
I would like to have a regex which would validate that a telephone
number is in the format xxx-xxx-.
Thanks.
Ethan
MySQL 5.1 PHP 5 Linux [Debian (sid)]
--
PHP Database Mailing List
At 07:27 PM 12/29/2010, Josh Kehn wrote:
On Dec 29, 2010, at 7:12 PM, Ethan Rosenberg eth...@earthlink.net wrote:
Dear List -
Thank you for all your help in the past.
Here is another one
I would like to have a regex which would validate that a
telephone number is in the format
Dear list -
I am an entry level data base programmer [PHP/MySQL HTTP/CSS] looking
for work in the NY metropolitan area. Any ideas?
Should we have a job search board?
Ethan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Dear List -
I would like to have two(2) forms in one PHP script. I would like to
have the forms appear sequentially; ie, that the first form would
appear, the data would be entered, and then the second form would
appear, the data would be entered, and the script would exit.
The code below
Oooops - left out the text that was supposed to be in the quotes.
Dear List -
I would like to have two(2) forms in one PHP script. I would like to
have the forms appear sequentially; ie, that the first form would
appear, the data would be entered, and then the second form would
appear, the
Dear List -
I am a NEWBIE, so .
How do I handle Craigslist postings? Is there anything special I
should do? Any advice for other web sites?
At this point I am talking about small jobs.
1] My payment. Should I ask for something up front? If so how much?
2] How do I protect myself so
Dear List -
I have a form. In one field, the customer types the name of a
product. The first seven(7) results of the MySQL query that the
entry generates should be displayed as a clickable drop down list.
How do I do it?
Thanks.
Ethan
MySQL 5.1 PHP 5.3.3-6 Linux [Debian (sid)]
Dear List -
I have a database:
mysql show tables;
+-+
| Tables_in_hospital2 |
+-+
| Intake3 |
| Visit3 |
+-+
mysql describe Intake3;
++-+--+-+-+---+
| Field | Type
Dear List -
I have a database:
mysql show tables;
+-+
| Tables_in_hospital2 |
+-+
| Intake3 |
| Visit3 |
+-+
mysql describe Intake3;
++-+--+-+-+---+
| Field | Type
';
logout and login as bob
ethan@rosenberg:~/Desktop$ /usr/bin/mysql -u bob -p
Enter password:
Welcome to the MySQL monitor.
mysql show databases;
++
| Database |
++
| information_schema |
| hospital2
Dear list -
This did not seem to post, so I am sending it again.
If it did post, and I missed it, my apologies.
Ethan
Dear list -
I have the following code:
$query = select * from Intake3 where 1;
$allowed_fields = array('Site', 'MedRec', 'Fname', 'Lname',
At 12:13 AM 2/10/2012, Amit Tandon wrote:
Dear Ethan
It seems you are trying to build a query.But you are not getting field
names. If you required field names then change the following line to
foreach ( $allowed_fields AS $field = $_POST['field'])
to
foreach ( $allowed_fields AS $field)
This
.
On Fri, Feb 10, 2012 at 11:04 AM, Ethan
Rosenberg mailto:eth...@earthlink.neteth...@earthlink.net wrote:
At 12:13 AM 2/10/2012, Amit Tandon wrote:
Dear Ethan
It seems you are trying to build a query.But you are not getting field
names. If you required field names then change the following line
.
On Fri, Feb 10, 2012 at 11:04 AM, Ethan
Rosenberg mailto:eth...@earthlink.neteth...@earthlink.net wrote:
At 12:13 AM 2/10/2012, Amit Tandon wrote:
Dear Ethan
It seems you are trying to build a query.But you are not getting field
names. If you required field names then change the following line
is not inserted properly into the table:
mysql select * from Visit3;
| 2416 | AA | 10001 | uih
s45t
|125 | 19.0 | -00-00 |
| 2417 | AA | 1 |
bnkjlolk
|174 | 28.1 | -00-00 |
Advice and help, please.
Thanks.
Ethan Rosenberg
--
PHP Database Mailing List (http://www.php.net
At 07:15 PM 3/29/2012, Matijn Woudt wrote:
On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg eth...@earthlink.net wrote:
Sending again, since no response on 1st try.
Ethan
==
Dear List
I am trying to insert data into a table, with no success.
I have two tables:
mysql
See below-
- Original Message - From: Ethan Rosenberg eth...@earthlink.net
Newsgroups: php.db
To: Matijn Woudt tijn...@gmail.com
Cc: php-db-lists.php.net
php-db@lists.php.net; jim.gi...@albanyhandball.com
Sent: Friday, March 30, 2012 1:00 PM
Subject: Re: [PHP-DB] search of data base
argument supplied for foreach() in
/var/www/srchrhsptl5.php on line 198
Advice and help, please.
Thank you.
Ethan Rosenberg
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
have a database
mysql describe Intake3;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| Site | varchar(6) | NO | PRI | | |
| MedRec | int(6) | NO |
type=\submit\ /br /br /;
echo input type=\reset\ value = \Clear Form\ //center;
echo input type=hidden name='welcome_already_seen'
value='already_seen';
}
?
I hope this helps.
Ethan
--
Ethan Rosenberg, PhD
Pres/CEO
Hygeia Biomedical
At 06:47 PM 5/2/2012, Matijn Woudt wrote:
On Wed, May 2, 2012 at 11:43 PM, Ethan Rosenberg
eth...@earthlink.net wrote: Dear list -
Sorry for the attachment. Â Here are code
snippets --- Ethan, I don't want to sound rude,
but it appears to me you don't have any
understanding of what you're
Dear List -
I have a database:
+-+
| Tables_in_hospital2 |
+-+
| Intake3 |
| Visit3 |
+-+
mysql describe Intake3;
++-+--+-+-+---+
| Field | Type| Null | Key |
At 03:30 PM 6/17/2012, Jim Giner wrote:
Ethan Rosenberg eth...@earthlink.net wrote in message
news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net...
Dear List -
The same query in a PHP program will only give me results for MedRec 10003
why the where 1 clause? Do you know what
At 04:21 PM 6/17/2012, Jim Giner wrote:
Ethan Rosenberg eth...@earthlink.net wrote in message
news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net...
At 03:30 PM 6/17/2012, Jim Giner wrote:
Ethan Rosenberg eth...@earthlink.net wrote in message
news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net...
Dear
Dear List -
I can't figure this out
mysql describe Inventory;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| UPC | varchar(14) | YES | |
On 08/21/2013 07:52 PM, Toby Hart Dyke wrote:
1) What is the error message?
2) This has an error:
values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk)
Missing '$' in front of 'odrpt'.
Toby
On 8/22/2013 12:48 AM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql
On 08/22/2013 11:54 AM, Jim Giner wrote:
On 8/22/2013 9:52 AM, Jim Giner wrote:
On 8/21/2013 7:48 PM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql describe Inventory;
+-+-+--+-+-+---+
| Field | Type| Null | Key
Ethan Rosenberg, PhD
/Pres/CEO/
*Hygeia Biomedical Research, Inc*
2 Cameo Ridge Road
Monsey, NY 10952
T: 845 352-3908
F: 845 352-7566
erosenb...@hygeiabiomedical.com
On 08/22/2013 06:56 PM, Jim Giner wrote:
On 8/22/2013 4:14 PM, Ethan Rosenberg wrote:
On 08/22/2013 11:54 AM, Jim Giner wrote
Dear List -
How do I configure Bluefish for PHP? I am running version 2.2.4 of
Bluefish.
TIA
Ethan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Dear List -
I have the following code:
The input from the form is a 10 digit string [1234567890] which is
converted to phone number format [123-456-7890]
$phn = $_POST[phone];
$phn = (string)$phn;
$dsh = '-';
$Phn =
Dear List -
I know I have a mistake here, but I cannot find it.
This is a part of a switch.
The switch is fed with a formatted phone number [123-456-7890], which is
then tested for validity, and if valid the results of the query are
displayed. I cannot get to the display part.
Here is the
Dear list -
When I use fopen, the file owner and group are both www-data.
How can I ensure that the owner and group will be ethan?
TIA
Ethan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Dear List -
I can't figure this one out.
1] Straighten out ownership
ethan@meow:/var/www$ rm receipt.txt
ethan@meow:/var/www$ touch receipt.txt
ethan@meow:/var/www$ ls -l receipt.txt
-rw-r--r-- 1 ethan ethan 0 Aug 26 19:31 receipt.txt
ethan@meow:/var/www$ chmod 766 receipt.txt
Dear List -
This works:
mysql describe Purchases;
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
| indx | smallint(6) | NO | PRI | NULL|
Dear List -
This works:
mysql describe Purchases;
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-++
| indx | smallint(6) | NO | PRI | NULL|
Dear List -
I seem to be getting dual writes causing a dual insert into the database, and I
cannot figure out why.
Database
mysql describe Inventory;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
shell_exec from a script
to another script in
processing a browser call is just weird) then you would have to pass the
session values you need in
the shell_exec call as parameters.
Bastien
On Thu, Jan 1, 2015 at 11:13 PM Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com
mailto:erosenb
On 02/05/2015 11:04 AM, Bastien Koert wrote:
I'm with the two Richard's on this, those users shouldn't have telnet
access to the host server at all. Users should be using the browser to
access your site.
Other than that, the most important thing you can do is to regularly back
up your code and
to process CC
data.
Bastien
On Thu, Feb 5, 2015 at 11:24 PM, Ethan Rosenberg
erosenb...@hygeiabiomedical.com
mailto:erosenb...@hygeiabiomedical.com wrote:
On 02/05/2015 11:04 AM, Bastien Koert wrote:
I'm with the two Richard's on this, those users shouldn't have telnet
access
On 02/13/2015 02:58 AM, Karl DeSaulniers wrote:
Prevent THIS from ever happening.
On Feb 12, 2015, at 11:03 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com
wrote:
He asks Mr.[naive]Nice if he could look at the computer while it is logged in.
Otherwise, I would say an external key
Dear List -
How do I prevent someone from opening a terminal window, going to /var/www and
stealing all my code?
TIA
Ethan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On 03/09/2015 08:27 AM, Ethan Rosenberg, PhD wrote:
On 03/09/2015 06:55 AM, Karl DeSaulniers wrote:
Don't know what to tell you bub.
Time for the books?
I think that it has to do with php parsing or not parsing the echo because
its echoing a script.
Can't remember off the top, but along those
On 03/18/2015 07:51 AM, Richard wrote:
Original Message
Date: Wednesday, March 18, 2015 00:23:00 -0400
From: Ethan Rosenberg erosenb...@hygeiabiomedical.com
To: Karl DeSaulniers k...@designdrumm.com, PHP Database List
php-db@lists.php.net
Subject: Re: [PHP-DB
that directs to this form.
Also, I noticed you spelt weight wrong.
value= 'WEIGH'
Could that be it or just a keyboard error in your mail program?
Did you copy and paste that code?
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
On Mar 15, 2015, at 11:02 PM, Ethan Rosenberg erosenb
On 03/15/2015 09:44 AM, Jason Pruim wrote:
If you load up handleweight.php outside of the script does it load normally?
Trying to pin down where the actual problem is.
Jason Pruim
352.359.0002
On Mar 14, 2015, at 10:17 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com
wrote:
On 03/09
. The. You can concentrate on fixing just that part instead of the
entire site.
Jason Pruim
352.359.0002
On Mar 15, 2015, at 2:40 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com
wrote:
On 03/15/2015 09:44 AM, Jason Pruim wrote:
If you load up handleweight.php outside of the script does
On Mar 8, 2015, at 12:29 AM, Ethan Rosenberg erosenb...@hygeiabiomedical.com
wrote:
window.open(HandleWeight.php,_self)
Karl -
Thank you.
OK here is the code-
?php
echo Hellobr /;
?
script type=text/javascript
On 03/08/2015 01:50 AM, Karl DeSaulniers wrote:
Shit! — Half Price Books!
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
On Mar 8, 2015, at 12:49 AM, Ethan Rosenberg erosenb...@hygeiabiomedical.com
wrote:
On 03/08/2015 01:43 AM, Karl DeSaulniers wrote:
The Dummies series
On 03/08/2015 07:00 PM, Karl DeSaulniers wrote:
Sorry, missed a parenthesis.
if($row7[0] === 1)
{
echo('script type=text/javascriptwindow.location =
HandleWeight.php;/script');
}
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com http://designdrumm.com/
Begin forwarded message:
PHP to do something it was
never meant to do, and
that can only turn out badly. You can think about it all you want, but you are
just looking for a
bigger hammer to drive something that isn't a nail.
On Sun, Feb 15, 2015 at 7:21 PM, Ethan Rosenberg
erosenb...@hygeiabiomedical.com
mailto:erosenb
Dear List -
I am getting the message - waiting for localhost.
Here are some diagnostic steps I have tried
root@meow:/home/ethan# cat /var/www/cgi-bin/httpd.conf
ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/jkj
ServerName 127.0.0.1:80
Listen xx.xx.xx.xx:80
Listen 127.0.0.1:80
-0400
From: Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com
Subject: Re: [users@httpd] Apache is Slow
Some more info
Changed the host in the connect
$cxn = mysqli_connect($host,$user,$password);
$host=127.0.1.1;
Now get an error...
Warning: mysqli_connect(): (HY000/2003): Can't connect
On 03/18/2015 07:51 AM, Richard wrote:
Original Message
Date: Wednesday, March 18, 2015 00:23:00 -0400
From: Ethan Rosenberg erosenb...@hygeiabiomedical.com
To: Karl DeSaulniers k...@designdrumm.com, PHP Database List
php-db@lists.php.net
Subject: Re: [PHP-DB
On 04/01/2015 07:34 AM, Richard wrote:
Original Message
Date: Wednesday, April 01, 2015 00:05:29 -0400
From: Ethan Rosenberg erosenb...@hygeiabiomedical.com
To: php-db@lists.php.net
Richard -
As we saw in the Apache list, the problem lies in PHP/MySQL
snip
it?
Or are they interchangeable?
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
On Apr 1, 2015, at 10:35 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com
wrote:
snip
Richard -
Thanks.
The problem is in the database connection.
from MySQL
mysql show tables
On 04/02/2015 06:17 AM, Richard wrote:
snip
Here are some hints
service apache2 restart
[] Restarting web server: apache2AH00558: apache2: Could not
reliably determine the server's fully qualified domain name, using
127.0.1.1. Set the 'ServerName' directive globally to suppress
Dear List -
I have a payment/charges table -
mysql> describe Charges;
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-+---+
| Indx |
On 09/01/2015 11:43 PM, Aziz Saleh wrote:
On Tue, Sep 1, 2015 at 11:36 PM, Ethan Rosenberg <
erosenb...@hygeiabiomedical.com> wrote:
Dear List -
I have a payment/charges table -
mysql> describe Charges;
+--+--+--+-+-+---+
| Field
Dear list -
I am not receiving replies. I have been instructed to send a test email.
Ethan
--
Ethan Rosenberg, PhD
/Pres/CEO/
*Hygeia Biomedical Research, Inc*
2 Cameo Ridge Road
Monsey, NY 10952
T: 845 352-3908
F: 845 352-7566
erosenb...@hygeiabiomedical.com
--
PHP Database Mailing List
$stmt;
mysqli_stmt_fetch($stmt);
mysqli_stmt_close($stmt);
}
else
echo Ouch;
Regrettably, all I see on the monitor is ouch!!
Help and advice, please.
Ethan Rosenberg
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
Ethan Rosenberg, PhD
/Pres/CEO/
*Hygeia Biomedical Research, Inc*
2 Cameo Ridge Road
Monsey, NY 10952
T: 845 352-3908
F: 845 352-7566
erosenb...@hygeiabiomedical.com
On 09/02/2012 08:33 AM, Matijn Woudt wrote:
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I wish to accomplish the following with prepared statements:
$stmt = mysqli_stmt_init($cxn);
if($stmt = mysqli_stmt_prepare($stmt, INSERT INTO Intake3 (Site,
MedRec, Fname, Lname
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
*
mysqli_stmt_fetch($stmt);
mysqli_stmt_close($stmt);
*Warning: mysqli_stmt_bind_result(): Number of bind variables doesn't match
number of fields in prepared statement*
*
*
Help and advice, please.
Ethan Rosenberg
--
PHP Database Mailing List (http://www.php.net
Dear List -
Here is another problem I am having with prepared statements. The last
one was INSERT, this one is SELECT.
Here is the database:
mysql describe Intake3;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
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:
Dear List -
-- THANKS TO ALL. See below --
Here is another problem I am having with prepared statements. The last
one was INSERT, this one is SELECT.
Here is the database:
mysql describe Intake3;
++-+--+-+-+---+
| Field | Type| Null | Key |
Dear List -
Thanks to all for your responses.
Here is another one
I wish to accomplish the following
mysqli_stmt_bind_param($stmt, 'sis', $_POST['Site'], $_POST['MedRec'],
$_POST['Sex']);
This statemnt was hand coded. I wish to be able to generalize it.
Therefore -
$sql11 =
Dear list -
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.
mysqli_stmt_bind_param expects three variables, in this order
mysqli_stmt_bind_param($stmt, num, $a, $b,
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.
mysqli_stmt_bind_param expects three variables, in this order
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 wait. Never goes
beyond this point.
Netbeans - 1]Will only give a Java debugger. 2] No
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 statements in the code, and could not
find the error.
The
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 failed. Server
configuration null not found.
Advice
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:
if(isset($_REQUEST['Sex']) trim($_POST['Sex']) != '' )
{
if ($_REQUEST['Sex'] === 0)
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
erosenb...@hygeiabiomedical.com wrote:
On 11/25/2012 12:56 PM, Jim Giner wrote:
On 11
Dear list
Here is the answer
ORIGINAL
centerbSearch Results/b/centerbr /
center
!-- This is the block that prints about one screen full down bellow
the Search Results header --
table border=4 cellpadding=5 cellspacing=55 rules=all
frame=box style=table-layout: fixed;
tr
Dear List -
Here is some code:
$sql13 = SELECT * FROM Intake3 WHERE MedRec = ?;
$stmt = mysqli_stmt_init($cxn);
mysqli_stmt_prepare( $stmt, $sql13 );
$_SESSION['stmt'] = $stmt;
$args = array();
$args[0] = $_POST['MR'];
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?
Thanks.
Ethan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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' = 'i',
'Phone' = 'i', 'Notes' =
1 - 100 of 125 matches
Mail list logo