[PHP-DB] Th is a test

2012-08-31 Thread Ethan Rosenberg, PhD
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

[PHP-DB] Prepared Statements Insert Problem

2012-09-01 Thread Ethan Rosenberg, PhD
Dear List - I wish to accomplish the following with prepared statements: FYI - The Database: mysql describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | Site

Re: [PHP-DB] Prepared Statements Insert Problem

2012-09-02 Thread Ethan Rosenberg, PhD
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

Re: [PHP-DB] Prepared Statements Insert Problem - Any more ideas?

2012-09-02 Thread Ethan Rosenberg, PhD
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

[PHP-DB] Adding entry to /dev

2012-09-10 Thread Ethan Rosenberg, PhD
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

[PHP-DB] Re: Problems w/ insert

2012-09-10 Thread Ethan Rosenberg, PhD
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,

[PHP-DB] Prepared Statements - Search

2012-09-13 Thread Ethan Rosenberg, PhD
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 |

Re: [PHP-DB] Re: Problems w/ insert -- SOLVED!!!

2012-09-13 Thread Ethan Rosenberg, PhD
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:

[PHP-DB] Prepared Statements - Search -- SOLVED!!!

2012-09-13 Thread Ethan Rosenberg, PhD
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 |

[PHP-DB] Prepared Statements - Select

2012-09-19 Thread Ethan Rosenberg, PhD
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 =

[PHP-DB] Prepared Statements - Select - Bind Parameters

2012-09-27 Thread Ethan Rosenberg, PhD
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,

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

2012-09-27 Thread Ethan Rosenberg, PhD
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

[PHP-DB] Debuggers

2012-10-14 Thread Ethan Rosenberg, PhD
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

[PHP-DB] Program Dies

2012-10-14 Thread Ethan Rosenberg, PhD
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

[PHP-DB] Debugger

2012-10-24 Thread Ethan Rosenberg, PhD
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

[PHP-DB] Formatting

2012-11-25 Thread Ethan Rosenberg, PhD
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)

Re: [PHP-DB] Re: Formatting

2012-11-25 Thread Ethan Rosenberg, PhD
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

[PHP-DB] Formatting - Solved

2012-11-26 Thread Ethan Rosenberg, PhD
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

[PHP-DB] mysqli_bind_result

2012-11-26 Thread Ethan Rosenberg, PhD
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'];

[PHP-DB] Gnome Desktop Button

2012-11-27 Thread Ethan Rosenberg, PhD
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

[PHP-DB] Prepared Statements - Search

2012-12-03 Thread Ethan Rosenberg, PhD
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' =

[PHP-DB] mysqldump

2013-01-01 Thread Ethan Rosenberg, PhD
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 help, please. Thanks. Ethan -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Programs not running

2013-01-03 Thread Ethan Rosenberg, PhD
on the laptop. Error_reporting is set to -1. I receive no errors. Advice and help, please. 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

[PHP-DB] Programs not Running - SOLVED

2013-01-06 Thread Ethan Rosenberg, PhD
Dear List - Thanks to all for your help. The problem was in this piece of code: require '/var/www/pass.inc'; $db = Store; $cxn = mysqli_connect($host,$user,$password,$db); if ( !$cxn ) { die( 'connect error: '.mysqli_connect_error() ); } I

[PHP-DB] Programs not running - Mystery SOLVED

2013-01-07 Thread Ethan Rosenberg, PhD
Dear list - Boy, Do I make STUPID MISTAKES! The show_errors was turned off in the program in question!! When I ran another program, that displayed errors, is threw the correct error message. My apologies for running everyone around numerous trees. Ethan -- PHP Database Mailing List

[PHP-DB] Another Apology

2013-01-07 Thread Ethan Rosenberg, PhD
Dear list - My humble apologies for listing my complete signature. It is pretentious and should not have happened! The eml is coming from my business account [my home computer is down]. The PhD is in chemistry, not computer science. When I communicate with other scientists I have no

[PHP-DB] Preventing repetition of a Form

2013-01-07 Thread Ethan Rosenberg, PhD
Dear list - I have a program [*pseudo code*]: if(!isset($_REQUEST[welcome_already_seen])) { initialize variables } $errors_array = array(); if($_REQUEST[welcome_already_seen]== already_seen) { check_data();

[PHP-DB] Error Checking

2013-01-08 Thread Ethan Rosenberg, PhD
Dear List - 1] What function(s) do you use for error checking? 2] What are the settings for the parameter(s) in the functions? 3] Do you have different php.ini files for development and production? Thank you. Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Netbeans

2013-01-08 Thread Ethan Rosenberg, PhD
Dear List - Does anyone know how to set up Netbeans? I've tried and am unsuccessful. Thanks Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Query will not work - SOLVED

2013-02-02 Thread Ethan Rosenberg, PhD
I must be missing something fundamental!! Here is a code snippet: $sql13 = UPDATE Customers SET Lname = 'Barnet', City = 'Lakewood', State = 'NJ' WHERE Cust_Num = 1089; $result13 = mysqli_query($cxn, UPDATE Customers SET Lname = 'Bleich', City = 'Lakewood', State = 'NJ' WHERE Cust_Num

[PHP-DB] AJAX/Javascript??

2013-02-09 Thread Ethan Rosenberg, PhD
I know that this might be an Ajax/Javascript question. Hopefully you can help. I do not know of any other source for good info. I would like to be able to click on one field in a table, and retrieve the data in another field. Here is the information: The table is:

[PHP-DB] My Comments

2013-02-21 Thread Ethan Rosenberg, PhD
Dear List - Correction William N. Lipscomb, Jr. Ethan Dear List - I feel, and correct me if I am wrong, that a list as this or similar, should be devoted to help and not sarcasm. I try to be quiet and to not toot my horn, but as events have progressed, I feel I must. As you

[PHP-DB] Placing a form on a page

2013-05-05 Thread Ethan Rosenberg, PhD
Dear List - I apologize if I offended some of you. I will see that it does not repeat. I am trying to center a form on the top of a page. Here is the form: div id=frm form name=poster method=post action= input type=text name=cnum hidden=hidden /input input type='hidden'

Re: [PHP-DB] Placing a form on a page

2013-05-05 Thread Ethan Rosenberg, PhD
On 05/06/2013 12:48 AM, tamouse mailing lists wrote: On Sun, May 5, 2013 at 11:22 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I apologize if I offended some of you. I will see that it does not repeat. I am trying to center a form on the top of a page. Here

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread Ethan Rosenberg, PhD
. -Mensaje original- De: Ethan Rosenberg, PhD [mailto:erosenb...@hygeiabiomedical.com] Enviado el: lunes, 06 de mayo de 2013 12:23 AM Para: PHP Database List Asunto: [?? Probable Spam] [PHP-DB] Placing a form on a page Dear List - I apologize if I offended some of you. I will see that it does

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread Ethan Rosenberg, PhD
On 05/06/2013 02:03 AM, David Robley wrote: Ethan Rosenberg, PhD wrote: On 05/06/2013 12:48 AM, tamouse mailing lists wrote: On Sun, May 5, 2013 at 11:22 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I apologize if I offended some of you. I will see

Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread Ethan Rosenberg, PhD
On 05/06/2013 02:03 AM, David Robley wrote: Ethan Rosenberg, PhD wrote: On 05/06/2013 12:48 AM, tamouse mailing lists wrote: On Sun, May 5, 2013 at 11:22 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - I apologize if I offended some of you. I will see

[PHP-DB] Problem with query

2013-06-23 Thread Ethan Rosenberg, PhD
Dear List - There is an error in my query, and I cannot find it. This fails: $_SESSION['Cust_Num'] = $_REQUEST['cnum']; $_SESSION['CustNum'] = $_REQUEST['cnum']; echo sessionbr /; //this has the proper values print_r($_SESSION); $sql10 = select Balance, Payments, Charges, Date from Charges

[PHP-DB] Re: Problem with query

2013-06-23 Thread Ethan Rosenberg, PhD
On 6/23/2013 2:31 PM, Ethan Rosenberg, PhD wrote: Dear List - There is an error in my query, and I cannot find it. This fails: $_SESSION['Cust_Num'] = $_REQUEST['cnum']; $_SESSION['CustNum'] = $_REQUEST['cnum']; echo sessionbr /; //this has the proper values print_r($_SESSION); $sql10

Re: [PHP-DB] Problem wkith Query

2013-06-23 Thread Ethan Rosenberg, PhD
On 23 June 2013 21:37, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: On 6/23/2013 2:31 PM, Ethan Rosenberg, PhD wrote: Dear List - There is an error in my query, and I cannot find it. This fails: $_SESSION['Cust_Num'] = $_REQUEST['cnum

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Ethan Rosenberg, PhD
On 08/22/2013 09:51 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 | Default | Extra |

Re: [PHP-DB] Newbie Question $2

2014-06-17 Thread Ethan Rosenberg, PhD
On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote: Hi Ethan, Here are some things to clean up your code: Your line: $phn = $_POST[phone]; should use quotations as follows: $phn = $_POST['phone']; Your line: $sql1 ='select Lname, Fname from Customers where Phone = $Phn '; Should use

Re: [PHP-DB] Re: What is my Mistake?

2014-06-24 Thread Ethan Rosenberg, PhD
On 06/24/2014 08:12 PM, Ethan Rosenberg, PhD wrote: On 06/24/2014 01:55 PM, Jim Giner wrote: Looking at your code again, I think that your query failed and your lack of error reporting isn't showing the error that occurred when you tried to access a property of the result which

[PHP-DB] Re: [PHP] SESSIONS

2015-01-01 Thread Ethan Rosenberg, PhD
-- Stuart Dallas 3ft9 Ltd http://3ft9.com/ Besides running from the terminal which won't set a session since the browser controls cookies and stuff shouldn't session_start go first? -- Ethan Rosenberg, PhD /Pres/CEO/ *Hygeia Biomedical Research, Inc* 2 Cameo Ridge Road Monsey, NY 10952

Re: [PHP-DB] Waiting for localhost

2015-03-17 Thread Ethan Rosenberg, PhD
On 03/16/2015 12:08 AM, Karl DeSaulniers wrote: Is this a weight that is entered in by your friend or a weight that is grabbed from a database or a scale per chance? If it is the latter, you don't need this form, just store the value some other way and incorporate into your other script that

Re: [PHP-DB] Waiting for localhost

2015-03-09 Thread Ethan Rosenberg, PhD
- Karl - Thanks. We all run up against brick walls. Anybody else have ideas? TIA. 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 (http