Re: [PHP-DB] Waiting for localhost

2015-04-02 Thread Ethan Rosenberg, PhD
On 04/02/2015 06:17 AM, Richard wrote: 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 this mes

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 di

Re: [PHP-DB] Waiting for localhost

2015-03-09 Thread Ethan Rosenberg, PhD
eWeight.php";'; } Best, Karl DeSaulniers Design Drumm http://designdrumm.com Karl - Thanks. The === avoids the infinite loop, but the call to the script is never executed. TIA Ethan Karl - Thanks. No improvement. TIA Ethan - Karl - Thanks. We all run up against

[PHP-DB] Re: [PHP] SESSIONS

2015-01-01 Thread Ethan Rosenberg, PhD
global $tax; > $upc = $_SESSION['UPC']; > > echo 'ses2'; > print_r($_SESSION); > - > From the terminal -- > > sess > Array > ( > ) > se

Re: [PHP-DB] Query does not work

2014-07-01 Thread Ethan Rosenberg, PhD
Dear List - I think I've lost the database connection. I put in the following code: $sql31= "select Lname, Fname, Phone, Cust_Num from Customers order by Lname"; echo $sql31; //echos correctly $result31 = mysqli_query($cxn,$sql31); var_dump($result31); // result n

[PHP-DB] Query does not work

2014-06-30 Thread Ethan Rosenberg, PhD
Dear List - Here is a query: select Lname, Fname, Payments, Charges, Balance from Customers, Charges where (Charges.Cust_Num = Customers.Cust_Num) and (Customers.Cust_Num =1022); Works beautifully from the terminal. In the php script: $sql31= "select Lname, Fname, Payments, Charges, Balanc

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 is

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

2014-06-24 Thread Ethan Rosenberg, PhD
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 is not a resource but merely a value of 'false'. One should ALWAYS c

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

2014-06-24 Thread Ethan Rosenberg, PhD
On 06/24/2014 09:39 AM, Jim Giner wrote: Ethan - You say your script stops here : echo 'here3'; To be sure, you mean that the script DOES echo out 'here3' or does NOT get there? I'm going to guess that it does get to that echo statement but the very next one is going to kill you because you ca

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 doubl

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] Problem wkith Query

2013-06-23 Thread Ethan Rosenberg, PhD
On 23 June 2013 21:37, Ethan Rosenberg, PhD 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'];

[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 "session"; //this

[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 "session"; //this has the proper values print_r($_SESSION); $sql10 = "select Balance, Payments, Charges, Date from Charges whe

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 wrote: Dear List - I apologize if I offended some of you. I will see that it does not repeat. I

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

2013-05-06 Thread Ethan Rosenberg, PhD
On 05/06/2013 04:26 AM, Karl DeSaulniers wrote: I would suggest googling your problem. In this case "centering an HTML form". Hth, Best, Karl DeSaulniers Design Drumm http://designdrumm.com On May 6, 2013, at 12:00 AM, Ethan Rosenberg, PhD wrote: On 05/06/2013 12:48 AM, tamou

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 wrote: Dear List - I apologize if I offended some of you. I will see that it does not repeat. I

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

2013-05-06 Thread Ethan Rosenberg, PhD
ou in the future. Greetings, Osain. -----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 offe

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 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 is the form: What you're a

[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: "; echo ""; ?> It is aligned on the p;age with the following css - #frm{ position: fixed; top: 5%; left:42%; } It aligns perfectly wi

[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 yo

[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] 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_N

[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] 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: http

[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] 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 choice

[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 (ht

[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() ); }

[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] 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: http:

[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', 'Note

[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] 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] Formatting - Solved

2012-11-26 Thread Ethan Rosenberg, PhD
Dear list Here is the answer ORIGINAL Search Results frame="box" style="table-layout: fixed;"> Site Medical Record First Name Last Name Phone Height Sex History Birthday Age $vara2 = array(array($Site, $MedRec, $Fname, $Lname, $Phone, $Height, $Sex, $Hx

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" wrote: On 11/25/2012 12:56 PM, Jim Giner wrote: On 11/25/2012

[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")

[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] 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 progra

[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 col

[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 mysq

[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

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 - 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 | Ke

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: http://www.php.net/unsub.ph

[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 | ++---

[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] 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

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 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, Phone, Height, Sex, Hx, Bday

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 wrote: Dear List - I wish

[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

[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] Th is a test #2 w/ copy

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