[PHP-DB] Books

2010-10-18 Thread Ethan Rosenberg
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

[PHP-DB] Database and Table creation

2010-10-19 Thread Ethan Rosenberg
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:

[PHP-DB] Parsing Tab Delimited file

2010-10-24 Thread Ethan Rosenberg
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

Re: [PHP-DB] Parsing Tab Delimited file

2010-10-26 Thread Ethan Rosenberg
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

Re: [PHP-DB] Parsing Tab Delimited file

2010-10-26 Thread Ethan Rosenberg
'); 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. Â

[PHP-DB] Incrementing Primary Key

2010-10-27 Thread Ethan Rosenberg
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

[PHP-DB] Books

2010-10-27 Thread Ethan Rosenberg
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

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Ethan Rosenberg
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

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Ethan Rosenberg
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

Re: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Ethan Rosenberg
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

[PHP-DB] Variable Assignment

2010-10-28 Thread Ethan Rosenberg
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

Re: [PHP-DB] Variable Assignment

2010-10-28 Thread Ethan Rosenberg
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

[PHP-DB] printf

2010-10-28 Thread Ethan Rosenberg
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

[PHP-DB] Reading from file

2010-11-01 Thread Ethan Rosenberg
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 =

Re: [PHP-DB] Reading from file

2010-11-02 Thread Ethan Rosenberg
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

[PHP-DB] If condition in query

2010-11-18 Thread Ethan Rosenberg
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 =

[PHP-DB] Closing Browser

2010-12-02 Thread Ethan Rosenberg
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

[PHP-DB] Resetting auto_increment

2010-12-14 Thread Ethan Rosenberg
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

Re: [PHP-DB] Resetting auto_increment

2010-12-14 Thread Ethan Rosenberg
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

[PHP-DB] Problems w/ goto

2010-12-17 Thread Ethan Rosenberg
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

[PHP-DB] goto - My comments

2010-12-18 Thread Ethan Rosenberg
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

[PHP-DB] Regex for telephone numbers

2010-12-29 Thread Ethan Rosenberg
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

[PHP-DB] Re: [PHP] Regex for telephone numbers

2010-12-30 Thread Ethan Rosenberg
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

[PHP-DB] Job Search

2010-12-31 Thread Ethan Rosenberg
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

[PHP-DB] Two forms on one page

2011-01-03 Thread Ethan Rosenberg
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

[PHP-DB] Two forms on one page

2011-01-03 Thread Ethan Rosenberg
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

[PHP-DB] Two forms on one page - THE ANSWER

2011-01-04 Thread Ethan Rosenberg
Jim - Much thanks to you for solving a problem with which I have been struggling for the last two weeks. Here is the code: === ?php session_start(); ? !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; ?php switch (

[PHP-DB] Craigslist Jobs

2011-01-11 Thread Ethan Rosenberg
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

[PHP-DB] Displaying Results

2011-02-15 Thread Ethan Rosenberg
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)]

[PHP-DB] Multiple Access to Database

2012-01-14 Thread Ethan Rosenberg
Dear List - I have a database: mysql show tables; +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 | +-+ mysql describe Intake3; ++-+--+-+-+---+ | Field | Type

[PHP-DB] Multiple Access to Database

2012-01-17 Thread Ethan Rosenberg
Dear List - I have a database: mysql show tables; +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 | +-+ mysql describe Intake3; ++-+--+-+-+---+ | Field | Type

[PHP-DB] Multiple Access to Database - The Answer

2012-01-18 Thread Ethan Rosenberg
'; 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

[PHP-DB] Problem w/query - again

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

Re: [PHP-DB] Problem w/query - again

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

Re: [PHP-DB] Problem w/query - again

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

Re: [PHP-DB] Problem w/query - again - CORRECTION

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

[PHP-DB] search of data base - again

2012-03-29 Thread Ethan Rosenberg
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

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Ethan Rosenberg
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

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Ethan Rosenberg
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

[PHP-DB] foreach

2012-04-05 Thread Ethan Rosenberg
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

[PHP-DB] PHP Database Problems

2012-05-02 Thread Ethan Rosenberg
have a database mysql describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | Site | varchar(6) | NO | PRI | | | | MedRec | int(6) | NO |

[PHP-DB] PHP Database Problems -- Code Snippets

2012-05-02 Thread Ethan Rosenberg
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

[PHP-DB] Re: [PHP] PHP Database Problems -- Code Snippets

2012-05-03 Thread Ethan Rosenberg
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

[PHP-DB] [PHP] PHP Database Problems -- Code Snippets - Any more Ideas?

2012-05-04 Thread Ethan Rosenberg
'; } ? I hope this helps. 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 mailto:erosenb...@hygeiabiomedical.comerosenb...@hygeiabiomedical.com -- PHP General Mailing List (http

[PHP-DB] Database Problems

2012-06-17 Thread Ethan Rosenberg
Dear List - I have a database: +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 | +-+ mysql describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Key |

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Ethan Rosenberg
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

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Ethan Rosenberg
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

[PHP-DB] mysql query

2013-08-21 Thread Ethan Rosenberg
Dear List - I can't figure this out mysql describe Inventory; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | UPC | varchar(14) | YES | |

Re: [PHP-DB] mysql query

2013-08-21 Thread Ethan Rosenberg
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

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Ethan Rosenberg
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

Re: [PHP-DB] Re: mysql query

2013-08-22 Thread Ethan Rosenberg
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

[PHP-DB] Bluefish for PHP

2013-08-22 Thread Ethan Rosenberg
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

[PHP-DB] Newbie Question $2

2014-06-16 Thread Ethan Rosenberg
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 =

[PHP-DB] What is my Mistake?

2014-06-23 Thread Ethan Rosenberg
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

[PHP-DB] www-data file

2014-08-25 Thread Ethan Rosenberg
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

[PHP-DB] Writing Problems

2014-08-26 Thread Ethan Rosenberg
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

Re: [PHP-DB] Writing Problems

2014-08-26 Thread Ethan Rosenberg
On 08/26/2014 09:19 PM, Matt Pelmear wrote: Do you check whether $fh2 is a resource after you fopen()? snip Do you check whether $fh2 is a resource after you fopen()? How? TIA Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Number of Lines in Table.

2014-09-02 Thread Ethan Rosenberg
Dear List - This works: mysql describe Purchases; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | indx | smallint(6) | NO | PRI | NULL|

[PHP-DB] Number of Lines in Table. SOLVED

2014-09-06 Thread Ethan Rosenberg
Dear List - This works: mysql describe Purchases; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | indx | smallint(6) | NO | PRI | NULL|

[PHP-DB] Duplicate Writes

2014-09-13 Thread Ethan Rosenberg
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 |

[PHP-DB] Re: [PHP] SESSIONS - SOLVED

2015-01-01 Thread Ethan Rosenberg
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

Re: [PHP-DB] Code Security

2015-02-05 Thread Ethan Rosenberg
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

Re: [PHP-DB] Code Security

2015-02-12 Thread Ethan Rosenberg
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

Re: [PHP-DB] Code Security

2015-02-13 Thread Ethan Rosenberg
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

[PHP-DB] Code Security

2015-02-04 Thread Ethan Rosenberg
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

Re: [PHP-DB] Waiting for localhost

2015-03-14 Thread Ethan Rosenberg
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

Re: [PHP-DB] Waiting for localhost

2015-03-18 Thread Ethan Rosenberg
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

Re: [PHP-DB] Waiting for localhost

2015-03-17 Thread Ethan Rosenberg
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

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Ethan Rosenberg
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

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Ethan Rosenberg
. 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

Re: [PHP-DB] Waiting for localhost

2015-03-08 Thread Ethan Rosenberg
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

Re: [PHP-DB] Waiting for localhost

2015-03-08 Thread Ethan Rosenberg
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

Re: Fwd: [PHP-DB] Waiting for localhost

2015-03-08 Thread Ethan Rosenberg
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:

Re: [PHP-DB] Code Security

2015-03-07 Thread Ethan Rosenberg
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

[PHP-DB] Waiting for localhost

2015-03-07 Thread Ethan Rosenberg
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

Re: [PHP-DB] Waiting for localhost

2015-03-31 Thread Ethan Rosenberg
-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

Re: [PHP-DB] Waiting for localhost

2015-03-26 Thread Ethan Rosenberg
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

Re: [PHP-DB] Waiting for localhost

2015-04-01 Thread Ethan Rosenberg
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

Re: [PHP-DB] Waiting for localhost

2015-04-01 Thread Ethan Rosenberg
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

Re: [PHP-DB] Waiting for localhost

2015-04-02 Thread Ethan Rosenberg
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

[PHP-DB] Zero Values

2015-09-01 Thread Ethan Rosenberg
Dear List - I have a payment/charges table - mysql> describe Charges; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | Indx |

Re: [PHP-DB] Zero Values

2015-09-02 Thread Ethan Rosenberg
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

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

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

[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

  1   2   >